Table pc_room

Description:
Details of rooms used for accommodation at a conference

PRIMARY KEY
p_venue_key_n bigint NOT NULL		pc_building
pc_building_code_c varchar (16) NOT NULL		pc_building
pc_room_number_c varchar (16) NOT NULL

pc_room_name_c varchar (100)
pc_beds_i integer default: 0
pc_max_occupancy_i integer default: 0
pc_bed_charge_n numeric (24, 10) default: 0
pc_bed_cost_n numeric (24, 10) default: 0
pc_usage_c varchar (32)
pc_gender_preference_c varchar (6)	Gender that is preferred to use that room
pc_layout_xpos_i integer	X Position for the room layout designer in pixels
pc_layout_ypos_i integer	Y Position for the room layout designer in pixels
pc_layout_width_i integer	Width for the room layout designer in pixels
pc_layout_height_i integer	Height for the room layout designer in pixels
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_fk1: p_venue_key_n;pc_building_code_c => pc_building pc_room_fkcr: s_created_by_c => s_user pc_room_fkmd: s_modified_by_c => s_user
REFERENCED BY pc_room_alloc, pc_room_attribute