tbl_masterformassign

-1 rows


Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single master form assignment record.
companyid int8 19 √ null

FK: public.tbl_company.id or similar (Presumed Foreign Key)
Meaning: The company to which this form assignment belongs.
Usage: Ensures the assignment adheres to the correct organizational context.
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 template being assigned.
Logic: Identifies the master document being used (e.g., Annual Performance Review).
employeeid varchar 50 √ null

FK: public.tbl_employee.employeeid or similar (Presumed Foreign Key)
Meaning: The ID of the employee who is the subject of this form assignment.
Usage: Links the form directly to the individual being reviewed/onboarded.
formtype int4 10 √ null

The classification/type of the form being assigned.
Format: Varchar/Text or lookup key
Example: PerformanceReview, GoalSetting, DevelopmentPlan.
comm1 int4 10 √ null

Custom Comment/Configuration Field 1
Meaning: Generic field for storing additional assignment details or comments.
Example: Review Cycle Name, Start Date of the Review Period.
comm2 varchar 50 √ null

Custom Comment/Configuration Field 2
Meaning: Generic field for storing additional assignment details or comments.
Example: Manager ID, Review Deadline.

Indexes

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

Relationships

Close relationships within degrees of separation