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