tbl_monthlyattendance

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
monthlyattendanceid bigserial 19 √ nextval('tbl_monthlyattendance_monthlyattendanceid_seq'::regclass)
employeeid varchar 500 null
tbl_employee.employeeid fk_ma_employee R
payslipmonth int4 10 √ null
mayear int4 10 √ null
days int4 10 √ null
periodstartdate timestamp 29,6 √ null
periodenddate timestamp 29,6 √ null
attendance numeric 0 √ '0'::numeric
holidaysoffdays numeric 0 √ '0'::numeric
overtimehrs numeric 0 √ '0'::numeric
monthleave numeric 0 √ '0'::numeric
grosssalary numeric 0 √ '0'::numeric
deductions numeric 0 √ '0'::numeric
netsalary numeric 0 √ '0'::numeric
cocontributions numeric 0 √ '0'::numeric
empdeduction numeric 0 √ '0'::numeric
paidamount numeric 0 √ '0'::numeric
remainingamount numeric 0 √ '0'::numeric
paymethod varchar 20 √ null
accounttype varchar 20 √ null
accountno varchar 20 √ null
chequeno varchar 12 √ null
chequedate timestamp 29,6 √ null
blocked bool 1 √ false
processed bool 1 √ false
processpost bool 1 √ false
processingdate timestamp 29,6 √ null
postingdate timestamp 29,6 √ null
stateid int8 19 null
tbl_statemaster.stateid Implied Constraint R
branchid int4 10 √ null
departmentid int4 10 √ null
designationid int4 10 √ null
paycaderid int4 10 √ null
cmpid int4 10 √ null
sbuid int4 10 √ null
holdsalary bool 1 √ false
salarypaid varchar 50 √ '''Paid'''::character varying
isimport bool 1 √ false
isdisbursed bool 1 false
postedcount int4 10 √ 0
disbursedcount int4 10 √ 0
holdsalaryamount numeric 0 √ '0'::numeric
holdsalaryremarks varchar 500 √ null
isdefault bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
tbl_monthlyattendance_pk_tbl_monthlyattendance Primary key Asc monthlyattendanceid
ix_tbl_monthlyattendance_employeeid_payslipmonth_mayear Performance Asc/Asc/Asc employeeid + payslipmonth + mayear
tbl_monthlyattendance_idx_employee_tbl_monthlyattendance Performance Asc employeeid

Relationships

Close relationships within degrees of separation