tbl_companymasterhistory

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_companymasterhistory_id_seq'::regclass)
companyid int8 19 √ null
history varchar 2147483647 √ null
createddate timestamp 29,6 √ null
createdby varchar 500 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 500 √ null

FK: public.tbl_userlogin.id (or similar user table)
Meaning: The user who last modified this history record itself.
Examples: “T”, “D”, “B” (These could be codes for meal types like Thali, Dosa, Breakfast).
Logic: As with “modifieddate”, this is rarely used and should be NULL if the log is immutable.

Indexes

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

Relationships

Close relationships within degrees of separation