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