tbl_departmentofcompany

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('tbl_departmentofcompany_id_seq'::regclass)
tbl_resignationclearanceemployee.departmentid fk_tbl_resignationclearanceemployee_departmentid R
tbl_ticketcategory.departmentofcompanyid fk_tbl_ticketcategory_departmentofcompanyid R
tbl_transferrequisitionmaster.department fk_tbl_transferrequisitionmaster_department R
tbl_transferrequisitionmaster.subdepartment fk_tbl_transferrequisitionmaster_subdepartment R
parentid int4 10 √ null
cmpid int4 10 √ null
tbl_companymaster.companyid fk__tbl_depar__cmpid__5c164c38 R
entityid int4 10 √ null
sbuid int4 10 √ null
departmentname varchar 500 √ null
isdept bool 1 √ null
description varchar 2147483647 √ null
createon timestamp 29,6 √ null
createby varchar 50 √ null
modifiedby varchar 50 √ null
modifiedon timestamp 29,6 √ null
status bool 1 √ null
staffemailid varchar 100 √ null
organizationchartvisibility bool 1 √ true
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifieddate timestamp 29,6 √ null
headofdepartment varchar 100 √ null
departmentreportto numeric 0 √ null

FK: public.tbl_employee.employeeid
Meaning: The employee ID to whom the “headofdepartment” functionally reports.
Logic: Used for matrix organizations or to link a department head to a higher executive (e.g., HOD of Engineering reports to the CTO).

Indexes

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

Relationships

Close relationships within degrees of separation