mission1
Tables (5)
mission (Untitled3)
- id — INT — Primary key — NOT NULL
- store_id (2) — INT — Foreign key → store.id — NOT NULL
- title (Field2) — VARCHAR(100)
- description (Field3) — TEXT
review (Untitled4)
- id (Key) — INT — Primary key — NOT NULL
- user_id (2) — INT — Foreign key → user.id — NOT NULL
- store_id (3) — INT — Foreign key → mission.id — NOT NULL
- mission_id (4) — INT — Foreign key → store.id — NOT NULL
- rating (Field4) — INT
- content (Field5) — TEXT
- created_at (Field6) — DATETIME
store (Untitled2)
- id — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(100)
- address (Field2) — VARCHAR(255)
user
- id — INT — Primary key — NOT NULL
- email (Field2) — VARCHAR(100)
- passward (Field3) — VARCHAR(100)
- nickname (Field) — VARCHAR(50)
- created_at (Field4) — DATETIME
user_mission (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- user_id (2) — INT — Foreign key → user.id — NOT NULL
- mission_id (3) — INT — Foreign key → mission.id — NOT NULL
- status (Field3) — VARCHAR(20)
- created_at (Field4) — DATETIME