#
#但し、テーブル名を
#CarteDiseaseListTable2
#CarteDisRelationTable
#とシンプルに変えたほうがいいです
#

CREATE TABLE [CarteDiseaseListTable2_new2] (
	[SytmDetailID] [int] NULL ,
	[SytmDetailGroup] [int] NULL ,
	[SymptomID] [int] NULL ,
	[DispArrayNum] [int] NULL ,
	[SytmDetailName] [varchar] (200) COLLATE Japanese_BIN NULL ,
	[FormFlag] [varchar] (10) COLLATE Japanese_BIN NULL ,
	[DeletedFlag] [int] NULL 
) ON [PRIMARY]
GO


CREATE TABLE [CarteDisRelationTable_new_02] (
	[CategoryID] [int] NULL ,
	[DiseaseID] [int] NULL ,
	[DiseaseName] [varchar] (100) COLLATE Japanese_BIN NULL ,
	[ValidFlag] [int] NULL ,
	[OLD4splitName] [varchar] (100) COLLATE Japanese_BIN NULL ,
	[DefaultCheckFlag] [varchar] (500) COLLATE Japanese_BIN NULL 
) ON [PRIMARY]
GO