resource_calendar_leaves

-1 rows


Description

Resource Time Off Detail

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('resource_calendar_leaves_id_seq'::regclass)
mrp_workorder.leave_id mrp_workorder_leave_id_fkey N
company_id int4 10 √ null
res_company.id resource_calendar_leaves_company_id_fkey N

Company
calendar_id int4 10 √ null
resource_calendar.id resource_calendar_leaves_calendar_id_fkey N

Working Hours
resource_id int4 10 √ null
resource_resource.id resource_calendar_leaves_resource_id_fkey N

Resource
create_uid int4 10 √ null
res_users.id resource_calendar_leaves_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id resource_calendar_leaves_write_uid_fkey N

Last Updated by
name varchar 2147483647 √ null

Reason
time_type varchar 2147483647 √ null

Time Type
date_from timestamp 29,6 null

Start Date
date_to timestamp 29,6 null

End Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
resource_calendar_leaves_pkey Primary key Asc id
resource_calendar_leaves__calendar_id_index Performance Asc calendar_id
resource_calendar_leaves__resource_id_index Performance Asc resource_id

Relationships

Close relationships within degrees of separation