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