tbl_stage_access

-1 rows


Columns

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

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

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

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

Timestamp of when the access mapping was last modified.
Stored as: UTC
UI: Converts to user’s local timezone
Format: YYYY-MM-DDTHH:MM:SSZ
uid int8 19 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.id (Presumed Foreign Key)
Meaning: The user ID or Employee ID to whom this specific stage access is granted.
entity varchar 255 √ null

The module or business object to which this access rule applies.
Format: Varchar/Text or lookup key
Example: Recruitment, Leave, Ticket.
username varchar 255 √ null

The username associated with the access rule.
Format: Varchar/Text
Usage: A convenient, non-unique reference for identifying the user without a join.
stageaccesscontrollid int8 19 √ null

FK: public.tbl_stage_access_control.id (Presumed Foreign Key)
Meaning: The ID of the parent stage access control rule.
Dependency: Links this specific user/entity mapping to a defined access configuration.

Indexes

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

Relationships

Close relationships within degrees of separation