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