whenwhen
Tables (5)
Copy Of Untitled (users)
- Key (id) — INT — Primary key — NOT NULL — AUTO_INCREMENT
- Field (account_name) — VARCHAR(50) — NOT NULL
- Field (email) — VARCHAR(255) — NOT NULL
- Field (thumbnail_image_url) — VARCHAR(255)
- Field (created_at) — TIMESTAMP — NOT NULL
Copy Of Untitled2 (refresh_tokens)
- Key (id) — INT — Primary key — NOT NULL — AUTO_INCREMENT
- Key (user_id) — INT — Foreign key → Copy Of Untitled.Key — NOT NULL — AUTO_INCREMENT
- Field (refresh_token) — VARCHAR(255) — NOT NULL
Untitled (events)
- Key (id) — INT — Primary key — NOT NULL — AUTO_INCREMENT
- Field (title) — VARCHAR(100) — NOT NULL
- Field2 (code) — VARCHAR(255) — NOT NULL — unique
- Field (start_hour) — INT — NOT NULL
- Field (end_hour) — INT — NOT NULL
- Field2 (status) — ENUM('active', 'completed') — NOT NULL
- Field5 (created_at) — TIMESTAMP — NOT NULL
Untitled (dates)
- Key (id) — INT — Primary key — NOT NULL — AUTO_INCREMENT
- Key (event_id) — INT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT
- Field (date) — DATE — NOT NULL
event_participants
- participant_id (id) — INT — Primary key — NOT NULL — AUTO_INCREMENT
- Key (event_id) — INT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT
- Key (kakao_user_id) — INT — Foreign key → Copy Of Untitled.Key — AUTO_INCREMENT
- Field (nickname) — VARCHAR(100) — NOT NULL
- Field (time_slots) — TEXT — bit text
- joined_at — TIMESTAMP — NOT NULL