tbl_generalpolicy

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gpolicyid bigserial 19 √ nextval('tbl_generalpolicy_gpolicyid_seq'::regclass)
companyid int4 10 null
tbl_companymaster.companyid Implied Constraint R
stateid int8 19 √ null
tbl_statemaster.stateid Implied Constraint R
branchid int8 19 √ null
tbl_branchmaster.branchid Implied Constraint R
probationperiod varchar 6 √ null
fnfnoticeperiod int4 10 √ null
validationamount numeric 0 √ null
gpother varchar 30 √ null
gpstatus bool 1 √ null
coffnonworking bool 1 √ false
overtimeascoff bool 1 √ false
offworking bool 1 √ false
offworkinghours numeric 0 √ null
holidayworking bool 1 √ false
holidayworkinghours numeric 0 √ null
overtimeworking bool 1 √ false
overtimeworkinghours numeric 0 √ null
overtimeapproval bool 1 √ false
coffapproval bool 1 √ false
overtimeflaxibility bool 1 √ false
earlygoing bool 1 √ false
latecoming bool 1 √ false
remainingamountlabel varchar 50 √ null
other bool 1 √ false
other1 varchar 50 √ null
other2 varchar 50 √ null
categoryid int8 19 √ null
tbl_categorymaster.categoryid Implied Constraint R
departmentid int4 10 √ null
sbuid int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_generalpolicy_pk_tbl_generalpolicy Primary key Asc gpolicyid

Relationships

Close relationships within degrees of separation