UMC week1
Tables (12)
Untitled (region)
- Field (id) — bigint — Primary key
- Field (name) — varchar(10)
Untitled (store)
- Field (id) — bigint — Primary key
- Field (name) — varchar(20)
- Field (address) — varchar(20)
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- Field (region_id) — bigint — Foreign key → Untitled.Field
Untitled (mission)
- Field (id) — bigint — Primary key
- Field (name) — varchar(20)
- Field (reward_point) — int
- Field (condition) — varchar(20)
- Field2 (condition_value) — int
- Field (start_date) — datetime(6)
- Field2 (end_date) — datetime(6)
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- Field (store_id) — bigint — Foreign key → Untitled.Field
Untitled (user_mission)
- Field (user_mission_id) — bigint — Primary key
- Field (status) — varchar(10)
- Field (started_at) — datetime(6)
- Field (completed_at) — datetime(6)
- Field (progress_count) — int
- Field2 (current_amount) — int
- Field2 (reward_point) — int
- Field (updated_at) — datetimme(6)
- Field (user_id) — bigint — Foreign key → user.Field
- Field (missoin_id) — bigint — Foreign key → Untitled.Field
Untitled (review)
- Field (id) — bigint — Primary key
- Field (rating) — int
- Field (comment) — varchar(500)
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (store_id) — bigint — Foreign key → Untitled.Field
- Field (user_id) — bigint — Foreign key → user.Field
Untitled (category)
- Field (id) — bigint — Primary key
- Field (name) — varchar(20)
Untitled (user_category)
- Field (category_id) — bigint — Foreign key → Untitled.Field
- Field (user_id) — bigint — Foreign key → user.Field
Untitled (point)
- Field (id) — bigint — Primary key
- Field (amount) — int
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (user_id) — bigint — Foreign key → user.Field
Untitled (inquiry)
- Field (id) — bigint — Primary key
- Field (title) — varchar(20)
- Field (content) — varchar(100)
- Field (status) — varchar(10)
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime
- Field (user_id) — bigint — Foreign key → user.Field
Untitled (user_region_progress)
- Field (id) — bigint — Primary key
- Field (completed_count) — int
- Field (updated_at) — datetime(6)
- Field (user_id) — bigint — Foreign key → user.Field
- Field (region_id) — bigint — Foreign key → Untitled.Field
Untitled (store_category)
- Field (category_id) — bigint — Foreign key → Untitled.Field
- Field (store_id) — bigint — Foreign key → Untitled.Field
user
- Field (id) — bigint — Primary key
- Field (email) — varchar(20)
- Field2 (phone_num) — varchar(15)
- Field (name) — varchar(10)
- Field (login_id) — bigint
- Field (nickname) — varchar(20)
- Field (password) — varchar(20)
- Field (gender) — varchar(10)
- Field (address) — varchar(20)
- Field (birth_date) — datetime
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- Field3 (status) — varchar(10)
- Field (inactive_date) — datetime(6)
- Field (total_point) — int