Wizzle
Tables (13)
Untitled (badge)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- Field (origin_name) — varchar(255)
- Field (saved_name) — varchar(255)
- Field (description) — varchar(255)
Untitled (member_has_badge)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- id (member_id) — AUTO_INCREMENT — Foreign key → member.id — NOT NULL
- Key (badge_id) — AUTO_INCREMENT — Foreign key → Untitled.Key — NOT NULL
- Field (created_date_time) — DateTime — NOT NULL
Untitled (member_action_log)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- id (member_id) — AUTO_INCREMENT — Foreign key → member.id — NOT NULL
- Field (level) — float
- Field (action) — ENUM("LOGIN", "REVIEW", "KEEP", "DIARY", "LIKE")
Untitled (preference)
- id — AUTO_INCREMENT — Foreign key → member.id — NOT NULL
- Field (price_range) — int
- Field (smoky) — int
- Field (peaty) — int
- Field2 (spicy) — int
- Field (herbal) — int
- Field2 (body) — int
- Field3 (rich) — int
- Field4 (sweet) — int
- Field5 (briny) — int
- Field6 (salty) — int
- Field7 (vanilla) — int
- Field8 (tart) — int
- Field9 (fruity) — int
- Field (floral) — int
- Field (created_date_time) — DateTime
- Field (modified_date_time) — DateTime
- Field (gender) — ENUM('MALE', 'FEMALE')
- Field (age) — ENUM('TWENTY', 'THIRTY', 'FORTY', 'FIFTY', 'SIXTY')
Untitled (whisky)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- Field (name) — varchar(255)
- Field (origin_name) — varchar(255)
- Field (saved_name) — varchar(255)
- Field (category) — varchar(100)
- Field (location) — varchar(255)
- Field2 (price_tier) — int
- Field (abv) — float
- Field (cask_type) — varchar(300)
- Field (smoky) — int
- Field (peaty) — int
- Field (spicy) — int
- Field (herbal) — int
- Field (oily) — int
- Field (body) — int
- Field (rich) — int
- Field (sweet) — int
- Field (briny) — int
- Field (salty) — int
- Field (vanilla) — int
- Field (tart) — int
- Field (fruity) — int
- Field (floral) — int
Untitled (keep)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- id (member_id) — AUTO_INCREMENT — Foreign key → member.id — NOT NULL
- Key (whisky_id) — AUTO_INCREMENT — Foreign key → Untitled.Key — NOT NULL
- Field (created_date_time) — DateTime
Untitled (review)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- id (member_id) — AUTO_INCREMENT — Foreign key → member.id — NOT NULL
- Key (whisky_id) — AUTO_INCREMENT — Foreign key → Untitled.Key — NOT NULL
- Field (rating) — float
- Field (content) — clob
- Field (created_date_time) — DateTime
- Field (modified_date_time) — DateTime
Untitled (like)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- id (member_id) — AUTO_INCREMENT — Foreign key → member.id — NOT NULL
- Key (review_id) — AUTO_INCREMENT — Foreign key → Untitled.Key — NOT NULL
- Field (created_date_time) — DateTime
Untitled (token)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- id (member_id) — AUTO_INCREMENT — Foreign key → member.id — NOT NULL
- Field (refresh_token) — varchar(255)
Untitled (diary)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- id (member_id) — AUTO_INCREMENT — Foreign key → member.id — NOT NULL
- Field (emotion) — ENUM("BAD", "NORMAL", "GOOD") — NOT NULL
- Field (content) — varchar(255) — NOT NULL
- Field (drink_level) — ENUM("LIGHT", "MODERATE", "HEAVY") — NOT NULL
Untitled (drink)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- Key (whisky_id) — AUTO_INCREMENT — Foreign key → Untitled.Key — NOT NULL
- Key (diary_id) — AUTO_INCREMENT — Foreign key → Untitled.Key — NOT NULL
Untitled2 (image)
- Key (id) — AUTO_INCREMENT — Primary key — NOT NULL
- Key (review_id) — AUTO_INCREMENT — Foreign key → Untitled.Key — NOT NULL
- Field (saved_name) — varchar(255)
- Field (origin_name) — varchar(255)
member
- id — AUTO_INCREMENT — Primary key — NOT NULL
- email — varchar(100) — NOT NULL
- Field (profile_saved_name) — varchar(255)
- Field (profile_origin_name) — varchar(255)
- Field (nickname) — varchar(255)
- Field (level) — float — NOT NULL