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