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