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)