数据库字段表.txt

医院管理方面的例子

1.
babies 表

1	babyid	bigint	8	0
0	name	char	20	0
0	sex	char	2	1
0	birthday	datetime	8	1
0	realage	int	4	1
0	addree	varchar	50	1
0	telphone	char	16	1
0	carid	char	13	1
2	birthdaynow	nvarchar	32	0
0	pictrue	image	16	1

2.
babyeyeillcheck 表

3	checkid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	motherstrong	varchar	100	1
0	babyo2	char	2	1
0	saveillrecord	char	2	1
0	eyeoutill	char	2	1
0	mothermeidacor	varchar	100	1
0	birthdayrecord	char	10	1
0	eatrecord	char	10	1
0	eatgood	char	10	1
0	eatmethod	char	10	1
0	lookertvtime	char	20	1

3.
beforeill 表
3	beforeillid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	nothingill	char	10	1
0	nofarsee	char	10	1
0	farsee	char	10	1
0	nopowersee	char	10	1
0	bysee	char	10	1
0	chateye	char	10	1
0	othereyeillone	char	10	1
0	othereyeilltwo	char	10	1
0	othereyeillthree	char	10	1

4. babyeyeillcheck 表

3	checkid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	motherstrong	varchar	100	1
0	mothermeidacor	varchar	100	1
0	birthdayrecord	char	10	1
0	babyo2	char	2	1
0	eatrecord	char	10	1
0	saveillrecord	char	2	1
0	eatgood	char	10	1
0	eyeoutill	char	2	1
0	eatmethod	char	10	1
0	lookertvtime	char	20	1

5. havebabyill 表

3	matherillid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	nothingill	char	10	1
0	clouhotill	char	10	1
0	renchengao	char	10	1
0	tangniao	char	10	1
0	otherill	char	10	1
0	otherillone	char	10	1
0	otherilltwo	char	10	1
0	otherillthree	char	10	1

6.beforeill 表

3	beforeillid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	nothingill	char	10	1
0	nofarsee	char	10	1
0	farsee	char	10	1
0	nopowersee	char	10	1
0	bysee	char	10	1
0	chateye	char	10	1
0	othereyeillone	char	10	1
0	othereyeilltwo	char	10	1
0	othereyeillthree	char	10	1

7. doctorcase 表

3	doctorcaseid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	noseedoctoer	char	10	1
0	withclassseze	char	10	1
0	medicor	char	10	1
0	tools	char	10	1
0	handnife	char	10	1
0	aother	char	10	1
0	aotherone	char	10	1
0	aothertwo	char	10	1



8. faimlyrecord 表

3	familid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	cheknuber	char	10	1
0	nothingill	char	10	1
0	nofarsee	char	10	1
0	farsee	char	10	1
0	nopowersee	char	10	1
0	bysee	char	10	1
0	othereyeill	char	10	1
0	othereyeillone	char	10	1
0	othereyeilltwo	char	10	1
0	othereyeillthree	char	10	1

9. bianhao 表

3	bhid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	bianhao	char	10	0
0	other	char	10	1

10. school 表
3	schoolid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	schoolname	char	30	1



11. eyepower 表

3	eyepowerid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	od	char	10	1
0	odjr	char	10	1
0	odball	char	10	1
0	odzhu	char	10	1
0	odzhou	char	10	1
0	os	char	10	1
0	osjr	char	10	1
0	osball	char	10	1
0	oszhu	char	10	1
0	oszhou	char	10	1

12. right_yanjan 表

3	yjid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	uptodown	char	10	1
0	daojie	char	10	1
0	jianbanda	char	10	1
0	other	char	10	1
0	otherone	char	10	1
0	othertwo	char	10	1

13. right_jiemo 表

3	jmid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	chateye	char	10	1
0	jiemoyan	char	10	1
0	jieshi	char	10	1
0	other	char	10	1
0	otherone	char	10	1
0	othertwo	char	10	1

14. right_jiaomo 表

3	jiaomoid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	jiaomobaiban	char	10	1
0	xiaojiaomo	char	10	1
0	dajiaomo	char	10	1
0	jiaomoyan	char	10	1
0	other	char	10	1
0	otherone	char	10	1
0	othertwo	char	10	1
0	otherthree	char	10	1

15. right_tongkong 表

3	tongkongid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	yuan	char	10	1
0	buguize	char	10	1
0	zhengchang	char	10	1
0	chi	char	10	1
0	other	char	10	1
0	otherone	char	10	1
0	othertwo	char	10	1
0	otherthree	char	10	1

16. right_qianfang 表

3	qianfangid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	shen	char	10	1
0	qian	char	10	1
0	fangshan	char	10	1
0	other	char	10	1

17. right_jingzhuangti 表

3	jingzhangid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	hunzhuo	char	10	1
0	tuowei	char	10	1
0	other	char	10	1

18. right_yandi 表

3	yandiid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	xiaoshikong	char	10	1
0	other	char	10	1

19. right_yanwei 表

3	yanweiid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	zhengwei	char	10	1
0	inbysee	char	10	1
0	outbysee	char	10	1
0	other	char	10	1



12. left_yanjan 表

3	yjid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	uptodown	char	10	1
0	daojie	char	10	1
0	jianbanda	char	10	1
0	other	char	10	1
0	otherone	char	10	1
0	othertwo	char	10	1

13. left_jiemo 表

3	jmid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	chateye	char	10	1
0	jiemoyan	char	10	1
0	jieshi	char	10	1
0	other	char	10	1
0	otherone	char	10	1
0	othertwo	char	10	1

14. left_jiaomo 表

3	jiaomoid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	jiaomobaiban	char	10	1
0	xiaojiaomo	char	10	1
0	dajiaomo	char	10	1
0	jiaomoyan	char	10	1
0	other	char	10	1
0	otherone	char	10	1
0	othertwo	char	10	1
0	otherthree	char	10	1

15. left_tongkong 表

3	tongkongid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	yuan	char	10	1
0	buguize	char	10	1
0	zhengchang	char	10	1
0	chi	char	10	1
0	other	char	10	1
0	otherone	char	10	1
0	othertwo	char	10	1
0	otherthree	char	10	1

16. left_qianfang 表

3	qianfangid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	shen	char	10	1
0	qian	char	10	1
0	fangshan	char	10	1
0	other	char	10	1

17. left_jingzhuangti 表

3	jingzhangid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	hunzhuo	char	10	1
0	tuowei	char	10	1
0	other	char	10	1

18. left_yandi 表

3	yandiid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	allgood	char	10	1
0	xiaoshikong	char	10	1
0	other	char	10	1

19. left_yanwei 表

3	yanweiid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	zhengwei	char	10	1
0	inbysee	char	10	1
0	outbysee	char	10	1
0	other	char	10	1

20. caozuorecord 表

3	caozuoid	bigint	8	0
0	birthdaynow	nvarchar	32	0
0	caozuoyan	char	10	1
0	shijian	datetime	8	0
0	caozuobh	char	10	1