tbl_stage

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_stage_id_seq'::regclass)
tbl_stage_access_controll.stageid fkdpriafcic8gjhlddr6rpmeilj R
tbl_stage_trigger.stageid fk9u5f7egdxmq9loy34jb8wew8x R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single defined stage in a process.
createdby varchar 50 null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who initially created this stage definition.
createddate timestamp 29,6 √ null

Timestamp of when the stage definition was created.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The last user who modified this stage definition.
modifieddate timestamp 29,6 √ null

Timestamp of when the stage definition was last modified.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
stage varchar 255 √ null

The numerical or system-defined order/sequence of the stage within the workflow.
Format: Integer or SmallInt
Logic: Used to correctly order the process flow (e.g., Stage 1, Stage 2).
entity varchar 255 √ null

The module or type of business object this stage applies to.
Format: Varchar/Text or lookup key
Example: Recruitment, Leave Management, Performance Review, Ticket.
isclose bool 1 √ null

Flag indicating if reaching this stage means the process is closed or complete.
Format: Boolean (True/False)
Logic: If True, the workflow stops at this stage.
stagedesc varchar 255 √ null

A detailed description of the purpose and expected action for this stage.
Format: Text
Usage: Provides context for users and developers.
stagename varchar 255 √ null

A short, unique system name for the stage.
Format: Varchar(50)
Example: HR_REVIEW, MANAGER_APPROVAL, CANDIDATE_SUBMISSION.
actiontype int4 10 √ 1

The category of action required in this stage.
Format: Varchar/Text or lookup key
Example: Approval, Review, Notification, Data Entry.
title varchar 100 √ null

The display title for the stage, typically used in the user interface.
Format: Varchar(100)
Example: Review by HR, Get Manager Approval, Final Submission.

Indexes

Constraint Name Type Sort Column(s)
tbl_stage_pk__tbl_stag__3213e83f5438b422 Primary key Asc id

Relationships

Close relationships within degrees of separation