create table HospData(
|
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
|
)
|
