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