📄 unitinfo.sql

📁 十分好的一个医院管理系统
💻 SQL
📖 第 1 页 / 共 5 页
字号:
12 3 4 5 下一页
CREATE TABLE unitinfo (
	unitcode char(6),
	name char(60),
	district char(24),
	unittype char(24),
	paypercent decimal(16, 2),
	p_paypercent decimal(16, 2),
	address char(60),
	upperunit char(60),
	legalrep char(16),
	repduty char(16),
	linkman char(16),
	tele char(16),
	fax char(16),
	bank char(60),
	account char(60),
	accname char(60),
	bookindate datetime,
	builddate datetime,
	logoutdate datetime,
	audityear datetime,
	employs float,
	sumwage decimal(16, 2),
	dispercent decimal(16, 2),
	t_employs float,
	t_sumwage decimal(16, 2),
	t_dispercent decimal(16, 2),
	l_employs float,
	l_sumwage decimal(16, 2),
	gs_paypercent decimal(16, 2),
	gspay decimal(16, 2),
	sy_paypercent decimal(16, 2),
	sypay decimal(16, 2),
	wbcode char(10),
	pycode char(10),
	fundflag float,
	stateflag float,
	updateflag char(60));
INSERT INTO unitinfo VALUES (
	'011050',
	'县人事局',
	'市区',
	'行政单位',
	6.00,
	2.00,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-2002 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	3.50,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	1,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'011054',
	'县体育局',
	'市区',
	'行政单位',
	6.00,
	2.00,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-2002 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	3.50,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	1,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014089',
	'沙坡镇财政所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014098',
	'月垌乡财政所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'011062',
	'县物价局',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'011063',
	'县审计局',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014100',
	'良田镇财政所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014104',
	'马坡镇土地所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014105',
	'沙坡镇土地所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'011075',
	'陆川县社会福利院',
	'<未定>',
	'事业单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014106',
	'珊罗镇土地所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014108',
	'米场镇土地所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014109',
	'沙湖乡土地所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014111',
	'大桥镇土地所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014112',
	'横山乡土地所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014118',
	'古城镇土地所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014128',
	'马坡镇计划生育办公室',
	'<未定>',
	'事业单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014123',
	'各乡镇水利站',
	'<未定>',
	'事业单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	-6,
	-2941.16,
	0,
	-2,
	-1541.33,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'011073',
	'陆川县民政局',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014132',
	'米场镇计划生育办公室',
	'<未定>',
	'事业单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'011080',
	'县法院',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014137',
	'乌石镇计划生育办公室',
	'<未定>',
	'事业单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014248',
	'沙湖乡村建站',
	'<未定>',
	'事业单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'011041',
	'陆川报社',
	'<未定>',
	'事业单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'011087',
	'陆城镇财政所',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014144',
	'马坡镇人民政府',
	'乡镇',
	'行政单位',
	6.00,
	2.00,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-2002 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	81,
	45689.00,
	0,
	18,
	12274.00,
	3.50,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	1,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'011103',
	'县国土资源局',
	'<未定>',
	'行政单位',
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
	2,
	1,
	'00110010111100111101110111111111111111111111111111');
INSERT INTO unitinfo VALUES (
	'014143',
	'陆城镇人民政府',
	'市区',
	'行政单位',
	6.00,
	2.00,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1-1-2002 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-1900 0:0:0.000',
	'1-1-2002 0:0:0.000',
	55,
	32384.00,
	0,
	5,
	3561.00,
	3.50,
	0,
	0,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'1',
12 3 4 5 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -