Project_AGORA_0.2
Tables (12)
BLOCK
- Key (USER) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Key (BLOCKED_USER) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
CHANNEL
- Key (CHANNEL_ID) — CHAR(36) — Primary key — NOT NULL
- Key (SERVER_ID) — CHAR(36) — Foreign key → SERVER.Key — NOT NULL
- Field (CHANNEL_NAME) — VARCHAR2(20)
- Field (CHANNEL_TYPE) — ENUM
CHANNEL_MSG
- Key (SERVER_ID) — CHAR(36) — Foreign key → SERVER.Key — NOT NULL
- Key (CHANNEL_ID) — CHAR(36) — Foreign key → CHANNEL.Key — NOT NULL
- Key (SENDER) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Field (TYPE) — ENUM
- Field (CREATE_AT) — DATE
- Field (CONTENT) — VARCHAR2(1000)
DM
- Key (SENDER) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Key (RECIPIENT) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Field (TYPE) — ENUM
- Field (CONTENT) — VARCHAR2(1000)
- Field (CREATE_AT) — DATE
FRIEND
- Key (SENDER) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Key (RECIPIENT) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Field (STATUS) — ENUM — 'PENDING', 'ACCEPTED', 'BLOCKED'
- Field (CREATE_AT) — DATE
ROLE_PERMISSION
- Key (ROLE_ID) — CHAR(36) — Foreign key → SERVER_ROLE.Key — NOT NULL
- Key (SERVER_ID) — CHAR(36) — Foreign key → SERVER_ROLE.Key — NOT NULL
- Field (CATEGORY) — ENUM — 'SERVER', 'CHANNEL'
- Key (CHANNEL_ID) — CHAR(36) — Foreign key → CHANNEL.Key — NOT NULL
- Field (PERMISSION_CODE) — ENUM — *CATEGORY -SERVER ADMIN : 서버 규칙 변경 가능 MANAGER : 유저 초대 및 방출 가능, 채널 생성 및 삭제 가능 -CHANNEL MEMBER : 읽기+쓰기 가능 READ_ONLY : 읽기…
SERVER
- Key (SERVER_ID) — CHAR(36) — Primary key — NOT NULL
- Field (SERVER_PW) — VARCHAR2(20)
- Field (SERVER_NAME) — VARCHAR2(20)
- Field (SERVER_IMG) — VARCHAR2(100)
- Field (SERVER_DESCRIPTION) — VARCHAR2(200)
- Field (JOIN_TYPE) — ENUM
- Field (CREATE_AT) — DATE
SERVER_BLOCK
- Key (SERVER_ID) — CHAR(36) — Foreign key → SERVER.Key — NOT NULL
- Key (BLOCKED_USER) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
SERVER_MEMBER
- Key (SERVER_ID) — CHAR(36) — Foreign key → SERVER_ROLE.Key — NOT NULL
- Key (MEMBER_ID) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Key (ROLE_ID) — CHAR(36) — Foreign key → SERVER_ROLE.Key — NOT NULL
- Field (STATUS) — ENUM
SERVER_ROLE
- Key (ROLE_ID) — CHAR(36) — Primary key — NOT NULL
- Key (SERVER_ID) — CHAR(36) — Foreign key → SERVER.Key — NOT NULL
- Field (ROLE_NAME) — VARCHAR2(20)
- Field (ROLE_IMG) — VARCHAR2(100)
USER_PERMISSION
- Key (ID) — VARCHAR2(20) — Foreign key → User.Key — NOT NULL
- Field (PERMISSION) — ENUM — 'BANNED', 'ADMIN' 일반 유저의 경우 테이블에 등록되있지않음.
User
- Key (ID) — VARCHAR2(20) — Primary key — NOT NULL
- Field (PW) — VARCHAR2(20)
- Field (CREATE_AT) — DATE
- Field (NAME) — VARCHAR2(20)
- Field (PROFILE_IMG) — VARCHAR2(100)
- Field (STATUS_MSG) — VARCHAR2(100)
- Field (LAST_LOGINNED) — DATE
- Field (email) — VARCHAR2(30)