CREATE TABLE HospData
(
HospID	int	yes	4	10   	0    	no	(n/a)	(n/a)	NULL,
HospID	int	no	4	10   	0    	no	(n/a)	(n/a)	NULL
HospName	nvarchar	no	200	     	     	yes	(n/a)	(n/a)	Chinese_PRC_CI_AS
HospCityID	int	no	4	10   	0    	yes	(n/a)	(n/a)	NULL
HospShort	nvarchar	no	200	     	     	yes	(n/a)	(n/a)	Chinese_PRC_CI_AS
HopsProvince	nvarchar	no	100	     	     	yes	(n/a)	(n/a)	Chinese_PRC_CI_AS
HopsCity	nvarchar	no	100	     	     	yes	(n/a)	(n/a)	Chinese_PRC_CI_AS
HopsArea	nvarchar	no	100	     	     	yes	(n/a)	(n/a)	Chinese_PRC_CI_AS
HospAddress	nvarchar	no	200	     	     	yes	(n/a)	(n/a)	Chinese_PRC_CI_AS
HospTEL	nvarchar	no	100	     	     	yes	(n/a)	(n/a)	Chinese_PRC_CI_AS
HospUnitID	int	no	4	10   	0    	yes	(n/a)	(n/a)	NULL
HospState	int	no	4	10   	0    	yes	(n/a)	(n/a)	NULL
HospOAID	nvarchar	no	100	     	     	yes	(n/a)	(n/a)	Chinese_PRC_CI_AS
HospIntroducerID	int	no	4	10   	0    	yes	(n/a)	(n/a)	NULL
HospIntroducerDate	datetime	no	8	     	     	yes	(n/a)	(n/a)	NULL
HospLevel	int	no	4	10   	0    	yes	(n/a)	(n/a)	NULL
)