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