数据库表结构和示例数据：财务管理系统

INSERT INTO sys_account (id, name, type, balance) VALUES (1, '账户1', '类型1', 1000.00); INSERT INTO sys_account (id, name, type, balance) VALUES (2, '账户2', '类型2', 2000.00); INSERT INTO sys_account (id, name, type, balance) VALUES (3, '账户3', '类型3', 3000.00); INSERT INTO sys_account (id, name, type, balance) VALUES (4, '账户4', '类型4', 4000.00); INSERT INTO sys_account (id, name, type, balance) VALUES (5, '账户5', '类型5', 5000.00);

INSERT INTO sys_asset (id, name, type, purDate) VALUES (1, '资产1', '类型1', '2020-01-01'); INSERT INTO sys_asset (id, name, type, purDate) VALUES (2, '资产2', '类型2', '2020-02-01'); INSERT INTO sys_asset (id, name, type, purDate) VALUES (3, '资产3', '类型3', '2020-03-01'); INSERT INTO sys_asset (id, name, type, purDate) VALUES (4, '资产4', '类型4', '2020-04-01'); INSERT INTO sys_asset (id, name, type, purDate) VALUES (5, '资产5', '类型5', '2020-05-01');

INSERT INTO sys_ba (id, bankName, amount) VALUES (1, '银行1', 10000.00); INSERT INTO sys_ba (id, bankName, amount) VALUES (2, '银行2', 20000.00); INSERT INTO sys_ba (id, bankName, amount) VALUES (3, '银行3', 30000.00); INSERT INTO sys_ba (id, bankName, amount) VALUES (4, '银行4', 40000.00); INSERT INTO sys_ba (id, bankName, amount) VALUES (5, '银行5', 50000.00);

INSERT INTO sys_bd (id, status, amount, budget_id, subject_id) VALUES (1, 0, 1000.00, 1, 1); INSERT INTO sys_bd (id, status, amount, budget_id, subject_id) VALUES (2, 0, 2000.00, 2, 2); INSERT INTO sys_bd (id, status, amount, budget_id, subject_id) VALUES (3, 0, 3000.00, 3, 3); INSERT INTO sys_bd (id, status, amount, budget_id, subject_id) VALUES (4, 0, 4000.00, 4, 4); INSERT INTO sys_bd (id, status, amount, budget_id, subject_id) VALUES (5, 0, 5000.00, 5, 5);

INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (1, '预算1', '起草1', '2020-01-01', '2020-12-31', 1, '分类1', '描述1'); INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (2, '预算2', '起草2', '2020-02-01', '2020-12-31', 2, '分类2', '描述2'); INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (3, '预算3', '起草3', '2020-03-01', '2020-12-31', 3, '分类3', '描述3'); INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (4, '预算4', '起草4', '2020-04-01', '2020-12-31', 4, '分类4', '描述4'); INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (5, '预算5', '起草5', '2020-05-01', '2020-12-31', 5, '分类5', '描述5');

INSERT INTO sys_ca (id, item_id, subject_id, AllocationAmount) VALUES (1, 1, 1, 1000.00); INSERT INTO sys_ca (id, item_id, subject_id, AllocationAmount) VALUES (2, 2, 2, 2000.00); INSERT INTO sys_ca (id, item_id, subject_id, AllocationAmount) VALUES (3, 3, 3, 3000.00); INSERT INTO sys_ca (id, item_id, subject_id, AllocationAmount) VALUES (4, 4, 4, 4000.00); INSERT INTO sys_ca (id, item_id, subject_id, AllocationAmount) VALUES (5, 5, 5, 5000.00);

INSERT INTO sys_cost (id, name, amount, costItem_id) VALUES (1, '成本1', 1000.00, 1); INSERT INTO sys_cost (id, name, amount, costItem_id) VALUES (2, '成本2', 2000.00, 2); INSERT INTO sys_cost (id, name, amount, costItem_id) VALUES (3, '成本3', 3000.00, 3); INSERT INTO sys_cost (id, name, amount, costItem_id) VALUES (4, '成本4', 4000.00, 4); INSERT INTO sys_cost (id, name, amount, costItem_id) VALUES (5, '成本5', 5000.00, 5);

INSERT INTO sys_costitem (id, name, amount) VALUES (1, '项目1', 1000.00); INSERT INTO sys_costitem (id, name, amount) VALUES (2, '项目2', 2000.00); INSERT INTO sys_costitem (id, name, amount) VALUES (3, '项目3', 3000.00); INSERT INTO sys_costitem (id, name, amount) VALUES (4, '项目4', 4000.00); INSERT INTO sys_costitem (id, name, amount) VALUES (5, '项目5', 5000.00);

INSERT INTO sys_dep (id, asset_id, amount) VALUES (1, 1, 1000.00); INSERT INTO sys_dep (id, asset_id, amount) VALUES (2, 2, 2000.00); INSERT INTO sys_dep (id, asset_id, amount) VALUES (3, 3, 3000.00); INSERT INTO sys_dep (id, asset_id, amount) VALUES (4, 4, 4000.00); INSERT INTO sys_dep (id, asset_id, amount) VALUES (5, 5, 5000.00);

INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (1, '部门1', '负责人1', '2020-01-01', '2020-12-31', '描述1'); INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (2, '部门2', '负责人2', '2020-02-01', '2020-12-31', '描述2'); INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (3, '部门3', '负责人3', '2020-03-01', '2020-12-31', '描述3'); INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (4, '部门4', '负责人4', '2020-04-01', '2020-12-31', '描述4'); INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (5, '部门5', '负责人5', '2020-05-01', '2020-12-31', '描述5');

