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