Legal-Mind-RAG

Tables (14)

answer_metas

  • meta_id — SERIAL
  • message_id — INT — Foreign key → messages.message_id — NOT NULL
  • disclaimer — TEXT
  • applied_rule — TEXT
  • confidence_score — FLOAT
  • created_at — TIMESTAMP

answer_traces

  • trace_id — SERIAL
  • message_id — INT — Foreign key → messages.message_id — NOT NULL
  • step_order — INT
  • logic_type — VARCHAR(50)
  • chunk_id — INT — Foreign key → document_chunks.chunk_id
  • relevance_score — FLOAT
  • created_at — TIMESTAMP

chat_sessions

  • chat_session_id — UUID
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255)
  • category — VARCHAR(50)
  • risk_level — VARCHAR(20)
  • summary — TEXT
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

companies

  • company_id — UUID
  • sector — VARCHAR(100)
  • has_labor_union — BOOLEAN
  • is_venture — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

conversion_leads

  • lead_id — SERIAL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • chat_session_id — UUID — Foreign key → chat_sessions.chat_session_id
  • trigger_type — VARCHAR(50)
  • partner_id — INT — Foreign key → partners.partner_id
  • status — VARCHAR(20)
  • created_at — TIMESTAMP

doc_hierarchies

  • hierarchy_id — SERIAL
  • document_id — INT — Foreign key → documents.document_id — NOT NULL
  • parent_id — INT — Foreign key → doc_hierarchies.hierarchy_id
  • level — VARCHAR(20)
  • title — VARCHAR(255)
  • content — TEXT
  • created_at — TIMESTAMP

document_chunks

  • chunk_id — SERIAL
  • document_id — INT — Foreign key → documents.document_id — NOT NULL
  • hierarchy_id — INT — Foreign key → doc_hierarchies.hierarchy_id
  • content — TEXT — NOT NULL
  • embedding_vector — VECTOR(1536)
  • chunk_index — INT
  • created_at — TIMESTAMP

documents

  • document_id — SERIAL
  • title — VARCHAR(255) — NOT NULL
  • organization — VARCHAR(100)
  • revision_date — DATE
  • effective_date — DATE
  • version — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

messages

  • message_id — SERIAL
  • chat_session_id — UUID — Foreign key → chat_sessions.chat_session_id — NOT NULL
  • message_index — INT — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • token_usage — INT
  • response_time_ms — INT
  • parent_message_id — INT — Foreign key → messages.message_id
  • created_at — TIMESTAMP

partners

  • partner_id — SERIAL
  • partner_type — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP

report_histories

  • report_id — SERIAL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • chat_session_id — UUID — Foreign key → chat_sessions.chat_session_id
  • report_type — VARCHAR(50)
  • is_paid — BOOLEAN
  • file_path — VARCHAR(512)
  • created_at — TIMESTAMP

user_lifecycles

  • lifecycle_id — SERIAL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • status — lifecycle_enum — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • created_at — TIMESTAMP

user_profiles

  • profile_id — SERIAL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • industry — VARCHAR(100)
  • company_id — UUID — Foreign key → companies.company_id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • user_id — UUID
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50)
  • emp_count_type — emp_count_enum — NOT NULL
  • region_code — CHAR(10)
  • is_active — BOOLEAN
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP