tbl_departmentofcompanyhistory

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('tbl_departmentofcompanyhistory_id_seq'::regclass)
departmentofcompanyid int4 10 null
parentid int4 10 √ null
cmpid int4 10 √ null
entityid int4 10 √ null
departmentname varchar 500 √ null
isdept bool 1 √ null
description varchar 2147483647 √ null
departmentreportto numeric 0 √ null
headofdepartment varchar 100 √ null
staffemailid varchar 100 √ null
organizationchartvisibility bool 1 √ true
status bool 1 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to this history record itself.
Warning: This seems incorrect. This column is: Timestamp of the last modification to this history record itself.
Stored as: UTC
Logic: As with “modifiedby”, this is rarely used and should be NULL if the log is immutable.

Relationships

Close relationships within degrees of separation