test
Tables (6)
Category
- category_id — INT
- category_name — VARCHAR(100) — NOT NULL
Country
- country_id — INT
- country_name — VARCHAR(100) — NOT NULL
Destination
- destination_id — INT
- destination_name — VARCHAR(150) — NOT NULL
- city — VARCHAR(100)
- description — TEXT
- image_url — TEXT
- price — DECIMAL(10,2)
- rating — DECIMAL(2,1)
- country_id — INT — Foreign key → Country.country_id
- category_id — INT — Foreign key → Category.category_id
Favorite
- favorite_id — INT
- user_id — INT — Foreign key → User.user_id
- destination_id — INT — Foreign key → Destination.destination_id
Review
- review_id — INT
- user_id — INT — Foreign key → User.user_id
- destination_id — INT — Foreign key → Destination.destination_id
- rating — INT
- comment — TEXT — EX
- created_at — TIMESTAMP
User
- user_id — INT
- username — VARCHAR(100) — NOT NULL
- email — VARCHAR(150) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP