| Wiki Markup |
|---|
h2.
h3. DB
{gliffy:name=DB Schema 2|space=IEPM|page=PerfSONAR_PS File Transfer MA|pageid=57348062|align=center|size=L}
h3. Sql Statements
h4. Data Table
{code} |
DB
| Gliffy Diagram | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Sql Statements
Data Table
| Code Block |
|---|
CREATE TABLE `Data` (
`ID` int(10) NOT NULL,
`Metadata_ID` int(10) NOT NULL,
`TransferTime` datetime NOT NULL,
`NBytes` int(20) NOT NULL,
`Duration` int(20) NOT NULL,
KEY `TransferTimeIndex` (`TransferTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
Metadata Table
| Code Block |
|---|
{code} h4. Metadata Table {code} CREATE TABLE `Metadata` ( `Stripes` varchar(255) default NULL, `BufferSize` int(32) default NULL, `BlockSize` int(32) default NULL, `Program` varchar(22) default NULL, `User` varchar(50) default NULL, `EndPointID` varchar(11) default NULL, `Streams` int(32) default NULL, `DestPath` varchar(255) default NULL, `SrcPath` varchar(255) default NULL, `ID` int(10) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `uni_metadata` (`Streams`,`Stripes`,`BufferSize`,`BlockSize`,`Program`,`User`,`EndPointID`,`DestPath`,`SrcPath`) ) ENGINE=InnoDB AUTO_INCREMENT=497967 DEFAULT CHARSET=utf8 COLLATE=utf8_bin \| |
EndPoints Table
| Code Block |
|---|
{code}
h4. EndPoints Table
{code}
CREATE TABLE `EndPoints` (
`ID` int(11) NOT NULL auto_increment,
`DestIP` varchar(32) NOT NULL,
`SrcIP` varchar(32) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `uni_endpoint` (`DestIP`,`SrcIP`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_bin \|
|
System Design
| Gliffy Diagram | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Xml Schema
...
{code} h3. System Design {gliffy:name=FilesetFilesAndChunks2|space=IEPM|page=PerfSONAR_PS File Transfer MA|pageid=57348062|align=center|size=L} h3. Xml Schema [][file-transfer.rnc|^file-transfer.rnc] |