deep api
Tables (10)
company
- company id (id) — uuid — Primary key — NOT NULL
- name — char
- created at (created_at) — timestamp
company member (company_member)
- member id (member_id) — uuid — Primary key — NOT NULL
- role — char
- permission — int
- created at (created_at) — timestamp
- is active (is_active) — boolean
- company id (company_id) — uuid — Foreign key → company.company id — NOT NULL
- user id (user_id) — uuid — Foreign key → user.user id — NOT NULL
doc type (doc_type)
- doc type id (id) — uuid — Primary key — NOT NULL
- name — text
- parent id (parent_id) — uuid — Foreign key → doc type.doc type id — NOT NULL
document task (document_task)
- document id (id) — uuid — Primary key — NOT NULL
- file url (file_url) — text
- file name (file_name) — varchar
- uploaded at (uploaded_at) — timestamp
- file size (file_size) — int — bytes
- started at (started_at) — timestamp
- ended at (ended_at) — timestamp
- status — Status
- company id (company_id) — uuid — Foreign key → company.company id — NOT NULL
- doc type id (doc_type_id) — uuid — Foreign key → doc type.doc type id — NOT NULL
kie result (kie_result)
- result id (id) — uuid — Primary key — NOT NULL
- confidence score (confidence_score) — float
- result — JSONB
- page id (page_id) — uuid — Foreign key → page.page id — NOT NULL
kie schema item (kie_schema_item)
- id — uuid — Primary key — NOT NULL
- key — char
- description — text
- type — SchemaType
- is active (is_active) — boolean
- additional properties (additional_properties) — boolean
- required — JSONB(array)
- strict — boolean
- parent id (parent_id) — uuid — Foreign key → kie schema item.id — NOT NULL
- schema id (template_id) — uuid — Foreign key → kie schema template.schema id — NOT NULL
kie schema template (kie_schema_template)
- schema id (id) — uuid — Primary key — NOT NULL
- title — char
- model schema (model_schema) — JSONB
- image url (image_url) — text
- doc type id (doc_type_id) — uuid — Foreign key → doc type.doc type id — NOT NULL
kie schema template history (kie_schema_template_history)
- history id (id) — uuid — Primary key — NOT NULL
- snapshot — JSONB
- model_schema — JSONB
- created at (created_at) — timestamp
- title — text
- image_url
- template id (template_id) — uuid — Foreign key → kie schema template.schema id — NOT NULL
- author id (author_id) — uuid — Foreign key → user.user id — NOT NULL
page (document_page)
- page id (id) — uuid — Primary key — NOT NULL
- title — text
- image url (image_url) — text
- document id (document_id) — uuid — Foreign key → document task.document id — NOT NULL
- doc type id (doc_type_id) — uuid — Foreign key → doc type.doc type id — NOT NULL
user
- user id (id) — uuid — Primary key — NOT NULL
- email — char
- password — text — hashed password
- created at (created_at) — timestamp