tbl_statemaster

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
stateid bigserial 19 √ nextval('tbl_statemaster_stateid_seq'::regclass)
tbl_announcement.stateid Implied Constraint R
tbl_branchmaster.stateid fk__tbl_branc__state__5a2e03c6 R
tbl_companymaster.stateid Implied Constraint R
tbl_complianceaccount.stateid Implied Constraint R
tbl_generalpolicy.stateid Implied Constraint R
tbl_holidaybranchmaster.stateid Implied Constraint R
tbl_holidaymaster.stateid fk__tbl_holid__state__63b76e00 R
tbl_monthlyattendance.stateid Implied Constraint R
tbl_pfmaster.stateid Implied Constraint R
tbl_ptheadermaster.stateid Implied Constraint R
tbl_todaysthought.stateid Implied Constraint R
tbl_transferrequisitionmaster.state fk_tbl_transferrequisitionmaster_state R
companyid int4 10 null
tbl_companymaster.companyid fk__tbl_state__compa__5939df8d R
statename varchar 60 null
statezone varchar 20 √ null
statecountry varchar 40 √ null
statecstno varchar 20 √ null
stateptno varchar 20 √ null
statefactoryregno varchar 20 √ null
statefactoryrewdate timestamp 29,6 √ null
statelstno varchar 20 √ null
statecreatedate timestamp 29,6 √ null
statestatus bool 1 √ true
sisdelete bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
tbl_statemaster_pk_tbl_statemaster Primary key Asc stateid

Relationships

Close relationships within degrees of separation