signal

Tables (5)

categories (카테고리)

  • id (카테고리 아이디) — Primary key — NOT NULL — 서버안에 있는 채널들을 묶는 카테고리
  • server_id — BIGINT — Foreign key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • display_order — INT

channels (채널)

  • id (채널아이디) — Primary key — NOT NULL
  • category_id (카테고리 아이디) — BIGINT — Foreign key
  • server_id (서버아이디) — BIGINT — Foreign key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(20)
  • display_order — INT

members (멤버)

  • id (멤버아이디) — BIGSERIAL — 필요한지 의문
  • server_id — BIGINT — Foreign key — NOT NULL
  • user_id — BIGINT — Foreign key — NOT NULL
  • role — VARCHAR(20)
  • joined_at — TIMESTAMP

servers (서버)

  • id (서버아이디) — Primary key — NOT NULL
  • name (서버이름) — VARCHAR(100) — NOT NULL
  • owner_id (채널주인) — BIGINT — Foreign key — NOT NULL
  • invite_code (초대코드) — VARCHAR(20) — NOT NULL
  • icon_image — TEXT
  • created_at — TIMESTAMP

users (유저)

  • id (유저아이디) — Primary key — NOT NULL
  • email (이메일) — VARCHAR(255) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • nickname (별명) — VARCHAR(50) — NOT NULL
  • profile_image — TEXT — url주소
  • created_at — TIMESTAMP