vip

15 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
group_info.vip_id fk_group_info_vip_id N
guest.vip_id fk_guest_vip_id N
room_summary.guest_vip_id fk_room_summary_guest_vip_id N
rsv_pickup.guest_vip_id fk_rsv_pickup_guest_vip_id N
code citext 2147483647 √ null
name text 2147483647 √ null
daykeep int2 5 √ null
enabled bool 1 √ true
vip_type bpchar 1 'R'::bpchar

Indexes

Constraint Name Type Sort Column(s)
vip_pkey Primary key Asc id
vip_code_key Must be unique Asc code

Relationships

Close relationships within degrees of separation