UMC-4th-mission
Tables (10)
Food category (food_category)
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(15) — NOT NULL
Member Agree (member_agree)
- id — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- id (terms_id) — BIGINT — Foreign key → Terms.id — NOT NULL
- created period (created_at) — DATETIME(6)
- updated period (updated_at) — DATETIME(6)
Mission (mission)
- id — BIGINT — Primary key — NOT NULL
- id (store_id) — BIGINT — Foreign key → Store.id — NOT NULL
- description — VARCHAR(500)
Preference (preference)
- id — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- id (food_id) — BIGINT — Foreign key → Food category.id — NOT NULL
Review (review)
- id — BIGINT — Primary key — NOT NULL
- id (store_id) — BIGINT — Foreign key → Store.id — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- rating — FLOAT
- body — VARCHAR(1000)
Review Image (review_image)
- id — BIGINT — Primary key — NOT NULL
- id (review_id) — BIGINT — Foreign key → Review.id — NOT NULL
- image url (img_url) — VARCHAR(20)
- created period (created_at) — DATETIME(6)
- updated period (updated_at) — DATETIME(6)
Store (restaurant)
- id — BIGINT — Primary key — NOT NULL
- id (food_category_id) — BIGINT — Foreign key → Food category.id — NOT NULL
- name — VARCHAR(50)
- address — VARCHAR(100)
- rating — FLOAT
- open time (open_time) — TIME
- close time (close_time) — TIME
- created period (created_at) — DATETIME(6)
- updated period (updated_at) — DATETIME(6)
Terms (terms)
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(20)
- body — TEXT
- created period (created_at) — DATETIME(6)
- updated period (updated_at) — DATETIME(6)
User (user)
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- gender — VARCHAR(5)
- birthday — VARCHAR(10)
- address — VARCHAR(40)
- specific address (spec_address) — VARCHAR(40)
- status — VARCHAR(15)
- point — INTEGER
- created period (created_at) — DATETIME(6)
- updated period (updated_at) — DATETIME(6)
- inactive date (inactive_date) — DATETIME
User Mission (user_mission)
- id — BIGINT — Primary key — NOT NULL
- id (user_id) — BIGINT — Foreign key → User.id — NOT NULL
- id (mission_id) — BIGINT — Foreign key → Mission.id — NOT NULL
- created period (created_at) — DATETIME(6)
- updated period (updated_at) — DATETIME(6)