UMC_11th

Tables (9)

favor_food_category (Untitled3)

  • id (Key3) — bigint — Primary key — NOT NULL
  • user_id (Key) — bigint — Foreign key → user.id — NOT NULL
  • food_category_id (Key2) — bigint — Foreign key → food_category.id — NOT NULL

food_category (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — vachar(40)

mission (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • prcie (Field) — int
  • point (Field2) — int
  • passkey (Field3) — varchar(10) — NOT NULL
  • restaurant_id (Key2) — bigint — Foreign key → restaurant.id — NOT NULL

point_recipt (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • add (Field) — int
  • reason (Field2) — archer(40)

restaurant (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — vachar(40)
  • run_time (Field2) — vachar(40)
  • r_address (Field3) — vachar(40)
  • food_category_id (Key2) — bigint — Foreign key → food_category.id — NOT NULL

review (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • restaurant_id (Key3) — bigint — Foreign key → restaurant.id — NOT NULL
  • text (Field) — varchar(1000) — NOT NULL
  • score (Field2) — float — NOT NULL
  • created_at (Field3) — datetime — NOT NULL

user (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — vachar(40) — NOT NULL
  • gender (Field2) — vachar(10)
  • birth (Field3) — datetime
  • u_address (Field4) — varcher(40)
  • point (Field5) — int — NOT NULL
  • delete_at (Field6) — datetime

user_10mission (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • count (Field) — int
  • region (Field2) — archer(40)
  • updated_at (Field3) — datetime(6)

user_mission (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
  • progress (Field) — int
  • over_time (Field2) — datetime
  • mission_id (Key3) — bigint — Foreign key → mission.id — NOT NULL