数据库表结构与示例数据 - 财务管理系统

INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (1, '部门一', '经理一', '2021-01-01', '2021-01-01', '部门描述一'); INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (2, '部门二', '经理二', '2021-01-01', '2021-01-01', '部门描述二'); INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (3, '部门三', '经理三', '2021-01-01', '2021-01-01', '部门描述三'); INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (4, '部门四', '经理四', '2021-01-01', '2021-01-01', '部门描述四'); INSERT INTO sys_department (id, name, manager, created, updated, description) VALUES (5, '部门五', '经理五', '2021-01-01', '2021-01-01', '部门描述五');

INSERT INTO sys_account (id, name, type, balance) VALUES (1, '账户一', '类型一', 10000); INSERT INTO sys_account (id, name, type, balance) VALUES (2, '账户二', '类型二', 20000); INSERT INTO sys_account (id, name, type, balance) VALUES (3, '账户三', '类型三', 30000); INSERT INTO sys_account (id, name, type, balance) VALUES (4, '账户四', '类型四', 40000); INSERT INTO sys_account (id, name, type, balance) VALUES (5, '账户五', '类型五', 50000);

INSERT INTO sys_asset (id, name, type, purDate) VALUES (1, '资产一', '类型一', '2021-01-01'); INSERT INTO sys_asset (id, name, type, purDate) VALUES (2, '资产二', '类型二', '2021-01-01'); INSERT INTO sys_asset (id, name, type, purDate) VALUES (3, '资产三', '类型三', '2021-01-01'); INSERT INTO sys_asset (id, name, type, purDate) VALUES (4, '资产四', '类型四', '2021-01-01'); INSERT INTO sys_asset (id, name, type, purDate) VALUES (5, '资产五', '类型五', '2021-01-01');

INSERT INTO sys_ba (id, bankName, amount) VALUES (1, '银行一', 100000); INSERT INTO sys_ba (id, bankName, amount) VALUES (2, '银行二', 200000); INSERT INTO sys_ba (id, bankName, amount) VALUES (3, '银行三', 300000); INSERT INTO sys_ba (id, bankName, amount) VALUES (4, '银行四', 400000); INSERT INTO sys_ba (id, bankName, amount) VALUES (5, '银行五', 500000);

INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (1, '预算一', '起草一', '2021-01-01', '2021-12-31', 1, '分类一', '描述一'); INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (2, '预算二', '起草二', '2021-01-01', '2021-12-31', 2, '分类二', '描述二'); INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (3, '预算三', '起草三', '2021-01-01', '2021-12-31', 3, '分类三', '描述三'); INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (4, '预算四', '起草四', '2021-01-01', '2021-12-31', 4, '分类四', '描述四'); INSERT INTO sys_budget (id, name, draft, start_date, end_date, department_id, category, description) VALUES (5, '预算五', '起草五', '2021-01-01', '2021-12-31', 5, '分类五', '描述五');

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