tbl_liability

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_liability_id_seq'::regclass)
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R
payelementid int8 19 null
tbl_employeepayelement.payelementid Implied Constraint R
payelementcode varchar 100 null
amount numeric 0 null
liabilitystatus varchar 50 null
liabilitytype varchar 50 null
liabilitymonth int8 19 null
liabilityyear int8 19 null
duedate date 13 null
adjustmentid int8 19 √ null
remarks varchar 100 √ null
groupname varchar 100 null
payeffect varchar 100 null
startdate date 13 null
paymenttype varchar 100 null
employeepayelementid int8 19 null
approverejectreason varchar 500 √ null
paidleavecount numeric 0 √ null
unpaidleavecount numeric 0 √ null
presentcount numeric 0 √ null
weekoff numeric 0 √ null
absentday numeric 0 √ null
holiday numeric 0 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
actamount numeric 0 √ null
salary_structure_id int8 19 √ null
salary_type varchar 50 √ 'SALARY'::character varying

Indexes

Constraint Name Type Sort Column(s)
tbl_liability_pk_tbl_liability Primary key Asc id

Relationships

Close relationships within degrees of separation