Hello,
 
I am wondering if it is possible to have more than one subclass (main) table
associated to a single central main table within the dataset but not
associated amongst themselves. 
 
Here is a sample schema:
 
CREATE TABLE hsapiens_testconf__sample__main (
 sample_id_key int(10) default NULL,
 KEY  (sample_id_key)
);
 
 
CREATE TABLE hsapiens_testconf__cohort__main (
 sample_id_key int(10) unsigned,
 cohort_id_key int(10) unsigned,
 KEY (cohort_id_key),
 KEY (sample_id_key)
);  
 
CREATE TABLE hsapiens_testconf__origin__main (
 sample_id_key int(10) unsigned,
 origin_id_key int(10) unsigned,
 KEY (origin_id_key),
 KEY (sample_id_key)
);  

Thanks,
Alex

Reply via email to