Data Structures

12079

Table Overview

General Tables

Business Tables

_app_account

Account Set Table

CREATE TABLE `_app_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID; can use abbreviation or Chinese name; cannot be modified',
  `appaName` varchar(255)  DEFAULT NULL COMMENT 'Account Set Name;',
  `appaStatus` varchar(255)  DEFAULT NULL COMMENT 'Account Set Status; Account Set Enabled, Account Set Disabled',
  `appaType` varchar(255)  DEFAULT 'Regular Account Set' COMMENT 'Account Set Type; Template Account Set, null',
  `subjectBalanceCalcStatus` varchar(255)  DEFAULT 'Normal' COMMENT 'Subject Balance Calculation Status',
  `periodIdStart` varchar(255)  DEFAULT NULL COMMENT 'Account Set Activation Year and Month;',
  `periodIdEnd` varchar(255)  DEFAULT NULL COMMENT 'Account Set End Year and Month; for audit purposes',
  `appaStandard` varchar(255)  DEFAULT NULL COMMENT 'Accounting Standards;',
  `appaIndustry` varchar(255)  DEFAULT NULL COMMENT 'Industry;',
  `appaVATType` varchar(255)  DEFAULT NULL COMMENT 'Value-Added Tax Type; Backup',
  `appaManagerId` varchar(255)  DEFAULT NULL COMMENT 'Account Set Manager ID',
  `appaManagerName` varchar(255)  DEFAULT NULL COMMENT 'Account Set Manager Name',
  `appaMemberIdList` varchar(255)  DEFAULT NULL COMMENT 'Account Set Member IDs',
  `appaMemberList` text  COMMENT 'Account Set Member Names',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_unique` (`appaId`) USING BTREE,
  UNIQUE KEY `appaName_unique` (`appaName`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Account Set Table'

_ui

UI Construction Plan

CREATE TABLE `_ui` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'Page ID; E.g: index',
  `uiActionType` varchar(255)  DEFAULT NULL COMMENT 'UI Action Type, e.g.: fetchData, postData, changeUi',
  `uiActionId` varchar(255)  DEFAULT NULL COMMENT 'Action ID; E.g: selectXXXByXXX',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'Description',
  `uiActionConfig` text  COMMENT 'UI Action Data',
  `appDataSchema` text  COMMENT 'UI Validation Data',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'UI Construction Plan'

app_account_file

Account Set Archive Table

CREATE TABLE `app_account_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID; can use abbreviation or Chinese name; cannot be modified',
  `periodId` varchar(255)  DEFAULT NULL COMMENT 'Accounting Period; Month Dimension E.g: 2023-03',
  `files` text  COMMENT 'Archived File JSON; separated by commas',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Account Set Archive Table'

assist_cunhuo

Auxiliary Accounting - Supplier

CREATE TABLE `assist_cunhuo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Auxiliary Accounting - Supplier'

assist_customer

Auxiliary Accounting - Customer

CREATE TABLE `assist_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2386 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Customer'

assist_depart

Auxiliary Accounting - Department

CREATE TABLE `assist_depart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Department'

assist_project

Auxiliary Accounting - Project

CREATE TABLE `assist_project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Project'

assist_staff

Auxiliary Accounting - Employee

CREATE TABLE `assist_staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Employee'

assist_supplier

Auxiliary Accounting - Supplier

CREATE TABLE `assist_supplier` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Supplier'

currency

Subject Table

CREATE TABLE `currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `currencyId` varchar(255)  DEFAULT NULL COMMENT 'Currency Code; ',
  `currencyName` varchar(255)  DEFAULT NULL COMMENT 'Currency Name;',
  `currencyRate` decimal(4, 2) DEFAULT NULL COMMENT 'Exchange Rate;',
  `isBaseCurrency` varchar(255)  DEFAULT NULL COMMENT 'Is Base Currency; Yes, No',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_subject_unique` (`appaId`, `currencyId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Subject Table'

employee

CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `employeeId` varchar(255)  DEFAULT NULL COMMENT 'Employee ID',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT 'Employee Name',
  `idSequence` int(11) DEFAULT NULL COMMENT 'Employee Sequence Number',
  `sex` varchar(255)  DEFAULT NULL COMMENT 'Gender',
  `icType` varchar(255)  DEFAULT NULL COMMENT 'Document Type',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT 'Document Number',
  `dateOfBirth` varchar(255)  DEFAULT NULL COMMENT 'Date of Birth',
  `phone` varchar(255)  DEFAULT NULL COMMENT 'Phone',
  `email` varchar(255)  DEFAULT NULL COMMENT 'Email',
  `education` varchar(255)  DEFAULT NULL COMMENT 'Education',
  `bankName` varchar(255)  DEFAULT NULL COMMENT 'Bank Name',
  `bankAccount` varchar(255)  DEFAULT NULL COMMENT 'Bank Account',
  `dateOfEntry` varchar(255)  DEFAULT NULL COMMENT 'Date of Entry',
  `department` varchar(255)  DEFAULT NULL COMMENT 'Department',
  `position` varchar(255)  DEFAULT NULL COMMENT 'Position',
  `positionLevel` varchar(255)  DEFAULT NULL COMMENT 'Position Level',
  `dateOfSalary` varchar(255)  DEFAULT NULL COMMENT 'Salary Start Date',
  `hasMemberInsurance` tinyint(1) DEFAULT NULL COMMENT 'Has Paid Five Insurances and One Fund',
  `subjectOfAccruedSalary` varchar(255)  DEFAULT NULL COMMENT 'Accrued Salary Subject',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'Remark',
  `entryStatus` varchar(255)  DEFAULT NULL COMMENT 'Employment Status',
  `insuranceConfig` longtext  COMMENT 'Five Insurances and One Fund Configuration; JSON',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 570 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin

fund_account

Fund - Account

CREATE TABLE `fund_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `idSequence` int(11) DEFAULT NULL COMMENT 'Auto Increment ID, 1001++',
  `accountId` varchar(255)  DEFAULT NULL COMMENT 'Account ID; ZJ1001',
  `accountName` varchar(255)  DEFAULT NULL COMMENT 'Account; xx Bank Account, xx Cash Account',
  `accountType` varchar(255)  DEFAULT NULL COMMENT 'Account Type; Cash, Bank Deposit',
  `currencyType` varchar(255)  DEFAULT NULL COMMENT 'Currency Type; RMB',
  `initAmount` decimal(10, 2) DEFAULT '0.00' COMMENT 'Initial Amount',
  `subjectId` varchar(255)  DEFAULT NULL COMMENT 'Accounting Subject Code;',
  `subjectName` varchar(255)  DEFAULT NULL COMMENT 'Accounting Subject;',
  `accountBankNum` varchar(255)  DEFAULT NULL COMMENT 'Bank Account Number; required only when accountType is Bank Deposit',
  `rowStatus` varchar(255)  DEFAULT 'Normal' COMMENT 'Data Status; Normal, Disabled',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_accountId_unique` (`appaId`, `accountId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Fund - Account'

fund_account_entry

Fund - Account Ledger

CREATE TABLE `fund_account_entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `idSequence` int(11) DEFAULT NULL COMMENT 'Auto Increment ID, 1++, accountEntryAt dimension auto increment',
  `accountEntryId` varchar(255)  DEFAULT NULL COMMENT 'Ledger Serial Number; accountId + accountEntryAt + 001',
  `accountId` varchar(255)  DEFAULT NULL COMMENT 'Account ID;',
  `accountEntryAt` varchar(255)  DEFAULT NULL COMMENT 'Date; time when the account is generated E.g: 2021-05-28',
  `accountEntryAbstract` varchar(255)  DEFAULT NULL COMMENT 'Abstract',
  `templateName` varchar(255)  DEFAULT NULL COMMENT 'Income and Expenditure Category Name; Template Name',
  `assistIdOfCustomer` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Employee ID',
  `assistNameOfCustomer` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Employee Name',
  `assistIdOfSupplier` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Supplier ID',
  `assistNameOfSupplier` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Supplier Name',
  `assistIdOfStaff` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Employee ID',
  `assistNameOfStaff` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Employee Name',
  `assistIdOfProject` varchar(255)  DEFAULT NULL,
  `assistNameOfProject` varchar(255)  DEFAULT NULL,
  `assistIdOfDepart` varchar(255)  DEFAULT NULL,
  `assistNameOfDepart` varchar(255)  DEFAULT NULL,
  `relTransferId` varchar(255)  DEFAULT NULL COMMENT 'Related Transfer ID',
  `transferAccountInfo` text  COMMENT 'Transfer Information',
  `amount` decimal(10, 2) DEFAULT NULL COMMENT 'Amount',
  `voucherId` varchar(255)  DEFAULT NULL COMMENT 'Related Voucher;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 342 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Fund - Account Ledger'

fund_account_transfer_entry

Fund - Account Ledger

CREATE TABLE `fund_account_transfer_entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `idSequence` int(11) DEFAULT NULL COMMENT 'Auto Increment ID, 1++, accountEntryAt dimension auto increment',
  `transferId` varchar(255)  DEFAULT NULL COMMENT 'Ledger Serial Number; accountId + accountEntryAt + 001',
  `transferAbstract` varchar(255)  DEFAULT NULL COMMENT 'Abstract',
  `fromAccountId` varchar(255)  DEFAULT NULL COMMENT 'Transfer Out Account ID',
  `toAccountId` varchar(255)  DEFAULT NULL COMMENT 'Transfer In Account ID',
  `amount` decimal(10, 2) DEFAULT NULL COMMENT 'Amount',
  `voucherId` varchar(255)  DEFAULT NULL COMMENT 'Related Voucher;',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'Remark',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 255 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Fund - Account Ledger'

invoice

Invoice

CREATE TABLE `invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `invoiceId` varchar(255)  DEFAULT NULL COMMENT 'Invoice Data ID',
  `periodId` varchar(255)  DEFAULT NULL COMMENT 'Accounting Period',
  `voucherId` varchar(255)  DEFAULT NULL COMMENT 'Related Voucher',
  `invoiceType` varchar(255)  DEFAULT NULL COMMENT 'Invoice Type: Output Invoice; Input Invoice',
  `invoiceDataType` varchar(255)  DEFAULT NULL COMMENT 'Invoice Category: Unissued Invoice; General VAT Invoice; Special VAT Invoice; Full Electronic Invoice (Special VAT Invoice); Full Electronic Invoice (General Invoice); Tax-Controlled Motor Vehicle Special Invoice; Tax Inspection Adjustment;',
  `invoiceRecordTime` varchar(255)  DEFAULT NULL COMMENT 'Entry Date',
  `invoiceTime` varchar(255)  DEFAULT NULL COMMENT 'Invoice Date',
  `invoiceCode` varchar(255)  DEFAULT NULL COMMENT 'Invoice Code',
  `invoiceUnifiedSocialCreditCode` varchar(255)  DEFAULT NULL COMMENT 'Unified Social Credit Code',
  `invoiceNumber` varchar(255)  DEFAULT NULL COMMENT 'Invoice Number',
  `invoiceStatus` varchar(255)  DEFAULT NULL COMMENT 'Invoice Status: Normal; Voided',
  `invoiceTaxpayerNum` varchar(255)  DEFAULT NULL COMMENT 'Taxpayer Identification Number',
  `invoiceAddressAndPhone` varchar(255)  DEFAULT NULL COMMENT 'Address and Phone: Address; Phone',
  `invoiceBankAndAccount` varchar(255)  DEFAULT NULL COMMENT 'Bank and Account',
  `invoiceTemplateName` varchar(255)  DEFAULT NULL COMMENT 'Business Type',
  `invoiceTemplateId` varchar(255)  DEFAULT NULL COMMENT 'Business Type ID',
  `invoiceCustomer` varchar(255)  DEFAULT NULL COMMENT 'Customer Name; for Output Invoice only',
  `invoiceCustomerName` varchar(255)  DEFAULT NULL COMMENT 'Customer Name; for Output Invoice only',
  `invoiceApproveTime` varchar(255)  DEFAULT NULL COMMENT 'Certification Date; for Input Invoice only',
  `invoiceSupplier` varchar(255)  DEFAULT NULL,
  `invoiceSupplierName` varchar(255)  DEFAULT NULL COMMENT 'Supplier Name; for Input Invoice only',
  `invoiceHasDetail` varchar(255)  DEFAULT NULL COMMENT 'Whether Invoice Details are Entered; Yes, No',
  `invoiceTotalPriceAmount` varchar(255)  DEFAULT NULL COMMENT 'Total Amount, Excluding Tax',
  `invoiceTotalTaxRate` varchar(255)  DEFAULT NULL COMMENT 'Total Tax Rate',
  `invoiceTotalTaxAmount` varchar(255)  DEFAULT NULL COMMENT 'Total Tax Amount',
  `invoiceTotalPriceAndTaxAmount` varchar(255)  DEFAULT NULL COMMENT 'Total Price and Tax Amount',
  `invoiceVIN` varchar(255)  DEFAULT NULL COMMENT 'Vehicle Identification Number',
  `invoiceMachineNo` varchar(255)  DEFAULT NULL COMMENT 'Machine Number',
  `invoiceTaxAuthorityCode` varchar(255)  DEFAULT NULL COMMENT 'Tax Authority Code',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'Remark',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Invoice'

invoice_entry

Invoice Data

CREATE TABLE `invoice_entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `invoiceId` varchar(255)  DEFAULT NULL COMMENT 'Invoice ID',
  `invoiceEntryId` varchar(255)  DEFAULT NULL COMMENT 'Invoice Data ID',
  `invoiceEntryName` varchar(255)  DEFAULT NULL COMMENT 'Product Name',
  `invoiceEntrySpec` varchar(255)  DEFAULT NULL COMMENT 'Specification Model',
  `invoiceEntryUnit` varchar(255)  DEFAULT NULL COMMENT 'Unit',
  `invoiceEntryCount` varchar(255)  DEFAULT NULL COMMENT 'Quantity',
  `invoiceEntryAmount` varchar(255)  DEFAULT NULL COMMENT 'Amount',
  `invoiceEntryTaxRate` varchar(255)  DEFAULT NULL COMMENT 'Tax Rate',
  `invoiceEntryTaxAmount` varchar(255)  DEFAULT NULL COMMENT 'Tax Amount',
  `invoiceEntryTaxProject` varchar(255)  DEFAULT NULL COMMENT 'Tax Project: Taxable Goods; Taxable Labor; Taxable Services, Real Estate, Intangible Assets',
  `invoiceEntryTaxMethod` varchar(255)  DEFAULT NULL COMMENT 'Tax Calculation Method: General Tax Method - General; General Tax Method - Immediate Refund; Simplified Tax Method - General; Simplified Tax Method - Immediate Refund; Exempt from Tax; Tax Exemption',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Invoice Data'

mb_currency

Subject Table

CREATE TABLE `mb_currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `currencyId` varchar(255)  DEFAULT NULL COMMENT 'Currency Code; ',
  `currencyName` varchar(255)  DEFAULT NULL COMMENT 'Currency Name;',
  `currencyRate` decimal(4, 2) DEFAULT NULL COMMENT 'Exchange Rate;',
  `isBaseCurrency` varchar(255)  DEFAULT NULL COMMENT 'Is Base Currency; Yes, No',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_subject_unique` (`appaId`, `currencyId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Subject Table'

mb_report_asset_liability_formula

Asset-Liability Calculation Rules

CREATE TABLE `mb_report_asset_liability_formula` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `subjectId` varchar(255)  DEFAULT NULL COMMENT 'Subject Code;',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Asset-Liability ID;',
  `countDirection` varchar(1)  NOT NULL COMMENT 'Operator; +, -',
  `accessRule` varchar(20)  NOT NULL DEFAULT '' COMMENT 'Data Retrieval Rule; Balance, Debit Balance, Credit Balance, Subject Debit Balance, Subject Credit Balance',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1430 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Calculation Rules'

mb_report_asset_liability_item

Asset-Liability Table

CREATE TABLE `mb_report_asset_liability_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `type` varchar(255)  DEFAULT NULL COMMENT 'Type; Asset, Liability',
  `editable` varchar(20)  DEFAULT NULL COMMENT 'Whether the formula can be edited; Yes, No',
  `computeFormula` varchar(255)  DEFAULT NULL COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1219 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'

mb_report_cash_flow_ex_formula

Asset-Liability Calculation Rules

CREATE TABLE `mb_report_cash_flow_ex_formula` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `subjectId` varchar(255)  DEFAULT NULL COMMENT 'Subject Code;',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Asset-Liability ID;',
  `countDirection` varchar(1)  NOT NULL COMMENT 'Operator; +, -',
  `accessRule` varchar(20)  NOT NULL DEFAULT '' COMMENT 'Data Retrieval Rule; Balance, Debit Balance, Credit Balance, Subject Debit Balance, Subject Credit Balance',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 169 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Calculation Rules'

mb_report_cash_flow_ex_item

Asset-Liability Table

CREATE TABLE `mb_report_cash_flow_ex_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `editable` varchar(20)  DEFAULT NULL COMMENT 'Whether the formula can be edited; Yes, No',
  `computeFormula` varchar(255)  DEFAULT NULL COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 442 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'

mb_report_cash_flow_item

Asset-Liability Table

CREATE TABLE `mb_report_cash_flow_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `computeFormula` text  COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 526 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'

mb_report_cash_flow_item3

Asset-Liability Table

CREATE TABLE `mb_report_cash_flow_item3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `computeFormula` text  COMMENT 'Project Fixed Formula;',
  `itemAmountMidYear` decimal(14, 2) DEFAULT NULL COMMENT 'Beginning Balance',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1651 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Asset-Liability Table'

mb_report_profit_formula

Asset-Liability Calculation Rules

CREATE TABLE `mb_report_profit_formula` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `subjectId` varchar(255)  DEFAULT NULL COMMENT 'Subject Code;',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Asset-Liability ID;',
  `countDirection` varchar(1)  NOT NULL COMMENT 'Operator; +, -',
  `accessRule` varchar(20)  NOT NULL DEFAULT '' COMMENT 'Data Retrieval Rule; Balance, Debit Balance, Credit Balance, Subject Debit Balance, Subject Credit Balance',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 744 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Calculation Rules'

mb_report_profit_item

Asset-Liability Table

CREATE TABLE `mb_report_profit_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `computeFormula` varchar(255)  DEFAULT NULL COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 621 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'

mb_report_summary_item

Asset-Liability Table

CREATE TABLE `mb_report_summary_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `editable` varchar(20)  DEFAULT NULL COMMENT 'Whether the formula can be edited; Yes, No',
  `computeFormula` text  COMMENT 'Project Fixed Formula;',
  `computeFormulaRemark` text  COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 381 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'

salary_month_record

Monthly Salary Record

CREATE TABLE `salary_month_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Auto Increment Primary Key',
  `appaId` varchar(255) DEFAULT NULL COMMENT 'Account Set ID',
  `salaryMonthRecordId` varchar(255) NOT NULL COMMENT 'Salary Month Record Number',
  `title` varchar(40) DEFAULT NULL COMMENT 'Report Title',
  `year` int(11) DEFAULT NULL COMMENT 'Year',
  `month` int(11) DEFAULT NULL COMMENT 'Month',
  `startTime` date DEFAULT NULL COMMENT 'Salary Calculation

# Table Overview

## General Tables

- [_user](/__appId__/page/article/12324#_user)
- [_user_session](/__appId__/page/article/12324#_user_session)
- [_role](/__appId__/page/article/12324#_role)
- [_page](/__appId__/page/article/12324#_page)
- [_resource](/__appId__/page/article/12324#_resource)
- [_group](/__appId__/page/article/12324#_group)
- [_user_group_role](/__appId__/page/article/12324#_user_group_role)
- [_user_group_role_page](/__appId__/page/article/12324#_user_group_role_page)
- [_user_group_role_resource](/__appId__/page/article/12324#_user_group_role_resource)
- [_constant](/__appId__/page/article/12324#_constant)
- [_constant_ui](/__appId__/page/article/12324#_constant_ui)
- [_record](/__appId__/page/article/12324#_record)
- [_record_history](/__appId__/page/article/12324#_record_history)
- [_cache](/__appId__/page/article/12324#_cache)
- [_file](/__appId__/page/article/12324#_file)
- [_view01_user](/__appId__/page/article/12324#_view01_user)

## Business Tables

### _app_account

- Account Set Table

```sql
CREATE TABLE `_app_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID; can use abbreviation or Chinese name; cannot be modified',
  `appaName` varchar(255)  DEFAULT NULL COMMENT 'Account Set Name;',
  `appaStatus` varchar(255)  DEFAULT NULL COMMENT 'Account Set Status; Account Set Enabled, Account Set Disabled',
  `appaType` varchar(255)  DEFAULT 'Regular Account Set' COMMENT 'Account Set Type; Template Account Set, null',
  `subjectBalanceCalcStatus` varchar(255)  DEFAULT 'Normal' COMMENT 'Subject Balance Calculation Status',
  `periodIdStart` varchar(255)  DEFAULT NULL COMMENT 'Account Set Activation Year and Month;',
  `periodIdEnd` varchar(255)  DEFAULT NULL COMMENT 'Account Set End Year and Month; for audit purposes',
  `appaStandard` varchar(255)  DEFAULT NULL COMMENT 'Accounting Standards;',
  `appaIndustry` varchar(255)  DEFAULT NULL COMMENT 'Industry;',
  `appaVATType` varchar(255)  DEFAULT NULL COMMENT 'Value-Added Tax Type; Backup',
  `appaManagerId` varchar(255)  DEFAULT NULL COMMENT 'Account Set Manager ID',
  `appaManagerName` varchar(255)  DEFAULT NULL COMMENT 'Account Set Manager Name',
  `appaMemberIdList` varchar(255)  DEFAULT NULL COMMENT 'Account Set Member IDs',
  `appaMemberList` text  COMMENT 'Account Set Member Names',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_unique` (`appaId`) USING BTREE,
  UNIQUE KEY `appaName_unique` (`appaName`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Account Set Table'
```

### _ui

- UI Construction Plan

```sql
CREATE TABLE `_ui` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pageId` varchar(255)  DEFAULT NULL COMMENT 'Page ID; E.g: index',
  `uiActionType` varchar(255)  DEFAULT NULL COMMENT 'UI Action Type, e.g.: fetchData, postData, changeUi',
  `uiActionId` varchar(255)  DEFAULT NULL COMMENT 'Action ID; E.g: selectXXXByXXX',
  `desc` varchar(255)  DEFAULT NULL COMMENT 'Description',
  `uiActionConfig` text  COMMENT 'UI Action Data',
  `appDataSchema` text  COMMENT 'UI Validation Data',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'UI Construction Plan'
```

### app_account_file

- Account Set Archive Table

```sql
CREATE TABLE `app_account_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID; can use abbreviation or Chinese name; cannot be modified',
  `periodId` varchar(255)  DEFAULT NULL COMMENT 'Accounting Period; Month Dimension E.g: 2023-03',
  `files` text  COMMENT 'Archived File JSON; separated by commas',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Account Set Archive Table'
```

### assist_cunhuo

- Auxiliary Accounting - Supplier

```sql
CREATE TABLE `assist_cunhuo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Auxiliary Accounting - Supplier'
```

### assist_customer

- Auxiliary Accounting - Customer

```sql
CREATE TABLE `assist_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2386 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Customer'
```

### assist_depart

- Auxiliary Accounting - Department

```sql
CREATE TABLE `assist_depart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Department'
```

### assist_project

- Auxiliary Accounting - Project

```sql
CREATE TABLE `assist_project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Project'
```

### assist_staff

- Auxiliary Accounting - Employee

```sql
CREATE TABLE `assist_staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Employee'
```

### assist_supplier

- Auxiliary Accounting - Supplier

```sql
CREATE TABLE `assist_supplier` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `assistId` varchar(255)  DEFAULT NULL COMMENT 'ID;',
  `assistName` varchar(255)  DEFAULT NULL COMMENT 'Name',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  `filePath` varchar(255)  DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_assistId_unique` (`appaId`, `assistId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Auxiliary Accounting - Supplier'
```

### currency

- Subject Table

```sql
CREATE TABLE `currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `currencyId` varchar(255)  DEFAULT NULL COMMENT 'Currency Code; ',
  `currencyName` varchar(255)  DEFAULT NULL COMMENT 'Currency Name;',
  `currencyRate` decimal(4, 2) DEFAULT NULL COMMENT 'Exchange Rate;',
  `isBaseCurrency` varchar(255)  DEFAULT NULL COMMENT 'Is Base Currency; Yes, No',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_subject_unique` (`appaId`, `currencyId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Subject Table'
```

### employee

```sql
CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `employeeId` varchar(255)  DEFAULT NULL COMMENT 'Employee ID',
  `employeeName` varchar(255)  DEFAULT NULL COMMENT 'Employee Name',
  `idSequence` int(11) DEFAULT NULL COMMENT 'Employee Sequence Number',
  `sex` varchar(255)  DEFAULT NULL COMMENT 'Gender',
  `icType` varchar(255)  DEFAULT NULL COMMENT 'Document Type',
  `icNumber` varchar(255)  DEFAULT NULL COMMENT 'Document Number',
  `dateOfBirth` varchar(255)  DEFAULT NULL COMMENT 'Date of Birth',
  `phone` varchar(255)  DEFAULT NULL COMMENT 'Phone',
  `email` varchar(255)  DEFAULT NULL COMMENT 'Email',
  `education` varchar(255)  DEFAULT NULL COMMENT 'Education',
  `bankName` varchar(255)  DEFAULT NULL COMMENT 'Bank Name',
  `bankAccount` varchar(255)  DEFAULT NULL COMMENT 'Bank Account',
  `dateOfEntry` varchar(255)  DEFAULT NULL COMMENT 'Date of Entry',
  `department` varchar(255)  DEFAULT NULL COMMENT 'Department',
  `position` varchar(255)  DEFAULT NULL COMMENT 'Position',
  `positionLevel` varchar(255)  DEFAULT NULL COMMENT 'Position Level',
  `dateOfSalary` varchar(255)  DEFAULT NULL COMMENT 'Salary Start Date',
  `hasMemberInsurance` tinyint(1) DEFAULT NULL COMMENT 'Has Paid Five Insurances and One Fund',
  `subjectOfAccruedSalary` varchar(255)  DEFAULT NULL COMMENT 'Accrued Salary Subject',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'Remark',
  `entryStatus` varchar(255)  DEFAULT NULL COMMENT 'Employment Status',
  `insuranceConfig` longtext  COMMENT 'Five Insurances and One Fund Configuration; JSON',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 570 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin
```

### fund_account

- Fund - Account

```sql
CREATE TABLE `fund_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `idSequence` int(11) DEFAULT NULL COMMENT 'Auto Increment ID, 1001++',
  `accountId` varchar(255)  DEFAULT NULL COMMENT 'Account ID; ZJ1001',
  `accountName` varchar(255)  DEFAULT NULL COMMENT 'Account; xx Bank Account, xx Cash Account',
  `accountType` varchar(255)  DEFAULT NULL COMMENT 'Account Type; Cash, Bank Deposit',
  `currencyType` varchar(255)  DEFAULT NULL COMMENT 'Currency Type; RMB',
  `initAmount` decimal(10, 2) DEFAULT '0.00' COMMENT 'Initial Amount',
  `subjectId` varchar(255)  DEFAULT NULL COMMENT 'Accounting Subject Code;',
  `subjectName` varchar(255)  DEFAULT NULL COMMENT 'Accounting Subject;',
  `accountBankNum` varchar(255)  DEFAULT NULL COMMENT 'Bank Account Number; required only when accountType is Bank Deposit',
  `rowStatus` varchar(255)  DEFAULT 'Normal' COMMENT 'Data Status; Normal, Disabled',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_accountId_unique` (`appaId`, `accountId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Fund - Account'
```

### fund_account_entry

- Fund - Account Ledger

```sql
CREATE TABLE `fund_account_entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `idSequence` int(11) DEFAULT NULL COMMENT 'Auto Increment ID, 1++, accountEntryAt dimension auto increment',
  `accountEntryId` varchar(255)  DEFAULT NULL COMMENT 'Ledger Serial Number; accountId + accountEntryAt + 001',
  `accountId` varchar(255)  DEFAULT NULL COMMENT 'Account ID;',
  `accountEntryAt` varchar(255)  DEFAULT NULL COMMENT 'Date; time when the account is generated E.g: 2021-05-28',
  `accountEntryAbstract` varchar(255)  DEFAULT NULL COMMENT 'Abstract',
  `templateName` varchar(255)  DEFAULT NULL COMMENT 'Income and Expenditure Category Name; Template Name',
  `assistIdOfCustomer` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Employee ID',
  `assistNameOfCustomer` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Employee Name',
  `assistIdOfSupplier` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Supplier ID',
  `assistNameOfSupplier` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Supplier Name',
  `assistIdOfStaff` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Employee ID',
  `assistNameOfStaff` varchar(255)  DEFAULT NULL COMMENT 'Auxiliary Accounting - Employee Name',
  `assistIdOfProject` varchar(255)  DEFAULT NULL,
  `assistNameOfProject` varchar(255)  DEFAULT NULL,
  `assistIdOfDepart` varchar(255)  DEFAULT NULL,
  `assistNameOfDepart` varchar(255)  DEFAULT NULL,
  `relTransferId` varchar(255)  DEFAULT NULL COMMENT 'Related Transfer ID',
  `transferAccountInfo` text  COMMENT 'Transfer Information',
  `amount` decimal(10, 2) DEFAULT NULL COMMENT 'Amount',
  `voucherId` varchar(255)  DEFAULT NULL COMMENT 'Related Voucher;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 342 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Fund - Account Ledger'
```

### fund_account_transfer_entry

- Fund - Account Ledger

```sql
CREATE TABLE `fund_account_transfer_entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `idSequence` int(11) DEFAULT NULL COMMENT 'Auto Increment ID, 1++, accountEntryAt dimension auto increment',
  `transferId` varchar(255)  DEFAULT NULL COMMENT 'Ledger Serial Number; accountId + accountEntryAt + 001',
  `transferAbstract` varchar(255)  DEFAULT NULL COMMENT 'Abstract',
  `fromAccountId` varchar(255)  DEFAULT NULL COMMENT 'Transfer Out Account ID',
  `toAccountId` varchar(255)  DEFAULT NULL COMMENT 'Transfer In Account ID',
  `amount` decimal(10, 2) DEFAULT NULL COMMENT 'Amount',
  `voucherId` varchar(255)  DEFAULT NULL COMMENT 'Related Voucher;',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'Remark',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 255 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Fund - Account Ledger'
```

### invoice

- Invoice

```sql
CREATE TABLE `invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `invoiceId` varchar(255)  DEFAULT NULL COMMENT 'Invoice Data ID',
  `periodId` varchar(255)  DEFAULT NULL COMMENT 'Accounting Period',
  `voucherId` varchar(255)  DEFAULT NULL COMMENT 'Related Voucher',
  `invoiceType` varchar(255)  DEFAULT NULL COMMENT 'Invoice Type: Output Invoice; Input Invoice',
  `invoiceDataType` varchar(255)  DEFAULT NULL COMMENT 'Invoice Category: Unissued Invoice; General VAT Invoice; Special VAT Invoice; Full Electronic Invoice (Special VAT Invoice); Full Electronic Invoice (General Invoice); Tax-Controlled Motor Vehicle Special Invoice; Tax Inspection Adjustment;',
  `invoiceRecordTime` varchar(255)  DEFAULT NULL COMMENT 'Entry Date',
  `invoiceTime` varchar(255)  DEFAULT NULL COMMENT 'Invoice Date',
  `invoiceCode` varchar(255)  DEFAULT NULL COMMENT 'Invoice Code',
  `invoiceUnifiedSocialCreditCode` varchar(255)  DEFAULT NULL COMMENT 'Unified Social Credit Code',
  `invoiceNumber` varchar(255)  DEFAULT NULL COMMENT 'Invoice Number',
  `invoiceStatus` varchar(255)  DEFAULT NULL COMMENT 'Invoice Status: Normal; Voided',
  `invoiceTaxpayerNum` varchar(255)  DEFAULT NULL COMMENT 'Taxpayer Identification Number',
  `invoiceAddressAndPhone` varchar(255)  DEFAULT NULL COMMENT 'Address and Phone: Address; Phone',
  `invoiceBankAndAccount` varchar(255)  DEFAULT NULL COMMENT 'Bank and Account',
  `invoiceTemplateName` varchar(255)  DEFAULT NULL COMMENT 'Business Type',
  `invoiceTemplateId` varchar(255)  DEFAULT NULL COMMENT 'Business Type ID',
  `invoiceCustomer` varchar(255)  DEFAULT NULL COMMENT 'Customer Name; for Output Invoice only',
  `invoiceCustomerName` varchar(255)  DEFAULT NULL COMMENT 'Customer Name; for Output Invoice only',
  `invoiceApproveTime` varchar(255)  DEFAULT NULL COMMENT 'Certification Date; for Input Invoice only',
  `invoiceSupplier` varchar(255)  DEFAULT NULL,
  `invoiceSupplierName` varchar(255)  DEFAULT NULL COMMENT 'Supplier Name; for Input Invoice only',
  `invoiceHasDetail` varchar(255)  DEFAULT NULL COMMENT 'Whether Invoice Details are Entered; Yes, No',
  `invoiceTotalPriceAmount` varchar(255)  DEFAULT NULL COMMENT 'Total Amount, Excluding Tax',
  `invoiceTotalTaxRate` varchar(255)  DEFAULT NULL COMMENT 'Total Tax Rate',
  `invoiceTotalTaxAmount` varchar(255)  DEFAULT NULL COMMENT 'Total Tax Amount',
  `invoiceTotalPriceAndTaxAmount` varchar(255)  DEFAULT NULL COMMENT 'Total Price and Tax Amount',
  `invoiceVIN` varchar(255)  DEFAULT NULL COMMENT 'Vehicle Identification Number',
  `invoiceMachineNo` varchar(255)  DEFAULT NULL COMMENT 'Machine Number',
  `invoiceTaxAuthorityCode` varchar(255)  DEFAULT NULL COMMENT 'Tax Authority Code',
  `remark` varchar(255)  DEFAULT NULL COMMENT 'Remark',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Invoice'
```

### invoice_entry

- Invoice Data

```sql
CREATE TABLE `invoice_entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `invoiceId` varchar(255)  DEFAULT NULL COMMENT 'Invoice ID',
  `invoiceEntryId` varchar(255)  DEFAULT NULL COMMENT 'Invoice Data ID',
  `invoiceEntryName` varchar(255)  DEFAULT NULL COMMENT 'Product Name',
  `invoiceEntrySpec` varchar(255)  DEFAULT NULL COMMENT 'Specification Model',
  `invoiceEntryUnit` varchar(255)  DEFAULT NULL COMMENT 'Unit',
  `invoiceEntryCount` varchar(255)  DEFAULT NULL COMMENT 'Quantity',
  `invoiceEntryAmount` varchar(255)  DEFAULT NULL COMMENT 'Amount',
  `invoiceEntryTaxRate` varchar(255)  DEFAULT NULL COMMENT 'Tax Rate',
  `invoiceEntryTaxAmount` varchar(255)  DEFAULT NULL COMMENT 'Tax Amount',
  `invoiceEntryTaxProject` varchar(255)  DEFAULT NULL COMMENT 'Tax Project: Taxable Goods; Taxable Labor; Taxable Services, Real Estate, Intangible Assets',
  `invoiceEntryTaxMethod` varchar(255)  DEFAULT NULL COMMENT 'Tax Calculation Method: General Tax Method - General; General Tax Method - Immediate Refund; Simplified Tax Method - General; Simplified Tax Method - Immediate Refund; Exempt from Tax; Tax Exemption',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Invoice Data'
```

### mb_currency

- Subject Table

```sql
CREATE TABLE `mb_currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `currencyId` varchar(255)  DEFAULT NULL COMMENT 'Currency Code; ',
  `currencyName` varchar(255)  DEFAULT NULL COMMENT 'Currency Name;',
  `currencyRate` decimal(4, 2) DEFAULT NULL COMMENT 'Exchange Rate;',
  `isBaseCurrency` varchar(255)  DEFAULT NULL COMMENT 'Is Base Currency; Yes, No',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `appaId_subject_unique` (`appaId`, `currencyId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Subject Table'
```

### mb_report_asset_liability_formula

- Asset-Liability Calculation Rules

```sql
CREATE TABLE `mb_report_asset_liability_formula` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `subjectId` varchar(255)  DEFAULT NULL COMMENT 'Subject Code;',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Asset-Liability ID;',
  `countDirection` varchar(1)  NOT NULL COMMENT 'Operator; +, -',
  `accessRule` varchar(20)  NOT NULL DEFAULT '' COMMENT 'Data Retrieval Rule; Balance, Debit Balance, Credit Balance, Subject Debit Balance, Subject Credit Balance',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1430 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Calculation Rules'
```

### mb_report_asset_liability_item

- Asset-Liability Table

```sql
CREATE TABLE `mb_report_asset_liability_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `type` varchar(255)  DEFAULT NULL COMMENT 'Type; Asset, Liability',
  `editable` varchar(20)  DEFAULT NULL COMMENT 'Whether the formula can be edited; Yes, No',
  `computeFormula` varchar(255)  DEFAULT NULL COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1219 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'
```

### mb_report_cash_flow_ex_formula

- Asset-Liability Calculation Rules

```sql
CREATE TABLE `mb_report_cash_flow_ex_formula` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `subjectId` varchar(255)  DEFAULT NULL COMMENT 'Subject Code;',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Asset-Liability ID;',
  `countDirection` varchar(1)  NOT NULL COMMENT 'Operator; +, -',
  `accessRule` varchar(20)  NOT NULL DEFAULT '' COMMENT 'Data Retrieval Rule; Balance, Debit Balance, Credit Balance, Subject Debit Balance, Subject Credit Balance',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 169 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Calculation Rules'
```

### mb_report_cash_flow_ex_item

- Asset-Liability Table

```sql
CREATE TABLE `mb_report_cash_flow_ex_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `editable` varchar(20)  DEFAULT NULL COMMENT 'Whether the formula can be edited; Yes, No',
  `computeFormula` varchar(255)  DEFAULT NULL COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 442 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'
```

### mb_report_cash_flow_item

- Asset-Liability Table

```sql
CREATE TABLE `mb_report_cash_flow_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `computeFormula` text  COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 526 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'
```

### mb_report_cash_flow_item3

- Asset-Liability Table

```sql
CREATE TABLE `mb_report_cash_flow_item3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `computeFormula` text  COMMENT 'Project Fixed Formula;',
  `itemAmountMidYear` decimal(14, 2) DEFAULT NULL COMMENT 'Beginning Balance',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1651 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = 'Asset-Liability Table'
```

### mb_report_profit_formula

- Asset-Liability Calculation Rules

```sql
CREATE TABLE `mb_report_profit_formula` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `subjectId` varchar(255)  DEFAULT NULL COMMENT 'Subject Code;',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Asset-Liability ID;',
  `countDirection` varchar(1)  NOT NULL COMMENT 'Operator; +, -',
  `accessRule` varchar(20)  NOT NULL DEFAULT '' COMMENT 'Data Retrieval Rule; Balance, Debit Balance, Credit Balance, Subject Debit Balance, Subject Credit Balance',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 744 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Calculation Rules'
```

### mb_report_profit_item

- Asset-Liability Table

```sql
CREATE TABLE `mb_report_profit_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `computeFormula` varchar(255)  DEFAULT NULL COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 621 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'
```

### mb_report_summary_item

- Asset-Liability Table

```sql
CREATE TABLE `mb_report_summary_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appaId` varchar(255)  DEFAULT NULL COMMENT 'Account Set ID',
  `itemId` varchar(255)  DEFAULT NULL COMMENT 'Project ID;',
  `itemName` varchar(255)  DEFAULT NULL COMMENT 'Project Name;',
  `level` int(11) DEFAULT '0' COMMENT 'Level;',
  `row` int(11) DEFAULT NULL COMMENT 'Row Number;',
  `editable` varchar(20)  DEFAULT NULL COMMENT 'Whether the formula can be edited; Yes, No',
  `computeFormula` text  COMMENT 'Project Fixed Formula;',
  `computeFormulaRemark` text  COMMENT 'Project Fixed Formula;',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT 'Operation; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT 'Operator User ID',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT 'Operator Username',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT 'Operation Time; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 381 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'Asset-Liability Table'
```

### salary_month_record

- Monthly Salary Record

```sql
CREATE TABLE `salary_month_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Auto Increment Primary Key',
  `appaId` varchar(255) DEFAULT NULL COMMENT 'Account Set ID',
  `salaryMonthRecordId` varchar(255) NOT NULL COMMENT 'Salary Month Record Number',
  `title` varchar(40) DEFAULT NULL COMMENT 'Report Title',
  `year` int(11) DEFAULT NULL COMMENT 'Year',
  `month` int(11) DEFAULT NULL COMMENT 'Month',
  `startTime` date DEFAULT NULL COMMENT 'Salary Calculation