bed_type

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
booking_items.bedtype_id fk_booking_items_bedtype_id N
room.bedtype_id fk_room_bedtype_id N
room_summary.bedtype_id fk_room_summary_bedtype_id N
rsv_pickup.bedtype_id fk_rsv_pickup_bedtype_id N
name text 2147483647 √ null
enabled bool 1 √ true
code citext 2147483647 √ null
image bytea 2147483647 √ null

raw image store base64
image_type text 2147483647 √ null

like image/png, image/jpeg
image_url text 2147483647 √ null

path url for send to front-end but must concate with prefix url

Indexes

Constraint Name Type Sort Column(s)
bed_type_pkey Primary key Asc id
bed_type_code_idx Must be unique Asc code
unq_bed_type_name Must be unique Asc name

Relationships

Close relationships within degrees of separation