tbl_employeehistory

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_employeehistory_id_seq'::regclass)
employeeid varchar 500 null
tbl_employee.employeeid fk_eh_employee R
companyid int4 10 null
tbl_companymaster.companyid Implied Constraint R
employeephoto varchar 200 √ null
enationality varchar 40 √ null
ereligion varchar 40 √ null
egender varchar 6 √ null
emaritalstatus varchar 10 √ null
eanniversarydate timestamp 29,6 √ null
ezipcode varchar 10 √ null
ehight numeric 0 √ null
eweight numeric 0 √ null
emarkidentification varchar 100 √ null
ebloodgroup varchar 10 √ null
edrivinglicenseno varchar 20 √ null
edrivinglicenseexpiry timestamp 29,6 √ null
enomineename varchar 60 √ null
enomineerelationship varchar 30 √ null
epanno varchar 20 √ null
status varchar 20 √ null
rejectreason varchar 200 √ null
createddate timestamp 29,6 √ null
createdby varchar 200 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
floorno varchar 50 √ null
aadhaarcardno varchar 2147483647 √ null
votercardno varchar 2147483647 √ null
dynamicfields varchar 2147483647 √ null
uanno text 2147483647 √ null
actual_date_of_birth date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_employeehistory_pk__tbl_empl__3214ec07208a64bc Primary key Asc id
tbl_employeehistory_idx_employee_tbl_employeehistory Performance Asc employeeid

Relationships

Close relationships within degrees of separation