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