CUPPS11
Tables (35)
APPLICATION_MAST
- APPLICATION_ID — int — Primary key — NOT NULL
- APPLICATION_NAME — varchar(50) — NOT NULL
- APPLICATION_TYPE — int — NOT NULL
- CUPPS_AIRLINE_ID — int — NOT NULL
- CREATE_DATE — datetime
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(400)
- CMD — varchar(260)
- CMD_OPTION — varchar(260)
- EVENT_TOKEN — varchar(255)
APPLICATION_POLICY_LIST
- APPLICATION_ID — int — Foreign key → APPLICATION_MAST.APPLICATION_ID — NOT NULL
- APPLICATION_POLICY_ID — int — Foreign key → APPLICATION_POLICY_MAST.APPLICATION_POLICY_ID — NOT NULL
- SORT_NO — int — NOT NULL
APPLICATION_POLICY_MAST
- APPLICATION_POLICY_ID — int — Primary key — NOT NULL
- APPLICATION_POLICY_NAME — varchar(50) — NOT NULL
- CUPPS_AIRLINE_ID — int — NOT NULL
- CREATE_DATE — datetime
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(400)
CUPPS_AIRLINE_MAST
- CUPPS_AIRLINE_ID — int — Primary key — NOT NULL
- CUPPS_AIRLINE_CODE — varchar(3) — NOT NULL
- CUPPS_AIRLINE_NAME — varchar(50) — NOT NULL
- INVALID_FLAG — bit
- CREATE_DATE — datetime
- UPDATE_DATE — datetime
- CUPPS_AIRLINE_SUB_CODE — varchar(3) — NOT NULL
- DCS_NAME — varchar(255)
- HEARTBEAT_URL — varchar(255)
- SESSION_TIMEOUT — int
- DESCRIPTION — varchar(400)
CUPPS_AIRLINE_POLICY_LIST
- CUPPS_AIRLINE_POLICY_ID — int — Foreign key → CUPPS_AIRLINE_POLICY_MAST.CUPPS_AIRLINE_POLICY_ID — NOT NULL
- CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
- APPLICATION_POLICY_ID — int — Foreign key → APPLICATION_POLICY_MAST.APPLICATION_POLICY_ID — NOT NULL
CUPPS_AIRLINE_POLICY_MAST
- CUPPS_AIRLINE_POLICY_ID — int — Primary key — NOT NULL
- CUPPS_AIRLINE_POLICY_NAME — varchar(50) — NOT NULL
- INVALID_FLAG — bit
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(400)
CUPPS_BG_HISTORY
- CREATE_DATE — datetime — Primary key — NOT NULL
- WORKSTATION_ID — int — Primary key — NOT NULL
- BOARDING_DATE — datetime
- AIRLINE_ID — int
- AIRLINE_CODE — varchar(3)
- AIRPORT_CODE — varchar(10)
- SEQ_NUMBER — varchar(100)
- TERMINAL — varchar(3)
- BCBP_DATA — varchar(400)
- CHARGE_FLAG — bit
- REBOARDING_FLAG — bit
- PROCESS_FLAG — bit
CUPPS_BP_HISTORY
- CREATE_DATE — datetime — Primary key — NOT NULL
- WORKSTATION_ID — int — Primary key — NOT NULL
- ISSUE_DATE — datetime
- CUPPS_AIRLINE_ID — int
- CUPPS_AIRLINE_CODE — varchar(3)
- AIRPORT_CODE — varchar(10)
- SEQ_NUMBER — varchar(100)
- TERMINAL — varchar(3)
- BCBP_DATA — varchar(400)
- NATIONALITY — varchar(3)
- GENDER — varchar(1)
- AGE — int
- DOC_TYPE — varchar(10)
- CHARGE_FLAG — bit
- REPRINT_FLAG — bit
- PROCESS_FLAG — bit
CUPPS_BT_HISTORY
- CREATE_DATE — datetime — Primary key — NOT NULL
- WORKSTATION_ID — int — Primary key — NOT NULL
- ISSUE_DATE — datetime
- CUPPS_AIRLINE_ID — int
- CUPPS_AIRLINE_CODE — varchar(3)
- AIRPORT_CODE — varchar(10)
- TERMINAL — varchar(3)
- BAGTAG_NUMBER — varchar(20)
- DOC_TYPE — varchar(10)
- ARRIVAL_AIRPORT — varchar(3)
- DEPARTURE_DATE — varchar(8)
- FLIGHT_NUMBER — varchar(8)
- CHARGE_FLAG — bit
- REPRINT_FLAG — bit
- PROCESS_FLAG — bit
DEVICE_HISTORY
- CREATE_DATE — datetime — Primary key — NOT NULL
- WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
- DEVICE_ID — int — NOT NULL
- WORKSTATION_NAME — varchar(50)
- DEVICE_NAME — varchar(50)
- EVENT_DATE — datetime
- HMD — varchar(1)
- ACTIVE_AIRLINE_ID — int
- ACTIVE_AIRLINE_CODE — varchar(3)
- ENABLE_FLAG — bit
- EVENT_CODE — varchar(30)
- OPER_NAME — varchar(30)
- REAL_COMP_ID — varchar(30)
- RECEIVED_DATA — varchar(400)
- STATUS_CODE — varchar(30)
DEVICE_MAST
- DEVICE_ID — int — Primary key — NOT NULL
- DEVICE_NAME — varchar(50) — NOT NULL
- INVALID_FLAG — bit
- OPERATION_MODE — int — NOT NULL
- DEVICE_TYPE — varchar(3) — NOT NULL
- MODEL_NAME — varchar(50) — NOT NULL
- COMPONENT_NAME — varchar(50) — NOT NULL
- FIRMWARE_VERSION — varchar(20)
- MANUFACTURE_NAME — varchar(50)
- DESCRIPTION — varchar(400)
DEVICE_POLICY_LIST
- DEVICE_POLICY_ID — int — Foreign key → DEVICE_POLICY_MAST.DEVICE_POLICY_ID — NOT NULL
- DEVICE_ID — int — Foreign key → DEVICE_MAST.DEVICE_ID — NOT NULL
DEVICE_POLICY_MAST
- DEVICE_POLICY_ID — int — Primary key — NOT NULL
- DEVICE_POLICY_NAME — varchar(255) — NOT NULL
- INVALID_FLAG — bit
- CREATE_DATE — datetime
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(400)
ERROR_CODE_LIST
- ERROR_CODE_ID — int — Primary key — NOT NULL
- ERROR_CODE_NAME — varchar(30) — NOT NULL
- CATEGORY — varchar(10)
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(400)
MAINTENANCE_HISTORY
- CREATE_DATE — datetime — Primary key — NOT NULL
- WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
- DEVICE_ID — int — Foreign key → DEVICE_MAST.DEVICE_ID — NOT NULL
- ERROR_CODE — varchar(30)
- ISSUED_DATE — datetime
- RECOVERY_DATE — datetime
MAINTENANCE_LIST
- WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
- DEVICE_ID — int — Foreign key → DEVICE_MAST.DEVICE_ID — NOT NULL
- ERROR_CODE — varchar(30) — NOT NULL
- ISSUED_DATE — datetime
- RECOVERY_DATE — datetime
- UPDATE_DATE — datetime
NLS_LIST
- NLS_ID — int — Primary key — NOT NULL
- LANGUAGE_TYPE — varchar(10) — Primary key — NOT NULL
- CREATE_DATE — datetime — NOT NULL
- NLS_CODE — varchar(10) — NOT NULL
- NLS_VALUE — varchar(255) — NOT NULL
- UPDATE_DATE — datetime
RFID_MAST
- RFID_TAG — varchar(30) — Primary key — NOT NULL
- USER_ID — int — NOT NULL
- REQUEST_NAME — varchar(50)
- REQUEST_DATE — datetime
- ALLOW_FLAG — bit
- ALLOW_USER_ID — int
- ALLOW_DATE — datetime
SBD_AIRLINE_MAST
- SBD_AIRLINE_ID — int — Primary key — NOT NULL
- SBD_AIRLINE_CODE — varchar(3) — NOT NULL
- SBD_AIRLINE_NAME — varchar(30) — NOT NULL
- INVALID_FLAG — bit
- CREATE_DATE — datetime
- UPDATE_DATE — datetime
- SBD_AIRLINE_SUB_CODE — varchar(3) — NOT NULL
- DCS_NAME — varchar(255)
- HEARTBEAT_URL — varchar(255)
- SESSION_TIMEOUT — int
- CHECKIN_AVAIL_TIME — int
- MULTI_LEG — int
- INFANT_FLAG — bit
- FALLBACK_TAG_FLAG — bit
- TWO_STEP_FLAG — bit
- PASSPORT_FLAG — bit
- EXPIRE_PASSPORT_FLAG — bit
- EMG_PASSPORT_FLAG — bit
- WEIGHT_POLICY — varchar(10)
- MAX_WEIGHT — int
- HEAVYTAG_WEIGHT — int
- UNABLE_CLASS — varchar(255)
- DESCRIPTION — varchar(400)
SBD_AIRLINE_POLICY_LIST
- SBD_AIRLINE_ID — int — Foreign key → SBD_AIRLINE_MAST.SBD_AIRLINE_ID — NOT NULL
- SBD_AIRLINE_POLICY_ID — int — Foreign key → SBD_AIRLINE_POLICY_MAST.SBD_AIRLINE_POLICY_ID — NOT NULL
SBD_AIRLINE_POLICY_MAST
- SBD_AIRLINE_POLICY_ID — int — Primary key — NOT NULL
- SBD_AIRLINE_POLICY_NAME — varchar(50) — NOT NULL
- INVALID_FLAG — bit
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(400)
SBD_BT_HISTORY
- CREATE_DATE — datetime — Primary key — NOT NULL
- WORKSTATION_ID — int — Primary key — NOT NULL
- ISSUE_DATE — datetime
- SBD_AIRLINE_ID — int
- SBD_AIRLINE_CODE — varchar(3)
- AIRPORT_CODE — varchar(10)
- TERMINAL — varchar(3)
- BAGTAG_NUMBER — varchar(20)
- DOC_TYPE — varchar(10)
- ARRIVAL_AIRPORT — varchar(3)
- DEPARTURE_DATE — varchar(8)
- FLIGHT_NUMBER — varchar(8)
- CHARGE_FLAG — bit
- REPRINT_FLAG — bit
- PROCESS_FLAG — bit
STAT_CUPPS_AIRLINE_STATUS
- CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
- AVAILABLE_CNT — int
- ACTIVE_CNT — int
STAT_SBD_AIRLINE_STATUS
- SBD_AIRLINE_ID — int — Foreign key → SBD_AIRLINE_MAST.SBD_AIRLINE_ID — NOT NULL
- AVAILABLE_CNT — int
- ACTIVE_CNT — int
USER_GROUP_MAST
- USER_GROUP_ID — int — Primary key — NOT NULL
- USER_GROUP_NAME — varchar(50) — NOT NULL
- INVALID_FLAG — bit
- CREATE_DATE — datetime
- UPDATE_DATE — datetime
- CHILD_COUNT — int
- PARENT_GROUP_ID — int — NOT NULL
USER_MAST
- USER_ID — int — Primary key — NOT NULL
- LOGIN_ID — varchar(50) — NOT NULL
- CUPPS_AIRLINE_ID — int — NOT NULL
- UPDATE_DATE — datetime
- AUTHORITY — varchar(30)
- CONTACT — varchar(50)
- DEPARTMENT — varchar(30)
- PASSWORD — varchar(80)
- POSITION — varchar(50)
- USER_NAME — varchar(50)
- ALARM_FLAG — bit — NOT NULL
- USER_GROUP_ID — int
WORKSTATION_CUPPS_AIRLINE_STATUS
- WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
- CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
- CUPPS_AIRLINE_CODE — varchar(3) — NOT NULL
- CUPPS_AIRLINE_SUB_CODE — varchar(3) — NOT NULL
- EVENT_CODE — varchar(30)
- UPDATE_DATE — datetime
WORKSTATION_CUPPS_AIRLINE_STATUS_HISTORY
- CREATE_DATE — datetime — Primary key — NOT NULL
- WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
- CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
- CUPPS_AIRLINE_CODE — varchar(3) — NOT NULL
- CUPPS_AIRLINE_SUB_CODE — varchar(3) — NOT NULL
- EVENT_DATE — datetime — NOT NULL
- EVENT_CODE — varchar(30)
WORKSTATION_DETAIL
- WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
- INVALID_FLAG — int
- PULL_DATE — datetime
- UPDATE_DATE — datetime
- OPERATION_MODE — int
- ACTIVE_AIRLINE_CODE — varchar(3)
- BARCODE_STATUS — int
- CARD_STATUS — int
- DOOR_STATUS — bit
- CONNECTION_STATUS — int
- PASSPORT_STATUS — int
- BAGTAG_PRINTER_STATUS — int
- BOARDING_PRINTER_STATUS — int
- CONFIRM_PRINTER_STATUS — int
- RFID_STATUS — int
- CONVEYOR_STATUS — int
WORKSTATION_GROUP_MAST
- WORKSTATION_GROUP_ID — int — Primary key — NOT NULL
- GROUP_NAME — varchar(50) — NOT NULL
- INVALID_FLAG — bit
- CREATE_DATE — datetime
- UPDATE_DATE — datetime
- CHILD_COUNT — int
- PARENT_GROUP_ID — int — NOT NULL
WORKSTATION_MAST
- WORKSTATION_ID — int — Primary key — NOT NULL
- WORKSTATION_NAME — varchar(50) — NOT NULL
- INVALID_FLAG — bit
- ENABLE_FLAG — bit
- OPERATION_MODE — int
- CREATE_DATE — datetime
- UPDATE_DATE — datetime
- AIRPORT_CODE — varchar(3) — NOT NULL
- TERMINAL — varchar(3) — NOT NULL
- SIDE_TYPE — varchar(3) — NOT NULL
- AREA — varchar(5)
- COUNTER_NUMBER — varchar(3)
- MODEL_NAME — varchar(50)
- GROUP_ID — int
- IP_ADDR — varchar(15)
- MAC_ADDR — varchar(17)
- HEARTBEAT_TIME — int
- SBD_AIRLINE_POLICY_ID — int — NOT NULL
- CUPPS_AIRLINE_POLICY_ID — int — NOT NULL
- DEVICE_POLICY_ID — int — NOT NULL
- VERSION — varchar(10)
WORKSTATION_MODEL_MAST
- WORKSTATION_MODEL_ID — int — Primary key — NOT NULL
- WORKSTATION_MODEL_NAME — varchar(50) — NOT NULL
- UPDATE_DATE — datetime
- DESCRIPTION — varchar(400)
WORKSTATION_SBD_AIRLINE_STATUS
- WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
- SBD_AIRLINE_ID — int — Foreign key → SBD_AIRLINE_MAST.SBD_AIRLINE_ID — NOT NULL
- SBD_AIRLINE_CODE — varchar(3) — NOT NULL
- SBD_AIRLINE_SUB_CODE — varchar(3) — NOT NULL
- EVENT_CODE — varchar(30)
- UPDATE_DATE — datetime
WORKSTATION_SBD_AIRLINE_STATUS_HISTORY
- CREATE_DATE — datetime — Primary key — NOT NULL
- WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
- SBD_AIRLINE_ID — int — Foreign key → SBD_AIRLINE_MAST.SBD_AIRLINE_ID — NOT NULL
- SBD_AIRLINE_CODE — varchar(3) — NOT NULL
- SBD_AIRLINE_SUB_CODE — varchar(3) — NOT NULL
- EVENT_DATE — datetime — NOT NULL
- EVENT_CODE — varchar(30)
WORKSTATION_STATUS_HISTORY
- CREATE_DATE — datetime — Primary key — NOT NULL
- WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
- WORKSTATION_NAME — varchar(50)
- EVENT_DATE — datetime
- OPERATION_MODE — int
- ACTIVE_AIRLINE_CODE — int
- BARCODE_STATUS — int
- CARD_STATUS — int
- DOOR_STATUS — int
- CONNECTION_STATUS — int
- PASSPORT_STATUS — int
- BAGTAG_PRINTER_STATUS — int
- BOARDING_PRINTER_STATUS — int
- CONFIRM_PRINTER_STATUS — int
- RFID_STATUS — int
- CONVEYOR_STATUS — int