1weeks_practice
Tables (4)
mission (Untitled3)
- PK (id) — int — Primary key — NOT NULL
- (store_id) — int
- (title) — varchar(20)
- (reward_points) — int
- (created_at) — datetime(6)
- (update_at) — datetime(6)
- FK (user_id) — int — Foreign key → user.PK — NOT NULL
mission_assignment (Untitled4)
- PK (id) — int — Primary key — NOT NULL
- FK (mission_id) — int — Foreign key → mission.PK — NOT NULL
- FK (user_id) — int — Foreign key → user.PK — NOT NULL
- (created_at) — datatime(6)
- (updated_at) — datatime(6)
user (Untitled)
- PK (id) — int — Primary key — NOT NULL
- (email) — varchar(50)
- (phone_num) — varchar(11)
- (name) — varchar(30)
- (created_at) — datetime(6)
- (updated_at) — datetime(6)
user_login (Untitled2)
- PK (user_id) — int — Foreign key → user.PK — NOT NULL
- (password) — int
- (created_at) — datatime(6)
- (updated_at) — datetime(6)