CUPPS_2ND

Tables (36)

APPLICATION_MAST

  • APPLICATION_ID — int — Primary key — NOT NULL
  • APPLICATION_NAME — varchar(50) — NOT NULL
  • APPLICATION_TYPE — int — NOT NULL
  • CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
  • CREATE_DATE — datetime
  • UPDATE_DATE — datetime
  • DESCRIPTION — varchar(400)
  • CMD — varchar(260)
  • CMD_OPTION — varchar(260)
  • EVENT_TOKEN — varchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

APPLICATION_POLICY_LIST

  • APPLICATION_POLICY_ID — int — Foreign key → APPLICATION_POLICY_MAST.APPLICATION_POLICY_ID — NOT NULL
  • APPLICATION_ID — int — Foreign key → APPLICATION_MAST.APPLICATION_ID — NOT NULL
  • SORT_NO — int — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • INVALID_FLAG — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

CUPPS_AIRLINE_POLICY_LIST

  • APPLICATION_POLICY_ID — int — Foreign key → APPLICATION_POLICY_MAST.APPLICATION_POLICY_ID — NOT NULL
  • CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
  • CUPPS_AIRLINE_POLICY_ID — int — Foreign key → CUPPS_AIRLINE_POLICY_MAST.CUPPS_AIRLINE_POLICY_ID — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • FLIGHT_NUMBER — varchar(8)
  • SEQ_NUMBER — varchar(100)
  • TERMINAL — varchar(3)
  • BCBP_DATA — varchar(400)
  • CHARGE_FLAG — bit
  • REBOARDING_FLAG — bit
  • PROCESS_FLAG — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • FLIGHT_NUMBER — varchar(8)
  • 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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • FLIGHT_NUMBER — varchar(8)
  • TERMINAL — varchar(3)
  • BAGTAG_NUMBER — varchar(20)
  • DOC_TYPE — varchar(10)
  • ARRIVAL_AIRPORT — varchar(3)
  • DEPARTURE_DATE — varchar(8)
  • CHARGE_FLAG — bit
  • REPRINT_FLAG — bit
  • PROCESS_FLAG — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

DEVICE_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
  • 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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

DEVICE_POLICY_LIST

  • DEVICE_ID — int — Foreign key → DEVICE_MAST.DEVICE_ID — NOT NULL
  • DEVICE_POLICY_ID — int — Foreign key → DEVICE_POLICY_MAST.DEVICE_POLICY_ID — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • ALARM_FLAG — bit — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

MAINTENANCE_HISTORY

  • CREATE_DATE — datetime — Primary key — NOT NULL
  • DEVICE_ID — int — Foreign key → DEVICE_MAST.DEVICE_ID — NOT NULL
  • WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
  • ERROR_CODE — varchar(30)
  • ISSUED_DATE — datetime
  • RECOVERY_DATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

MAINTENANCE_LIST

  • DEVICE_ID — int — Foreign key → DEVICE_MAST.DEVICE_ID — NOT NULL
  • WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
  • ERROR_CODE — varchar(30) — NOT NULL
  • ISSUED_DATE — datetime
  • RECOVERY_DATE — datetime
  • UPDATE_DATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

NLS_LIST

  • NLS_ID — int — Primary key — NOT NULL
  • CREATE_DATE — datetime — NOT NULL
  • LANGUAGE_TYPE — varchar(10) — NOT NULL
  • NLS_CODE — varchar(10) — NOT NULL
  • NLS_VALUE — varchar(255) — NOT NULL
  • UPDATE_DATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

RFID_MAST

  • RFID_TAG — varchar(30) — Primary key — NOT NULL
  • USER_ID — int — Foreign key → USER_MAST.USER_ID — NOT NULL
  • REQUEST_NAME — varchar(50)
  • REQUEST_DATE — datetime
  • ALLOW_STATUS — int
  • ALLOW_USER_ID — int — Foreign key → USER_MAST.USER_ID
  • ALLOW_DATE — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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
  • TERMINAL — varchar(3)
  • 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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

STAT_CUPPS_AIRLINE_STATUS

  • CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
  • AVAILABLE_CNT — int
  • ACTIVE_CNT — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

STAT_SBD_AIRLINE_STATUS

  • SBD_AIRLINE_ID — int — Foreign key → SBD_AIRLINE_MAST.SBD_AIRLINE_ID — NOT NULL
  • AVAILABLE_CNT — int
  • ACTIVE_CNT — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

USER_MAST

  • USER_ID — int — Primary key — NOT NULL
  • LOGIN_ID — varchar(50) — NOT NULL
  • CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
  • UPDATE_DATE — datetime
  • AUTHORITY — varchar(30)
  • CONTACT — varchar(50)
  • DEPARTMENT — varchar(30)
  • PASSWORD — varchar(480)
  • POSITION — varchar(50)
  • USER_NAME — varchar(50)
  • ALARM_FLAG — bit — NOT NULL
  • USER_GROUP_ID — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

WORKSTATION_CUPPS_AIRLINE_STATUS

  • CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
  • WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

WORKSTATION_CUPPS_AIRLINE_STATUS_HISTORY

  • CREATE_DATE — datetime — Primary key — NOT NULL
  • CUPPS_AIRLINE_ID — int — Foreign key → CUPPS_AIRLINE_MAST.CUPPS_AIRLINE_ID — NOT NULL
  • WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

WORKSTATION_DETAIL

  • WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_ID — NOT NULL
  • INVALID_FLAG — bit
  • 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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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 — Foreign key → SBD_AIRLINE_POLICY_MAST.SBD_AIRLINE_POLICY_ID — NOT NULL
  • CUPPS_AIRLINE_POLICY_ID — int — Foreign key → CUPPS_AIRLINE_POLICY_MAST.CUPPS_AIRLINE_POLICY_ID — NOT NULL
  • DEVICE_POLICY_ID — int — Foreign key → DEVICE_POLICY_MAST.DEVICE_POLICY_ID — NOT NULL
  • VERSION — varchar(10)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

WORKSTATION_MODEL_MAST

  • WORKSTATION_MODEL_ID — int — Primary key — NOT NULL
  • WORKSTATION_MODEL_NAME — varchar(50) — NOT NULL
  • UPDATE_DATE — datetime
  • DESCRIPTION — varchar(400)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

WORKSTATION_PARAMETER

  • SEQUENCE_NUMBER — int
  • WORKSTATION_ID — int
  • PARAMETER_ID — int
  • VALUE — varchar(400)

WORKSTATION_SBD_AIRLINE_STATUS

  • SBD_AIRLINE_ID — int — Foreign key → SBD_AIRLINE_MAST.SBD_AIRLINE_ID — NOT NULL
  • WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

WORKSTATION_SBD_AIRLINE_STATUS_HISTORY

  • CREATE_DATE — datetime — Primary key — NOT NULL
  • SBD_AIRLINE_ID — int — Foreign key → SBD_AIRLINE_MAST.SBD_AIRLINE_ID — NOT NULL
  • WORKSTATION_ID — int — Foreign key → WORKSTATION_MAST.WORKSTATION_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)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

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 — varchar(3)
  • 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
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =