umc 1week

Tables (9)

Untitled (food_category)

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

Untitled (user_food_select)

  • Key (id) — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → user.Key — NOT NULL
  • Key (food_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (oauth_provider)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (activation)

Untitled (oauth_connection)

  • Key (oauth_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → user.Key — NOT NULL

Untitled (region)

  • Key (region_id) — Primary key — NOT NULL

Untitled (store)

  • Key (store_id) — Primary key — NOT NULL
  • Key (region_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (mission)

  • Key (mission_id) — Primary key — NOT NULL
  • Field (point)
  • Field2 (expire_date)
  • Key (store_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (mission_amount)

Untitled (mission_complete)

  • Key (id) — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → user.Key — NOT NULL
  • Key (mission_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (complete_date)

user

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (sex) — varchar — NOT NULL
  • Field (birthday) — date — NOT NULL
  • Field (address) — varchar — NOT NULL
  • Field (address_detail) — varchar — NOT NULL
  • Field (point)
  • Field (email)
  • Field (telephone)