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