resource_calendar_attendance

45 rows


Description

Work Detail

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('resource_calendar_attendance_id_seq'::regclass)
calendar_id int4 10 null
resource_calendar.id resource_calendar_attendance_calendar_id_fkey C

Resource’s Calendar
resource_id int4 10 √ null
resource_resource.id resource_calendar_attendance_resource_id_fkey N

Resource
sequence int4 10 √ null

Sequence
create_uid int4 10 √ null
res_users.id resource_calendar_attendance_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Name
dayofweek varchar 2147483647 null

Day of Week
day_period varchar 2147483647 null

Day Period
week_type varchar 2147483647 √ null

Week Number
display_type varchar 2147483647 √ null

Display Type
date_from date 13 √ null

Starting Date
date_to date 13 √ null

End Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
hour_from float8 17,17 null

Work from
hour_to float8 17,17 null

Work to
duration_days float8 17,17 √ null

Duration (days)

Indexes

Constraint Name Type Sort Column(s)
resource_calendar_attendance_pkey Primary key Asc id
resource_calendar_attendance__dayofweek_index Performance Asc dayofweek
resource_calendar_attendance__hour_from_index Performance Asc hour_from

Relationships

Close relationships within degrees of separation