umc

Tables (10)

agreement_term (Untitled10)

  • id — BIGINT — Primary key — NOT NULL
  • user_agreement_term_id — BIGINT — Foreign key → user_agreement_term.id — NOT NULL
  • user_id — BIGINT — Foreign key → user_agreement_term.user_id — NOT NULL
  • name — VARCHAR
  • info — TEXT

fav_food (Untitled3)

  • id — INT — Primary key — NOT NULL
  • user_fav_food_id — BIGINT — Foreign key → user_fav_food.id — NOT NULL
  • food_name — VARCHAR

mission (Untitled4)

  • id — BIGINT — Primary key — NOT NULL
  • mission_name — VARCHAR
  • mission_point — INT

review (Untitled7)

  • id — BIGINT — Primary key — NOT NULL
  • user_id (user_Id) — BIGINT — Foreign key → user.id — NOT NULL
  • store_Id (store_id) — BIGINT — Foreign key → store.id — NOT NULL
  • content — VARCHAR
  • rate — TINYINT

review_image (Untitled8)

  • id — BIGINT — Primary key — NOT NULL
  • review_id — BIGINT — Foreign key → review.id — NOT NULL
  • id (id2) — BIGINT — Foreign key → review.user_id — NOT NULL
  • id (id22) — BIGINT — Foreign key → review.store_Id — NOT NULL
  • img_uri — TEXT

store (Untitled6)

  • id — BIGINT — Primary key — NOT NULL
  • store_name — VARCHAR
  • address1 — VARCHAR
  • address2 — VARCHAR
  • address3 — VARCHAR
  • open_time — VARCHAR
  • end_time — VARCHAR
  • category — TINYINT

user (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • gender — VARCHAR
  • birtch — VARCHAR
  • address1 — VARCHAR
  • address2 — VARCHAR
  • socialType — TINYINT
  • pont (point) — INT
  • account_status — TINYINT

user_agreement_term (Untitled9)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • agreement_id (agreement_Id) — BIGINT

user_fav_food (Untitled2)

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • userId — BIGINT
  • foodId — BIGINT

user_mission (Untitled5)

  • id — BIGINT — Primary key — NOT NULL
  • mission_Id (mission_id) — BIGIN — Foreign key → mission.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • success_status — TINYINT
  • due_date — VARCHAR