Food-mission-app

Tables (11)

favorite_category

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

food_category

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

inquiry

  • id — bigint — Primary key — NOT NULL
  • type — varchar(10)
  • title — text
  • content — text
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • status — tinyint(2)
  • member_id — bigint — Foreign key → member.id — NOT NULL

inquiry_image

  • id — bigint — Primary key — NOT NULL
  • image — text
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • status — tinyint(2)
  • inquiry_id — bigint — Foreign key → inquiry.id — NOT NULL

member

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • nickname — varchar(20) — NOT NULL
  • gender — tinyint(1) — NOT NULL
  • birthday — datetime() — NOT NULL
  • address — text — NOT NULL
  • phone_no — varchar(11)
  • point — int — NOT NULL
  • login_method — varchar(10)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • status — varchar(10) — NOT NULL
  • inactive_date — datetime()

menu

  • id — bigint — Primary key — NOT NULL
  • name — varchar(30)
  • descript — text
  • price — int
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL

mission

  • id — bigint — Primary key — NOT NULL
  • price — int — NOT NULL
  • point — int — NOT NULL
  • location — text
  • due_date — datetime()
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL

my_mission

  • id — bigint — Primary key — NOT NULL
  • status — tinyint(2)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL

restaurant

  • id — bigint — Primary key — NOT NULL
  • name — varchar(30) — NOT NULL
  • address — text — NOT NULL
  • status — varchar(20) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • food_category_id — bigint — Foreign key → food_category.id — NOT NULL

review

  • id — bigint — Primary key — NOT NULL
  • review_text — text
  • score — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL

review_image

  • id — bigint — Primary key — NOT NULL
  • image — text
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • review_id — bigint — Foreign key → review.id — NOT NULL