prac1

Tables (11)

food_category

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

mission

  • id — bigint — Primary key — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • region_id — bigint — Foreign key → store.region_id — NOT NULL
  • reward — int
  • deadline — datetime
  • detail — text
  • created_at — datetime(6)
  • updated_at — datetime(6)

region

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

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
  • region_id — bigint — Foreign key → store.region_id — NOT NULL
  • score — float
  • detail — text

review_image

  • id — bigint — Primary key — NOT NULL
  • review_id — bigint — Foreign key → review.id — NOT NULL
  • user_id — bigint — Foreign key → review.user_id — NOT NULL
  • store_id — bigint — Foreign key → review.store_id — NOT NULL
  • region_id — bigint — Foreign key → review.region_id — NOT NULL
  • image_url — text
  • 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(50)
  • address — varchar(50)
  • score — float
  • created_at — datetime(6)
  • updated_at — datetime(6)

terms

  • id — bigint — Primary key — NOT NULL
  • title — varchar(20)
  • body — varchar(20)
  • agree_status — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)

user

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • gender — varchar(10)
  • age — int
  • address — varchar(50)
  • address_detailed — varchar(50)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • email — varchar(30)
  • point — int

user_agree

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

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
  • store_id — bigint — Foreign key → mission.store_id — NOT NULL
  • id (id2) — bigint — Foreign key → mission.region_id — NOT NULL
  • status — varchar(10)
  • Field

user_prefer

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