UMC_workbook_ERD
Tables (5)
mission
- id — BIGINT — Primary key — NOT NULL
- id (id2) — BIGINT — Foreign key → store.id — NOT NULL
- id (id22) — BIGINT — Foreign key → store.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- point_value — INT — NOT NULL
- store_id — BIGINT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
mission_completion
- id (id2) — BIGINT — Foreign key → user.id — NOT NULL
- id (id3) — BIGINT — Foreign key → mission.id — NOT NULL
- id (id22) — BIGINT — Foreign key → mission.id — NOT NULL
- id (id222) — BIGINT — Foreign key → mission.id — NOT NULL
- id — BIGINT
- user_id — BIGINT
- mission_id — BIGINT
- completed_at — DATETIME(6)
- review — TEXT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- completed_status — VARCHAR(15)
region
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
store
- id — BIGINT — Primary key — NOT NULL
- id (id2) — BIGINT — Foreign key → region.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- description — TEXT
- region_id — BIGINT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
user
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- status — VARCHAR(15)
- inactive_date — DATETIME(6)