UMC-7th_week1

Tables (8)

Untitled (member)

  • Key (id) — long — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (gender) — varchar
  • Field (birth) — localdate
  • Field (address) — varchar
  • Field (agreement) — varchar
  • Field (status) — varchar
  • Field (created_at) — localdate
  • Field (updated_at) — localdate

Untitled (food_prefer)

  • Key (id) — long — Primary key — NOT NULL
  • Field (category) — varchar

Untitled (member_prefer)

  • Key (id) — long — Primary key — NOT NULL
  • Key (member_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (prefer_id) — long — Foreign key → Untitled.Key — NOT NULL

Untitled (region)

  • Key (id) — long — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (location) — varchar

Untitled (store)

  • Key (id) — long — Primary key — NOT NULL
  • Key (region_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar
  • Field (location) — varchar

Untitled (home)

  • Key (id) — long — Primary key — NOT NULL
  • Key (mission_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (store_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (region_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — varchar

Untitled (review)

  • Key (id) — long — Primary key — NOT NULL
  • Key (store_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (region_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (star_point) — int
  • Field (description) — text
  • Field (title) — varchar

Untitled (mission)

  • Key (id) — long — Primary key — NOT NULL
  • Key (store_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (region_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (point) — int