| Table pc_room_alloc |
|
Description: Links rooms to attendees of a conference or a booking in the hospitality module |
| PRIMARY KEY | ||
|
pc_key_i
integer NOT NULL | Surrogate Primary Key; required because there can be several bookings per room, and not all guests might be linked to a partner | |
|
p_venue_key_n
bigint NOT NULL | pc_room | |
|
pc_building_code_c
varchar (16) NOT NULL | pc_room | |
|
pc_room_number_c
varchar (16) NOT NULL | pc_room | |
|
pc_conference_key_n
bigint | The room can be reserved for a conference | pc_attendee |
|
p_partner_key_n
bigint default: 0 | The partner key of the guest, can be null if group booking (see ph_booking for p_charged_key_n to find who is booking the room) | pc_attendee |
|
ph_book_whole_room_l
boolean default: '1' NOT NULL | This makes the room unavailable for other guests even if not all beds are used | |
|
ph_number_of_beds_i
integer default: 1 | number of beds required by this allocation | |
|
ph_number_of_overflow_beds_i
integer default: 0 | number of additional beds (e.g. mattrass, childrens cot, etc) required by this allocation | |
|
ph_gender_c
varchar (40) | possible values: couple, family, male, female | |
|
pc_in_d
date NOT NULL | ||
|
pc_out_d
date | ||
|
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
|
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
|
s_date_modified_d
date | The date the record was modified. | |
|
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
|
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP | This identifies the current version of the record. | |
FOREIGN KEY pc_room_alloc_fk1: pc_conference_key_n;p_partner_key_n => pc_attendee pc_room_alloc_fk2: p_venue_key_n;pc_building_code_c;pc_room_number_c => pc_room pc_room_alloc_fkcr: s_created_by_c => s_user pc_room_alloc_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY ph_room_booking | ||