tbl_formassignhistory

-1 rows


Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single line-item or history record within a form assignment.
assignid int8 19 null
tbl_formassign.assignid Implied Constraint R

FK: public.tbl_formassign.assignid
Meaning: The parent form assignment this history/criterion record is linked to.
Dependency: Links the criteria to a specific assigned form instance.
criteria text 2147483647 √ null

The specific evaluation criteria or goal being measured.
Format: Text
Example: “Goal: Complete Project X,” “Competency: Communication Skills.”
weightage int4 10 √ null

The importance or weighting assigned to this criteria.
Format: Numeric (e.g., Integer or Decimal)
Usage: Used in calculating the final score or rating for the form.
createdby varchar 500 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user who defined or entered this criterion/history record.
createddate timestamp 29,6 √ null

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

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

Indexes

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

Relationships

Close relationships within degrees of separation