vfp操作sqlite数据库？
jxc.rar
(72.36 KB)
想通过vfp,把表中记录追加到上面解压后jxc.db数据库的一张表中。如何实现？（附件解压为：jxc.db ，好像是sqlite数据库。）
数据库目录如下，可以想办法添加信息的。
Database: [jxc]
File name: C:\jxc\jxc.db
File size: 355328 bytes
Page size: 1024
Encoding: UTF-8
Auto vacuum: 0
Tables: 30
Views: 0
Virtual Tables: 0
------------------------------------------------------------
Table [account_management]
Fields: 21
[id]: VARCHAR(100)
NOT NULL
[accountNumber]: VARCHAR(100)
[accountName]: VARCHAR(100)
[creditCode]: VARCHAR(100)
[address]: VARCHAR(300)
[provinceCode]: VARCHAR(300)
[cityCode]: VARCHAR(300)
[countyCode]: VARCHAR(300)
[addressDetails]: VARCHAR(1000)
[taxpayeCode]: VARCHAR(255)
[remark]: VARCHAR(1000)
[contactName]: VARCHAR(100)
[contactWay]: VARCHAR(200)
[depositBankName]: VARCHAR(100)
[depositBankNumber]: VARCHAR(100)
[depositBankAddress]: VARCHAR(500)
[accountType]: VARCHAR(10)
[isImp]: VARCHAR(10)
[isConvert]: VARCHAR(10)
[productLicenseCode]: VARCHAR(100)
[businessLicenseCode]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [account_management] end
------------------------------------------------------------
Table [common_user]
Fields: 9
[id]: VARCHAR(100)
NOT NULL
[sex]: VARCHAR(20)
[identityCode]: VARCHAR(100)
[telphone]: VARCHAR(300)
[wechat]: VARCHAR(100)
[qq]: VARCHAR(255)
[remark]: VARCHAR(1000)
[username]: VARCHAR(100)
[usernamesearch]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [common_user] end
------------------------------------------------------------
Table [customsetting]
Fields: 3
[customkey]: varchar(200)
[customkeyvalue]: varchar(500)
[btype]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [customkey]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [customsetting] end
------------------------------------------------------------
Table [profitloss_management]
Fields: 13
[id]: VARCHAR(100)
NOT NULL
[formId]: VARCHAR(50)
[warehouseNum]: VARCHAR(20)
[productsNumber]: VARCHAR(100)
[productsName]: VARCHAR(255)
[specification]: VARCHAR(100)
[productUnit]: VARCHAR(300)
[stockAmount]: VARCHAR(20)
[profitLossNum]: VARCHAR(20)
[productRemark]: VARCHAR(1000)
[createDate]: VARCHAR(20)
[updateDate]: VARCHAR(20)
[createUserId]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [profitloss_management] end
------------------------------------------------------------
Table [profitloss_orders]
Fields: 10
[id]: VARCHAR(100)
NOT NULL
[handlers]: VARCHAR(100)
[handlersUserId]: VARCHAR(100)
[formCode]: VARCHAR(50)
[warehouseNum]: VARCHAR(20)
[reckonDate]: VARCHAR(20)
[reckonNo]: VARCHAR(100)
[createDate]: VARCHAR(20)
[updateDate]: VARCHAR(20)
[createUserId]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [profitloss_orders] end
------------------------------------------------------------
Table [purchase_management]
Fields: 39
[id]: VARCHAR(100)
NOT NULL
[handlers]: VARCHAR(30)
[handlersUserId]: VARCHAR(100)
[formCode]: VARCHAR(50)
[formId]: VARCHAR(50)
[twodimensionCode]: VARCHAR(32)
[buyDate]: VARCHAR(20)
[supplier]: VARCHAR(300)
[productsNumber]: VARCHAR(50)
[productsName]: VARCHAR(255)
[productionBatch]: VARCHAR(100)
[productionDate]: VARCHAR(20)
[validUntil]: VARCHAR(20)
[productUnit]: VARCHAR(300)
[saleunit]: VARCHAR(300)
[productUnivalence]: VARCHAR(20)
[saleUnivalence]: VARCHAR(20)
[warningDay]: VARCHAR(300)
[goodsType]: VARCHAR(300)
[relationNum]: decimal(15, 3)
[productAmounts]: VARCHAR(20)
[identifyCode]: VARCHAR(100)
[warehouseNum]: VARCHAR(20)
[specification]: VARCHAR(100)
[purchaseAmount]: VARCHAR(20)
[productStatus]: VARCHAR(10)
[createDate]: VARCHAR(20)
[updateDate]: VARCHAR(20)
[createUserId]: VARCHAR(100)
[salesReturnDate]: VARCHAR(20)
[dataType]: VARCHAR(20)
[correlationCode]: varchar(50)
[salesAmounts]: varchar(20)
[surplusAmounts]: varchar(20)
[haveStockRecord]: VARCHAR(20)
[agricultureNo]: VARCHAR(100)
[restricpesticides]: VARCHAR(100)
[productionLicenseCode]: VARCHAR(100)
[companyName]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [purchase_management] end
------------------------------------------------------------
Table [purchase_orders]
Fields: 20
[id]: VARCHAR(100)
NOT NULL
[handlers]: VARCHAR(30)
[handlersUserId]: VARCHAR(100)
[formCode]: VARCHAR(50)
[buyDate]: VARCHAR(20)
[supplier]: VARCHAR(300)
[warehouseNum]: VARCHAR(20)
[productStatus]: VARCHAR(10)
[totalMoney]: VARCHAR(20)
[correlationCode]: varchar(50)
[createDate]: VARCHAR(20)
[updateDate]: VARCHAR(20)
[createUserId]: VARCHAR(100)
[salesReturnDate]: VARCHAR(20)
[dataType]: VARCHAR(20)
[haveStockRecord]: VARCHAR(20)
[readyPay]: VARCHAR(20)
[surplusPay]: VARCHAR(20)
[returnMoney]: VARCHAR(20)
[dataStatus]: VARCHAR(20)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [purchase_orders] end
------------------------------------------------------------
Table [purchase_standing_book]
Fields: 23
[id]: VARCHAR(100)
NOT NULL
[dataStatus]: VARCHAR(20)
[restricpesticides]: VARCHAR(100)
[productionLicenseCode]: VARCHAR(100)
[SKUCode]: VARCHAR(900)
[companyName]: VARCHAR(100)
[supplierName]: VARCHAR(100)
[licenseCode]: VARCHAR(100)
[contactWay]: VARCHAR(200)
[purchaseDate]: varchar(100)
[twodimensionCode]: VARCHAR(32)
[purchaseAmounts]: VARCHAR(20)
[purchaseUnit]: VARCHAR(20)
[agricultureNo]: VARCHAR(300)
[productsName]: VARCHAR(255)
[specification]: VARCHAR(100)
[productionDate]: VARCHAR(20)
[productionBatch]: VARCHAR(100)
[dataType]: VARCHAR(100)
[formId]: VARCHAR(100)
[formCode]: VARCHAR(100)
[dataId]: VARCHAR(100)
[salesAmounts]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [purchase_standing_book] end
------------------------------------------------------------
Table [reckon_management]
Fields: 28
[id]: VARCHAR(100)
NOT NULL
[formId]: VARCHAR(50)
[warehouseNum]: VARCHAR(20)
[productsNumber]: VARCHAR(100)
[productsName]: VARCHAR(255)
[specification]: VARCHAR(100)
[productionBatch]: VARCHAR(100)
[reckonBatch]: VARCHAR(100)
[stockAmount]: VARCHAR(20)
[reckoningAmount]: VARCHAR(20)
[profitLossNum]: VARCHAR(20)
[productUnit]: VARCHAR(300)
[productRemark]: VARCHAR(1000)
[createDate]: VARCHAR(20)
[updateDate]: VARCHAR(20)
[createUserId]: VARCHAR(100)
[cgunit]: varchar(30)
[cgprice]: decimal(15, 3)
[saleprice]: decimal(15, 3)
[relationNum]: decimal(15, 3)
[separateType]: decimal(1, 0)
[productionDate]: varchar(100)
[warningDay]: VARCHAR(300)
[goodsType]: VARCHAR(300)
[holderName]: VARCHAR(300)
[companyName]: VARCHAR(300)
[agricultureNo]: VARCHAR(300)
[restricpesticides]: VARCHAR(20)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [reckon_management] end
------------------------------------------------------------
Table [reckon_orders]
Fields: 12
[id]: VARCHAR(100)
NOT NULL
[handlers]: VARCHAR(100)
[handlersUserId]: VARCHAR(100)
[formCode]: VARCHAR(50)
[warehouseNum]: VARCHAR(20)
[reckonDate]: VARCHAR(20)
[createDate]: VARCHAR(20)
[updateDate]: VARCHAR(20)
[createUserId]: VARCHAR(100)
[remark]: VARCHAR(1000)
[updateType]: VARCHAR(10)
[isReckon]: VARCHAR(10)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [reckon_orders] end
------------------------------------------------------------
Table [sales_management]
Fields: 34
[id]: VARCHAR(100)
NOT NULL
[handlers]: VARCHAR(100)
[handlersUserId]: VARCHAR(100)
[twodimensionCode]: VARCHAR(32)
[restricpesticides]: VARCHAR(100)
[sex]: VARCHAR(300)
[formId]: VARCHAR(50)
[formCode]: VARCHAR(50)
[correlationCode]: VARCHAR(50)
[salesDate]: VARCHAR(20)
[clientName]: VARCHAR(300)
[idCard]: VARCHAR(30)
[companyName]: VARCHAR(300)
[productsNumber]: VARCHAR(100)
[productsName]: VARCHAR(255)
[productUnit]: VARCHAR(300)
[productUnivalence]: VARCHAR(20)
[productAmounts]: VARCHAR(20)
[purchaseAmount]: VARCHAR(20)
[identifyCode]: VARCHAR(100)
[specification]: VARCHAR(100)
[productStatus]: VARCHAR(10)
[totalMoney]: VARCHAR(20)
[createDate]: VARCHAR(20)
[updateDate]: VARCHAR(20)
[createUserId]: VARCHAR(100)
[salesNumber]: VARCHAR(20)
[surplusAmounts]: VARCHAR(20)
[salesReturnDate]: VARCHAR(20)
[dataType]: VARCHAR(20)
[haveStockRecord]: VARCHAR(20)
[agricultureNo]: VARCHAR(100)
[productionLicenseCode]: VARCHAR(100)
[salesType]: VARCHAR(20)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [sales_management] end
------------------------------------------------------------
Table [sales_orders]
Fields: 30
[id]: VARCHAR(100)
NOT NULL
[handlers]: VARCHAR(30)
[handlersUserId]: VARCHAR(100)
[restricpesticides]: VARCHAR(100)
[formCode]: VARCHAR(50)
[returnCode]: VARCHAR(50)
[salesDate]: VARCHAR(20)
[companyName]: VARCHAR(300)
[clientName]: VARCHAR(300)
[sex]: VARCHAR(300)
[idCard]: VARCHAR(300)
[phone]: VARCHAR(30)
[address]: VARCHAR(300)
[totalMoney]: VARCHAR(20)
[accountMoney]: VARCHAR(20)
[practicalMoney]: VARCHAR(20)
[advancePayment]: VARCHAR(20)
[creditAccount]: VARCHAR(20)
[returnMoney]: VARCHAR(20)
[barCode]: VARCHAR(300)
[createDate]: VARCHAR(20)
[updateDate]: VARCHAR(20)
[createUserId]: VARCHAR(100)
[salesReturnDate]: VARCHAR(20)
[productStatus]: VARCHAR(10)
[dataType]: VARCHAR(20)
[haveStockRecord]: VARCHAR(20)
[salesType]: VARCHAR(20)
[dataStatus]: VARCHAR(20)
[remark]: VARCHAR(1000)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [sales_orders] end
------------------------------------------------------------
Table [sales_standing_book]
Fields: 22
[id]: VARCHAR(100)
NOT NULL
[dataStatus]: VARCHAR(20)
[agricultureNo]: VARCHAR(300)
[productsName]: VARCHAR(255)
[specification]: VARCHAR(100)
[restricpesticides]: VARCHAR(100)
[companyName]: VARCHAR(100)
[productionLicenseCode]: VARCHAR(100)
[buyers]: VARCHAR(100)
[buyersIDCard]: VARCHAR(100)
[salesDate]: varchar(100)
[twodimensionCode]: VARCHAR(32)
[goodsNo]: VARCHAR(900)
[productionDate]: VARCHAR(20)
[productionBatch]: VARCHAR(100)
[salesAmounts]: VARCHAR(20)
[saleunit]: varchar(30)
[dataType]: VARCHAR(100)
[formId]: VARCHAR(100)
[formCode]: VARCHAR(100)
[salesType]: VARCHAR(10)
[dataId]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [sales_standing_book] end
------------------------------------------------------------
Table [sqlite_master]
Fields: 5
[type]: TEXT
[name]: TEXT
[tbl_name]: TEXT
[rootpage]: INTEGER
[sql]: TEXT
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields:
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [sqlite_master] end
------------------------------------------------------------
Table [t_company]
Fields: 13
[id]: varchar(100)
[enterpriseName]: varchar(500)
[creditCode]: varchar(500)
[enterpriseProperty]: varchar(100)
[address]: varchar(1000)
[zipCode]: varchar(100)
[businessScope]: varchar(1000)
[sellRestrictivePesticide]: varchar(500)
[streetOther]: varchar(500)
[businessLicenseCode]: VARCHAR(100)
[phone]: VARCHAR(20)
[userName]: VARCHAR(20)
[uploadKey]: VARCHAR(50)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields:
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_company] end
------------------------------------------------------------
Table [t_enter_apply]
Fields: 11
[id]: varchar(100)
[userId]: varchar(100)
[userName]: varchar(50)
[enterNo]: varchar(100)
[enterDate]: varchar(100)
[warehouseNo]: varchar(100)
[busType]: decimal(2, 0)
[relationCode]: varchar(100)
[goodsIds]: varchar(2000)
[supplierId]: varchar(100)
[supplierName]: varchar(500)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id];[enterNo]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_enter_apply] end
------------------------------------------------------------
Table [t_goodsbrands]
Fields: 5
[id]: varchar(300)
[brandsNo]: varchar(900)
[brandsName]: varchar(900)
[state]: varchar(30)
[remark]: varchar(3000)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields:
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_goodsbrands] end
------------------------------------------------------------
Table [t_goodsinfo]
Fields: 30
[id]: VARCHAR(100)
NOT NULL
[goodsNo]: VARCHAR(900)
[goodsName]: VARCHAR(100)
[goodsType]: VARCHAR(300)
[specification]: VARCHAR(300)
[warningDay]: VARCHAR(300)
[cgunit]: varchar(30)
[saleunit]: varchar(30)
[relationNum]: decimal(15, 3)
[agricultureNo]: VARCHAR(300)
[agricultureName]: VARCHAR(300)
[agricultureTypeName]: VARCHAR(300)
[agricultureTypeCode]: VARCHAR(300)
[agricultureDate]: VARCHAR(300)
[agricultureState]: VARCHAR(300)
[holderName]: VARCHAR(300)
[holderId]: VARCHAR(300)
[uniqueCode]: VARCHAR(30)
[state]: VARCHAR(30)
[restricpesticides]: VARCHAR(20)
[productcode]: VARCHAR(300)
[remark]: VARCHAR(900)
[saleprice]: VARCHAR(20)
[numberx]: int(20)
[regularCode]: VARCHAR(20)
[productionLicenseCode]: VARCHAR(100)
[companyName]: VARCHAR(100)
[specificationType]: VARCHAR(100)
[goodsNameSearch]: VARCHAR(100)
[twodimensionCode]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_goodsinfo] end
------------------------------------------------------------
Table [t_goodstype]
Fields: 7
[id]: varchar(100)
[name]: varchar(200)
[pId]: varchar(100)
[nodeLevel]: int(11)
[levelOrder]: int(11)
[disabled]: tinyint(1)
[typeCode]: varchar(20)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_goodstype] end
------------------------------------------------------------
Table [t_goodsunit]
Fields: 4
[id]: varchar(100)
[name]: varchar(200)
[levelOrder]: int(11)
[typeCode]: varchar(20)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_goodsunit] end
------------------------------------------------------------
Table [t_inventory]
Fields: 25
[id]: varchar(100)
NOT NULL
[goodsType]: VARCHAR(30)
[warehouseNo]: varchar(100)
[goodsNo]: varchar(100)
[twodimensionCode]: varchar(100)
[goodsName]: varchar(100)
[specification]: varchar(100)
[productionBatch]: varchar(100)
[productionDate]: varchar(100)
[validDate]: varchar(100)
[cgunit]: varchar(30)
[cgprice]: decimal(15, 3)
[cgnum]: decimal(15, 3)
[saleunit]: varchar(100)
[saleprice]: decimal(15, 3)
[relationNum]: decimal(15, 3)
[salenum]: decimal(15, 3)
[separateType]: decimal(1, 0)
[enternum]: decimal(15, 3)
[enterNo]: varchar(100)
[warningDay]: VARCHAR(300)
[agricultureNo]: VARCHAR(100)
[restricpesticides]: VARCHAR(100)
[productionLicenseCode]: VARCHAR(100)
[companyName]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_inventory] end
------------------------------------------------------------
Table [t_othersystem_setup]
Fields: 5
[id]: varchar(100)
[salenum]: decimal(15, 3)
[earlywarnDays]: varchar(100)
[inventoryWarning]: varchar(100)
[batchWarning]: varchar(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_othersystem_setup] end
------------------------------------------------------------
Table [t_out_apply]
Fields: 11
[id]: varchar(100)
[userId]: varchar(100)
[userName]: varchar(50)
[outerNo]: varchar(100)
[outerDate]: varchar(100)
[warehouseNo]: varchar(100)
[outType]: decimal(2, 0)
[relationCode]: varchar(100)
[goodsIds]: varchar(2000)
[accountId]: varchar(100)
[saccountName]: varchar(500)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id];[outerNo]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_out_apply] end
------------------------------------------------------------
Table [t_out_goods]
Fields: 20
[id]: varchar(100)
[warehouseNo]: varchar(100)
[goodsNo]: varchar(100)
[twodimensionCode]: varchar(100)
[goodsName]: varchar(100)
[specification]: varchar(100)
[productionBatch]: varchar(100)
[productionDate]: varchar(100)
[validDate]: varchar(100)
[saleunit]: varchar(100)
[saleprice]: decimal(15, 3)
[salenum]: decimal(15, 3)
[enterNo]: varchar(100)
[outremark]: varchar(100)
[outmoney]: varchar(100)
[inventoryids]: varchar(2000)
[agricultureNo]: VARCHAR(100)
[restricpesticides]: VARCHAR(100)
[productionLicenseCode]: VARCHAR(100)
[companyName]: VARCHAR(100)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_out_goods] end
------------------------------------------------------------
Table [t_repayment]
Fields: 9
[id]: VARCHAR(100)
NOT NULL
[handlers]: VARCHAR(30)
[handlersUserId]: VARCHAR(100)
[formCode]: VARCHAR(50)
[payDate]: VARCHAR(20)
[clientName]: VARCHAR(300)
[idCard]: VARCHAR(300)
[phone]: VARCHAR(30)
[advancePayment]: VARCHAR(20)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_repayment] end
------------------------------------------------------------
Table [t_serial_number]
Fields: 4
[id]: VARCHAR(100)
NOT NULL
[createDate]: VARCHAR(20)
[numberx]: int(20)
[regularCode]: VARCHAR(20)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_serial_number] end
------------------------------------------------------------
Table [t_specification]
Fields: 2
[id]: VARCHAR(100)
NOT NULL
[specification]: VARCHAR(200)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_specification] end
------------------------------------------------------------
Table [t_specificationtype]
Fields: 3
[id]: VARCHAR(100)
NOT NULL
[levelOrder]: int(11)
[specification]: VARCHAR(200)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields: [id]
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_specificationtype] end
------------------------------------------------------------
Table [t_sys_region]
Fields: 12
[id_]: double
[name_]: varchar(300)
[pid_]: double
[value_]: double
[code_]: double
[order_]: double
[status_]: double
[level_]: varchar(150)
[level_code_]: double
[alias_]: varchar(300)
[name_en_]: varchar(600)
[department_id_]: varchar(300)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields:
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [t_sys_region] end
------------------------------------------------------------
Table [xp_user]
Fields: 7
[id]: varchar(96)
[loginName]: varchar(96)
[name]: varchar(300)
[role]: Decimal(11)
[password]: varchar(300)
[state]: Decimal(2)
[remark]: VARCHAR(1000)
Indexes: 0
Triggers: 0
Table constraints:
Primary Key:
Fields:
On Conflict:
Foreign Keys: 0
Unique constraints: 0
Check constraints: 0
Table [xp_user] end
