tbl_stage_access_controll

264 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_stage_access_controll_id_seq'::regclass)
tbl_stage_trigger_action_users.accesscontrollid fkditxthptyj633l7xt3jqtld4w R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single access control rule.
createdby varchar 50 null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who initially defined this access control rule.
createddate timestamp 29,6 √ null

Timestamp of when the access control rule 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 access control rule.
modifieddate timestamp 29,6 √ null

Timestamp of when the access control rule was last modified.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
createaccess bool 1 √ null

Flag indicating if the user/role defined by this rule has CREATE (Insert) permission.
Format: Boolean (True/False)
Logic: Governs the ability to create new records at the specified stage.
deleteaccess bool 1 √ null

Flag indicating if the user/role defined by this rule has DELETE permission.
Format: Boolean (True/False)
Logic: Governs the ability to delete records at the specified stage.
readaccess bool 1 √ null

Flag indicating if the user/role defined by this rule has READ (Select) permission.
Format: Boolean (True/False)
Logic: Governs the ability to view records at the specified stage.
updateaccess bool 1 √ null

Flag indicating if the user/role defined by this rule has UPDATE permission.
Format: Boolean (True/False)
Logic: Governs the ability to modify existing records at the specified stage.
username varchar 255 √ null

The name or identifier of the user or role to whom these permissions apply.
Format: Varchar/Text
Logic: A non-unique identifier, often for display or simplified configuration.
usertype int4 10 √ null

The type of user or role the access control applies to.
Format: Varchar/Text or lookup key
Example: Employee, Manager, HR_Admin, System_Role.
stageid int8 19 √ null
tbl_stage.id fkdpriafcic8gjhlddr6rpmeilj R

FK: public.tbl_stage.id (Presumed Foreign Key)
Meaning: The workflow stage to which these access rules are bound.
Dependency: Ensures permissions are context-specific to a point in the process.
entitycolumn varchar 100 √ null

The specific column name within the entity/module that this rule controls.
Format: Varchar/Text
Logic: Allows for granular, column-level permission control (e.g., controlling access to the “salary” column).
name varchar 100 √ null

A unique or descriptive name given to this access control rule.
Format: Varchar/Text
Example: Recruitment_Manager_Read_Only, HR_Edit_All.

Indexes

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

Relationships

Close relationships within degrees of separation