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