resource

63 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('booking.resource_id_seq'::regclass)
reservation_transit_copy.target_copy artc_tc_fkey C
reservation.current_resource reservation_current_resource_fkey C
reservation.target_resource reservation_target_resource_fkey C
resource_attr_map.resource resource_attr_map_resource_fkey C
owner int4 10 null
org_unit.id resource_owner_fkey R
type int4 10 null
resource_type.id resource_type_fkey R
overbook bool 1 false
barcode text 2147483647 null
deposit bool 1 false
deposit_amount numeric 8,2 0.00
user_fee numeric 8,2 0.00

Indexes

Constraint Name Type Sort Column(s)
resource_pkey Primary key Asc id
br_unique Must be unique Asc/Asc owner + barcode

Relationships

Close relationships within degrees of separation