Table openpetra_trunk.public.pc_room_alloc
Links rooms to attendees of a conference or a booking in the hospitality module

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
pc_key_i int4 10
ph_room_booking.ph_room_alloc_key_i ph_room_booking_fk2 R
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 numeric 10
pc_room.p_venue_key_n pc_room_alloc_fk2 R
pc_building_code_c varchar 16
pc_room.pc_building_code_c pc_room_alloc_fk2 R
pc_room_number_c varchar 16
pc_room.pc_room_number_c pc_room_alloc_fk2 R
pc_conference_key_n numeric 10  √  null
pc_attendee.pc_conference_key_n pc_room_alloc_fk1 R
The room can be reserved for a conference
p_partner_key_n numeric 10  √  0
pc_attendee.p_partner_key_n pc_room_alloc_fk1 R
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)
ph_book_whole_room_l bool 1 true This makes the room unavailable for other guests even if not all beds are used
ph_number_of_beds_i int4 10  √  1 number of beds required by this allocation
ph_number_of_overflow_beds_i int4 10  √  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 13
pc_out_d date 13  √  null
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c pc_room_alloc_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c pc_room_alloc_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 1 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
pc_key_i Primary key Asc pc_room_alloc_pk
pc_conference_key_n + p_partner_key_n Performance Asc/Asc inx_pc_room_alloc_fk1_key1
p_venue_key_n + pc_building_code_c + pc_room_number_c Performance Asc/Asc/Asc inx_pc_room_alloc_fk2_key2
s_created_by_c Performance Asc inx_pc_room_alloc_fkcr_key3
s_modified_by_c Performance Asc inx_pc_room_alloc_fkmd_key4
pc_key_i Must be unique Asc inx_pc_room_alloc_pk0
pc_conference_key_n + p_partner_key_n + pc_in_d Performance Asc/Asc/Asc pc_room_alloc_k0
pc_conference_key_n + p_partner_key_n + p_venue_key_n + pc_in_d Performance Asc/Asc/Asc/Asc pc_room_alloc_k21

Close relationships  within of separation: