homebody

Tables (3)

Untitled (user)

  • Key (id) — Primary key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime — NOT NULL
  • Field (email) — NOT NULL
  • Field (password) — NOT NULL
  • Field (nickname) — NOT NULL
  • Field (contact) — NOT NULL

Untitled (party)

  • Key (id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime — NOT NULL
  • Field (type) — enum — NOT NULL — 모집 or 대여
  • Field (num_of_people) — int — NOT NULL
  • Field (start_date) — datetime — NOT NULL
  • Field (end_date) — datetime
  • Field (cost) — int — NOT NULL
  • Field (ott) — enum — NOT NULL
  • Field (is_completed) — boolean — NOT NULL
  • Field (title) — text — NOT NULL
  • Field (content) — text — NOT NULL

Untitled (participate)

  • Key (id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (party_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime — NOT NULL
  • Field (is_selected) — boolean — NOT NULL