Chapter 1 Mission

Tables (9)

User (Untitled)

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6)
  • uid — varchar(20)
  • password — varchar(20)
  • email — varchar(30) — NOT NULL
  • gender — varchar(10) — NOT NULL
  • birth — date — NOT NULL
  • address — varchar(30) — NOT NULL
  • point — int
  • status — varchar(15) — NOT NULL
  • inactivate_date — datetime

mission (Untitled3)

  • id — bigint — Primary key — NOT NULL
  • user_id (id2) — bigint — Foreign key → User.id — NOT NULL
  • restaurant_id (id3) — bigint — Foreign key → restaurant.id — NOT NULL
  • point — int
  • meal_price — int
  • due_date — date
  • status — varchar(15) — NOT NULL
  • identification_number — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)

notification (Untitled7)

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.id — NOT NULL
  • type — varchar(30)
  • is_read — boolean
  • created_at — datetime(6)

point_history (Untitled8)

  • id — bigint — Primary key — NOT NULL
  • user_id (id2) — bigint — Foreign key → User.id — NOT NULL
  • amount — int
  • type — varchar(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)

preference_category (Untitled2)

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

restaurant (Untitled6)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(30)
  • category (Field) — varchar(30)
  • address — varchar(50)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • image — varchar(50)

review (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • mission_id (id2) — bigint — Foreign key → mission.id — NOT NULL
  • user_id (id22) — bigint — Foreign key → mission.user_id — NOT NULL
  • restaurant_id (id3) — bigint — Foreign key → mission.restaurant_id — NOT NULL
  • rating — float
  • content — text
  • created_at — datetime(6)
  • updated_at — datetime(6)

review_img (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • review_id (id) — bigint — Foreign key → review.id — NOT NULL
  • mission_id (id2) — bigint — Foreign key → review.mission_id — NOT NULL
  • user_id (id22) — bigint — Foreign key → review.user_id — NOT NULL
  • restaurant_id (id3) — bigint — Foreign key → review.restaurant_id — NOT NULL
  • Field — varchar(255)
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

user_preference (Untitled5)

  • id — bigint — Primary key — NOT NULL
  • category_id (id2) — bigint — Foreign key → preference_category.id — NOT NULL
  • user_id (id3) — bigint — Foreign key → User.id — NOT NULL