gendoc

Tables (20)

CompanyDetail

  • id — INTEGER
  • company_id — INTEGER
  • sector_code — TEXT — NOT NULL
  • business_registration_number — TEXT — NOT NULL
  • corporate_registration_number — TEXT
  • type — TEXT
  • revenue_size — INTEGER
  • postal_code — TEXT
  • phone_number — TEXT
  • email — TEXT — NOT NULL
  • signature_path — TEXT — NOT NULL
  • age — INTEGER
  • bank_name — TEXT
  • bank_account_owner — TEXT
  • bank_account_number — TEXT
  • employee_number — INTEGER
  • size — TEXT
  • logo_path — TEXT
  • website — TEXT

Company_Team

  • id — INTEGER — Primary key
  • companyId — Integer — Foreign key → company.id — NOT NULL

Document

  • id — INTEGER — Primary key
  • documentVersionId — INTEGER — Foreign key → DocumentVersion.id
  • document_id — int — Foreign key → DocumentVersion.templateId
  • categoryId — int — Foreign key → DocumentVersion.categoryId
  • companyId — int — Foreign key → DocumentVersion.companyId
  • name — VARCHAR — NOT NULL
  • type — VARCHAR
  • created_at — TIMESTAMP
  • creator_id — VARCHAR
  • original_file_path — VARCHAR
  • converted_file_path — VARCHAR

DocumentVersion

  • id — INTEGER — Primary key
  • document_id — UUID — Foreign key → document_mappings.document_id
  • templateId — int — Foreign key → document_templates.id
  • categoryId — int — Foreign key → document_templates.categoryId
  • companyId — int — Foreign key → document_templates.companyId
  • version_number — INTEGER
  • created_at — TIMESTAMP
  • creator_id — VARCHAR
  • file_path — VARCHAR

Education

  • id — INTEGER
  • name — TEXT — NOT NULL
  • type — TEXT
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • status — TEXT

Experience

  • id — INTEGER
  • name — TEXT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • occupation — TEXT
  • desc — TEXT
  • department — TEXT

Person

  • id — Integer — Primary key
  • companyTeamId — Integer — Foreign key → Company_Team.id — NOT NULL
  • name — TEXT — NOT NULL
  • birth_date — DATE
  • is_female — BOOLEAN
  • title — TEXT
  • occupation — TEXT
  • phone_number — TEXT
  • email — TEXT — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • address — TEXT — NOT NULL
  • signature_path — TEXT
  • identification_number — TEXT
  • image_path — TEXT

Person_Education

  • id — INTEGER
  • person_id — INTEGER
  • education_id — INTEGER

Person_Experience

  • id — INTEGER
  • person_id — INTEGER
  • experience_id — INTEGER
  • id2 — INTEGER

ProcessHistory

  • id — INTEGER — Primary key
  • document_id — UUID — Foreign key → DocumentVersion.document_id
  • templateId — int — Foreign key → DocumentVersion.templateId
  • categoryId — int — Foreign key → DocumentVersion.categoryId
  • companyId — int — Foreign key → DocumentVersion.companyId
  • process_type — VARCHAR
  • status — VARCHAR
  • created_at — TIMESTAMP
  • creator_id — VARCHAR
  • remarks — VARCHAR

User

  • userId — Not — Primary key — NOT NULL
  • email — Not — NOT NULL
  • password — Not — NOT NULL

categories

  • id — int — Primary key
  • companyId — int — Foreign key → company.id
  • main_category — varchar(50) — NOT NULL
  • sub_category — varchar(50) — NOT NULL
  • is_custom — tinyint(1)
  • created_at — datetime
  • updated_at — datetime

company

  • id — int — Primary key
  • businessNumber — varchar(191) — NOT NULL
  • name — varchar(191) — NOT NULL
  • description — text
  • address — varchar(191) — NOT NULL
  • category — varchar(191) — NOT NULL
  • revenue — bigint — NOT NULL
  • location — varchar(191) — NOT NULL
  • representativeAge — int — NOT NULL
  • serviceName — varchar(191) — NOT NULL
  • employeeCount — int — NOT NULL
  • logo — varchar(191)
  • representativeName — varchar(191)
  • representativeEmail — varchar(191)
  • establishmentDate — datetime(3)
  • representativePhoneNumber — varchar(191)
  • companyWebsite — varchar(191)
  • sign — varchar(191)
  • representativeIsFemale — tinyint(1)
  • revenueCurrency — varchar(191) — NOT NULL
  • userId — Not — Foreign key → User.userId — NOT NULL

conversion_results

  • id — int — Primary key
  • original_file_path — varchar(512) — NOT NULL
  • converted_file_path — varchar(512)
  • xml_path — varchar(512)
  • xsl_path — varchar(512)
  • semantic_json_path — varchar(512)
  • created_at — datetime
  • updated_at — datetime

document_mappings

  • document_id — UUID — Primary key
  • templateId — int — Foreign key → document_templates.id
  • template_type — VARCHAR(100)
  • mapping_result — JSONB — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

document_templates

  • id — int — Primary key
  • categoryId — int — Foreign key → categories.id
  • companyId — int — Foreign key → categories.companyId
  • fileId — int — Foreign key → files.id
  • template_name — varchar(255)
  • status — varchar(50) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

files

  • id — int — Primary key
  • filename — varchar(255) — NOT NULL
  • file_path — varchar(512) — NOT NULL
  • mime_type — varchar(100) — NOT NULL
  • file_size — int — NOT NULL
  • file_metadata — text
  • conversion_status — enum
  • created_at — datetime
  • updated_at — datetime

key_values

  • document_id — UUID — Foreign key → document_mappings.document_id
  • templateId — int — Foreign key → document_mappings.templateId
  • key_name — VARCHAR(255)
  • value — TEXT
  • confidence — FLOAT
  • bbox — JSONB
  • template_type — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

processing_locks

  • resource_id — INTEGER

processing_status

  • resource_id — INTEGER
  • status — JSONB — NOT NULL