evoc

Tables (4)

brands (Untitled)

  • (brand_id) — UUID — Primary key — NOT NULL
  • (brand_code) — VARCHAR(50)
  • (brand_name) — VARCHAR(100)
  • (is_active) — BOOLEAN
  • (created_at) — TIMESTAMP

categories (Untitled2)

  • (category_id) — UUID — Primary key — NOT NULL
  • (parent_category_id) — UUID
  • (category_code) — VARCHAR(50)
  • (category_name) — VARCHAR(100)
  • (depth) — SMALLINT
  • (is_active) — BOOLEAN
  • (created_at) — TIMESTAMP
  • (brand_id) — UUID — Foreign key → brands.brand_id — NOT NULL

knowledge_chunks (Untitled4)

  • (chunk_id) — UUID — Primary key — NOT NULL
  • (document_id) — UUID
  • (chunk_index) — INTEGER
  • (content) — TEXT
  • (token_count) — INTEGER
  • (vector_record_id) — VARCHAR(100)
  • (metadata) — JSONB
  • (created_at) — TIMESTAMP

knowledge_documents (Untitled3)

  • (document_id) — UUID — Primary key — NOT NULL
  • (brand_id) — UUID
  • (category_id) — UUID
  • (document_type) — VARCHAR(30)
  • (title) — VARCHAR(255)
  • (version) — VARCHAR(30)
  • (status) — VARCHAR(30)
  • (effective_from) — DATE
  • (effective_to) — DATE
  • (source_filename) — VARCHAR(255)
  • (checksum) — VARCHAR(64)
  • (created_at) — TIMESTAMP
  • (updated_at) — TIMESTAMP