tbl_travel_expense

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_travel_expense_id_seq'::regclass)
travel_request_id int8 19 null
tbl_travelrequestmaster.id fk_tbl_travel_expense_travel_request_id R
expense_type_id int8 19 null
tbl_customfields_options.id fk_tbl_travel_expense_expense_type_id R
expense_date date 13 null
expense_attachment varchar 500 √ null
original_amount numeric 0 √ null
eligible_amount numeric 0 √ null
approved_amount numeric 0 √ null
custom_fields text 2147483647 √ null
description varchar 500 √ null
expense_limits text 2147483647 √ null
rep1 varchar 50 √ null
rep1_remarks varchar 500 √ null
rep2 varchar 50 √ null
rep2_remarks varchar 500 √ null
admin varchar 50 √ null
admin_remarks varchar 500 √ null
l2 varchar 50 √ null
l2_remarks varchar 500 √ null
is_deleted bool 1 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation