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)