3
Tables (9)
categories
- category_id — INT
- name — VARCHAR(50) — NOT NULL
missions
- mission_id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- region — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- inactive_date — DATETIME
- restaurant_id — INT — NOT NULL
preferences
- user_id — INT — Primary key — NOT NULL
- category_id — INT — Primary key — NOT NULL
- priority — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
regions
- region_id — INT
- name — VARCHAR(100) — NOT NULL
restaurant_categories
- restaurant_id — INT — Primary key — NOT NULL
- category_id — INT — Primary key — NOT NULL
restaurants
- restaurant_id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- inactive_date — DATETIME
- region_id — INT — NOT NULL
reviews
- review_id — INT
- user_id — INT
- restaurant_id — INT
- rating — DECIMAL(3, 2) — NOT NULL
- comment — TEXT — EXT NUL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_missions
- user_id — INT — Primary key — NOT NULL
- mission_id — INT — Primary key — NOT NULL
- status — ENUM('in_progress', 'completed')
users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- inactive_date — DATETIME