UMC CH1
Tables (8)
Untitled (user_mission)
- Key (id) — bigint — Primary key — NOT NULL
- Field (status) — varchar(10) — NOT NULL
- id (missioin_id) — bigint — Foreign key → mission.id — NOT NULL — unique
- id (user_id) — bigint — Foreign key → user.id — NOT NULL — unique
food_type
- id — bigint — Primary key — NOT NULL
- name — varchar(15) — NOT NULL
mission
- id — bigint — Primary key — NOT NULL
- description — varchar(120) — NOT NULL
- id (store_id) — bigint — Foreign key → store.id — NOT NULL
- id (region_id) — bigint — Foreign key → region.id — NOT NULL
region
- id — bigint — Primary key — NOT NULL
- name — varchar(10) — NOT NULL
region_mission (user_region_mission)
- Key (id) — bigint — Primary key — NOT NULL
- success_count — bigint — NOT NULL
- status — varchar(10) — NOT NULL
- id (region_id) — bigint — Foreign key → region.id — NOT NULL — unique
- id (user_id) — bigint — Foreign key → user.id — NOT NULL — unique
store
- id — bigint — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- id (food_type_id) — bigint — Foreign key → food_type.id — NOT NULL
- id (region_id) — bigint — Foreign key → region.id — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- social_type — varchar(10) — NOT NULL
- name — varchar(10) — NOT NULL
- gender — varchar(10) — NOT NULL
- birth — datetime — NOT NULL
- address — varchar(60) — NOT NULL
- credated_at (created_at) — datetime(6) — NOT NULL
- updated_at — datetime(6)
user_preference
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- id (food_type_id) — bigint — Foreign key → food_type.id — NOT NULL
- id (user_id) — bigint — Foreign key → user.id — NOT NULL