MyLittleBeer

Tables (4)

Untitled (Beers)

  • Key (beer_id) — int — Primary key — NOT NULL
  • Field (name) — string
  • Field2 (style) — string
  • Field (category) — string
  • Field (aroma) — list[string]
  • Field (flavor) — list[string]
  • Field (balance) — list[string]
  • Field (season) — list[string]
  • Field (paring_food) — list[string]
  • Field (body) — list[string]
  • Field (rating) — float
  • Field (img_url) — string

Untitled (Users_Beers)

  • Key (like_id) — int — Primary key — NOT NULL
  • Key (beer_id) — int — Foreign key → Untitled.Key — NOT NULL
  • email — string — Foreign key → User.email — NOT NULL

Untitled (Historys)

  • Key (history_id) — int — Primary key — NOT NULL
  • Key (beer_id) — int — Foreign key → Untitled.Key — NOT NULL
  • email — string — Foreign key → User.email — NOT NULL
  • Field (created_at) — datetime

User (Users)

  • email — string — Primary key — NOT NULL
  • Field (name) — string
  • Field2 (password) — hash(string)