BTS
Tables (7)
BTS_BROADROOM
- BTS_BOARDROOM_NO — NUMBER — Primary key — NOT NULL
- Field — VARCHAR(255)
BTS_CHATINFO
- CHATROOM_NO — NUMBER — NOT NULL
- MEMBER_NO — NUMBER — NOT NULL
- COUNT — NUMBER
BTS_CHATROOM
- CHATROOM_NO — NUMBER — Primary key — NOT NULL
- CHATROOM_REGDATE — DATE
BTS_FAVORITES
- MEMBER_NO — NUMBER — NOT NULL
- Field — VARCHAR(255)
BTS_FRIEND
- MEMBER_NO — NUMBER — NOT NULL
- FRIEND_NO — NUMBER — NOT NULL
BTS_MEMBER
- 고유번호 (MEMBER_NO) — NUMBER — Primary key — NOT NULL
- 아이디 (MEMBER_ID) — VARCHAR2 — NOT NULL
- MEMBER_PW — VARCHAR2 — NOT NULL
- MEMBER_ENABLE — NUMBER — NOT NULL
- MEMBER_AUTHORITY — VARCHAR2 — NOT NULL
- MEMBER_NICKNAME — VARCHAR2 — NOT NULL
- MEMBER_EMAIL — VARCHAR2 — NOT NULL
- MEMBER_IMAGE — VARCHAR2
- MEMBER_REGDATE — DATE — NOT NULL
BTS_MESSAGE
- MESSAGE_NO — NUMBER — Primary key — NOT NULL
- CHATROOM_NO — NUMBER — NOT NULL
- MEMBER_NO — NUMBER — NOT NULL
- MESSAGE_CONTENT — VARCHAR2
- MESSAGE_REGDATE — DATE