chaterd
Tables (3)
CHATMESSAGE
- WIRTER — VARCHAR2(30) — Foreign key → CHATWRITER.WIRTER — NOT NULL — 작성자
- ROOMID — VARCHAR2(10) — Foreign key → ChatRoom.ROOMID — NOT NULL — 채팅방번호
- MESSAGE — VARCHAR2(300) — NOT NULL — 채팅 내용
- CDATE — TIMESTAMP — NOT NULL — 작성 시간
CHATWRITER
- WIRTER — VARCHAR2(30) — Primary key — NOT NULL — 작성자
ChatRoom
- ROOMID — VARCHAR2(10) — Primary key — NOT NULL — 채팅방번호
- WIRTER — VARCHAR2(30) — Foreign key → CHATWRITER.WIRTER — NOT NULL — 작성자
- ROOMNAME — VARCHAR2(50) — NOT NULL — 채팅방이름