tbl_leaveapplicationline

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
leavelineid bigserial 19 √ nextval('tbl_leaveapplicationline_leavelineid_seq'::regclass)
leaveappid varchar 20 √ null
lvdate timestamp 29,6 √ null
lvduration varchar 20 √ null
lvmonth int4 10 √ null
lvyear int4 10 √ null
lvstatus varchar 20 √ null
lvdiscription varchar 200 √ null
leavecancellationreqdate timestamp 29,6 √ null
leaveapproveddate timestamp 29,6 √ null
leavecancellationdate timestamp 29,6 √ null
cancelationrequest varchar 20 √ null
dateofapproval1 timestamp 29,6 √ null
dateofapproval2 timestamp 29,6 √ null
reporting1status varchar 20 √ null
reporting2status varchar 50 √ null
reporting1name varchar 50 √ null
reporting2name varchar 50 √ null
report1approvedate timestamp 29,6 √ null
repport2approvedate timestamp 29,6 √ null
com varchar 50 √ null
com1 varchar 50 √ null
com2 varchar 50 √ null
com3 varchar 50 √ null
com4 varchar 50 √ null
leaveapplicationid int8 19 null
tbl_leaveapplicationheader.id fk_tbl_leaveapplicationline_leaveapplicationid R

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_leaveapplicationline_1 Primary key Asc leavelineid

Relationships

Close relationships within degrees of separation