django-recommendation-wine
Tables (6)
follow (Untitled5)
- follow_id (Key) — integer — Primary key — NOT NULL
- from_id (Key2) — integer — Foreign key → users.user_id — NOT NULL
- to_id (Field) — integer
- Field2
ratings (Untitled6)
- rating_id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → users.user_id — NOT NULL
- wine_id (Key3) — integer — Foreign key → wines.wine_id — NOT NULL
- rating (Field) — real
- Field2
reviews (Untitled3)
- review_id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → users.user_id — NOT NULL
- wine_id (Key3) — integer — Foreign key → wines.wine_id — NOT NULL
- rating_id (Key4) — integer — Foreign key → ratings.rating_id — NOT NULL
- rating (Field) — real
- content (Field2) — text
- created_at (Field3) — datetime
- updated_at (Field4) — datetime
- Field5
users (Untitled)
- user_id (Key) — integer — Primary key — NOT NULL
- email (Field) — varchar
- password (Field2) — varchar
- nickname (Field3) — varchar
- date_joined (Field4) — datetime
- Field5
wines (Untitled2)
- wine_id (Key) — integer — Primary key — NOT NULL
- name (Field) — varchar
- producer (Field2) — varchar
- nation (Field3) — varchar
- local (Field4) — varchar
- varieties1 (Field5) — varchar
- varieties2 (Field6) — varchar
- varieties3 (Field7) — varchar
- degree (Field8) — real
- sweet (Field9) — integer
- acidity (Field10) — integer
- body (Field11) — integer
- tannin (Field12) — integer
- price (Field13) — integer
- av_rating (Field14) — real
- Field15
wishes (Untitled4)
- wish_id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → users.user_id — NOT NULL
- wine_id (Key3) — integer — Foreign key → wines.wine_id — NOT NULL
- Field