messenger

Tables (5)

TBL_CHAT_MESSAGE (Untitled3)

  • 메세지ID (CHAT_MESSAGE_ID) — NUMBER — Primary key — NOT NULL
  • 메세지 타입 (MESSAGE_TYPE) — VARCHAR2(20) — MESSAGE, SYSTEM, ENTER, LEAVE
  • 메세지 내용 (CONTENT) — CLOB
  • 전송 시간 (SENT_AT) — DATE
  • 아카이브 여부 (IS_ARCHIVED) — CHAR(1) — Y, N
  • 방ID (CHAT_ROOM_ID) — NUMBER — Foreign key → TBL_CHAT_ROOM.방ID — NOT NULL
  • 유저ID (USER_ID) — VARCHAR2(50) — Foreign key → TBL_USER.유저ID — NOT NULL

TBL_CHAT_MESSAGE_READ (Untitled4)

  • 읽은시간 (READ_AT) — DATE
  • 유저ID (USER_ID) — VARCHAR2(50) — Foreign key → TBL_USER.유저ID — NOT NULL
  • 메세지ID (CHAT_MESSAGE_ID) — VARCHAR2(50) — Foreign key → TBL_CHAT_MESSAGE.메세지ID — NOT NULL

TBL_CHAT_ROOM (Untitled2)

  • 방ID (CHAT_ROOM_ID) — NUMBER — Primary key — NOT NULL
  • 방 이름 (CHAT_ROOM_NAME) — VARCHAR2(50) — NOT NULL
  • 요약 컨텍스트 (SUMMARY) — CLOB
  • 생성일 (CREATED_AT) — DATE

TBL_CHAT_ROOM_USER (Untitled5)

  • 채팅방-사용자 연결ID (CHAT_ROOM_USER_ID) — NUMBER — Primary key — NOT NULL
  • 입장시간 (JOINED_AT) — DATE
  • 퇴장시간 (LEFT_AT) — DATE
  • 접속여부 (IS_CONNECTED) — CHAR(1) — Y, N
  • 방ID (CHAT_ROOM_ID) — NUMBER — Foreign key → TBL_CHAT_ROOM.방ID — NOT NULL
  • 유저ID (USER_ID) — VARCHAR2(50) — Foreign key → TBL_USER.유저ID — NOT NULL

TBL_USER (Untitled)

  • 유저ID (USER_ID) — VARCHAR2(50) — Primary key — NOT NULL
  • 유저 이름 (USER_NAME) — VARCHAR2(50) — NOT NULL
  • 비밀번호 (USER_PASSWORD) — VARCHAR2(255) — NOT NULL
  • 생성일 (CREATED_AT) — DATE