umc-chapter1

Tables (8)

Untitled (user)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(10) — NOT NULL
  • Field2 (gender) — ENUM('MAN', 'WOMAN') — NOT NULL
  • Field3 (birth) — DATE — NOT NULL
  • Field4 (address) — VARCHAR(100) — NOT NULL
  • Field (point) — INT — NOT NULL
  • Field5 (created_at) — DATETIME(6) — NOT NULL
  • Field6 (updated_at) — DATETIME(6)

Untitled (category)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(10) — NOT NULL

Untitled (store)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL
  • Field (address) — VARCHAR(100) — NOT NULL
  • Field (image_url) — VARCHAR(100)

Untitled (mission)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (cost) — INT — NOT NULL
  • Field (point) — INT — NOT NULL
  • Field (expire_date) — DATETIME — NOT NULL

Untitled (favorite_category)

  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (accepted_mission)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (mission_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — ENUM('PENDING', 'COMPLETE') — NOT NULL

Untitled (review)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — VARCHAR(500) — NOT NULL
  • Field (rating) — VARCHAR(5) — NOT NULL

Untitled (review_image)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (review_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — VARCHAR(100) — NOT NULL