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