You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
11 lines
2.2 KiB
Plaintext
11 lines
2.2 KiB
Plaintext
9 months ago
|
{
|
||
|
|
"global":
|
||
|
|
{
|
||
|
|
"all":
|
||
|
|
[
|
||
|
|
"CREATE TABLE pos_product (id varchar (24) NOT NULL UNIQUE, tenantId varchar (16) NOT NULL, brandId varchar (24), typeId varchar (24), typePath varchar (128), no varchar (8), name varchar (128), shortName VARCHAR (128), spell varchar (24), assistNo varchar (24), otherNo VARCHAR (32), barCode varchar (24), english varchar (128), unitId varchar (24), price DECIMAL (24, 4), memberPrice DECIMAL (24, 4), memo varchar (64), commissionType int, commissionValue DECIMAL (24, 4), discountFlag int, suitFlag int, tapleFlag int, weighFlag int, currentFlag int, labelPrintFlag int, stopFlag int, groupName varchar (24), picture varchar (64), mebDiscountFlag INTEGER, giveFlag INTEGER, promotionFlag INTEGER, type INTEGER, stockFlag INTEGER, pointType INTEGER, pointValue DECIMAL (24, 4), purchaseTax DECIMAL (24, 4), saleTax DECIMAL (24, 4), lyRate DECIMAL (24, 4), otherPrice DECIMAL (24, 4), costPrice DECIMAL (24, 4), purchasePrice DECIMAL (24, 4), dispatchPrice DECIMAL (24, 4), minPrice DECIMAL (24, 4), specCount INTEGER, ext1 varchar (32), ext3 varchar (32), ext2 varchar (32), createUser varchar (16), createDate VARCHAR (32), modifyUser varchar (16), modifyDate VARCHAR (32), kdsFlag INT default 0);",
|
||
|
|
"CREATE TABLE pos_product_spec (id varchar (24) NOT NULL UNIQUE PRIMARY KEY, tenantId varchar (16) NOT NULL, productId varchar (24), no varchar (8), name varchar (128), price DECIMAL (24, 4), memberPrice DECIMAL (24, 4), otherPrice DECIMAL (24, 4), costPrice DECIMAL (24, 4), purchasePrice DECIMAL (24, 4), dispatchPrice DECIMAL (24, 4), minPrice DECIMAL (24, 4), materialRate DECIMAL (24, 4), isDefault int, deleteFlag INTEGER, ext1 varchar (32), ext3 varchar (32), ext2 varchar (32), createUser varchar (16), createDate VARCHAR (32), modifyUser varchar (16), modifyDate VARCHAR (32), thUseLevel decimal(24,4) default 0, realThUseLevel decimal(24,4) default 0, cost decimal(24,4) default 0);",
|
||
|
|
"CREATE TABLE pos_product_unit (id varchar (24) NOT NULL UNIQUE, tenantId varchar (16) NOT NULL, no varchar (8), name varchar (16), ext1 varchar (32), ext2 varchar (32), ext3 varchar (32), createUser varchar (16), createDate VARCHAR (32), modifyUser varchar (16), modifyDate VARCHAR (32));"
|
||
|
|
]
|
||
|
|
}
|
||
|
|
}
|