ITWILL_1ST

Tables (11)

CHATMESSAGE

  • CHATTINGMESSAGE_ID — NUMBER
  • CHATTINGROOM_ID — NUMBER — NOT NULL
  • UNAME1 — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(4000)
  • REGDATE — DATE

CHATTINGLIST

  • CHATTINGLIST_ID — NUMBER
  • CHATTINGROOM_ID — NUMBER — NOT NULL
  • UNAME1 — NUMBER — NOT NULL
  • UNAME2 — NUMBER — NOT NULL

CHATTINGROOM

  • CHATTINGROOM_ID — NUMBER
  • ROOMNAME — VARCHAR2(100) — NOT NULL
  • UNAME1 — NUMBER — NOT NULL
  • UNAME2 — NUMBER — NOT NULL

ChattingList

  • ChattingList_ID — INT — Primary key — NOT NULL
  • UID — INT — Foreign key → User.UID — NOT NULL
  • ChattingRoom_ID — INT — Foreign key → ChattingRoom.ChattingRoom_ID — NOT NULL

ChattingMessage

  • ChattingMessage_ID — INT — Primary key — NOT NULL
  • ChattingRoom_ID — INT — Foreign key → ChattingRoom.ChattingRoom_ID — NOT NULL
  • Content — VARCHAR2(500)
  • RegDate (Date) — SYSDATE

ChattingRoom

  • ChattingRoom_ID — INT — Primary key — NOT NULL
  • UID — INT — Foreign key → User.UID — NOT NULL
  • UID (UID2) — INT — Foreign key → User.UID — NOT NULL
  • ChattingName — VARCHAR2(100) — NOT NULL

MEMBER

  • ID — NUMBER
  • NAME — VARCHAR2(100) — NOT NULL

MULTICHATMESSAGE

  • MULTICHATTINGMESSAGE_ID — NUMBER
  • MULTICHATTINGROOM_ID — NUMBER — NOT NULL
  • UNAME1 — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(4000)
  • REGDATE — DATE

MULTICHATTINGLIST

  • MULTICHATTINGLIST_ID — NUMBER
  • MULTICHATTINGROOM_ID — NUMBER — NOT NULL
  • ID — NUMBER — NOT NULL

MULTICHATTINGROOM

  • MULTICHATTINGROOM_ID — NUMBER
  • MULTIROOMNAME — VARCHAR2(100) — NOT NULL

User

  • UID — INT — Primary key — NOT NULL
  • Name — VARCHAR2(50) — NOT NULL
  • NickName — VARCHAR2(50) — NOT NULL
  • Pw — VARCHAR2(100) — NOT NULL