운영 AI 지원 ERD

테이블 (18)

ai_approvals

  • id — BIGINT — 기본 키
  • batch_id — BIGINT — NOT NULL
  • approver_id — BIGINT — NOT NULL
  • decision — VARCHAR(10) — NOT NULL
  • note — VARCHAR(300)
  • decided_at — DATETIME — NOT NULL

ai_plan_batches

  • id — BIGINT — 기본 키
  • request_id — BIGINT — NOT NULL
  • version — INT — NOT NULL
  • generated_at — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL

ai_plan_requests

  • id — BIGINT — 기본 키
  • org_id — BIGINT — NOT NULL
  • period_type — VARCHAR(10) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • constraints_json — JSON
  • requested_by — BIGINT — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL

allergies

  • id — BIGINT — 기본 키
  • code — VARCHAR(30) — NOT NULL
  • name — VARCHAR(60) — NOT NULL

audit_logs

  • id — BIGINT — 기본 키
  • org_id — BIGINT — NOT NULL
  • actor_id — BIGINT — NOT NULL
  • action — VARCHAR(60) — NOT NULL
  • entity_type — VARCHAR(40)
  • entity_id — BIGINT
  • diff_json — JSON
  • created_at — DATETIME — NOT NULL

bid_prices

  • id — BIGINT — 기본 키
  • org_id — BIGINT — NOT NULL
  • ingredient_id — BIGINT — NOT NULL
  • unit_price — DECIMAL(12,2) — NOT NULL
  • contract_start — DATE — NOT NULL
  • contract_end — DATE — NOT NULL

ingredient_allergies

  • ingredient_id — BIGINT — 기본 키 — NOT NULL
  • allergy_id — BIGINT — 기본 키 — NOT NULL

meal_plan_locks

  • org_id — BIGINT — 기본 키 — NOT NULL
  • plan_date — DATE — 기본 키 — NOT NULL
  • meal_type — VARCHAR(10) — 기본 키 — NOT NULL
  • locked_by — BIGINT — NOT NULL
  • locked_at — DATETIME — NOT NULL

meal_plan_menus

  • meal_plan_id — BIGINT — 기본 키 — NOT NULL
  • menu_id — BIGINT — 기본 키 — NOT NULL
  • seq — INT — NOT NULL

meal_plans

  • id — BIGINT — 기본 키
  • org_id — BIGINT — NOT NULL
  • plan_date — DATE — NOT NULL
  • meal_type — VARCHAR(10) — NOT NULL
  • source — VARCHAR(10) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • ai_batch_id — BIGINT
  • created_by — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

menu_images

  • id — BIGINT — 기본 키
  • menu_id — BIGINT — NOT NULL
  • url — TEXT — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • sort_no — INT — NOT NULL
  • is_primary — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

menu_ingredients

  • menu_id — BIGINT — 기본 키 — NOT NULL
  • ingredient_id — BIGINT — 기본 키 — NOT NULL
  • qty — DECIMAL(10,2) — NOT NULL

menu_substitutes

  • id — BIGINT — 기본 키
  • org_id — BIGINT — NOT NULL
  • base_menu_id — BIGINT — NOT NULL
  • substitute_menu_id — BIGINT — NOT NULL
  • reason — VARCHAR(200)
  • created_at — DATETIME — NOT NULL

operation_settings

  • id — BIGINT — 기본 키
  • org_id — BIGINT — NOT NULL
  • effective_from — DATE — NOT NULL
  • daily_budget_limit — DECIMAL(12,2)
  • max_side_count — INT
  • constraints_json — JSON
  • created_by — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

organizations

  • id — BIGINT — 기본 키
  • name — VARCHAR(100) — NOT NULL
  • org_type — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

ratings

  • id — BIGINT — 기본 키
  • user_id — BIGINT — NOT NULL
  • meal_plan_id — BIGINT — NOT NULL
  • score — TINYINT — NOT NULL
  • comment — VARCHAR(500) — ARCHAR(500) NUL
  • created_at — DATETIME — NOT NULL

user_allergies

  • user_id — BIGINT — 기본 키 — NOT NULL
  • allergy_id — BIGINT — 기본 키 — NOT NULL

users

  • id — BIGINT — 기본 키
  • org_id — BIGINT
  • email — VARCHAR(120) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL