tbl_formassignv1

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single form assignment criteria row in this version (V1) of the structure.

FK: public.tbl_form_master.id or similar (Presumed Foreign Key)
Meaning: The specific form template being configured (e.g., Annual Review Form).

FK: public.tbl_role.id or public.tbl_formassign.assignid (Presumed Foreign Key)
Meaning: The role ID or parent assignment ID defining who this criteria applies to.
Logic: Links criteria to a specific user group (e.g., all Senior Developers).

The specific evaluation criteria, competency, or goal.
Format: Text
Example: “Goal: Q3 Revenue Target,” “Competency: Leadership.”

The classification/type of the form.
Format: Varchar/Text or lookup key
Example: PerformanceReview, GoalSetting, 360Feedback.

The importance or weighting assigned to this criteria.
Format: Numeric (e.g., Integer or Decimal)
Usage: Determines the contribution of this criterion to the form’s final rating.

Flag indicating if the criteria is marked for soft deletion.
Format: Boolean (True/False)
Logic: True means the record is logically deleted but retained for history/audit.

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who created this criterion row.

Timestamp of when the criteria record was created.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The last user who modified this criterion record.

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