tbl_formassign

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
assignid bigserial 19 √ nextval('tbl_formassign_assignid_seq'::regclass)
tbl_formassignhistory.assignid Implied Constraint R
tbl_template_assign_mapping.assignid Implied Constraint R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single form assignment or configuration record.
formid int8 19 √ null
tbl_formdetail.formid Implied Constraint R

FK: public.tbl_form_master.id or similar (Presumed Foreign Key)
Meaning: The specific form (e.g., Appraisal Form, Onboarding Checklist) being assigned.
Logic: Identifies the document or template used for the process.
compid int8 19 √ null

FK: public.tbl_company.id or similar (Presumed Foreign Key)
Meaning: The company ID for which this form assignment is valid.
Usage: Allows configuration to be specific to a particular business entity.
roleformid int4 10 √ null

FK: public.tbl_user_role.id or public.tbl_role.id (Presumed Foreign Key)
Meaning: The Role ID or Access Control ID being assigned the form.
Logic: Defines who (e.g., all Managers, all HR) is supposed to fill out or view this form.
com1 int8 19 √ null

Custom Field 1
Meaning: Generic field for additional configuration or complexity (e.g., Department ID, Location ID).
Format: Varchar/Integer (Context-dependent)
com2 int8 19 √ null

Custom Field 2
Meaning: Generic field for additional configuration or complexity (e.g., Job Title filter, Start Date criteria).
Format: Varchar/Integer (Context-dependent)
com3 varchar 50 √ null

Custom Field 3
Meaning: Generic field for additional configuration or complexity.
Format: Varchar/Integer (Context-dependent)
com4 varchar 50 √ null

Custom Field 4
Meaning: Generic field for additional configuration or complexity.
Format: Varchar/Integer (Context-dependent)
formtype int4 10 √ null

The classification/type of the form being assigned.
Format: Varchar/Text or lookup key
Example: Review, Onboarding, Exit, Survey.
Logic: Groups forms by their overarching business function.
createdby varchar 500 √ null

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

Timestamp of when the assignment record was created.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 500 √ null

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

Timestamp of when the assignment record was last modified.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ

Indexes

Constraint Name Type Sort Column(s)
tbl_formassign_pk_tbl_formassign Primary key Asc assignid

Relationships

Close relationships within degrees of separation