UMC_W2

Tables (12)

alarm

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • type (Field) — varchar(30)
  • checked — bool
  • created_at — datetime(6)
  • updated_at — datetime(6)

food_category

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

meal

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • store_id — bigint — Foreign key → store.region_id — NOT NULL
  • paid_amount — int
  • paid_at — datetime

mission

  • id — bigint — Primary key — NOT NULL
  • region_id — bigint — Foreign key → region.id — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • tittle — varchar(40)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • started_at — datetime
  • end_at — datetime
  • is_active — boolean
  • reqiured_store_count — int
  • min_amount — int
  • point — int

point

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • point_date — datetime
  • point_num — int

preference_survey

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • food_category_id — bigint — Foreign key → food_category.id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

region

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

review

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • user_mission_id — bigint — Foreign key → user_mission.mission_id — NOT NULL
  • review_ image_id — bigint — Foreign key → user_mission.review_id — NOT NULL
  • content — text
  • score — int
  • created_at — datetime(6)
  • updated_at — datetime(6)

review_image

  • id — bigint — Primary key — NOT NULL
  • review_id — bigint — Foreign key → review.user_id — NOT NULL
  • image_url (imgae_url) — varchar(50)
  • created_at — datetime(6)
  • updated_at — datetime(6)

store

  • id — bigint — Primary key — NOT NULL
  • region_id — bigint — Foreign key → region.id — NOT NULL
  • name — varchar(20)
  • address — varchar(30)
  • oper_time — json
  • created_at — datetime(6)
  • updated_at — datetime(6)

user

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • gender — varchar(10)
  • birth — date
  • address — varchar(30)
  • agree — boolean
  • status — varchar(15)
  • inactive_date — datetime
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • point — int
  • password — varchar(255)

user_mission

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL
  • review_id — bigint — Foreign key → mission.store_id — NOT NULL
  • status — varchar(20)
  • progress_count — int
  • created_at — datetime