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 |