week 0 ERD
Tables (6)
Member (Untitled)
- Key — Primary key — NOT NULL
- PK (id) — INT
- (email) — VARCHAR(255)
- (password) — VARCHAR(255)
- (name) — VARCHAR(50)
- (nickname) — VARCHAR(50)
- (gender) — VARCHAR(10)
- (birth_date) — DATE
- (address) — VARCHAR(255)
Member_Mission (Untitled4)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Mission.Key — NOT NULL
- Key (Key3) — Foreign key → Store.Key — NOT NULL
- Key (Key22) — Foreign key → Store.Key — NOT NULL
- Key (Key222) — Foreign key → Store.Key — NOT NULL
- PK (id) — INT
- FK (member_id) — INT
- FK (mission_id) — INT
- (status) — VARCHAR(20)
Mission (Untitled5)
- Key — Primary key — NOT NULL
- PK (id) — INT
- FK (store_id) — INT
- (reward) — VARCHAR(100)
- (deadline) — DATE
Region (Untitled2)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Member.Key — NOT NULL
- PK (id) — INT
- (name) — VARCHAR(100)
Region_Progress (Untitled6)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Store.Key — NOT NULL
- Key (Key22) — Foreign key → Store.Key — NOT NULL
- Key (Key222) — Foreign key → Store.Key — NOT NULL
- FK (member_id) — INT
- FK (region_id) — INT
- (completed_count) — INT
Store (Untitled3)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Region.Key — NOT NULL
- Key (Key22) — Foreign key → Region.Key — NOT NULL
- PK (id) — INT
- FK (region_id) — INT
- (name) — VARCHAR(100)
- (category) — VARCHAR(50)