tbl_attendancerequest

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
arequestid bigserial 19 √ nextval('tbl_attendancerequest_arequestid_seq'::regclass)
artype varchar 60 √ null
companyid int4 10 √ null
tbl_companymaster.companyid Implied Constraint R
employeeid varchar 500 null
tbl_employee.employeeid fk_at_employee R
ardate timestamp 29,6 √ null
artime varchar 25 √ null
aroutnextday bool 1 √ false
arreason varchar 500 √ null
createdate timestamp 29,6 √ null
arstatus varchar 20 √ '''Pending'''::character varying
arapprovby varchar 20 √ null
arother varchar 50 √ null
createdby varchar 50 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
comp1 varchar 200 √ null
comp2 varchar 200 √ null
comp3 numeric 0 √ null
comp4 int4 10 √ null
comp5 bool 1 √ null
comp6 timestamp 29,6 √ null
rep1remark varchar 255 √ null
rep2remark varchar 255 √ null
finalremark varchar 255 √ null
primarymanagerid varchar 100 √ null
secondarymanagerid varchar 100 √ null
primarymanagerapprovaldate timestamp 29,6 √ null
secondarymanagerapprovaldate timestamp 29,6 √ null
in_time timestamp 29,6 √ null
out_time timestamp 29,6 √ null
selected_shift_id int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_attendancerequest_pk_tbl_attendancerequest Primary key Asc arequestid
tbl_attendancerequest_idx_employee_tbl_attendancerequest Performance Asc employeeid

Relationships

Close relationships within degrees of separation