tbl_leavecodepolicyemployeemapping

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_leavecodepolicyemployeemapping_id_seq'::regclass)
leavecodepolicyid int8 19 null
tbl_leavecodepolicyconfig.id fk_tbl_leavecodepolicyemployeemapping_leavecodepolicyid R
employeeid varchar 500 null
tbl_employee.employeeid fk_tbl_leavecodepolicyemployeemapping_employeeid R
createdby varchar 50 null
createddate timestamp 29,6 null
modifiedby varchar 50 null
modifieddate timestamp 29,6 null

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_leavecodepolicyemployeemapping_id Primary key Asc id
ux_tbl_leavecodepolicyemployeemapping_leavecodepolicyid_employe Must be unique Asc/Asc leavecodepolicyid + employeeid

Relationships

Close relationships within degrees of separation