운영 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