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