test

테이블 (4)

Copy Of Copy Of RS_ROOMLIST(방 정보) (RS_USER(유저))

  • Key (USER_ID) — varchar(36) — 기본 키 — NOT NULL
  • Field2 (USER_NO) — int(20) — NOT NULL
  • Field (USER_PASSWORD) — varchar(256) — NOT NULL
  • Field3 (USER_LEVEL) — varchar(16) — NOT NULL
  • Field (USER_JOINDATE) — datetime
  • Field (USER_TOKEN) — varchar(256) — NOT NULL
  • Field (USER_ISCODE) — int(1) — NOT NULL
  • Field (SOFTDELETE) — int(1) — NOT NULL

Copy Of RS_ROOMLIST(방 정보) (RS_LED (LED제어 설정))

  • Key (ROOM_INDEX) — int(36) — 기본 키 — NOT NULL
  • Field (ROOM_NUM) — int(36) — NOT NULL
  • Field (ROOM_LOCATION) — int(2) — NOT NULL
  • Field2 (COLOR_R) — int(3) — NOT NULL
  • Field3 (COLOR_G) — int(3) — NOT NULL
  • Field (COLOR_B) — int(3) — NOT NULL
  • Field (ROOM_OBJECT) — int(1) — NOT NULL

Copy Of RS_ROOMLIST(방 정보) (RS_ADMINCODE(어드민 코드))

  • Key (CODE_INDEX) — int(20) — 기본 키 — NOT NULL
  • Field (CODE_REGISTER) — int(1)
  • Field2 (REGISTRATION_DATE) — datetime
  • Field3 (CODE_DURATION) — int(3) — NOT NULL
  • Field (CREATE_DATE) — datetime — NOT NULL
  • Field (EXPIRY_DATE) — datetime — NOT NULL
  • Field (CODE_CLASS) — int(10) — NOT NULL
  • Field (USER_ID) — varchar(36)
  • Field (CODE_NUM) — varchar(16) — NOT NULL
  • Field (SOFTDELETE) — int(1) — NOT NULL

RS_ROOMLIST(방 정보)

  • Key (ROOM_NUM) — int(36) — 기본 키 — NOT NULL
  • Key (USER_ID) — varchar(36) — 기본 키 — NOT NULL
  • Field (TEMA) — int(3) — NOT NULL
  • Field2 (SCORE_STANDARD) — int(3) — NOT NULL
  • Field3 (ROOM_NAME) — varchar(36) — NOT NULL
  • Field (ROOM_PASSWORD) — varchar(36) — NOT NULL
  • Field (ROOM_INDEX) — int(36) — NOT NULL
  • Field (SOFTDELETE) — int(1) — NOT NULL