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