2
Tables (11)
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
terms
- term_id — int
- title — varchar(255) — NOT NULL
- body — text — NOT NULL
- optional — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
user_missions
- user_id — int — Primary key — NOT NULL
- mission_id — int — Primary key — NOT NULL
- status — enum
user_terms
- user_id — int — Primary key — NOT NULL
- term_id — int — Primary key — NOT NULL
- agreed_at — timestamp
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