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 — 채팅방이름