reservation

15 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('money.billable_xact_id_seq'::regclass)
emergency_closing_reservation.reservation emergency_closing_reservation_reservation_fkey C
reservation_transit_copy.reservation reservation_transit_copy_reservation_fkey N
reservation_attr_value_map.reservation reservation_attr_value_map_reservation_fkey C
usr int4 10 null
usr.id booking_reservation_usr_fkey R
xact_start timestamptz 35,6 now()
xact_finish timestamptz 35,6 √ null
unrecovered bool 1 √ null
request_time timestamptz 35,6 now()
start_time timestamptz 35,6 √ null
end_time timestamptz 35,6 √ null
capture_time timestamptz 35,6 √ null
cancel_time timestamptz 35,6 √ null
pickup_time timestamptz 35,6 √ null
return_time timestamptz 35,6 √ null
booking_interval interval 49,6 √ null
fine_interval interval 49,6 √ null
fine_amount numeric 8,2 √ null
max_fine numeric 8,2 √ null
target_resource_type int4 10 null
resource_type.id reservation_target_resource_type_fkey C
target_resource int4 10 √ null
resource.id reservation_target_resource_fkey C
current_resource int4 10 √ null
resource.id reservation_current_resource_fkey C
request_lib int4 10 null
org_unit.id reservation_request_lib_fkey R
pickup_lib int4 10 √ null
org_unit.id reservation_pickup_lib_fkey R
capture_staff int4 10 √ null
usr.id reservation_capture_staff_fkey R
email_notify bool 1 false
note text 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation