alcohol_recomendation_system

Tables (3)

alcohol_tb

  • alcohol_id — int — Primary key — NOT NULL
  • alcohol_type — TEXT
  • origin — TEXT
  • age — TEXT
  • cost — TEXT
  • ABV — TEXT
  • tasting_note — TEXT
  • tasting_score — int
  • flavor_profile — TEXT
  • flavor_type_rating — TEXT

rating_tb

  • user_id — int — Foreign key → user_tb.user_id — NOT NULL
  • alcohol_id — int — Foreign key → alcohol_tb.alcohol_id — NOT NULL
  • user_name — TEXT
  • alcohol_name — TEXT
  • rating — float
  • text_review — TEXT
  • alcohol_url — TEXT
  • alcohol_type — TEXT
  • likes_cnt — int

user_tb

  • user_id — int — Primary key — NOT NULL
  • user_name — TEXT
  • user_url — TEXT
  • taste_cnt — int
  • follower_cnt — int
  • following_cnt — int