The attachment contains a phpMyAdmin SQL Dump of a subset of my schema with only two tables demo and drug.
The graph schema is similar: there is a class for every table, a property for every attribute and when primaryid values matches between classes there is an edge from drug to demo classes. Il 01/07/2016 11:50, Ivan Mainetti ha scritto: > Hi, > could you post your RDBMS schema and the graph schema? > > thx -- Fabio Rinnone Skype: fabiorinnone Web: http://www.fabiorinnone.eu -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
-- phpMyAdmin SQL Dump -- version 4.3.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Lug 01, 2016 alle 10:05 -- Versione del server: 5.5.31-MariaDB -- PHP Version: 5.5.20 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `faers` -- -- -------------------------------------------------------- -- -- Struttura della tabella `demo` -- DROP TABLE IF EXISTS `demo`; CREATE TABLE IF NOT EXISTS `demo` ( `primaryid` bigint(20) NOT NULL DEFAULT '0', `caseid` bigint(20) DEFAULT NULL, `caseversion` int(11) DEFAULT NULL, `i_f_code` char(1) DEFAULT NULL, `event_dt` varchar(8) DEFAULT NULL, `mfr_dt` varchar(8) DEFAULT NULL, `init_fda_dt` date DEFAULT NULL, `fda_dt` date DEFAULT NULL, `rept_cod` varchar(8) DEFAULT NULL, `auth_num` varchar(64) DEFAULT NULL, `mfr_num` varchar(64) DEFAULT NULL, `mfr_sndr` varchar(64) DEFAULT NULL, `lit_ref` varchar(500) DEFAULT NULL, `age` decimal(10,0) DEFAULT NULL, `age_cod` varchar(8) DEFAULT NULL, `age_grp` char(1) DEFAULT NULL, `sex` varchar(3) DEFAULT NULL, `e_sub` tinyint(1) DEFAULT NULL, `wt` decimal(15,2) DEFAULT NULL, `wt_cod` varchar(3) DEFAULT NULL, `rept_dt` varchar(8) DEFAULT NULL, `to_mfr` tinyint(1) DEFAULT NULL, `occp_cod` varchar(2) DEFAULT NULL, `reporter_country` varchar(2) DEFAULT NULL, `occr_country` varchar(2) DEFAULT NULL, `filename` varchar(256) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Struttura della tabella `drug` -- DROP TABLE IF EXISTS `drug`; CREATE TABLE IF NOT EXISTS `drug` ( `primaryid` bigint(20) NOT NULL DEFAULT '0', `caseid` bigint(20) DEFAULT NULL, `drug_seq` int(11) NOT NULL DEFAULT '0', `role_cod` varchar(3) DEFAULT NULL, `drugname` varchar(500) DEFAULT NULL, `prod_ai` varchar(500) DEFAULT NULL, `val_vbm` smallint(6) DEFAULT NULL, `route` varchar(128) DEFAULT NULL, `dose_vbm` varchar(300) DEFAULT NULL, `cum_dose_chr` varchar(16) DEFAULT NULL, `cum_dose_unit` varchar(50) DEFAULT NULL, `dechal` char(1) DEFAULT NULL, `rechal` char(1) DEFAULT NULL, `lot_num` varchar(1000) DEFAULT NULL, `exp_dt` varchar(8) DEFAULT NULL, `nda_num` decimal(10,0) DEFAULT NULL, `dose_amt` varchar(16) DEFAULT NULL, `dose_unit` varchar(50) DEFAULT NULL, `dose_form` varchar(50) DEFAULT NULL, `dose_freq` varchar(50) DEFAULT NULL, `filename` varchar(256) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `demo` -- ALTER TABLE `demo` ADD PRIMARY KEY (`primaryid`); -- -- Indexes for table `drug` -- ALTER TABLE `drug` ADD PRIMARY KEY (`primaryid`,`drug_seq`); -- -- Limiti per le tabelle scaricate -- -- -- Limiti per la tabella `drug` -- ALTER TABLE `drug` ADD CONSTRAINT `drug_ibfk_1` FOREIGN KEY (`primaryid`) REFERENCES `demo` (`primaryid`) ON DELETE CASCADE ON UPDATE CASCADE; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
signature.asc
Description: OpenPGP digital signature