INSERT INTO sys_is (id, date, income, expense) VALUES (1, '2020-01-01', 10000.00, 5000.00); INSERT INTO sys_is (id, date, income, expense) VALUES (2, '2020-02-01', 20000.00, 10000.00); INSERT INTO sys_is (id, date, income, expense) VALUES (3, '2020-03-01', 30000.00, 15000.00); INSERT INTO sys_is (id, date, income, expense) VALUES (4, '2020-04-01', 40000.00, 20000.00); INSERT INTO sys_is (id, date, income, expense) VALUES (5, '2020-05-01', 50000.00, 25000.00);

INSERT INTO sys_ledger (id, voucher_id, subject_id, debitAmount, creditAmount, asset_id, created) VALUES (1, 1, 1, 1000.00, NULL, 1, '2020-01-01'); INSERT INTO sys_ledger (id, voucher_id, subject_id, debitAmount, creditAmount, asset_id, created) VALUES (2, 2, 2, 2000.00, NULL, 2, '2020-02-01'); INSERT INTO sys_ledger (id, voucher_id, subject_id, debitAmount, creditAmount, asset_id, created) VALUES (3, 3, 3, 3000.00, NULL, 3, '2020-03-01'); INSERT INTO sys_ledger (id, voucher_id, subject_id, debitAmount, creditAmount, asset_id, created) VALUES (4, 4, 4, 4000.00, NULL, 4, '2020-04-01'); INSERT INTO sys_ledger (id, voucher_id, subject_id, debitAmount, creditAmount, asset_id, created) VALUES (5, 5, 5, 5000.00, NULL, 5, '2020-05-01');

INSERT INTO sys_maint (id, asset_id, date, cost) VALUES (1, 1, '2020-01-01', 100.00); INSERT INTO sys_maint (id, asset_id, date, cost) VALUES (2, 2, '2020-02-01', 200.00); INSERT INTO sys_maint (id, asset_id, date, cost) VALUES (3, 3, '2020-03-01', 300.00); INSERT INTO sys_maint (id, asset_id, date, cost) VALUES (4, 4, '2020-04-01', 400.00); INSERT INTO sys_maint (id, asset_id, date, cost) VALUES (5, 5, '2020-05-01', 500.00);

INSERT INTO sys_recon (id, account_id, bank_id, date, result) VALUES (1, 1, 1, '2020-01-01', '一致'); INSERT INTO sys_recon (id, account_id, bank_id, date, result) VALUES (2, 2, 2, '2020-02-01', '一致'); INSERT INTO sys_recon (id, account_id, bank_id, date, result) VALUES (3, 3, 3, '2020-03-01', '一致'); INSERT INTO sys_recon (id, account_id, bank_id, date, result) VALUES (4, 4, 4, '2020-04-01', '一致'); INSERT INTO sys_recon (id, account_id, bank_id, date, result) VALUES (5, 5, 5, '2020-05-01', '一致');

INSERT INTO sys_subject (id, name, parentID) VALUES (1, '科目1', NULL); INSERT INTO sys_subject (id, name, parentID) VALUES (2, '科目2', NULL); INSERT INTO sys_subject (id, name, parentID) VALUES (3, '科目3', NULL); INSERT INTO sys_subject (id, name, parentID) VALUES (4, '科目4', NULL); INSERT INTO sys_subject (id, name, parentID) VALUES (5, '科目5', NULL);

INSERT INTO sys_td (id, date, amount) VALUES (1, '2020-01-01', 100.00); INSERT INTO sys_td (id, date, amount) VALUES (2, '2020-02-01', 200.00); INSERT INTO sys_td (id, date, amount) VALUES (3, '2020-03-01', 300.00); INSERT INTO sys_td (id, date, amount) VALUES (4, '2020-04-01', 400.00); INSERT INTO sys_td (id, date, amount) VALUES (5, '2020-05-01', 500.00);

INSERT INTO sys_tv (id, td_id, vouch_id, summary) VALUES (1, 1, 1, '凭证摘要1'); INSERT INTO sys_tv (id, td_id, vouch_id, summary) VALUES (2, 2, 2, '凭证摘要2'); INSERT INTO sys_tv (id, td_id, vouch_id, summary) VALUES (3, 3, 3, '凭证摘要3'); INSERT INTO sys_tv (id, td_id, vouch_id, summary) VALUES (4, 4, 4, '凭证摘要4'); INSERT INTO sys_tv (id, td_id, vouch_id, summary) VALUES (5, 5, 5, '凭证摘要5');

INSERT INTO sys_voucher (id, number, date, summary, createdBy) VALUES (1, '凭证号1', '2020-01-01', '凭证摘要1', '创建人1'); INSERT INTO sys_voucher (id, number, date, summary, createdBy) VALUES (2, '凭证号2', '2020-02-01', '凭证摘要2', '创建人2'); INSERT INTO sys_voucher (id, number, date, summary, createdBy) VALUES (3, '凭证号3', '2020-03-01', '凭证摘要3', '创建人3'); INSERT INTO sys_voucher (id, number, date, summary, createdBy) VALUES (4, '凭证号4', '2020-04-01', '凭证摘要4', '创建人4'); INSERT INTO sys_voucher (id, number, date, summary, createdBy) VALUES (5, '凭证号5', '2020-05-01', '凭证摘要5', '创建人5');