trello
Tables (8)
alarm (알람)
- id (Key) — number — Primary key — NOT NULL
- user_id (Key2) — number — Foreign key → users.id — NOT NULL
- message (Field) — string
boards (보드)
- id (Key) — number — Primary key — NOT NULL
- title (Field) — string
- background (Field2) — string
- description (Field3) — string
- creator (Field4) — number
cards (카드)
- id (Key) — number — Primary key — NOT NULL
- column_id (Key4) — number — Foreign key → columns.id — NOT NULL
- previous_id (Key2) — number — Foreign key → cards.id — NOT NULL
- next_id (Key3) — number — Foreign key → cards.id — NOT NULL
- user_id (Key5) — number — Foreign key → users.id — NOT NULL
- title (Field) — string
- content (Field3) — string
- color (Field4) — string
- deadline (Field2) — Date
columns (컬럼)
- id (Key) — number — Primary key — NOT NULL
- board_id (Key4) — number — Foreign key → boards.id — NOT NULL
- previous_id (Key2) — number — Foreign key → columns.id — NOT NULL
- next_id (Key3) — number — Foreign key → columns.id — NOT NULL
- title (Field) — string
- sort (Field2) — string
comments (댓글)
- id (Key) — number — Primary key — NOT NULL
- user_id (Key2) — number — Foreign key → users.id — NOT NULL
- content (Field) — string
invite (초대)
- id (Key) — number — Primary key — NOT NULL
- user_id (Key2) — number — Foreign key → users.id — NOT NULL
- board_id (Key3) — number — Foreign key → boards.id — NOT NULL
user_board (사용자&보드)
- id (Key) — number — Primary key — NOT NULL
- user_id (Key2) — number — Foreign key → users.id — NOT NULL
- board_id (Key3) — number — Foreign key → boards.id — NOT NULL
users (사용자)
- id (Key) — number — Primary key — NOT NULL
- email (Field) — string
- password (Field2) — string
- name (Field3) — string
- currentRefreshToken (Field4) — string