- 中天生資·Last edited by Isaac on Mar 22, 2022Linked with GitHubContributed by
腸生態健康評估報告-DataBase
Change root password
mysqladmin -u root [new password]
Create database
create database ReportSystem;
GRANT ALL PRIVILEGES ON * . * TO '[user]'@'localhost';
FLUSH PRIVILEGES;
## Remove
revoke All on *.* from [user];
## Delete user
DROP USER [user];
遠端連線
ReportSystem
Create Tables
CREATE TABLE `IDInfo`(
`ID` VARCHAR(18) NOT NULL,
`Name` VARCHAR(20) NOT NULL,
`Gender` VARCHAR(6),
`PhoneNum` VARCHAR(20),
`MobileNum` VARCHAR(20),
`Birth` DATE NOT NULL,
`Email` VARCHAR(200),
`Address` VARCHAR(200),
`Note` VARCHAR(20),
PRIMARY KEY ( `ID` )
)CHARSET=utf8;
insert into IDInfo (ID, Name, Gender, PhoneNum, MobileNum, Birth, Adress, Note) values ("F123456789", "Jordan", "Male", "02-2655-8558", "(+886)09123456", "1987/8/7", "115台北市南港區園區街3號14號樓之1", "VIP");
CREATE TABLE `SampleInfo`(
`ID` VARCHAR(18) NOT NULL,
`Sample` VARCHAR(20) NOT NULL,
`TestMethod` VARCHAR(20) NOT NULL,
`SamplingDateTime` DATETIME NOT NULL,
`ReceiveDate` DATE NOT NULL,
`ReceiveFrom` VARCHAR(40) NOT NULL,
`SequencingDate` DATE NOT NULL,
`Project` VARCHAR(40) NOT NULL,
`Pipeline` VARCHAR(10) NOT NULL,
`BaseVersion` VARCHAR(10) NOT NULL,
`Note` VARCHAR(20),
PRIMARY KEY ( `Sample` )
)CHARSET=utf8;
CREATE TABLE `FailSample`(
`ID` VARCHAR(18) NOT NULL,
`Sample` VARCHAR(20) NOT NULL,
`Reason` VARCHAR(20) NOT NULL,
`Date` DATE NOT NULL,
PRIMARY KEY ( `Sample` )
);
CREATE TABLE `OTUInfo`(
`ID` VARCHAR(18) NOT NULL,
`Time` VARCHAR(10) NOT NULL,
`FilePath` VARCHAR(400) NOT NULL,
`Row` INT NOT NULL,
`Source` VARCHAR(10) NOT NULL,
PRIMARY KEY ( `ID`, `Time` )
);
CREATE TABLE `SampleRecord`(
`ID` VARCHAR(18) NOT NULL,
`Sample` VARCHAR(20) NOT NULL,
`ReportDate` DATE NOT NULL,
PRIMARY KEY ( `Sample` )
)CHARSET=utf8;
# change TestMethod length;
alter table SampleInfo modify column TestMethod varchar(50);
insert into SampleInfo (`ID`, `Sample`, `NGSID`, `TestMethod`, `SamplingDateTime`, `ReceiveDate`, `ReceiveFrom`, `ReportDate`, `Project`, `Pipeline`, `DataBase`, `Note`) values ("F123456789", "GI21-00001-V1-1", "XX;XX", "QIAsymphony SP DNA萃取操作標準書\n16S基因體定序操作標準書", "2021/12/1 18:00", "2021/12/3", "Mayo Clinic", "2022/1/1", "腸生態個人健康評估", "V1.0", "V1.0", "急件");
CREATE TABLE `BaselineInfo`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`FilePath` VARCHAR(400) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `HealthGuide`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`SixCoreIndex` VARCHAR(255),
`BodyFunction` VARCHAR(255),
`Product` VARCHAR(50),
PRIMARY KEY ( `ID`, `DataPoint` )
);
insert into HealthGuide (ID, DataPoint, SixCoreIndex, BodyFunction, Product) values ("F123456789", "V1-1", "SixCore_MicroBiome;SixCore_Glucose", "Risk_HeartVS;Risk_Liver", "Product1");
CREATE TABLE `AnalysisResult`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`NumberOfGenus` TINYINT NOT NULL,
`FBRatio` FLOAT NOT NULL,
`BERatio` FLOAT NOT NULL,
`TotalAcetateAbundance` FLOAT NOT NULL,
`TotalButyrateAbundance` FLOAT NOT NULL,
`TotalPropionateAbundance` FLOAT NOT NULL,
`Enterotype` VARCHAR(5) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
insert into AnalysisResult (ID, DataPoint, NumberOfGenus, FBratio, BEratio, Acetate, Butyrate, Propionate, Enterotypes) values ("F123456789", "V1-1", "49", "1.69", "1000.0", "0.0011", "0.2458", "2.3509", "Type1");
CREATE TABLE `FixedDescriptions`(
`Case` VARCHAR(30) NOT NULL,
`Description` VARCHAR(500) NOT NULL,
PRIMARY KEY ( `Case` )
)CHARSET=utf8;
CREATE TABLE `FixedBacteriaInfo`(
`Name` VARCHAR(30) NOT NULL,
`ChinieseName` VARCHAR(30) NOT NULL,
`Description` VARCHAR(100) NOT NULL,
PRIMARY KEY ( `Name` )
)CHARSET=utf8;
CREATE TABLE `VersionAndCutOff`(
`Version` VARCHAR(10) NOT NULL,
`GutBiomeDiversity_High` TINYINT NOT NULL,
`GutBiomeDiversity_Low` TINYINT NOT NULL,
`GoodBadIndex_High` TINYINT NOT NULL,
`GoodBadIndex_Low` TINYINT NOT NULL,
`GlucoseIndex_High` TINYINT NOT NULL,
`GlucoseIndex_Low` TINYINT NOT NULL,
`LipidIndex_High` TINYINT NOT NULL,
`LipidIndex_Low` TINYINT NOT NULL,
`ImmueIndex_High` TINYINT NOT NULL,
`ImmueIndex_Low` TINYINT NOT NULL,
`GutFuncIndex_High` TINYINT NOT NULL,
`GutFuncIndex_Low` TINYINT NOT NULL,
`Brain_High` TINYINT NOT NULL,
`Brain_Low` TINYINT NOT NULL,
`HeartVS_High` TINYINT NOT NULL,
`HeartVS_Low` TINYINT NOT NULL,
`Lung_High` TINYINT NOT NULL,
`Lung_Low` TINYINT NOT NULL,
`Liver_High` TINYINT NOT NULL,
`Liver_Low` TINYINT NOT NULL,
`Kidney_High` TINYINT NOT NULL,
`Kidney_Low` TINYINT NOT NULL,
`Stomach_High` TINYINT NOT NULL,
`Stomach_Low` TINYINT NOT NULL,
`Intestine_High` TINYINT NOT NULL,
`Intestine_Low` TINYINT NOT NULL,
`Immune_High` TINYINT NOT NULL,
`Immune_Low` TINYINT NOT NULL,
`Obesity_High` TINYINT NOT NULL,
`Obesity_Low` TINYINT NOT NULL,
`Metabolism_High` TINYINT NOT NULL,
`Metabolism_Low` TINYINT NOT NULL,
PRIMARY KEY ( `Version` )
);
CREATE TABLE `BioChemistry`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Description` VARCHAR(700) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
)CHARSET=utf8;
CREATE TABLE `GutBiome`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Firmicutes` FLOAT NOT NULL,
`Bacteroidetes` FLOAT NOT NULL,
`Actinobacteria` FLOAT NOT NULL,
`Proteobacteria` FLOAT NOT NULL,
`Fusobacteria` FLOAT NOT NULL,
`Tenericutes` FLOAT NOT NULL,
`Synergistetes` FLOAT NOT NULL,
`Verrucomicrobia` FLOAT NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `Indices`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Shannon` TINYINT NOT NULL,
`GoodBad` TINYINT NOT NULL,
`GlucoseIndex` TINYINT NOT NULL,
`OilIndex` TINYINT NOT NULL,
`ImmuneIndex` TINYINT NOT NULL,
`GutFunction` TINYINT NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
insert into Indices (ID, DataPoint, GutBiomeDiversity, GoodBadIndex, GlucoseIndex, LipidIndex, ImmueIndex, GutFuncIndex) values ("F123456789", "V1-1", "45", "90", "85", "19", "60", "18");
CREATE TABLE `ModRecored`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`TableName` VARCHAR(20) NOT NULL,
`Field` VARCHAR(20) NOT NULL,
`OriginData` VARCHAR(700) NOT NULL,
`NewData` VARCHAR(700) NOT NULL,
`ModDate` DATETIME NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `PDAD`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `HeartVessel`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `Lung`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `Liver`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `Kidney`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `Stomach`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `Intestine`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `Immune`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `Obesity`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
CREATE TABLE `Metabolism`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria1` VARCHAR(30) NOT NULL,
`GBacteria1Status` VARCHAR(6) NOT NULL,
`GoodBacteria2` VARCHAR(30) NOT NULL,
`GBacteria2Status` VARCHAR(6) NOT NULL,
`GoodBacteria3` VARCHAR(30) NOT NULL,
`GBacteria3Status` VARCHAR(6) NOT NULL,
`BadBacteria1` VARCHAR(30) NOT NULL,
`BBacteria1Status` VARCHAR(6) NOT NULL,
`BadBacteria2` VARCHAR(30) NOT NULL,
`BBacteria2Status` VARCHAR(6) NOT NULL,
`BadBacteria3` VARCHAR(30) NOT NULL,
`BBacteria3Status` VARCHAR(6) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
);
PDAD
HeartVessel
Immune
Intestine
Kidney
Liver
Lung
Metabolism
Obesity
Stomach
CREATE TABLE `Metabolism`(
`ID` VARCHAR(18) NOT NULL,
`DataPoint` VARCHAR(10) NOT NULL,
`Score` TINYINT NOT NULL,
`GoodBacteria` VARCHAR(5000) NOT NULL,
`BadBacteria` VARCHAR(5000) NOT NULL,
PRIMARY KEY ( `ID`, `DataPoint` )
)CHARSET=utf8;
check datatype
select table_name, column_name, data_type, character_maximum_length, is_nullable from information_schema.columns where table_schema = Database();
+-------------------+------------------------+-----------+--------------------------+-------------+
| table_name | column_name | data_type | character_maximum_length | is_nullable |
+-------------------+------------------------+-----------+--------------------------+-------------+
| AnalysisResult | ID | varchar | 18 | NO |
| AnalysisResult | DataPoint | varchar | 10 | NO |
| AnalysisResult | NumberOfGenus | tinyint | NULL | NO |
| AnalysisResult | FBratio | float | NULL | NO |
| AnalysisResult | BEratio | float | NULL | NO |
| AnalysisResult | Acetate | float | NULL | NO |
| AnalysisResult | Butyrate | float | NULL | NO |
| AnalysisResult | Propionate | float | NULL | NO |
| AnalysisResult | Enterotypes | varchar | 5 | NO |
| BioChemistry | ID | varchar | 18 | NO |
| BioChemistry | DataPoint | varchar | 10 | NO |
| BioChemistry | Description | varchar | 700 | NO |
| Brain | ID | varchar | 18 | NO |
| Brain | DataPoint | varchar | 10 | NO |
| Brain | Score | tinyint | NULL | NO |
| Brain | GoodBacteria1 | varchar | 30 | NO |
| Brain | GBacteria1Status | varchar | 6 | NO |
| Brain | GoodBacteria2 | varchar | 30 | NO |
| Brain | GBacteria2Status | varchar | 6 | NO |
| Brain | GoodBacteria3 | varchar | 30 | NO |
| Brain | GBacteria3Status | varchar | 6 | NO |
| Brain | BadBacteria1 | varchar | 30 | NO |
| Brain | BBacteria1Status | varchar | 6 | NO |
| Brain | BadBacteria2 | varchar | 30 | NO |
| Brain | BBacteria2Status | varchar | 6 | NO |
| Brain | BadBacteria3 | varchar | 30 | NO |
| Brain | BBacteria3Status | varchar | 6 | NO |
| FixedBacteriaInfo | Name | varchar | 30 | NO |
| FixedBacteriaInfo | ChinieseName | varchar | 30 | NO |
| FixedBacteriaInfo | Description | varchar | 100 | NO |
| FixedDescriptions | Case | varchar | 30 | NO |
| FixedDescriptions | Description | varchar | 500 | NO |
| GutBiome | ID | varchar | 18 | NO |
| GutBiome | DataPoint | varchar | 10 | NO |
| GutBiome | Description | varchar | 700 | NO |
| HealthGuide | ID | varchar | 18 | NO |
| HealthGuide | DataPoint | varchar | 10 | NO |
| HealthGuide | SixCoreIndex | varchar | 255 | YES |
| HealthGuide | BodyFunction | varchar | 255 | YES |
| HealthGuide | Product | varchar | 50 | YES |
| HeartVS | ID | varchar | 18 | NO |
| HeartVS | DataPoint | varchar | 10 | NO |
| HeartVS | Score | tinyint | NULL | NO |
| HeartVS | GoodBacteria1 | varchar | 30 | NO |
| HeartVS | GBacteria1Status | varchar | 6 | NO |
| HeartVS | GoodBacteria2 | varchar | 30 | NO |
| HeartVS | GBacteria2Status | varchar | 6 | NO |
| HeartVS | GoodBacteria3 | varchar | 30 | NO |
| HeartVS | GBacteria3Status | varchar | 6 | NO |
| HeartVS | BadBacteria1 | varchar | 30 | NO |
| HeartVS | BBacteria1Status | varchar | 6 | NO |
| HeartVS | BadBacteria2 | varchar | 30 | NO |
| HeartVS | BBacteria2Status | varchar | 6 | NO |
| HeartVS | BadBacteria3 | varchar | 30 | NO |
| HeartVS | BBacteria3Status | varchar | 6 | NO |
| IDInfo | ID | varchar | 18 | NO |
| IDInfo | Name | varchar | 20 | NO |
| IDInfo | Gender | varchar | 6 | YES |
| IDInfo | PhoneNum | varchar | 20 | YES |
| IDInfo | MobileNum | varchar | 20 | YES |
| IDInfo | Birth | date | NULL | NO |
| IDInfo | Adress | varchar | 200 | YES |
| IDInfo | Note | varchar | 20 | YES |
| Immune | ID | varchar | 18 | NO |
| Immune | DataPoint | varchar | 10 | NO |
| Immune | Score | tinyint | NULL | NO |
| Immune | GoodBacteria1 | varchar | 30 | NO |
| Immune | GBacteria1Status | varchar | 6 | NO |
| Immune | GoodBacteria2 | varchar | 30 | NO |
| Immune | GBacteria2Status | varchar | 6 | NO |
| Immune | GoodBacteria3 | varchar | 30 | NO |
| Immune | GBacteria3Status | varchar | 6 | NO |
| Immune | BadBacteria1 | varchar | 30 | NO |
| Immune | BBacteria1Status | varchar | 6 | NO |
| Immune | BadBacteria2 | varchar | 30 | NO |
| Immune | BBacteria2Status | varchar | 6 | NO |
| Immune | BadBacteria3 | varchar | 30 | NO |
| Immune | BBacteria3Status | varchar | 6 | NO |
| Indices | ID | varchar | 18 | NO |
| Indices | DataPoint | varchar | 10 | NO |
| Indices | GutBiomeDiversity | tinyint | NULL | NO |
| Indices | GoodBadIndex | tinyint | NULL | NO |
| Indices | GlucoseIndex | tinyint | NULL | NO |
| Indices | LipidIndex | tinyint | NULL | NO |
| Indices | ImmueIndex | tinyint | NULL | NO |
| Indices | GutFuncIndex | tinyint | NULL | NO |
| Intestine | ID | varchar | 18 | NO |
| Intestine | DataPoint | varchar | 10 | NO |
| Intestine | Score | tinyint | NULL | NO |
| Intestine | GoodBacteria1 | varchar | 30 | NO |
| Intestine | GBacteria1Status | varchar | 6 | NO |
| Intestine | GoodBacteria2 | varchar | 30 | NO |
| Intestine | GBacteria2Status | varchar | 6 | NO |
| Intestine | GoodBacteria3 | varchar | 30 | NO |
| Intestine | GBacteria3Status | varchar | 6 | NO |
| Intestine | BadBacteria1 | varchar | 30 | NO |
| Intestine | BBacteria1Status | varchar | 6 | NO |
| Intestine | BadBacteria2 | varchar | 30 | NO |
| Intestine | BBacteria2Status | varchar | 6 | NO |
| Intestine | BadBacteria3 | varchar | 30 | NO |
| Intestine | BBacteria3Status | varchar | 6 | NO |
| Kidney | ID | varchar | 18 | NO |
| Kidney | DataPoint | varchar | 10 | NO |
| Kidney | Score | tinyint | NULL | NO |
| Kidney | GoodBacteria1 | varchar | 30 | NO |
| Kidney | GBacteria1Status | varchar | 6 | NO |
| Kidney | GoodBacteria2 | varchar | 30 | NO |
| Kidney | GBacteria2Status | varchar | 6 | NO |
| Kidney | GoodBacteria3 | varchar | 30 | NO |
| Kidney | GBacteria3Status | varchar | 6 | NO |
| Kidney | BadBacteria1 | varchar | 30 | NO |
| Kidney | BBacteria1Status | varchar | 6 | NO |
| Kidney | BadBacteria2 | varchar | 30 | NO |
| Kidney | BBacteria2Status | varchar | 6 | NO |
| Kidney | BadBacteria3 | varchar | 30 | NO |
| Kidney | BBacteria3Status | varchar | 6 | NO |
| Liver | ID | varchar | 18 | NO |
| Liver | DataPoint | varchar | 10 | NO |
| Liver | Score | tinyint | NULL | NO |
| Liver | GoodBacteria1 | varchar | 30 | NO |
| Liver | GBacteria1Status | varchar | 6 | NO |
| Liver | GoodBacteria2 | varchar | 30 | NO |
| Liver | GBacteria2Status | varchar | 6 | NO |
| Liver | GoodBacteria3 | varchar | 30 | NO |
| Liver | GBacteria3Status | varchar | 6 | NO |
| Liver | BadBacteria1 | varchar | 30 | NO |
| Liver | BBacteria1Status | varchar | 6 | NO |
| Liver | BadBacteria2 | varchar | 30 | NO |
| Liver | BBacteria2Status | varchar | 6 | NO |
| Liver | BadBacteria3 | varchar | 30 | NO |
| Liver | BBacteria3Status | varchar | 6 | NO |
| Lung | ID | varchar | 18 | NO |
| Lung | DataPoint | varchar | 10 | NO |
| Lung | Score | tinyint | NULL | NO |
| Lung | GoodBacteria1 | varchar | 30 | NO |
| Lung | GBacteria1Status | varchar | 6 | NO |
| Lung | GoodBacteria2 | varchar | 30 | NO |
| Lung | GBacteria2Status | varchar | 6 | NO |
| Lung | GoodBacteria3 | varchar | 30 | NO |
| Lung | GBacteria3Status | varchar | 6 | NO |
| Lung | BadBacteria1 | varchar | 30 | NO |
| Lung | BBacteria1Status | varchar | 6 | NO |
| Lung | BadBacteria2 | varchar | 30 | NO |
| Lung | BBacteria2Status | varchar | 6 | NO |
| Lung | BadBacteria3 | varchar | 30 | NO |
| Lung | BBacteria3Status | varchar | 6 | NO |
| Metabolism | ID | varchar | 18 | NO |
| Metabolism | DataPoint | varchar | 10 | NO |
| Metabolism | Score | tinyint | NULL | NO |
| Metabolism | GoodBacteria1 | varchar | 30 | NO |
| Metabolism | GBacteria1Status | varchar | 6 | NO |
| Metabolism | GoodBacteria2 | varchar | 30 | NO |
| Metabolism | GBacteria2Status | varchar | 6 | NO |
| Metabolism | GoodBacteria3 | varchar | 30 | NO |
| Metabolism | GBacteria3Status | varchar | 6 | NO |
| Metabolism | BadBacteria1 | varchar | 30 | NO |
| Metabolism | BBacteria1Status | varchar | 6 | NO |
| Metabolism | BadBacteria2 | varchar | 30 | NO |
| Metabolism | BBacteria2Status | varchar | 6 | NO |
| Metabolism | BadBacteria3 | varchar | 30 | NO |
| Metabolism | BBacteria3Status | varchar | 6 | NO |
| ModRecored | ID | varchar | 18 | NO |
| ModRecored | DataPoint | varchar | 10 | NO |
| ModRecored | TableName | varchar | 20 | NO |
| ModRecored | Field | varchar | 20 | NO |
| ModRecored | OriginData | varchar | 700 | NO |
| ModRecored | NewData | varchar | 700 | NO |
| ModRecored | ModDate | datetime | NULL | NO |
| Obesity | ID | varchar | 18 | NO |
| Obesity | DataPoint | varchar | 10 | NO |
| Obesity | Score | tinyint | NULL | NO |
| Obesity | GoodBacteria1 | varchar | 30 | NO |
| Obesity | GBacteria1Status | varchar | 6 | NO |
| Obesity | GoodBacteria2 | varchar | 30 | NO |
| Obesity | GBacteria2Status | varchar | 6 | NO |
| Obesity | GoodBacteria3 | varchar | 30 | NO |
| Obesity | GBacteria3Status | varchar | 6 | NO |
| Obesity | BadBacteria1 | varchar | 30 | NO |
| Obesity | BBacteria1Status | varchar | 6 | NO |
| Obesity | BadBacteria2 | varchar | 30 | NO |
| Obesity | BBacteria2Status | varchar | 6 | NO |
| Obesity | BadBacteria3 | varchar | 30 | NO |
| Obesity | BBacteria3Status | varchar | 6 | NO |
| SampleInfo | ID | varchar | 18 | NO |
| SampleInfo | Sample | varchar | 20 | NO |
| SampleInfo | NGSID | varchar | 20 | NO |
| SampleInfo | TestMethod | varchar | 50 | YES |
| SampleInfo | SamplingDateTime | datetime | NULL | NO |
| SampleInfo | ReceiveDate | date | NULL | NO |
| SampleInfo | ReceiveFrom | varchar | 40 | NO |
| SampleInfo | ReportDate | date | NULL | NO |
| SampleInfo | Project | varchar | 40 | NO |
| SampleInfo | Pipeline | varchar | 10 | NO |
| SampleInfo | DataBase | varchar | 10 | NO |
| SampleInfo | Note | varchar | 20 | YES |
| Stomach | ID | varchar | 18 | NO |
| Stomach | DataPoint | varchar | 10 | NO |
| Stomach | Score | tinyint | NULL | NO |
| Stomach | GoodBacteria1 | varchar | 30 | NO |
| Stomach | GBacteria1Status | varchar | 6 | NO |
| Stomach | GoodBacteria2 | varchar | 30 | NO |
| Stomach | GBacteria2Status | varchar | 6 | NO |
| Stomach | GoodBacteria3 | varchar | 30 | NO |
| Stomach | GBacteria3Status | varchar | 6 | NO |
| Stomach | BadBacteria1 | varchar | 30 | NO |
| Stomach | BBacteria1Status | varchar | 6 | NO |
| Stomach | BadBacteria2 | varchar | 30 | NO |
| Stomach | BBacteria2Status | varchar | 6 | NO |
| Stomach | BadBacteria3 | varchar | 30 | NO |
| Stomach | BBacteria3Status | varchar | 6 | NO |
| VersionAndCutOff | Version | varchar | 10 | NO |
| VersionAndCutOff | GutBiomeDiversity_High | tinyint | NULL | NO |
| VersionAndCutOff | GutBiomeDiversity_Low | tinyint | NULL | NO |
| VersionAndCutOff | GoodBadIndex_High | tinyint | NULL | NO |
| VersionAndCutOff | GoodBadIndex_Low | tinyint | NULL | NO |
| VersionAndCutOff | GlucoseIndex_High | tinyint | NULL | NO |
| VersionAndCutOff | GlucoseIndex_Low | tinyint | NULL | NO |
| VersionAndCutOff | LipidIndex_High | tinyint | NULL | NO |
| VersionAndCutOff | LipidIndex_Low | tinyint | NULL | NO |
| VersionAndCutOff | ImmueIndex_High | tinyint | NULL | NO |
| VersionAndCutOff | ImmueIndex_Low | tinyint | NULL | NO |
| VersionAndCutOff | GutFuncIndex_High | tinyint | NULL | NO |
| VersionAndCutOff | GutFuncIndex_Low | tinyint | NULL | NO |
| VersionAndCutOff | Brain_High | tinyint | NULL | NO |
| VersionAndCutOff | Brain_Low | tinyint | NULL | NO |
| VersionAndCutOff | HeartVS_High | tinyint | NULL | NO |
| VersionAndCutOff | HeartVS_Low | tinyint | NULL | NO |
| VersionAndCutOff | Lung_High | tinyint | NULL | NO |
| VersionAndCutOff | Lung_Low | tinyint | NULL | NO |
| VersionAndCutOff | Liver_High | tinyint | NULL | NO |
| VersionAndCutOff | Liver_Low | tinyint | NULL | NO |
| VersionAndCutOff | Kidney_High | tinyint | NULL | NO |
| VersionAndCutOff | Kidney_Low | tinyint | NULL | NO |
| VersionAndCutOff | Stomach_High | tinyint | NULL | NO |
| VersionAndCutOff | Stomach_Low | tinyint | NULL | NO |
| VersionAndCutOff | Intestine_High | tinyint | NULL | NO |
| VersionAndCutOff | Intestine_Low | tinyint | NULL | NO |
| VersionAndCutOff | Immune_High | tinyint | NULL | NO |
| VersionAndCutOff | Immune_Low | tinyint | NULL | NO |
| VersionAndCutOff | Obesity_High | tinyint | NULL | NO |
| VersionAndCutOff | Obesity_Low | tinyint | NULL | NO |
| VersionAndCutOff | Metabolism_High | tinyint | NULL | NO |
| VersionAndCutOff | Metabolism_Low | tinyint | NULL | NO |
+-------------------+------------------------+-----------+--------------------------+-------------+
Customer
tags: Report
Read more
Taiwan Server1 update history
Install STAR & Trimmomatic
Jun 19, 2025Taiwan Server2 update history
Install Miniconda & QIIME2
Nov 7, 2023Taiwan server update history(before 20220105)
Change RHEL yum library repositories 問題 已註冊的RHEL server，但目前非訂閱狀態 嘗試歷程 更換yum library repositories路徑 參照網址 wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpm sudo yum install ./epel-release-latest-*.noarch.rpm
Jan 14, 2022Published on 
HackMD
HackMD