UMC-5th-MissonDB

Tables (5)

Untitled (store)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(30)
  • Field (address) — varchar(50)
  • Field (score) — float

Untitled (review)

  • Key (id) — int — Primary key — NOT NULL
  • Key (store_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled2.Key — NOT NULL
  • Field (body) — text
  • Field (score) — float

Untitled (misson)

  • Key (id) — int — Primary key — NOT NULL
  • Key (store_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(20)
  • Field (point) — int
  • Field (body) — text

Untitled (misson_of_member)

  • Key (misson_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled2.Key — NOT NULL
  • Field (state) — varchar(20)

Untitled2 (user)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (gender) — varchar(10)
  • Field (point) — int
  • Field (age) — int