MVPIA

Tables (12)

alarm (Untitled2)

  • (id) — NN — Primary key — NOT NULL
  • (user_id) — NN — Foreign key → user.id — NOT NULL
  • (created_at) — NN

data_agree (Untitled10)

  • (id) — NN — Primary key — NOT NULL
  • (title) — NN
  • (body) — NN
  • (is_checked) — NN
  • (created_at) — NN
  • (updated_at) — NULL

mission (Untitled6)

  • (id) — NN — Primary key — NOT NULL
  • (store_id) — NN — Foreign key → store.id — NOT NULL
  • (point) — NN
  • (deadline) — NN
  • (specification) — NULL
  • (created_at) — NN
  • (updated_at) — NULL

new_mission (Untitled4)

  • (id) — NN — Primary key — NOT NULL
  • (alarm_id) — NN — Foreign key → alarm.id — NOT NULL
  • (title) — NULL
  • (body) — NULL

prefer (Untitled8)

  • (id) — NN — Primary key — NOT NULL
  • (name) — NN
  • (is_checked) — NN
  • (created_at) — NN
  • (updated_at) — NULL

request_review (CopyOfUntitled4)

  • (id) — NN — Primary key — NOT NULL
  • (alarm_id) — NN — Foreign key → alarm.id — NOT NULL
  • (title) — NULL
  • (body) — NULL

review (Untitled3)

  • (id) — NN — Primary key — NOT NULL
  • (user_id) — NN — Foreign key → user.id — NOT NULL
  • (store_id) — NN — Foreign key → store.id — NOT NULL
  • (title) — NULL
  • (body) — NULL
  • (score) — NN

store (Untitled5)

  • (id) — NN — Primary key — NOT NULL
  • (name) — NN
  • (address) — NN
  • (score) — NULL
  • (created_at) — NN
  • (updated_at) — NULL

user (Untitled)

  • (id) — NN — Primary key — NOT NULL
  • (name) — NULL
  • (birthday) — NULL
  • (address) — NULL
  • (gender) — NULL
  • (created_at) — NULL
  • (updated_at) — NULL
  • (status) — NULL
  • (inactivate_date) — NULL
  • (point) — NULL
  • (email) — NULL

user_agree_map (Untitled11)

  • (id) — NN — Primary key — NOT NULL
  • (user_id) — NN — Foreign key → user.id — NOT NULL
  • (data_id) — NN — Foreign key → data_agree.id — NOT NULL
  • (created_at) — NN
  • (updated_at) — NULL

user_mission_map (Untitled7)

  • (id) — NN — Primary key — NOT NULL
  • (mission_id) — NN — Foreign key → mission.id — NOT NULL
  • (user_id) — NN — Foreign key → user.id — NOT NULL
  • (status) — Null
  • (created_at) — NULL
  • (updated_at) — NULL

user_prefer_map (Untitled9)

  • (id) — NN — Primary key — NOT NULL
  • (prefer_id) — NN — Foreign key → prefer.id — NOT NULL
  • (user_id) — NN — Foreign key → user.id — NOT NULL
  • (created_at) — NN
  • (updated_at) — NULL