MVP
Tables (7)
Map
- map_id — Bigint — Primary key — NOT NULL
- id (id2) — Bigint — Foreign key → User.id — NOT NULL
- location — varchar(20)
Mission
- mtssion_id — Bigint — Primary key — NOT NULL
- title — varchar(20)
- description — text
User
- id — Bigint — Primary key — NOT NULL
- name — varchar(20)
- gender — enum
- date — Bigint
- address — text
- created_at — datetime
- updated_at — datetime
- state — enum
- outTime — datetime
- point — Bigint
- location — varchar(20)
alarm
- alarm_id — Bigint — Primary key — NOT NULL
- id (id2) — Bigint — Foreign key → User.id — NOT NULL
- title — varchar(20)
- description — text
- Field
review
- Key — Foreign key → store.store_id — NOT NULL
- id — Bigint — Foreign key → User.id — NOT NULL
- score — Bigint
- description — text
- created_at — datetime
store
- store_id — Bigint — Primary key — NOT NULL
- map_id — Bigint — Foreign key → Map.map_id — NOT NULL
- id (id2) — Bigint — Foreign key → Map.id — NOT NULL
- name — varchar(20)
- description — text
user_mission
- id — Bigint — Foreign key → User.id — NOT NULL
- mtssion_id — Bigint — Foreign key → Mission.mtssion_id — NOT NULL
- map_id — Bigint — Foreign key → Map.map_id — NOT NULL
- id (id2) — Bigint — Foreign key → Map.id — NOT NULL
- state — enum
- updated_at — datetime