checkin.sql

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

CREATE TABLE checkin (
	hoscode char(4),
	riceiptcode char(20),
	unitcode char(6),
	personcode char(12),
	sickname char(10),
	sex char(2),
	age float,
	department char(16),
	indate datetime,
	outdate datetime,
	payflag float,
	mcflag float);
INSERT INTO checkin VALUES (
	'0020',
	'12340201',
	'011236',
	'011236120056',
	'李莉',
	'女',
	27,
	'内儿科',
	'4-2-2002 0:0:0.000',
	'4-3-2002 0:0:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'718350201',
	'014302',
	'014302110053',
	'林志南',
	'男',
	49,
	'脑系科',
	'4-12-2002 0:0:0.000',
	'4-12-2002 16:27:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'719670201',
	'011069',
	'011069210025',
	'余明学',
	'男',
	70,
	'内一科',
	NULL,
	'4-13-2002 9:12:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'20020371630',
	'014303',
	'014303210440',
	'黎琼',
	'男',
	71,
	'五官科',
	'3-28-2002 0:0:0.000',
	'4-13-2002 11:22:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'7211290201',
	'014303',
	'014303110025',
	'林成祥',
	'男',
	63,
	'内一科',
	'4-18-2002 0:0:0.000',
	'4-20-2002 8:38:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'721630201',
	'011068',
	'011068210066',
	'冯彬',
	'男',
	62,
	'内一科',
	'4-1-2002 0:0:0.000',
	'4-22-2002 10:35:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'721920201',
	'018010',
	'018010210076',
	'董德光',
	'男',
	76,
	'内一科',
	'4-23-2002 0:0:0.000',
	'4-25-2002 16:17:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'20020346565',
	'011162',
	'011162110003',
	'陈德坤',
	'男',
	59,
	'内三科',
	'3-29-2002 0:0:0.000',
	'4-29-2002 10:42:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'060201',
	'017020',
	'017020210024',
	'丘兆南',
	'男',
	64,
	'内儿科',
	'4-28-2002 0:0:0.000',
	'4-30-2002 14:53:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'080201',
	'011291',
	'011291120080',
	'崔坚',
	'女',
	36,
	'妇产科',
	'4-30-2002 0:0:0.000',
	'4-30-2002 16:48:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'020201',
	'011069',
	'011069210025',
	'余明学',
	'男',
	70,
	'内儿科',
	NULL,
	'5-1-2002 9:53:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'030201',
	'014303',
	'014303120207',
	'姚彩连',
	'女',
	26,
	'妇产科',
	'5-1-2002 0:0:0.000',
	'5-2-2002 9:19:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'722990201',
	'014314',
	'014314110067',
	'阮万赟',
	'男',
	22,
	'内一科',
	'4-24-2002 0:0:0.000',
	'5-5-2002 11:14:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'725580201',
	'014308',
	'014308120335',
	'罗海青',
	'女',
	35,
	'妇产科',
	'5-5-2002 0:0:0.000',
	'5-7-2002 11:4:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'20020371575',
	'012017',
	'012017120220',
	'尹锡文',
	'女',
	47,
	'妇产科',
	'3-25-2002 0:0:0.000',
	'5-8-2002 9:37:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'010201',
	'011291',
	'011291210165',
	'林远光',
	'男',
	68,
	'外科',
	'4-19-2002 0:0:0.000',
	'5-9-2002 10:8:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'050201',
	'011069',
	'011069110015',
	'罗可玉',
	'男',
	57,
	'外科',
	'4-25-2002 0:0:0.000',
	'5-9-2002 16:24:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'721520201',
	'011300',
	'011300120019',
	'韦兰枝',
	'女',
	40,
	'外一科',
	'4-19-2002 0:0:0.000',
	'5-9-2002 9:58:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'719210201',
	'011069',
	'011069110014',
	'陈达军',
	'男',
	47,
	'外一科',
	'4-10-2002 0:0:0.000',
	'5-9-2002 16:24:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'727800201',
	'014303',
	'014303110260',
	'刘远华',
	'男',
	59,
	'脑系科',
	'5-13-2002 0:0:0.000',
	'5-14-2002 10:11:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'725390201',
	'011279',
	'011279220057',
	'刘育端',
	'女',
	67,
	'内三科',
	'5-9-2002 0:0:0.000',
	'5-14-2002 14:55:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'727830201',
	'011064',
	'011064210023',
	'张永盛',
	'男',
	69,
	'内一科',
	'5-14-2002 0:0:0.000',
	'5-18-2002 11:4:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'727430201',
	'011298',
	'011298120064',
	'范琴',
	'女',
	32,
	'妇产科',
	'5-11-2002 0:0:0.000',
	'5-20-2002 11:19:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'728020201',
	'018012',
	'018012210115',
	'李炳俊',
	'男',
	74,
	'内三科',
	'5-14-2002 0:0:0.000',
	'5-20-2002 14:31:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'727840201',
	'014308',
	'014308220228',
	'黎素清',
	'女',
	69,
	'脑系科',
	'5-13-2002 0:0:0.000',
	'5-20-2002 16:3:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'725900201',
	'011078',
	'011078120101',
	'罗春',
	'女',
	27,
	'妇产科',
	'10-3-2002 0:0:0.000',
	'5-20-2002 16:34:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'723830201',
	'018010',
	'018010210090',
	'刘汉元',
	'男',
	63,
	'内一科',
	'4-27-2002 0:0:0.000',
	'5-21-2002 9:41:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'726950201',
	'014312',
	'014312210564',
	'罗开明',
	'男',
	64,
	'脑系科',
	'5-9-2002 0:0:0.000',
	'5-21-2002 10:17:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'727780201',
	'011239',
	'011239120058',
	'吴健春',
	'女',
	41,
	'妇产科',
	'5-15-2002 0:0:0.000',
	'5-21-2002 14:35:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'040201',
	'014308',
	'014308120603',
	'冯春健',
	'女',
	40,
	'内儿科',
	'5-13-2002 0:0:0.000',
	'5-24-2002 13:13:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'721170202',
	'011242',
	'011242210026',
	'丘礼芳',
	'男',
	71,
	'内一科',
	'5-17-2002 0:0:0.000',
	'5-24-2002 10:15:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'701130201',
	'014308',
	'014308120501',
	'李媛先',
	'女',
	37,
	'外一科',
	'4-26-2002 0:0:0.000',
	'5-27-2002 10:15:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'684490201',
	'014098',
	'014098110001',
	'郭益宏',
	'男',
	33,
	'外一科',
	NULL,
	'5-27-2002 11:30:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'666680201',
	'017020',
	'017020210025',
	'廖桂武',
	'男',
	75,
	'脑系科',
	'5-20-2002 0:0:0.000',
	'5-28-2002 14:47:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'110201',
	'011291',
	'011291120057',
	'罗彩琼',
	'女',
	51,
	'内儿科',
	'5-16-2002 0:0:0.000',
	'5-27-2002 10:36:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100010201',
	'014319',
	'014319210474',
	'罗炳东',
	'男',
	82,
	'内科',
	'4-30-2002 0:0:0.000',
	'6-2-2002 0:0:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'730870201',
	'014308',
	'014308120127',
	'吴丽娜',
	'女',
	43,
	'内三科',
	'5-24-2002 0:0:0.000',
	'5-29-2002 10:46:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'721590201',
	'018012',
	'018012220164',
	'林丽群',
	'女',
	52,
	'妇产科',
	NULL,
	'5-29-2002 15:43:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'727390201',
	'011080',
	'011080110100',
	'韦晓颖',
	'男',
	37,
	'外二科',
	'5-14-2002 0:0:0.000',
	'5-29-2002 17:5:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'728230201',
	'011284',
	'011284120250',
	'谢丽娜',
	'女',
	36,
	'脑系科',
	'5-15-2002 0:0:0.000',
	'5-30-2002 8:20:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'726720201',
	'014308',
	'014308210468',
	'李祖明',
	'男',
	67,
	'内一科',
	'5-10-2002 0:0:0.000',
	'5-31-2002 9:15:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'729980201',
	'012017',
	'012017220557',
	'党汝珍',
	'女',
	72,
	'内三科',
	'5-22-2002 0:0:0.000',
	'5-31-2002 9:36:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'728400201',
	'017020',
	'017020210023',
	'吕茂光',
	'男',
	64,
	'内三科',
	'5-16-2002 0:0:0.000',
	'5-31-2002 9:53:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'727790201',
	'014306',
	'014306210473',
	'林广才',
	'男',
	68,
	'门诊五官',
	'5-31-2002 0:0:0.000',
	'5-31-2002 15:19:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'728650201',
	'011082',
	'011082110034',
	'吕志军',
	'男',
	27,
	'门诊五官',
	'5-27-2002 0:0:0.000',
	'5-31-2002 16:1:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'731190201',
	'014318',
	'014318210432',
	'李腾林',
	'男',
	63,
	'脑系科',
	'5-27-2002 0:0:0.000',
	'6-1-2002 9:0:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'100202',
	'017020',
	'017020210024',
	'丘兆南',
	'男',
	64,
	'内儿科',
	'5-15-2002 0:0:0.000',
	'6-1-2002 11:23:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'711320202',
	'011050',
	'011050110007',
	'林桂志',
	'男',
	51,
	'外一科',
	'5-18-2002 0:0:0.000',
	'6-5-2002 9:54:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'731850201',
	'014301',
	'014301110312',
	'覃保育',
	'男',
	54,
	'外一科',
	'5-30-2002 0:0:0.000',
	'6-6-2002 14:36:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'465650202',
	'011162',
	'011162110003',
	'陈德坤',
	'男',
	59,
	'内三科',
	'5-6-2002 0:0:0.000',
	'6-7-2002 10:6:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'730820201',
	'011002',
	'011002110005',
	'刘云',
	'男',
	56,
	'脑系科',
	'5-24-2002 0:0:0.000',
	'6-7-2002 15:41:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'732110201',
	'018008',
	'018008210048',
	'黄理性',
	'男',
	70,
	'内三科',
	'5-29-2002 0:0:0.000',
	'6-10-2002 10:33:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'734860201',
	'014303',
	'014303210442',
	'易宗信',
	'男',
	66,
	'外一科',
	'6-8-2002 0:0:0.000',
	'6-10-2002 11:44:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'727890201',
	'014319',
	'014319120200',
	'范琼清',
	'女',
	22,
	'内三科',
	'5-14-2002 0:0:0.000',
	'6-11-2002 14:33:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'150201',
	'011283',
	'011283210028',
	'陈炎先',
	'男',
	69,
	'内儿科',
	'6-9-2002 0:0:0.000',
	'6-11-2002 15:26:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'120201',
	'018012',
	'018012110057',
	'曾品华',
	'男',
	21,
	'外科',
	'5-20-2002 0:0:0.000',
	'6-12-2002 8:38:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'130201',
	'011279',
	'011279210052',
	'胡增福',
	'男',
	62,
	'内儿科',
	'5-27-2002 0:0:0.000',
	'6-13-2002 8:29:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'070201',
	'011343',
	'011343110004',
	'陈有远',
	'男',
	44,
	'妇产科',
	'4-27-2002 0:0:0.000',
	'6-13-2002 14:47:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'655470201',
	'012017',
	'012017110127',
	'罗忠才',
	'男',
	39,
	'内一科',
	'5-18-2002 0:0:0.000',
	'6-13-2002 15:16:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'170201',
	'011279',
	'011279110012',
	'林日成',
	'男',
	45,
	'外科',
	'6-12-2002 0:0:0.000',
	'6-15-2002 7:57:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'735400201',
	'014318',
	'014318210379',
	'何超祥',
	'男',
	64,
	'内一科',
	'6-9-2002 0:0:0.000',
	'6-17-2002 15:6:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'736270201',
	'014319',
	'014319210118',
	'赖均华',
	'男',
	77,
	'内一科',
	'6-13-2002 0:0:0.000',
	'6-17-2002 16:13:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'140206',
	'011069',
	'011069210025',
	'余明学',
	'男',
	70,
	'内儿科',
	NULL,
	'6-19-2002 10:14:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'723300201',
	'014303',
	'014303110203',
	'林家柱',
	'男',
	50,
	'外一科',
	'4-25-2002 0:0:0.000',
	'6-22-2002 8:42:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'731690201',
	'011290',
	'011290210195',
	'吕辑高',
	'男',
	75,
	'内三科',
	'6-27-2002 0:0:0.000',
	'6-24-2002 15:12:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'737530201',
	'014306',
	'014306110394',
	'李庆瑞',
	'男',
	60,
	'内三科',
	'6-18-2002 0:0:0.000',
	'6-26-2002 10:8:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'737890201',
	'014316',
	'014316210350',
	'周桂荣',
	'男',
	68,
	'内一科',
	'6-19-2002 0:0:0.000',
	'6-26-2002 16:30:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'735720201',
	'014311',
	'014311210259',
	'肖炎',
	'男',
	67,
	'内一科',
	'6-10-2002 0:0:0.000',
	'6-27-2002 10:28:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'736100201',
	'011284',
	'011284220305',
	'吕汉琪',
	'女',
	71,
	'内一科',
	'6-12-2002 0:0:0.000',
	'6-28-2002 10:41:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'738190201',
	'011124',
	'011124110008',
	'凌天胜',
	'男',