hosdepartment.sql

十分好的一个医院管理系统

CREATE TABLE hosdepartment (
	hoscode char(4),
	code char(2),
	name char(20),
	pycode char(5),
	wbcode char(5),
	effectflag float,
	updateflag float);
INSERT INTO hosdepartment VALUES (
	'0001',
	'1',
	'门诊部',
	'MZB',
	'UYU',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'2',
	'急诊科',
	'JZK',
	'TYT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'3',
	'功能科',
	'GNK',
	'ACT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'4',
	'内科一区',
	'NKYQ',
	'MTGA',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'5',
	'五官科门诊',
	'WGKMZ',
	'GPTUY',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'6',
	'皮肤科',
	'PFK',
	'DET',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'7',
	'内科三区',
	'NKSQ',
	'MTDA',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'8',
	'外科一区',
	'WKYQ',
	'QTGA',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'9',
	'脑系科',
	'NXK',
	'ETT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'A',
	'康复科',
	'KFK',
	'YTT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'B',
	'专家',
	'ZJ',
	'FP',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'C',
	'儿科门诊',
	'RKMZ',
	'QTMY',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'D',
	'门诊妇科',
	'MZFK',
	'MYVT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'F',
	'妇产科',
	'VUT',
	'VUT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'i',
	'外二科',
	NULL,
	'QFT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0001',
	'f',
	'五官科',
	NULL,
	'GPT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0006',
	'01',
	'妇科',
	NULL,
	'VT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0006',
	'02',
	'外科',
	NULL,
	'QT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0006',
	'03',
	'内科',
	NULL,
	'MT',
	1,
	1);
INSERT INTO hosdepartment VALUES (
	'0006',
	'04',
	'门诊',
	NULL,
	'UY',
	1,
	1);