사내 기반 문서 프로젝트
테이블 (7)
document_chunks
- id — BIGSERIAL
- document_id — BIGINT — 외래 키 → documents.id — NOT NULL
- content — TEXT — NOT NULL
- chunk_order — INT — NOT NULL
- vector_db_id — VARCHAR(255)
- created_at — TIMESTAMP
document_permissions
- id — BIGSERIAL
- document_id — BIGINT — 외래 키 → documents.id — NOT NULL
- group_id — BIGINT — 외래 키 → user_groups.id — NOT NULL
- permission_level — VARCHAR(20)
documents
- id — BIGSERIAL
- title — VARCHAR(255) — NOT NULL
- content_url — TEXT — NOT NULL
- doc_type — VARCHAR(50)
- file_size — BIGINT
- status — VARCHAR(20)
- created_by — BIGINT — 외래 키 → users.id
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
search_history
- id — BIGSERIAL
- user_id — BIGINT — 외래 키 → users.id
- query — TEXT — NOT NULL
- answer — TEXT
- referenced_chunks — JSONB
- feedback — BOOLEAN
- created_at — TIMESTAMP
user_group_members
- user_id — BIGINT — 외래 키 → users.id
- group_id — BIGINT — 외래 키 → user_groups.id
user_groups
- id — BIGSERIAL
- group_name — VARCHAR(100) — NOT NULL
- description — TEXT
users
- id — BIGSERIAL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(100)
- role — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP