tbl_holidaymaster

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
holidayid serial 10 √ nextval('tbl_holidaymaster_holidayid_seq'::regclass)
tbl_holidaybranchmaster.holidayid fk__tbl_holid__holid__64ab9239 R
stateid int8 19 null
tbl_statemaster.stateid fk__tbl_holid__state__63b76e00 R
holidayname varchar 60 null
holidaydate timestamp 29,6 null
holidaytype varchar 15 null
holidaycontinue bool 1 √ false
holidaystatus bool 1 √ true
holidayrunning bool 1 √ true
companyid int4 10 √ null
tbl_companymaster.companyid companyid_fk R
isoptionalholiday bool 1 √ null
sbuid int4 10 √ null
tbl_companymaster.companyid fk__tbl_holid__sbuid__62c349c7 R
holidaypay bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_holidaymaster_pk_tbl_holidaymaster Primary key Asc holidayid

Relationships

Close relationships within degrees of separation