zerospy_erd
Tables (5)
History (Untitled3)
- id (Key) — Long — Primary key — NOT NULL
- product_id (Key2) — Long — Foreign key → Product.product_id — NOT NULL
- member_id (Key3) — Long — Foreign key → Member.member_id — NOT NULL
- barcode (Field) — String — 바코드 숫자 13자리
- status (Field4) — Enum — ATE, PLAN, SKIP
- llm_ingredient (Field5) — TEXT — LLM 대체감미료
- llm_summarize (Field7) — TEXT — LLM 요약설명
- created_at (Field2) — DATETIME — 생성일
- updated_at (Field3) — DATETIME — 수정일
- tags (Field6) — ENUM
History_sweetener (Untitled5)
- history_id (Key3) — Long — Foreign key → History.member_id — NOT NULL
- sweetener_id (Key) — Long — Foreign key → Sweetener.id — NOT NULL
Member (Untitled)
- member_id (Key) — Long — Primary key — NOT NULL
- username (Field) — String
- reduced_sugar (Field2) — Integer
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
Product (Untitled4)
- product_id (Key) — Long — Primary key — NOT NULL
- product_name (Field) — String — 제품명
- manufacturer (Field2) — String — 제조사명
- manufacturing_num (Field3) — String — 품목제조보고번호
- sweeteners (Field4) — Enum — 대체감미료 리스트
- product_category (Field5) — Enum — 간편식류, 간식류, 음료류, 조미용식품, 반찬류, 기타
Sweetener (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — ENUM