tbl_stage_column_visibility

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_stage_column_visibility_id_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single column visibility rule.
stageid int8 19 √ null

FK: public.tbl_stage.id (Presumed Foreign Key)
Meaning: The workflow stage to which this visibility rule applies.
Dependency: Ensures column visibility changes based on the process step (e.g., fields visible in “Draft” but hidden in “Approved”).
columnid int8 19 √ null

FK: public.tbl_column_master.id or similar (Presumed Foreign Key)
Meaning: The specific column (field) whose visibility is being controlled.
Logic: Identifies the target field in the application (e.g., “candidate_salary”, “manager_comments”).
visibilitytype int4 10 √ null

The visibility state of the column at this stage.
Format: Varchar/Text or lookup key
Example: Visible, Hidden, ReadOnly, Mandatory.
Logic: Defines how the column should behave in the user interface during this specific stage.

Indexes

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

Relationships

Close relationships within degrees of separation