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