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