UMC_Week1

Tables (12)

Untitled (review)

  • Key (id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL
  • id (store_id) — bigint — Foreign key → stores.id — NOT NULL
  • Field (rating) — int
  • Field (description) — text
  • Field (created_at) — datetime(6)

Untitled (user_mission)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL
  • id (mission_id) — bigint — Foreign key → missions.id — NOT NULL
  • Field (status) — varchar(20)

Untitled (alarm)

  • Key (id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL
  • Field (is_confirmed) — boolean
  • Field (created_at) — datetime(6)
  • Field (dtype) — varchar(20)
  • Field (title) — varchar(30)
  • Field (body) — text

Untitled (review_comment)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (body) — text
  • Field (created_at) — datetime(6)

Untitled (review_images)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — varchar(2048)
  • Field (created_at) — datetime(6)

Untitled (inquiry)

  • Key (id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL
  • Field (title) — varchar(100)
  • Field (created_at) — datetime(6)
  • Field (status) — varchar(10)

Untitled (inquiry_images)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (inquiry_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — varchar(2048)
  • Field (created_at) — datetime(6)

food_category (category)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(60)

missions

  • id — bigint — Primary key — NOT NULL
  • id (store_id) — bigint — Foreign key → stores.food_category_id — NOT NULL
  • description — text
  • point — int
  • Field (expired_at) — date

stores (store)

  • id — bigint — Primary key — NOT NULL
  • food_category_id (category_id) — bigint — Foreign key → food_category.id — NOT NULL
  • id (owner_id) — bigint — Foreign key → user.id — NOT NULL
  • name — varchar(100)
  • address — varchar(255)
  • status — varchar(20)

user

  • id — bigint — Primary key — NOT NULL
  • name — varchar(30)
  • birth — date
  • gender — varchar(10)
  • Field (email) — varchar(30)
  • Field (phone_num) — varchar(15)
  • address — varchar(255)
  • Field (role) — varchar(10)
  • Field (point) — int
  • agree_location — boolean
  • agree_marketing — boolean
  • created_at — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (status) — varchar(20)
  • Field (inactive_date) — datetime
  • Field (alarm_new_event) — boolean
  • Field2 (alarm_comment) — boolean
  • Field3 (alarm_inquiry) — boolean

user_preferred_food_category (user_prefer_category)

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • food_category_id (category_id) — bigint — Foreign key → food_category.id — NOT NULL