umc_9th

Tables (8)

food_category

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

member (user)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(10)
  • gender — int
  • address — varchar(40)
  • birth — datetime
  • create_at — datetime(6)
  • update_at — datetime(6)
  • status — int
  • inactive_date — datetime
  • point — bigint
  • email — varchar(40)
  • Field (phone_number) — int
  • Field (nickname) — varchar(40)

member_mission (user_mission)

  • id — bigint — Primary key — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL
  • member_id (user_id) — bigint — Foreign key → member.id — NOT NULL
  • status — int
  • create_at — datetime(6)
  • update_at — datetime(6)

member_prefer (user_prefer)

  • id — bigint — Primary key — NOT NULL
  • member_id (user_id) — bigint — Foreign key → member.id — NOT NULL
  • category_id — bigint — Foreign key → food_category.id — NOT NULL
  • create_at — datetime(6)
  • update_at — datetime(6)

mission

  • id — bigint — Primary key — NOT NULL
  • id (store_id) — bigint — Foreign key → store.id — NOT NULL
  • reward — int
  • deadline — datetime
  • mission_spec — varchar(255)
  • create_at — datetime(6)
  • update_at — datetime(6)

region

  • id — bigint — Primary key — NOT NULL
  • name — varchar(50)
  • create_at — datetime(6)
  • update_at — datetime(6)

review

  • id — bigint — Primary key — NOT NULL
  • member_id (user_id) — bigint — Foreign key → member.id — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • body — varchar(255)
  • score — float

store

  • id — bigint — Primary key — NOT NULL
  • region_id — bigint — Foreign key → region.id — NOT NULL
  • name — varchar(40)
  • score — float
  • address — varchar(255)
  • create_at — datetime(6)
  • update_at — datetime(6)