tbl_attendanceoutstation

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
aoutstationid bigserial 19 √ nextval('tbl_attendanceoutstation_aoutstationid_seq'::regclass)
companyid int4 10 √ null
tbl_companymaster.companyid Implied Constraint R
aocategory int4 10 √ null
employeeid varchar 500 null
tbl_employee.employeeid fk_ao_employee R
aofromdate timestamp 29,6 √ null
aotodate timestamp 29,6 √ null
aodescription varchar 500 √ null
aocreatedate timestamp 29,6 √ null
aostatus varchar 25 √ '''Pending'''::character varying
aoapprovby varchar 20 √ null
aoapprovdate timestamp 29,6 √ null
aoother varchar 50 √ null
aocreatedby varchar 50 √ null
aoapprovedby varchar 50 √ null
aomodifieddate timestamp 29,6 √ null
comm1 varchar 50 √ null
comm2 varchar 2147483647 √ null
comm3 varchar 50 √ null
comm4 varchar 50 √ null
comm5 varchar 2147483647 √ null
rep1remark varchar 255 √ null
rep2remark varchar 255 √ null
primarymanagerid varchar 100 √ null
secondarymanagerid varchar 100 √ null
primarymanagerapprovaldate timestamp 29,6 √ null
secondarymanagerapprovaldate timestamp 29,6 √ null
modifiedby varchar 100 √ null
in_day varchar 50 √ 'CURRENT'::character varying
out_day varchar 50 √ 'CURRENT'::character varying
selected_shift_id int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_attendanceoutstation_pk_tbl_attendanceoutstation Primary key Asc aoutstationid
ix_tbl_attendanceoutstation_aofromdate_aotodate_aostatus Performance Asc/Asc/Asc aofromdate + aotodate + aostatus
tbl_attendanceoutstation_idx_employee_tbl_attendanceoutstation Performance Asc employeeid

Relationships

Close relationships within degrees of separation