tbl_employeeinsurance

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
einsuranceid bigserial 19 √ nextval('tbl_employeeinsurance_einsuranceid_seq'::regclass)
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R
eimonth int4 10 √ null
eiyear int4 10 √ null
einsuranceno varchar 30 √ null
einsuranceamount numeric 0 √ '0'::numeric
eage int4 10 √ null
eicompany varchar 80 √ null
einsurancedate timestamp 29,6 √ null
einsuranceexpire timestamp 29,6 √ null
eiremark varchar 500 √ null
eicreatedate timestamp 29,6 √ null
eistatus bool 1 √ true

Indexes

Constraint Name Type Sort Column(s)
tbl_employeeinsurance_pk_tbl_employeeinsurance Primary key Asc einsuranceid

Relationships

Close relationships within degrees of separation