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