MVP

Tables (11)

Untitled (user)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(50)
  • Field2 (gender) — varchar(1)
  • Field3 (birth) — date
  • Field4 (address) — varchar(50)
  • Field5 (sns_email) — varchar(20)
  • Field (status) — enum('noraml', 'withdrawn')
  • Field2 (withdraw_at) — datetime(1)
  • Field (signup_at) — datetime(6)
  • Field (total_point) — int
  • Field (phone_number) — int

Untitled (favorite_food)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (favorite_food) — enum

Untitled (mission)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — varchar(100)
  • Field (created_at) — datetime(6)
  • Field2 (updated_at) — datetime(6)
  • Field (expire_at) — datetime(6)
  • Field (point) — int

Untitled (store)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (favorite_food_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(50)
  • Field (created_at) — datetime(6)
  • Field2 (updated_at) — datetime(6)
  • Field

Untitled (region)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(50)

Untitled (user_region_point)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (clear_count) — int
  • Field (reward_received_count) — int

Untitled (user_mission)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — enum('completed', 'uncompleted')
  • Field2 (completed_at) — datetime(6)

Untitled (review)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (rating) — float
  • Field2 (comment) — text
  • Field3 (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

Untitled (inquiry)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(100)
  • Field2 (comment) — text
  • Field3 (created_at) — datetime(6)
  • Field (reply_at) — datetime(6)

Untitled (inquiry_reply)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (inquiry_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (reply) — comment

Untitled (review_reply)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — text