1 / 7

테이블 제작 1. BSUBMIT : BSUBMIT : MyISAM : euc-kr

테이블 제작 1. BSUBMIT : BSUBMIT : MyISAM : euc-kr 1) submit id : submitID : varchar(50) : not null : Unique 2) project id : projectID : varchar(50) : not null : index 2) pipeline id : pipelineID : varchar(50) : not null : Index : Primary Key

adem
Download Presentation

테이블 제작 1. BSUBMIT : BSUBMIT : MyISAM : euc-kr

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 테이블 제작 1. BSUBMIT : BSUBMIT : MyISAM : euc-kr 1) submit id : submitID : varchar(50) : not null : Unique 2) project id : projectID : varchar(50) : not null : index 2) pipeline id : pipelineID : varchar(50) : not null : Index : Primary Key 3) pipeline name : pipelineName : varchar(100) : not null : Index 4) pipeline description : pipelineDesc : text : null 5) pipeline origin : pipelineOrigin : tinyint : not null 7) pipeline version : pipelineVersion : varchar(50) : not null 8) pipeline update : pipelineUpdate : int : not null 9) pipeline author : pipelineAuthor : varchar(50) : not null : Index 10) pipeline xml : pipelineXML : longblob : not null 11) submit category : submitCategory : int : not null 12) submit date : submitDate : bigint(20) : not null 2. BSUBMIT_CATEGORY : BSUBMITCATEGORY : MyISAM : euc-kr 1) category id : categoryID : int : auto_increment : Primary Key 2) parent id : parentID : int : not null : Index : Unique 3) category name : categoryName : varchar(50) : not null

  2. 2. BREGISTER_P : BRegisterPipe 1) register id : registerID : varchar(50) : not null : Primary Key 2) pipeline id : pipelineID : varchar(50) : not null : Index : Unique 3) pipeline name : pipelineName : varchar(100) : not null : Index 4) pipeline desc : pipelineDesc : text : null 5) pipeline origin type : pOriginType : tinyint : not null 6) author : author : varchar(50) : not null : Index 7) register_date : registerDate : bigint(20) : not null 8) pipeline_xml : pipelineXML : longblob : not null 9) Version : pVersion : varchar(50) : not null 10) Update : pUpdate : int : not null : default 0 11) is_public : isPublic : boolean : not null 12) is_ws : isWS : boolean : not null 3. RegisterPipelineData 1) dataID : varchar(50) : not null : Primary Key 2) pipeline id : pipelineID : varchar(50) : not null : Index 3) dataName : varchar(100) : not null : Index 4) dataDesc : text : null 5) dataType : tinyint : not null 6) dataDefVal : longblob : null 7) dataXML : longblob : not null 8) argInOut : tinyint : not null 4. BREGISTER_P_M : BRegisterPipeMod 1) pipeline id : pipelineID : varchar(50) : not null : Index 2) module id : moduleID : varchar(50) : not null : Primary Key 3) module name : moduleName : varchar(100) : not null : Index 4) module type : moduleType : tinyint : not null 5) module desc : moduleDesc : text : null 6) module xml : moduleXML : longblob : not null 7) source : source : longblob : null

  3. 5. BREGISTER_P_M_A : BRegisterPipeModArg 1) idx : IDX : int : auto_increment : Primary Key 2) pipeline id : pipelineID : varchar(50) : not null : index 3) module_id : moduleID : varchar(50) : not null : Index 4) arg_id : argID : varchar(50) : not null : Index 5) arg_in_out : argInOut : tinyint : not null 9. BREGISTER_ONTOLOGY : BRegisterOntology : MyISAM : euckr 1) ontology id : OntologyID : int : auto_increment : Primary Key 2) parent id : ParentID : int : not null : Index 3) ontology name : OntologyName : varchar(50) : not null 10. BREGISTER_PIPE_ONTO_MATCH : BRegisterPipeOntoMatch : MyISAM : euckr 1) idx : idx : int : auto_increment : Primary Key 2) pipeline id : AppID : varchar(50) : not null : Index 3) ontology id : OntologyID : int : not null : Index

  4. 5. BINSTANTPIPELINE : BInstantPipeline : MyISAM : euckr 1) instance id : InstanceID : varchar(50) : not null : Primary Key 2) pipeline id : PipelineID : varchar(50) : not null : Index 3) pipeline name : PipelineName : varchar(100) : not null 4) pipeline version : pipelineVersion : varchar(50) : not null 3) owner : Owner : varchar(50) : not null : Index 4) instance name : InstanceName : varchar(100) : not null 5) instance description : InstanceDesc : blob : null 6) create date : CreateDate : bigint : not null 7) last run date : LastRunDate : bigint : null 8) status : Status : tinyint(1) : not null 9) pipeline instance xml : PipeInstXML : longblob : not null 6. BINSTANCERUNHISTORY : BInstanceRunHistory : MyISAM : euckr 1) run id : RunID : varchar(50) : not null : Primary Key 2) instance id : InstanceID : varchar(50) : not null : Index 3) instance type : InstanceType : tinyint : not null : Index 4) user id : UserID : varchar(50) : not null : Index 5) run start date : RunStartDate : bigint : not null 6) run end date : RunEndDate : bigint : null 7) history status : Status : tinyint : not null 7. BINSTANCERUNSTEP : BInstanceRunStep : MyISAM : euckr 1) step id : StepID : varchar(50) : not null : Primary Key 2) run id : RunID : varchar(50): not null : Index 3) step name : StepName : varchar(100) : not null 4) step start date : StepStartDate : bigint : not null 5) step end date : StepEndDate : bigint : null 6) step status : Status : tinyint : not null 7) run machine : RunMachine : tinyint : null

  5. 8. BINSTANCERUNJOB : BInstanceRunJob : MyISAM : euckr 1) job id : jobID : varchar(50): not null : Index 2) step id : stepID : varchar(50) : not null : Primary Key 3) job number : jobNumber : int : not null 4) job start date : jobStartDate : bigint : not null 5) job end date : jobEndDate : bigint : null 6) job status : jobStatus : tinyint : not null 7) run machine : runMachine : tinyint : null 8) output log file path : outLogFilePath : blob : null 9) error log file path : errLogFilePath : blob : null

  6. Create SQL CREATE TABLE `BSUBMIT` ( `SubmitID` varchar(50) NOT NULL, `AppID` varchar(50) NOT NULL, `AppName` varchar(100) NOT NULL, `AppDesc` text, `AppType` tinyint(4) NOT NULL, `AppCategory` tinyint(4) NOT NULL, `AppVersion` varchar(50) NOT NULL default ‘1.0’, `AppUpdate` int NOT NULL default ‘0’, `Author` varchar(50) NOT NULL, `SubmitDate` bigint(20) NOT NULL, PRIMARY KEY (`SubmitID`) ) ENGINE=MyISAM DEFAULT CHARSET=euckr; CREATE TABLE `BSUBMITCATEGORY` ( `CategoryID` int(11) NOT NULL auto_increment, `ParentID` int(11) NOT NULL, `CategoryName` varchar(50) NOT NULL, PRIMARY KEY (`CategoryID`) ) ENGINE=MyISAM DEFAULT CHARSET=euckr; insert into BSUBMITCATEGORY(ParentID, CategoryName) values (0, 'root'); insert into BSUBMITCATEGORY(ParentID, CategoryName) values (1, ‘New Submission'); insert into BSUBMITCATEGORY(ParentID, CategoryName) values (1, ‘Update Submission'); CREATE TABLE `BREGISTERONTOLOGY` ( `OntologyID` int(11) NOT NULL auto_increment, `ParentID` int(11) NOT NULL, `OntologyName` varchar(50) NOT NULL, PRIMARY KEY (`OntologyID`) ) ENGINE=MyISAM DEFAULT CHARSET=euckr; insert into BREGISTERONTOLOGY(ParentID, OntologyName) values (0, 'root'); insert into BREGISTERONTOLOGY(ParentID, OntologyName) values (1, ‘Genome'); insert into BREGISTERONTOLOGY(ParentID, OntologyName) values (1, ‘EST'); insert into BREGISTERONTOLOGY(ParentID, OntologyName) values (1, ‘Microarray'); insert into BREGISTERONTOLOGY(ParentID, OntologyName) values (1, ‘Variome'); insert into BREGISTERONTOLOGY(ParentID, OntologyName) values (1, ‘Proteome');

  7. Create SQL CREATE TABLE `BINSTANTPIPELINE` ( `InstanceID` varchar(50) NOT NULL, `PipelineID` varchar(50) NOT NULL, `PipelineName` varchar(100) NOT NULL, `Owner` varchar(50) NOT NULL, `InstanceName` varchar(100) NOT NULL, `InstanceDesc` blob, `CreateDate` bigint(20) NOT NULL, `LastRunDate` bigint(20) default NULL, `Status` tinyint(1) NOT NULL default '0', `PipeInstXML` longblob NOT NULL, PRIMARY KEY (`InstanceID`), ) ENGINE=MyISAM DEFAULT CHARSET=euckr; CREATE TABLE `BINSTANCERUNHISTORY` ( `RunID` varchar(50) NOT NULL, `InstanceID` varchar(50) NOT NULL, `InstanceType` tinyint(1) NOT NULL, `UserID` varchar(50) NOT NULL, `RunStartDate` bigint(20) NOT NULL, `RunEndDate` bigint(20) default NULL, `Status` tinyint(1) NOT NULL default '0', PRIMARY KEY (`RunID`) ) ENGINE=MyISAM DEFAULT CHARSET=euckr;

More Related