QR-ERD-4
Tables (8)
AI_ANALYSIS
- id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → USER.id — NOT NULL
- analysis_date — DATE — NOT NULL
- top_category — VARCHAR(100)
- top_color — VARCHAR(50)
- summary — TEXT
- raw_stats — TEXT
CATEGORY
- id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
DEVICE
- id — VARCHAR(36) — Primary key — NOT NULL
- device_uuid — VARCHAR(100) — NOT NULL
- first_seen_at — DATETIME — NOT NULL
OAUTH_ACCOUNT
- id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → USER.id — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- access_token — VARCHAR(500)
- linked_at — DATETIME — NOT NULL
PRODUCT
- id — VARCHAR(36) — Primary key — NOT NULL
- product_unit (sku) — VARCHAR(100) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- category_id — VARCHAR(36) — Foreign key → CATEGORY.id — NOT NULL
- color — VARCHAR(50)
- price — INT
- description — TEXT
- image_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
QR_CODE
- id — VARCHAR(36) — Primary key — NOT NULL
- product_id — VARCHAR(36) — Foreign key → PRODUCT.id — NOT NULL
- qr_value — VARCHAR(255) — NOT NULL
- issued_at — DATETIME — NOT NULL
SCAN_RECORD
- id — VARCHAR(36) — Primary key — NOT NULL
- device_id — VARCHAR(36) — Foreign key → DEVICE.id
- user_id — VARCHAR(36) — Foreign key → USER.id
- product_id — VARCHAR(36) — Foreign key → PRODUCT.id — NOT NULL
- scanned_at — DATETIME — NOT NULL
- expires_at — DATETIME
USER
- id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- created_at — DATETIME — NOT NULL