Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
| AREA | VARCHAR2 | 240 | Y | Area | Area name |
| AREA_INVALIDATED | NUMBER | 22 | Y | Number of invalidated seats in the not numbered area | |
| AVAILABLE | NUMBER | 22 | Y | Available | Number of available seats (neither booked, nor sold, nor invalidated, nor frozen) matching the current table row |
| BLOCK | VARCHAR2 | 240 | Y | Block | Block name |
| CONFIG_TYPE | VARCHAR2 | 7 | Y | Configuration type | Type of configuration: - SALES: configuration specific to a given performance - LOGICAL: configuration common to several performances |
| CONTINGENT | VARCHAR2 | 4000 | Y | Contingent | Contingent name |
| CONTINGENT_TYPE | VARCHAR2 | 4000 | Y | Contingent type | Type of audience for which the contingent is foreseen. Possible values are: - Target group - Invited - Company - Services - Press - Diplomatic - Disabled - Other - Goods stock |
| ENTRANCE | VARCHAR2 | 240 | Y | Entrance | Entrance name |
| FLOOR | VARCHAR2 | 240 | Y | Floor | Floor |
| FROZEN | NUMBER | 22 | Y | Frozen | Number of frozen seats matching the current table row |
| INSTIT_CODE | VARCHAR2 | 15 | Y | Institution code | |
| INVALIDATED | NUMBER | 22 | Y | Invalidated | Number of invalidated seats matching the current table row |
| IS_NUMBERED | VARCHAR2 | 2 | Y | Flag or numbering type | |
| LOGICAL_SEAT_CATEGORY | VARCHAR2 | 240 | Y | Logical seat category | Name of logical seat category |
| LOG_CONFIG | VARCHAR2 | 240 | Y | Name of logical configuration | |
| PARENT_CONTINGENT | VARCHAR2 | 240 | Y | Parent contingent | Contingent name |
| PHY_CONFIG | VARCHAR2 | 240 | Y | Name of physical configuration | |
| PRODUCT | VARCHAR2 | 240 | Y | Product | Product name |
| PRODUCT_DATE_TIME | TIMESTAMP(3) | 11 | Y | Product date time | Performance or timeslot date and time (dd.mm.yyyy hh:mm:ss) |
| PRODUCT_EXTERNAL_NAME | VARCHAR2 | 240 | Y | External name of product | |
| QUOTA | NUMBER | 22 | Y | Quota | Initial number of available seats (neither booked, nor sold, nor invalidated, nor frozen) matching the current table row |
| RATE_TYPE | VARCHAR2 | 240 | Y | Rate type | Name of rate type |
| RESERVED | NUMBER | 22 | Y | Reserved | Number of reserved seats matching the current table row |
| SEASON | VARCHAR2 | 240 | Y | Season | Season name |
| SEAT_CAT | VARCHAR2 | 32 | Y | Seat category name | |
| SEAT_CLASSFN_1 | VARCHAR2 | 4000 | Y | Seat classification 1 | |
| SEAT_CLASSFN_2 | VARCHAR2 | 4000 | Y | Seat classification 2 | |
| SEAT_QUALITY | VARCHAR2 | 4000 | Y | Seat quality | Seat quality describing the level of comfort provided. Possible values are: - Bench - Seat - Armchair - Wheelchair - Seat - Folding chair |
| SECTOR | VARCHAR2 | 240 | Y | Sector | Name of sector in which an area is located |
| SITE | VARCHAR2 | 240 | Y | Site | Name of site where event takes place |
| SOLD | NUMBER | 22 | Y | Sold | Number of sold seats matching the current table row |
| SPACE | VARCHAR2 | 240 | Y | Space | Name of space where event takes place |
| T_ABSTR_CONFIG_ID | NUMBER | 22 | Y | Technical identifier of configuration | |
| T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
| T_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
| T_CONTINGENT_TYPE | VARCHAR2 | 25 | Y | Type of audience for which the contingent is foreseen. Possible values are: - Target group - Invited - Company - Services - Press - Diplomatic - Disabled - Other - Goods stock |
|
| T_ENTRANCE_ID | NUMBER | 22 | Y | Technical identifier of entrance to be used to reach an area or a set of seats | |
| T_FAMILY_SUB_TYPE | VARCHAR2 | 25 | Y | Name of product family subtype. Possible values are: - DATE_SPECIFIC_PASS: dated pass - DONATION: donation - GOODS: goods product - HOSPITALITY: hospitality for a single match - HOSPITALITY_PACKAGE: hospitality for several matches - MEMBERSHIP: membership - OPEN: open product - OPEN_PASS: non-dated pass - PACKAGE: package - SEASONTICKET: season ticket - SERVICE: service - SIMPLE_TICKET: event - SPORTING_EVENT: competition - TIMESLOT_PASS: timeslot pass - VISIT: visit (old visits based on events) - VISIT_PASS: visit pass - VOUCHER: voucher |
|
| T_LOGAREA_ID | NUMBER | 22 | Y | Technical identifier of the logical seat | |
| T_LOGCONFIG_ID | NUMBER | 22 | Y | Technical identifier of performance logical configuration | |
| T_LOG_SEAT_CAT_ID | NUMBER | 22 | Y | Technical identifier of logical seat category | |
| T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
| T_PHYAREA_ID | NUMBER | 22 | Y | Technical identifier of physical area | |
| T_PHYBLOCK_ID | NUMBER | 22 | Y | Technical identifier of physical block | |
| T_PHYCONFIG_ID | NUMBER | 22 | Y | Technical identifier of physical configuration | |
| T_PRODUCT_ID | NUMBER | 22 | Y | Product technical identifier | |
| T_P_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
| T_RATE_TYPE_ID | NUMBER | 22 | Y | Technical identifier of rate type | |
| T_SALECONFIG_ID | NUMBER | 22 | Y | Technical identifier of sales configuration | |
| T_SEASON_ID | NUMBER | 22 | Y | Season technical identifier | |
| T_SEAT_CAT_ID | NUMBER | 22 | Y | Seat category technical identifier | |
| T_SEAT_CLASSFN_1 | VARCHAR2 | 40 | Y | Seat classification 1 | |
| T_SEAT_CLASSFN_2 | VARCHAR2 | 40 | Y | Seat classification 2 | |
| T_SITE_ID | NUMBER | 22 | Y | Technical identifier of site | |
| T_SPACE_ID | NUMBER | 22 | Y | Technical identifier of space |