checkin.sql

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

	57,
	'内三科',
	'6-19-2002 0:0:0.000',
	'6-28-2002 15:19:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'737730201',
	'014152',
	'014152110064',
	'陈海金',
	'男',
	23,
	'外一科',
	'6-18-2002 0:0:0.000',
	'6-28-2002 15:47:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'726160202',
	'014308',
	'014308210624',
	'吕秉荣',
	'男',
	66,
	'内三科',
	'6-25-2002 0:0:0.000',
	'6-28-2002 16:18:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'160201',
	'011124',
	'011124210028',
	'丘兆辉',
	'男',
	59,
	'内儿科',
	'6-13-2002 0:0:0.000',
	'6-28-2002 14:44:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0002',
	'180201',
	'011279',
	'011279110010',
	'陈文昭',
	'男',
	58,
	'外科',
	'6-25-2002 0:0:0.000',
	'6-30-2002 10:22:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'574500203',
	'011242',
	'011242210026',
	'丘礼芳',
	'男',
	71,
	'内科一区',
	'7-22-2002 0:0:0.000',
	'7-22-2002 16:36:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'736790201',
	'014319',
	'014319110009',
	'黄祖昌',
	'男',
	59,
	'脑系科',
	'10-28-2002 0:0:0.000',
	'7-25-2002 15:20:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'734860202',
	'014303',
	'014303210442',
	'易宗信',
	'男',
	66,
	'外科一区',
	'6-24-2002 0:0:0.000',
	'7-26-2002 8:34:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'742000201',
	'011279',
	'011279210041',
	'钟允炎',
	'男',
	70,
	'内科三区',
	'7-25-2002 0:0:0.000',
	'7-26-2002 9:40:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'740850201',
	'014303',
	'014303110136',
	'莫振清',
	'男',
	53,
	'内科三区',
	'7-6-2002 0:0:0.000',
	'7-26-2002 15:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'742230201',
	'011057',
	'011057120014',
	'李璟',
	'女',
	21,
	'妇产科',
	'7-26-2002 0:0:0.000',
	'7-26-2002 16:41:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'743510201',
	'014149',
	'014149210056',
	'陈焕其',
	'男',
	67,
	'脑系科',
	'7-26-2002 0:0:0.000',
	'7-27-2002 8:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'742340201',
	'014303',
	'014303210431',
	'林庾才',
	'男',
	66,
	'脑系科',
	'7-27-2002 0:0:0.000',
	'7-27-2002 9:7:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'743510202',
	'014149',
	'014149210056',
	'陈焕其',
	'男',
	67,
	'脑系科',
	'7-27-2002 0:0:0.000',
	'7-27-2002 10:55:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'739170201',
	'014305',
	'014305210165',
	'李达通',
	'男',
	77,
	'内科三区',
	'6-22-2002 0:0:0.000',
	'7-29-2002 9:51:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'745030201',
	'014306',
	'014306120187',
	'杨冬梅',
	'女',
	26,
	'妇产科',
	'7-25-2002 0:0:0.000',
	'7-31-2002 9:55:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'732110202',
	'018008',
	'018008210048',
	'黄理性',
	'男',
	70,
	'内科三区',
	'7-30-2002 0:0:0.000',
	'7-31-2002 16:2:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'739120201',
	'014311',
	'014311110025',
	'陈纪强',
	'男',
	39,
	'内科一区',
	'6-22-2002 0:0:0.000',
	'8-1-2002 14:22:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'749650201',
	'017020',
	'017020120006',
	'陈燕',
	'女',
	28,
	'妇产科',
	'8-2-2002 0:0:0.000',
	'8-5-2002 10:42:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'465650203',
	'011162',
	'011162110003',
	'陈德坤',
	'男',
	59,
	'内科三区',
	'7-24-2002 0:0:0.000',
	'8-5-2002 11:1:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'747710201',
	'018002',
	'018002210123',
	'吴兴荣',
	'男',
	76,
	'内科一区',
	'7-24-2002 0:0:0.000',
	'8-7-2002 10:56:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'723650203',
	'011259',
	'011259110004',
	'陈岳良',
	'男',
	33,
	'五官科门诊',
	'8-8-2002 0:0:0.000',
	'8-12-2002 14:54:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'684490202',
	'014098',
	'014098110001',
	'郭益宏',
	'男',
	33,
	'内科一区',
	NULL,
	'8-12-2002 16:22:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'751560201',
	'014310',
	'014310110025',
	'陈德才',
	'男',
	53,
	'外科一区',
	NULL,
	'8-14-2002 10:23:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'752990205',
	'018001',
	'018001410179',
	'刘俊林',
	'男',
	56,
	'外科一区',
	'8-10-2002 0:0:0.000',
	'8-15-2002 11:8:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'753920201',
	'014319',
	'014319210411',
	'李明先',
	'男',
	69,
	'内科三区',
	'8-14-2002 0:0:0.000',
	'8-16-2002 9:7:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'741460201',
	'014316',
	'014316210365',
	'谢文德',
	'男',
	62,
	'内科三区',
	'7-24-2002 0:0:0.000',
	'8-16-2002 14:48:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'749890201',
	'011222',
	'011222110024',
	'陈纯全',
	'男',
	53,
	'内科三区',
	'8-1-2002 0:0:0.000',
	'8-21-2002 16:8:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'755200201',
	'011321',
	'011321220018',
	'陈翠珍',
	'女',
	49,
	'内科三区',
	'11-28-2002 0:0:0.000',
	'8-29-2002 11:10:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'753900201',
	'014310',
	'014310210355',
	'胡松林',
	'男',
	78,
	'外科一区',
	'8-14-2002 0:0:0.000',
	'8-30-2002 10:1:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'757160201',
	'014303',
	'014303210441',
	'吕伟华',
	'男',
	74,
	'脑系科',
	'8-26-2002 0:0:0.000',
	'9-3-2002 10:40:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'581400201',
	'014310',
	'014310220456',
	'李育芬',
	'女',
	80,
	'内科三区',
	'8-26-2002 0:0:0.000',
	'9-3-2002 11:10:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'747150201',
	'011294',
	'011294110001',
	'吕声群',
	'男',
	60,
	'五官科门诊',
	'12-6-2002 0:0:0.000',
	'9-4-2002 15:15:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'755200202',
	'011321',
	'011321220018',
	'陈翠珍',
	'女',
	49,
	'内科三区',
	'11-28-2002 0:0:0.000',
	'9-6-2002 15:19:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'759800201',
	'014308',
	'014308120462',
	'黄敏',
	'女',
	36,
	'妇产科',
	'9-11-2002 0:0:0.000',
	'9-11-2002 15:13:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'753550201',
	'011279',
	'011279110011',
	'黎康生',
	'男',
	42,
	'外二科',
	'8-12-2002 0:0:0.000',
	'9-11-2002 15:35:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'760120201',
	'014312',
	'014312210450',
	'罗达钦',
	'男',
	67,
	'内科三区',
	'9-6-2002 0:0:0.000',
	'9-12-2002 11:33:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'758210201',
	'011061',
	'011061210022',
	'林福斌',
	'男',
	71,
	'内科一区',
	'11-18-2002 0:0:0.000',
	'9-12-2002 15:1:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'761290201',
	'011078',
	'011078110273',
	'温永龙',
	'男',
	37,
	'外科一区',
	'9-11-2002 0:0:0.000',
	'9-12-2002 16:44:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'760080201',
	'014308',
	'014308120347',
	'吕华枫',
	'女',
	26,
	'门诊妇科',
	'9-6-2002 0:0:0.000',
	'9-13-2002 9:7:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'757730201',
	'018012',
	'018012220140',
	'丘燕娟',
	'女',
	67,
	'脑系科',
	'8-28-2002 0:0:0.000',
	'9-14-2002 11:6:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'758620201',
	'011227',
	'011227120022',
	'吕朝炜',
	'女',
	52,
	'脑系科',
	'8-31-2002 0:0:0.000',
	'9-16-2002 9:5:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'756940201',
	'014144',
	'014144110019',
	'覃世升',
	'男',
	60,
	'脑系科',
	NULL,
	'9-16-2002 10:8:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'687600201',
	'012017',
	'012017120219',
	'叶伟琴',
	'女',
	48,
	'外二科',
	'8-12-2002 0:0:0.000',
	'9-17-2002 15:47:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'684490203',
	'014098',
	'014098110001',
	'郭益宏',
	'男',
	33,
	'内科一区',
	NULL,
	'9-17-2002 16:36:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'753360201',
	'011284',
	'011284110008',
	'吕夏声',
	'男',
	59,
	'脑系科',
	'8-12-2002 0:0:0.000',
	'9-18-2002 10:37:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'760860201',
	'014305',
	'014305210067',
	'戴家济',
	'男',
	74,
	'五官科门诊',
	'9-16-2002 0:0:0.000',
	'9-19-2002 15:43:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'761200201',
	'011046',
	'011046210064',
	'卢述贵',
	'男',
	61,
	'脑系科',
	'9-12-2002 0:0:0.000',
	'9-20-2002 15:22:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'761850201',
	'012017',
	'012017220566',
	'吕美珍',
	'女',
	60,
	'五官科',
	'9-13-2002 0:0:0.000',
	'9-24-2002 9:57:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'765650204',
	'011162',
	'011162110003',
	'陈德坤',
	'男',
	59,
	'内科三区',
	'9-24-2002 0:0:0.000',
	'9-25-2002 10:9:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'762540202',
	'011078',
	'011078210385',
	'罗秀成',
	'男',
	67,
	'外科一区',
	'9-19-2002 0:0:0.000',
	'9-25-2002 14:48:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'764440201',
	'011025',
	'011025210012',
	'丘家勇',
	'男',
	70,
	'内科三区',
	'9-24-2002 0:0:0.000',
	'9-30-2002 9:7:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'728020202',
	'018012',
	'018012210115',
	'李炳俊',
	'男',
	74,
	'内科三区',
	'9-6-2002 0:0:0.000',
	'9-30-2002 9:11:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'581400202',
	'014310',
	'014310220456',
	'李育芬',
	'女',
	80,
	'内科三区',
	'9-23-2002 0:0:0.000',
	'9-30-2002 11:13:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'762980201',
	'014144',
	'014144210084',
	'梁明华',
	'男',
	77,
	'外科一区',
	'9-18-2002 0:0:0.000',
	'9-30-2002 11:20:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'755200203',
	'011321',
	'011321220018',
	'陈翠珍',
	'女',
	49,
	'内科三区',
	'11-28-2002 0:0:0.000',
	'10-8-2002 8:51:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'690210203',
	'012017',
	'012017110127',
	'罗忠才',
	'男',
	39,
	'门诊部',
	'8-27-2002 0:0:0.000',
	'10-8-2002 10:7:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'762810201',
	'014303',
	'014303210405',
	'田深育',
	'男',
	71,
	'脑系科',
	'9-20-2002 0:0:0.000',
	'10-8-2002 10:40:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'760820201',
	'011284',
	'011284110040',
	'温健聪',
	'男',
	50,
	'脑系科',
	'9-9-2002 0:0:0.000',
	'10-8-2002 11:4:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'699520203',
	'011080',
	'011080210131',
	'徐为生',
	'男',
	77,
	'内科三区',
	'9-30-2002 0:0:0.000',
	'10-9-2002 14:44:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'764630201',
	'012017',
	'012017120334',
	'庞晓婷',
	'女',
	29,
	'妇产科',
	'9-25-2002 0:0:0.000',
	'10-10-2002 10:7:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'765920201',
	'011078',
	'011078210374',
	'吕汉坤',
	'男',
	61,
	'内科三区',
	'10-8-2002 0:0:0.000',
	'10-11-2002 10:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'768110201',
	'011227',
	'011227210035',
	'周镇权',
	'男',
	64,
	'内科三区',
	'10-8-2002 0:0:0.000',
	'10-14-2002 10:19:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'765370201',
	'014312',
	'014312210451',
	'罗俊权',
	'男',
	71,
	'脑系科',
	'10-9-2002 0:0:0.000',
	'10-15-2002 10:36:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'761200202',
	'011046',
	'011046210064',
	'卢述贵',
	'男',
	61,
	'脑系科',
	'10-9-2002 0:0:0.000',
	'10-15-2002 15:10:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'766320202',
	'018010',
	'018010210080',
	'谭志',
	'男',
	62,
	'内科三区',
	'10-8-2002 0:0:0.000',
	'10-15-2002 15:33:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'746090202',
	'011285',
	'011285120140',
	'李惠娟',
	'女',
	36,
	'五官科',
	'9-21-2002 0:0:0.000',
	'10-16-2002 15:45:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'767290201',
	'014088',
	'014088110040',
	'刘池',
	'男',
	49,
	'内科一区',
	'10-8-2002 0:0:0.000',
	'10-17-2002 9:34:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'767940201',
	'018001',
	'018001210204',
	'吕宣文',
	'男',
	66,
	'内科一区',
	'10-8-2002 0:0:0.000',
	'10-17-2002 10:25:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'766140201',
	'011321',
	'011321210017',
	'吕育光',
	'男',
	61,
	'内科三区',
	'10-1-2002 0:0:0.000',
	'10-18-2002 16:5:0.000',
	1,
	1);
INSERT INTO checkin VALUES (
	'0001',
	'764660201',
	'018007',
	'018007210053',
	'庞庆茂',
	'男',
	62,
	'五官科',
	'9-25-2002 0:0:0.000',
	'10-21-2002 15:21:0.000',
	1,
	1);
INSERT INTO checkin VALUES (