예약/반납

테이블 (4)

alpha-tas2 (tb_company)

  • COMPANY_ID (Key) — varchar(40) — 기본 키 — NOT NULL
  • DISPLAY_NAME (Field) — varchar(40)
  • CREATE_DATETIME (Field2) — datetime
  • CREATE_USER_ID (Field3) — varchar(40)
  • UPDATE_DATETIME (Field4) — datetime
  • UPDATE_USER_ID (Field5) — varchar(40)

alpha-tas2 (tb_device_temp)

  • DEVICE_ID (Key) — varchar(40) — 기본 키 — NOT NULL
  • DEVICE_NAME (Field) — varchar(100)
  • DEVICE_MODEL (Field2) — varchar(50)
  • DEVICE_OS (Field3) — varchar(20)
  • DEVICE_OS_VERSION (Field4) — varchar(45)
  • ADID (Field5) — varchar(50)
  • RESERVATION_STATUS (Field6) — char(1)
  • STATUS (Field7) — char(1)
  • CONNECT_YN (Field8) — char(1)
  • BATTERY_STATUS (Field9) — int(10) unsigned
  • DEVICE_MANAGER (Field10) — varchar(45)
  • USE_YN (Field11) — char(1)
  • IP (Field12) — varchar(45)
  • PORT (Field13) — varchar(45)
  • LAST_PACKAGE_NAME (Field14) — varchar(50)
  • FIX_PACKAGE_NAME (Field15) — varchar(50)
  • LAST_USER_SEQ (Field16) — int(11)
  • UPDATE_DATETIME (Field17) — datetime
  • FREE_MEMORY (Field18) — int(10)
  • COMPANY_ONLY (Field19) — char(1)
  • COMPANY_RESERVATION_STATUS (Field20) — char(1)

alpha-tas2 (tb_company_device_pool)

  • COMPANY_DEVICE_SEQ (Key) — bigint(20) unsigned auto_increment — 기본 키 — NOT NULL
  • COMPANY_ID (Key2) — varchar(40) — 외래 키 → alpha-tas2.COMPANY_ID — NOT NULL
  • GAME_CODE (Key4) — varchar(50) — 외래 키 → common_origin.GAME_CODE — NOT NULL
  • DEVICE_ID (Key3) — varchar(40) — 외래 키 → alpha-tas2.DEVICE_ID — NOT NULL
  • START_DATETIME (Field) — datetime
  • END_DATETIME (Field2) — datetime
  • CREATE_DATETIME (Field3) — datetime
  • CREATE_USER_ID (Field4) — varchar(40)
  • UPDATE_DATETIME (Field5) — datetime
  • UPDATE_USER_ID (Field6) — varchar(40)
  • COMPANY_RESERVATION_STATUS (Field7) — char(1)

common_origin (tb_board_project_temp)

  • GAME_CODE (Key) — varchar(50) — 기본 키 — NOT NULL
  • COMPANY_ID (varchar(40)) — varchar(40) — 외래 키 → alpha-tas2.COMPANY_ID — NOT NULL
  • PACKAGE_NAME (Field) — varchar(50)
  • DISPLAY_NAME (Field2) — varchar(100)
  • CREATE_DATETIME (Field3) — datetime
  • UPDATE_DATETIME (Field4) — datetime