UMCweek1
Tables (8)
food_category
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(15)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
inquiries
- id — BIGINT — Primary key — NOT NULL
- id (users_id) — BIGINT — Foreign key → users.id — NOT NULL
- subject — VARCHAR(255) — NOT NULL
- inquirytype — VARCHAR(100)
- inquirytext — TEXT — NOT NULL
- inquirydate — DATETIME(6)
- inquiryPhoto (inquiryphoto) — VARCHAR(255)
- status — VARCHAR(50)
missions
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- reward — INT
- deadline — DATETIME
- information — TEXT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
preferencefoods (preferencefood)
- id — BIGINT — Primary key — NOT NULL
- id (users_id) — BIGINT — Foreign key → users.id — NOT NULL
- id (food_category_id) — BIGINT — Foreign key → food_category.id — NOT NULL
- crated_at (created_at) — DATETIME(6)
- updated_at — DATETIME(6)
reviews
- id — BIGINT — Primary key — NOT NULL
- id (users_id) — BIGINT — Foreign key → users.id — NOT NULL
- id (shops_id) — BIGINT — Foreign key → shops.id
- rating — DECIMAL(2,1) — NOT NULL
- text — TEXT
- photo — VARCHAR(255)
shops
- id — BIGINT — Primary key
- name — VARCHAR(30) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
- photo — VARCHAR(255)
- rating — DECIMAL(2,1)
users
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- ageverication — TINYINT(1)
- termsaccepted — TINYINT(1) — 0
- nickname — VARCHAR(45) — NOT NULL
- privacypolicyaccepted — TINYINT(1)
- locationconsent — TINYINT(1)
- marketingconsent — TINYINT(1)
- gender — ENUM('M', 'F', 'Other')
- birthdate — DATE — NOT NULL
- address — VARCHAR(200)
- email — VARCHAR(100) — NOT NULL
- phonenumber — VARCHAR(45)
- point — INT
users_missions
- id — BIGINT — Primary key — NOT NULL
- id (users_id) — BIGINT — Foreign key → users.id — NOT NULL
- id (missions_id) — BIGINT — Foreign key → missions.id — NOT NULL
- status — VARCHAR(15)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)