저장 생태계

내부망 GPT가 어떤 저장 라인을 쓰는지, 연결된 테이블이 살아있는지 보는 읽기 전용 관제방입니다.
이 화면은 저장/수정/삭제를 하지 않습니다.

PDOOK

저장 라인8

확인 테이블16

존재13

미존재3

히스토리 저장 OK

tool: history_memo
생활 기록, 메모, 기억 저장

✅ personal_memo_inbox rows: 63 / latest: 2026-06-22 16:33:48
text cols: content, customer_name

tool: personal_expense
개인 지출 구조화 저장

✅ personal_expense_records rows: 2 / latest: 2026-05-30 17:01:11
text cols: title, raw_text, memo

✅ personal_expense_items rows: 5 / latest: 2026-05-30 17:01:11
text cols: item_name

tool: payment
업무 입금/수금 저장

✅ incomes rows: 317 / latest: 2026-10-03 08:26:01
text cols: memo, payer_name

✅ income rows: 0 / latest:
text cols: memo

tool: worklog
현장 작업 기록 저장

— work_logs rows: - / latest:
text cols:

— worklog rows: - / latest:
text cols:

— worksite_logs rows: - / latest:
text cols:

tool: schedule
일정/캘린더 저장

✅ schedule_events rows: 83 / latest: 2026-10-01 18:18:17
text cols: title, memo, raw_text

✅ calendar_events rows: 9 / latest:
text cols: title, description

✅ events rows: 15 / latest: 2025-07-29 23:07:44
text cols: title, description

tool: quotation
견적 등록/수정 승인 흐름

✅ quotations rows: 111 / latest: 2026-09-28 18:36:27
text cols: project_name, customer_name, memo

✅ quotation_items rows: 42 / latest:
text cols:

tool: customer
고객 등록/수정

✅ customers rows: 155 / latest: 2026-09-30 16:08:53
text cols: name

tool: project/customer/schedule
현장/프로젝트/캘린더 프로젝트

✅ projects rows: 90 / latest: 2026-09-28 18:36:27
text cols: project_name, customer_name, memo

✅ calendar_projects rows: 75 / latest: 2026-09-30 03:16:49
text cols: title, description