예약/반납
테이블 (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