resource_booking_intervals

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
interval_id VARCHAR 32 null
resource_id CHAR 32
files_search_attributes.id Implied ConstraintR
booking_id VARCHAR 32
begin INT 10 0
end INT 10 0
mkdate INT UNSIGNED 10 0
chdate INT UNSIGNED 10 0
takes_place BIT 1 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc interval_id
assign_object_id Performance Asc/Asc booking_id + resource_id
resource_id Performance Asc/Asc/Asc resource_id + takes_place + end

Relationships