AI 사업계획서
테이블 (6)
conversation
- id — BIGINT — 기본 키
- title — TEXT
- created_at — TIMESTAMP
- user_id — BIGINT — 외래 키 → user.id
convo_summary
- conversation_id — BIGINT — 외래 키 → conversation.id
- summary — TEXT — NOT NULL
- last_msg_id — BIGINT — NOT NULL
- updated_at — TIMESTAMP
memory
- id — BIGINT — 기본 키
- kind — VARCHAR(50)
- text — TEXT — NOT NULL
- embedding — TEXT
- created_at — TIMESTAMP
- user_id — BIGINT — 외래 키 → user.id
message
- id — BIGINT — 기본 키
- parent_id — BIGINT
- role — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- meta — TEXT
- created_at — TIMESTAMP
- client_msg_id — VARCHAR(100)
- conversation_id — BIGINT — 외래 키 → conversation.id
plan_document
- id — BIGINT — 기본 키
- title — TEXT
- payload — TEXT — NOT NULL
- progress — SMALLINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- conversation_id — BIGINT — 외래 키 → conversation.id
- user_id — BIGINT — 외래 키 → user.id
user (app_user)
- id — BIGINT — 기본 키
- external_id — VARCHAR(255)
- provider — VARCHAR(50)
- email — VARCHAR(255)
- name — VARCHAR(255)
- created_at — TIMESTAMP