CREATE TABLE AgeCategoryTable (
	CategoryID int NOT NULL ,
	CategoryName varchar (50)  NULL ,
	MinDay int NULL ,
	MaxDay int NULL ,
	ValidFlag int NOT NULL,
	PRIMARY KEY (CategoryID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE ConsultNameTable (
	DiagnosisID int NOT NULL ,
	DiagnosisContents varchar (100)  NULL ,
	DiagnosisContentsS3 varchar (100)  NULL ,
	DiagnosisContentsS5 varchar (100)  NULL ,
	DiagnosisContentsL3 varchar (100)  NULL ,
	DiagnosisContentsL5 varchar (100)  NULL ,
	R3HKK_DiagnosisContents varchar (300)  NULL ,
	R3HKK_DiagFileName varchar (50)  NULL,
	PRIMARY KEY (DiagnosisID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE ConsultRelationTable (
	TDRelationID int NOT NULL ,
	DAnswerID int NOT NULL,
	PRIMARY KEY (TDRelationID, DAnswerID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE ConsultResultTable (
	TDRelationID int NOT NULL ,
	CategoryID int NOT NULL ,
	DiagnosisID int NOT NULL ,
	TreatmentName varchar (8000)  NULL,
	PRIMARY KEY (TDRelationID, CategoryID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE DAExaminationTable (
	DAnswerID int NOT NULL ,
	CategoryID int NOT NULL ,
	DQuestionID int NOT NULL ,
	DAContents varchar (250)  NULL ,
	DAParameter int NULL,
	PRIMARY KEY (DAnswerID, CategoryID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE DQExaminationTable (
	DQuestionID int NOT NULL ,
	CategoryID int NOT NULL ,
	DiseaseID int NOT NULL ,
	DQContents varchar (250)  NULL ,
	DQParameter int NULL,
	PRIMARY KEY (DQuestionID, CategoryID)
) ENGINE=InnoDB CHARACTER SET UTF8;


-- CREATE TABLE DiseaseNameTable (
-- 	CategoryID int NOT NULL ,
-- 	DiseaseID int NOT NULL ,
-- 	DiseaseName varchar (100)  NULL ,
-- 	DisCatID int NULL ,
-- 	DisCatName varchar (50)  NULL ,
-- 	ValidFlag int NOT NULL,
-- 	PRIMARY KEY (CategoryID, DiseaseID)
-- ) ENGINE=InnoDB CHARACTER SET UTF8;
CREATE TABLE DiseaseNameTable (
	CategoryID int NOT NULL ,
	DiseaseID int NOT NULL ,
	OLDDiseaseName varchar (100)  NULL ,
	DiseaseName varchar (100)  NULL ,
	DisCatID int NULL ,
	DisFileName varchar (50)  NULL ,
	ValidFlag int NOT NULL,
	PRIMARY KEY (CategoryID, DiseaseID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE IAExaminationTable (
	IAnswerID int NOT NULL ,
	IQuestionID int NOT NULL ,
	IAContents varchar (250)  NOT NULL ,
	IAParameter int NULL,
	PRIMARY KEY (IAnswerID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE IQAResultTable (
	IResultID int NOT NULL ,
	DiagnosisID int NOT NULL ,
	Result1 int NOT NULL ,
	Result2 int NOT NULL ,
	Result3 int NOT NULL ,
	Result1LN int NOT NULL ,
	Result2LN int NOT NULL ,
	Result3LN int NOT NULL ,
	InjuryDetailTreat varchar (2000)  NULL,
	PRIMARY KEY (IResultID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE IQExaminationTable (
	IQuestionID int NOT NULL ,
	InjuryID int NOT NULL ,
	IQContents varchar (250)  NULL,
	PRIMARY KEY (IQuestionID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE InjuryNameTable (
	InjuryID int NOT NULL ,
	InjuryName varchar (50)  NULL ,
	InjFileName varchar (50)  NULL ,
	InjuryCommonTreat varchar (2000)  NULL ,
	ValidFlag int NOT NULL,
	PRIMARY KEY (InjuryID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE NCAgeCategoryTable (
	CategoryID int NOT NULL ,
	CategoryName varchar (50)  NULL ,
	MinDay int NULL ,
	MaxDay int NULL ,
	ValidFlag int NOT NULL,
	PRIMARY KEY (CategoryID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE NCGAConditionRelationTable (
	CategoryID int NOT NULL ,
	ClassID int NOT NULL ,
	GAnswerID int NOT NULL ,
	GANumber int NOT NULL ,
	GAContentsID int NOT NULL,
	PRIMARY KEY (CategoryID, ClassID, GAnswerID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE NCGADetailTable (
	GAContentsID int NOT NULL ,
	GAContents varchar (250)  NOT NULL ,
	ShortGAContents varchar (250)  NOT NULL ,
	GAParameter int NOT NULL ,
	TreatmentContents varchar (7000)  NULL,
	PRIMARY KEY (GAContentsID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE NCGQAResultTable (
	DResultID int NOT NULL ,
	CategoryID int NOT NULL ,
	DiagnosisID int NOT NULL ,
	InjuryID int NOT NULL ,
	ConsciousnessID int NOT NULL ,
	BreathID int NOT NULL ,
	ActivityID int NOT NULL ,
	DehydrationID int NOT NULL ,
	InjuryLNID int NOT NULL ,
	ConsciousnessLNID int NOT NULL ,
	BreathLNID int NOT NULL ,
	ActivityLNID int NOT NULL ,
	DehydrationLNID int NOT NULL,
	PRIMARY KEY (DResultID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE NCGQConditionRelationTable (
	CategoryID int NOT NULL ,
	ClassID int NOT NULL ,
	GQNumber int NOT NULL ,
	GQContentsID int NOT NULL,
	PRIMARY KEY (CategoryID, ClassID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE NCGQDetailTable (
	GQContentsID int NOT NULL ,
	GQContents varchar (100)  NULL ,
	ShortGQContents varchar (100)  NULL,
	PRIMARY KEY (GQContentsID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE SwallowClassTable (
	SwallowClass int NOT NULL ,
	SwallowContents varchar (50)  NULL ,
	DetailNumber int NULL ,
	ValidFlag int NOT NULL,
	PRIMARY KEY (SwallowClass)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE SwallowExaminationTable (
	SwallowObjectID int NOT NULL ,
	SwallowClass int NOT NULL ,
	SwallowObjectName varchar (50)  NULL ,
	ValidFlag int NOT NULL,
	PRIMARY KEY (SwallowObjectID)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE SwallowInformationTable (
	SwallowTreatmentClass int NOT NULL ,
	SwallowTreatmentInformation varchar (50)  NULL,
	PRIMARY KEY (SwallowTreatmentClass)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE SwallowTreatmentTable (
	dummy int NULL ,
	SwallowObjectID int NOT NULL ,
	SwallowTreatmentClass int NOT NULL ,
	SwallowTreatmentContents varchar (8000)  NULL ,
	ValidFlag int NOT NULL,
	PRIMARY KEY (SwallowObjectID, SwallowTreatmentClass)
) ENGINE=InnoDB CHARACTER SET UTF8;


CREATE TABLE DiseaseCategoryTable (
	DisCatID int NOT NULL ,
	DisCatName varchar (50)  NOT NULL ,
	DisCatFileName varchar (50)  NOT NULL,
	PRIMARY KEY (DisCatID)
) ENGINE=InnoDB CHARACTER SET UTF8;