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