사내 기반 문서 프로젝트

테이블 (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