unit-converter

Tables (4)

categories

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • created_at — DATETIME
  • owner_id — BIGINT — Foreign key → users.id — NOT NULL

favorites

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id — NOT NULL
  • from_unit_id — BIGINT — Foreign key → units.id — NOT NULL
  • to_unit_id — BIGINT — Foreign key → units.id — NOT NULL

units

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • symbol — VARCHAR(30)
  • to_base_factor — DECIMAL(20,10)
  • created_at — DATETIME
  • owner_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • created_at — DATETIME