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