checkin.sql

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

	'0001',
	'755350202',
	'011284',
	'011284210284',
	'周华昆',
	'男',
	67,
	'内科一区',
	'10-17-2002 0:0:0.000',
	'10-23-2002 15:34:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'769770201',
	'014311',
	'014311210244',
	'李毅华',
	'男',
	79,
	'内科三区',
	'10-15-2002 0:0:0.000',
	'10-24-2002 10:18:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'760120202',
	'014312',
	'014312210450',
	'罗达钦',
	'男',
	67,
	'内科三区',
	'10-14-2002 0:0:0.000',
	'10-24-2002 14:31:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'766230201',
	'012017',
	'012017220554',
	'梁大明',
	'女',
	59,
	'内科三区',
	'10-1-2002 0:0:0.000',
	'10-25-2002 8:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'769050201',
	'011002',
	'011002110013',
	'吕汉新',
	'男',
	48,
	'五官科',
	'10-14-2002 0:0:0.000',
	'10-25-2002 9:15:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'654800201',
	'011082',
	'011082210112',
	'吕仕才',
	'男',
	71,
	'内科三区',
	'12-3-2002 0:0:0.000',
	'10-28-2002 15:1:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'770610201',
	'011081',
	'011081210035',
	'陈德浩',
	'男',
	67,
	'外科一区',
	'10-28-2002 0:0:0.000',
	'10-28-2002 16:0:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'773060201',
	'014308',
	'014308110246',
	'钟华权',
	'男',
	51,
	'外科一区',
	'10-30-2002 0:0:0.000',
	'11-2-2002 14:46:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'771820201',
	'011119',
	'011119210022',
	'江淇',
	'男',
	63,
	'外科一区',
	'10-24-2002 0:0:0.000',
	'11-3-2002 10:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'768190201',
	'014319',
	'014319210123',
	'陈权昌',
	'男',
	67,
	'内科三区',
	'10-11-2002 0:0:0.000',
	'11-4-2002 10:35:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'304330202',
	'011227',
	'011227210032',
	'陈仁玉',
	'男',
	65,
	'脑系科',
	'11-1-2002 0:0:0.000',
	'11-4-2002 15:58:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'672230202',
	'012017',
	'012017220537',
	'魏君',
	'女',
	75,
	'脑系科',
	'10-31-2002 0:0:0.000',
	'11-6-2002 10:2:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'773630201',
	'012017',
	'012017110138',
	'陈德柱',
	'男',
	55,
	'内科一区',
	'10-31-2002 0:0:0.000',
	'11-7-2002 15:5:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'775050201',
	'011080',
	'011080110072',
	'罗锦辉',
	'男',
	25,
	'外科一区',
	'11-7-2002 0:0:0.000',
	'11-9-2002 9:39:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'773940201',
	'014144',
	'014144210089',
	'庞志信',
	'男',
	61,
	'内科三区',
	'11-4-2002 0:0:0.000',
	'11-11-2002 9:36:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'772800201',
	'018006',
	'018006120050',
	'吴惠英',
	'女',
	41,
	'妇产科',
	'11-8-2002 0:0:0.000',
	'11-11-2002 10:25:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'757390201',
	'011078',
	'011078110209',
	'林圣',
	'男',
	33,
	'五官科',
	'8-28-2002 0:0:0.000',
	'11-11-2002 10:31:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'775710201',
	'011078',
	'011078210390',
	'蓝炳富',
	'男',
	60,
	'内科一区',
	NULL,
	'11-12-2002 9:34:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'581400203',
	'014310',
	'014310220456',
	'李育芬',
	'女',
	80,
	'内科三区',
	'11-4-2002 0:0:0.000',
	'11-12-2002 10:13:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'762510201',
	'011298',
	'011298220202',
	'陈名英',
	'女',
	69,
	'脑系科',
	'9-25-2002 0:0:0.000',
	'11-12-2002 16:15:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'775320201',
	'014311',
	'014311210225',
	'陈瑞权',
	'男',
	70,
	'脑系科',
	'11-7-2002 0:0:0.000',
	'11-15-2002 8:59:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'709080202',
	'014308',
	'014308210053',
	'林祖明',
	'男',
	67,
	'内科三区',
	'11-5-2002 0:0:0.000',
	'11-15-2002 9:27:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'777900201',
	'011025',
	'011025110009',
	'宁梦佳',
	'男',
	39,
	'内科一区',
	'11-16-2002 0:0:0.000',
	'11-17-2002 15:23:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'766900201',
	'014310',
	'014310210421',
	'陈华文',
	'男',
	73,
	'内科一区',
	'10-9-2002 0:0:0.000',
	'11-19-2002 9:33:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'772810201',
	'014308',
	'014308120129',
	'吕文英',
	'女',
	53,
	'外科一区',
	'10-28-2002 0:0:0.000',
	'11-19-2002 15:42:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'777800203',
	'011061',
	'011061210022',
	'林福斌',
	'男',
	71,
	'内科一区',
	'11-18-2002 0:0:0.000',
	'11-20-2002 11:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'778110204',
	'011073',
	'011073110007',
	'陈运生',
	'男',
	55,
	'五官科',
	'7-11-2002 0:0:0.000',
	'11-21-2002 15:20:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'777120201',
	'014308',
	'014308220155',
	'吕燕珍',
	'女',
	59,
	'五官科',
	'11-13-2002 0:0:0.000',
	'11-22-2002 10:4:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'771160202',
	'011284',
	'011284110014',
	'范桓意',
	'男',
	47,
	'内科三区',
	'10-31-2002 0:0:0.000',
	'11-25-2002 10:20:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'726160203',
	'014308',
	'014308210624',
	'吕秉荣',
	'男',
	66,
	'内科一区',
	'11-25-2002 0:0:0.000',
	'11-27-2002 11:18:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'704260201',
	'012017',
	'012017110018',
	'李琰光',
	'男',
	48,
	'外科一区',
	'11-25-2002 0:0:0.000',
	'11-27-2002 15:18:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'779060201',
	'011068',
	'011068110047',
	'刘伟科',
	'男',
	23,
	'外科一区',
	'11-20-2002 0:0:0.000',
	'11-28-2002 11:0:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'776810201',
	'011222',
	'011222110047',
	'李恒清',
	'男',
	47,
	'妇产科',
	'11-11-2002 0:0:0.000',
	'11-28-2002 15:24:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'777130201',
	'011227',
	'011227210030',
	'陈庆元',
	'男',
	64,
	'内科三区',
	'11-14-2002 0:0:0.000',
	'11-28-2002 15:27:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'742870201',
	'011078',
	'011078110022',
	'黄宗礼',
	'男',
	49,
	'内科一区',
	'7-8-2002 0:0:0.000',
	'11-29-2002 10:42:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'777630201',
	'018012',
	'018012220128',
	'黎瑞芳',
	'女',
	70,
	'外科一区',
	'11-18-2002 0:0:0.000',
	'11-29-2002 15:24:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'773350201',
	'014315',
	'014315110051',
	'罗子科',
	'男',
	53,
	'内科一区',
	'11-8-2002 0:0:0.000',
	'11-29-2002 15:27:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'705890202',
	'011064',
	'011064210023',
	'张永盛',
	'男',
	69,
	'内科三区',
	'11-8-2002 0:0:0.000',
	'11-30-2002 10:29:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'779960201',
	'014310',
	'014310210371',
	'陈文青',
	'男',
	69,
	'内科三区',
	'11-27-2002 0:0:0.000',
	'12-1-2002 10:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'780810201',
	'014308',
	'014308210472',
	'谭培恩',
	'男',
	73,
	'外二科',
	'11-28-2002 0:0:0.000',
	'12-1-2002 10:32:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'780400201',
	'017008',
	'017008210134',
	'陈道能',
	'男',
	67,
	'内科三区',
	NULL,
	'12-1-2002 11:29:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'781370201',
	'011227',
	'011227120023',
	'蓝美青',
	'女',
	43,
	'内科一区',
	'11-29-2002 0:0:0.000',
	'12-2-2002 9:15:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'725890201',
	'012017',
	'012017110095',
	'戴迭宗',
	'男',
	28,
	'内科一区',
	'5-6-2002 0:0:0.000',
	'12-6-2002 14:26:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'781550201',
	'014310',
	'014310110223',
	'陈志翔',
	'男',
	21,
	'内科一区',
	'12-6-2002 0:0:0.000',
	'12-8-2002 9:48:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'781790201',
	'014303',
	'014303220454',
	'李绍清',
	'女',
	83,
	'门诊部',
	'12-3-2002 0:0:0.000',
	'12-8-2002 15:44:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'782900201',
	'011036',
	'011036110004',
	'吕代景',
	'男',
	48,
	'外科一区',
	'12-9-2002 0:0:0.000',
	'12-10-2002 11:13:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'782470201',
	'017008',
	'017008210164',
	'江崇仁',
	'男',
	91,
	'内科一区',
	'12-4-2002 0:0:0.000',
	'12-10-2002 14:39:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'782990201',
	'018012',
	'018012110035',
	'丘绍伟',
	'男',
	37,
	'外科一区',
	'12-9-2002 0:0:0.000',
	'12-12-2002 9:40:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'768190202',
	'014319',
	'014319210123',
	'陈权昌',
	'男',
	67,
	'内科三区',
	'12-10-2002 0:0:0.000',
	'12-12-2002 14:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'785320203',
	'011002',
	'011002110005',
	'刘云',
	'男',
	56,
	'脑系科',
	'12-12-2002 0:0:0.000',
	'12-12-2002 16:55:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'765650205',
	'011162',
	'011162110003',
	'陈德坤',
	'男',
	59,
	'内科三区',
	'12-11-2002 0:0:0.000',
	'12-13-2002 10:50:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'775060201',
	'011042',
	'011042210025',
	'甘开畴',
	'男',
	68,
	'内科三区',
	'11-18-2002 0:0:0.000',
	'12-13-2002 16:6:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'200201',
	'014308',
	'014308220421',
	'苏波',
	'女',
	57,
	'内儿科',
	'7-8-2002 0:0:0.000',
	'7-10-2002 15:9:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'190201',
	'011068',
	'011068110017',
	'黎阳光',
	'男',
	54,
	'内儿科',
	'6-26-2002 0:0:0.000',
	'7-11-2002 16:53:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'210201',
	'014308',
	'014308210589',
	'吕广孝',
	'男',
	69,
	'外科',
	'7-8-2002 0:0:0.000',
	'7-15-2002 14:40:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'220207',
	'011069',
	'011069210025',
	'余明学',
	'男',
	70,
	'内儿科',
	NULL,
	'7-16-2002 16:48:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'250201',
	'018002',
	'018002210106',
	'刘德南',
	'男',
	63,
	'内儿科',
	'7-19-2002 0:0:0.000',
	'7-26-2002 14:47:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'260201',
	'011284',
	'011284220305',
	'吕汉琪',
	'女',
	71,
	'内儿科',
	'7-19-2002 0:0:0.000',
	'7-26-2002 16:36:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'240203',
	'018001',
	'018001410179',
	'刘俊林',
	'男',
	56,
	'内儿科',
	'7-16-2002 0:0:0.000',
	'7-29-2002 10:10:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'280201',
	'011024',
	'011024210050',
	'陈伟铨',
	'男',
	72,
	'内儿科',
	'8-13-2002 0:0:0.000',
	'8-20-2002 14:31:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'270201',
	'017020',
	'017020110020',
	'朱和相',
	'男',
	55,
	'内儿科',
	'8-6-2002 0:0:0.000',
	'8-22-2002 15:58:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'310201',
	'011279',
	'011279210053',
	'杨承忠',
	'男',
	55,
	'内儿科',
	'1-13-2002 0:0:0.000',
	'8-26-2002 8:13:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'320202',
	'011024',
	'011024210050',
	'陈伟铨',
	'男',
	72,
	'内儿科',
	'8-23-2002 0:0:0.000',
	'8-31-2002 10:41:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'300203',
	'017020',
	'017020210024',
	'丘兆南',
	'男',
	64,
	'内儿科',
	'8-17-2002 0:0:0.000',
	'9-1-2002 16:16:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'250203',
	'011279',
	'011279210052',
	'胡增福',
	'男',
	62,
	'内儿科',
	'8-5-2002 0:0:0.000',
	'9-6-2002 9:54:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100020201',
	'015033',
	'015033120017',
	'江友芬',
	'女',
	50,
	'内科',
	'6-21-2002 0:0:0.000',
	'7-1-2002 14:33:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100050201',
	'014319',
	'014319210236',
	'王子华',
	'男',
	74,
	'内科',
	'7-18-2002 0:0:0.000',
	'7-28-2002 10:57:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100030201',
	'014319',
	'014319120478',
	'谢伟英',
	'女',
	47,
	'内科',
	'7-6-2002 0:0:0.000',
	'7-24-2002 15:2:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100040201',
	'014319',
	'014319210235',
	'王乃龙',
	'男',
	74,
	'内科',
	'7-16-2002 0:0:0.000',
	'8-2-2002 9:23:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100060201',
	'015033',
	'015033210025',
	'万和昌```',
	'男',
	71,
	'内科',
	'8-7-2002 0:0:0.000',
	'8-15-2002 11:33:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0019',
	'100070201',
	'015033',
	'015033110014',
	'庞福记',
	'男',
	57,