| Table openpetra_trunk.public.ph_room_booking Links room allocations and a booking
|
Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 0 rows at Do Nov 10 18:00 MEZ 2011 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| ph_booking_key_i + ph_room_alloc_key_i | Primary key | Asc/Asc | ph_room_booking_pk |
| ph_booking_key_i | Performance | Asc | inx_ph_room_booking_fk1_key1 |
| ph_room_alloc_key_i | Performance | Asc | inx_ph_room_booking_fk2_key2 |
| s_created_by_c | Performance | Asc | inx_ph_room_booking_fkcr_key3 |
| s_modified_by_c | Performance | Asc | inx_ph_room_booking_fkmd_key4 |
| ph_booking_key_i + ph_room_alloc_key_i | Must be unique | Asc/Asc | inx_ph_room_booking_pk0 |
|