resource_resource

-1 rows


Description

Resources

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('resource_resource_id_seq'::regclass)
mrp_workcenter.resource_id mrp_workcenter_resource_id_fkey R
resource_calendar_attendance.resource_id resource_calendar_attendance_resource_id_fkey N
resource_calendar_leaves.resource_id resource_calendar_leaves_resource_id_fkey N
company_id int4 10 √ null
res_company.id resource_resource_company_id_fkey N

Company
user_id int4 10 √ null
res_users.id resource_resource_user_id_fkey N

User
calendar_id int4 10 √ null
resource_calendar.id resource_resource_calendar_id_fkey N

Working Time
create_uid int4 10 √ null
res_users.id resource_resource_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Name
resource_type varchar 2147483647 null

Type
tz varchar 2147483647 null

Timezone
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
time_efficiency float8 17,17 null

Efficiency Factor

Indexes

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

Check Constraints

Constraint Name Constraint
resource_resource_check_time_efficiency ((time_efficiency > (0)::double precision))

Relationships

Close relationships within degrees of separation