create table ShoppingBill
(
    shoppingBillCode varchar(255)   not null
        primary key,
    abandon          bit            null,
    amount           decimal(19, 2) null,
    auditScore       int            null,
    auditor          varchar(255)   null,
    resubmitTimes    int            null,
    shoppingState    varchar(255)   null,
    submitTime       datetime(6)    null,
    submitter        varchar(255)   null,
    supplyCompany    varchar(255)   null,
    updateTime       datetime(6)    null
);

INSERT INTO ShoppingBill (shoppingBillCode, abandon, amount, auditScore, auditor, resubmitTimes, shoppingState, submitTime, submitter, supplyCompany, updateTime) VALUES ('SH24460509164017', false, 0.00, 80, 'anonymousUser', 1, 'agreed', '2022-05-09 09:15:29.700000', 'anonymousUser', '蓝天供销社', '2022-05-09 09:15:55.278000');
INSERT INTO ShoppingBill (shoppingBillCode, abandon, amount, auditScore, auditor, resubmitTimes, shoppingState, submitTime, submitter, supplyCompany, updateTime) VALUES ('SH75140509163554', false, 0.00, -1, 'anonymousUser', 0, 'toSubmit', null, 'anonymousUser', '青苹供销社', '2022-05-09 08:35:54.712000');
INSERT INTO ShoppingBill (shoppingBillCode, abandon, amount, auditScore, auditor, resubmitTimes, shoppingState, submitTime, submitter, supplyCompany, updateTime) VALUES ('SH86380509163945', false, 0.00, -1, 'anonymousUser', 0, 'toSubmit', null, 'anonymousUser', '蓝天供销社', '2022-05-09 08:39:45.056000');