WorkBook Chapter 1

Tables (11)

food_category (Untitled6)

  • id (Field) — bigint — Primary key
  • name (Field2) — varchar(20)

mission (Untitled8)

  • id (Field) — bigint — Primary key
  • store_id (Field7) — bigint — Foreign key → store.id
  • expired_date (Field3) — date
  • description (Field4) — text
  • reward_point (Field5) — int
  • created_at (Field2) — datetime(6)
  • updated_at (Field6) — datetime(6)

point (Untitled12)

  • id (Field) — bigint — Primary key
  • user_id (Field2) — bigint — Foreign key → user.id
  • mission_id (Field6) — bigint — Foreign key → mission.id
  • point_amount (Field3) — int
  • created_at (Field4) — datetime(6)
  • updated_at (Field5) — datetime(6)

region (Untitled11)

  • id (Field) — bigint — Primary key
  • name (Field2) — varchar(20)
  • created_at (Field3) — datetime(6)
  • updated_at (Field4) — datetime(6)

review (Untitled13)

  • id (Field) — bigint — Primary key
  • user_id (Field7) — bigint — Foreign key → user.id
  • store_id (Field3) — bigint — Foreign key → store.id
  • content (Field2) — text
  • star_rate (Field4) — decimal(2,1)
  • created_at (Field5) — datetime(6)
  • updated_at (Field6) — datetime(6)

review_image (Untitled14)

  • id (Field) — bigint — Primary key
  • review_id (Field3) — bigint — Foreign key → review.id
  • image_url (Field2) — text
  • created_at (Field4) — datetime(6)

store (Untitled10)

  • id (Field) — bigint — Primary key
  • region_id (Field4) — bigint — Foreign key → region.id
  • name (Field2) — varchar(20)
  • store_category (Field3) — varchar(20)
  • created_at (Field5) — datetime(6)
  • updated_at (Field6) — datetime(6)

user (Untitled5)

  • id (Field) — bigint — Primary key
  • name (Field2) — varchar(20)
  • gender (Field3) — enum(FEMALE, MALE)
  • birth_date (Field4) — date
  • address (Field5) — text
  • phone_num (Field6) — varchar(20)
  • point (Field11) — int
  • status (Field9) — int
  • inactive_date (Field10) — datetime
  • created_at (Field7) — datetime(6)
  • updated_at (Field8) — datetiem(6)

user_food_category (Untitled7)

  • id (Field) — bigint — Primary key
  • user_id (Field4) — bigint — Foreign key → user.id
  • food_id (Field5) — bigint — Foreign key → food_category.id
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

user_image (Untitled)

  • id (Field) — bigint — Primary key
  • user_id (Field4) — bigint — Foreign key → user.id
  • image_url (Field2) — text
  • created_at (Field3) — datetime(6)

user_mission (Untitled9)

  • id (Field) — bigint — Primary key
  • user_id (Field3) — bigint — Foreign key → user.id
  • mission_id (Field4) — bigint — Foreign key → mission.id
  • status (Field7) — int
  • created_at (Field5) — datetime(6)
  • updated_at (Field6) — datetime(6)