UMC

Tables (6)

mission

  • mission_idx — BIGINT — Primary key — NOT NULL
  • store_idx (sotre_idx) — BIGINT — Foreign key → store.store_idx — NOT NULL
  • mission_type (Field) — varchar(15) — NOT NULL

review

  • review_idx — BIGINT — Primary key — NOT NULL
  • mission_idx (mission_idx2) — BIGINT — Foreign key → user_mission.mission_idx — NOT NULL
  • store_idx (sotre_idx) — BIGINT — Foreign key → store.store_idx — NOT NULL
  • title — varchar(15) — NOT NULL
  • content — text

store

  • store_idx (sotre_idx) — BIGINT — Primary key — NOT NULL

udrees (udress)

  • user_id (Key) — BIGINT — Foreign key → user.user_id — NOT NULL
  • city — varchar(15)
  • state — varchar(15) — NOT NULL

user

  • user_id (Key) — BIGINT — Primary key — NOT NULL
  • user_name — varchar(15) — NOT NULL
  • user_pw — varchar(45) — NOT NULL
  • gender — varchar(10)
  • phone_number — varchar(15) — NOT NULL

user_mission

  • user_mission_idx (mission_idx) — BIGINT — Primary key — NOT NULL
  • user_id (Key) — BIGINT — Foreign key → user.user_id — NOT NULL
  • mission_idx (Key2) — BIGINT — Foreign key → mission.mission_idx — NOT NULL
  • store_idx (sotre_idx) — BIGINT — Foreign key → mission.store_idx — NOT NULL