Hi,
I have been trying to put 2 main tables, Pathway and Reaction
into one dataset. There is a 1:n dependancy between these tables.
I have set up keys linking these tables. The table descriptions
are at the bottom of this email.
I can use the MartEditor to naievely generate the meta_ tables
for these main tables. However, it only provides features for
the Pathway table, it seems to ignore the Reaction table. When
I use the web interface to this mart, I only get Pathways in the
results list, never Reactions, even without any filters.
Is this the way things are supposed to be, or is something wrong
here? Is there any way that I can gain access to the Reaction
table as well?
Cheers,
David.
Pathway:
| Field |
Type | Null | Key | Default | Extra |
+----------------------------------------------------+----------------------+------+-----+---------+-------+
| DB_ID | int(10)
unsigned | YES | | NULL | |
| _class |
varchar(64) | YES | | NULL | |
| _displayName |
text | YES | | NULL | |
| _doNotRelease |
enum('TRUE','FALSE') | YES | | NULL | |
| authored__displayName |
text | YES | | NULL | |
| authored_note |
text | YES | | NULL | |
| created__displayName |
text | YES | | NULL | |
| created_note |
text | YES | | NULL | |
| definition |
text | YES | | NULL | |
| evidenceType__displayName |
text | YES | | NULL | |
| evidenceType_definition |
text | YES | | NULL | |
| goBiologicalProcess__displayName |
text | YES | | NULL | |
| goBiologicalProcess_accession |
text | YES | | NULL | |
| goBiologicalProcess_definition |
text | YES | | NULL | |
| goBiologicalProcess_referenceDatabase__displayName |
text | YES | | NULL | |
| goBiologicalProcess_referenceDatabase_url |
text | YES | | NULL | |
| releaseDate |
date | YES | | NULL | |
| pathway_stableIdentifier_key |
int(10) | YES | MUL | NULL | |
| referencednasequence_concat |
longtext | YES | | NULL | |
| has_referencednasequence_info_bool |
bigint(1) | YES | | NULL | |
| referencemolecule_concat |
longtext | YES | | NULL | |
| has_referencemolecule_info_bool |
bigint(1) | YES | | NULL | |
| referencepeptidesequence_concat |
longtext | YES | | NULL | |
| has_referencepeptidesequence_info_bool |
bigint(1) | YES | | NULL | |
Reaction:
| Field |
Type | Null | Key | Default | Extra |
+----------------------------------------------------+----------------------+------+-----+---------+-------+
| pathway_stableIdentifier_key |
int(10) | YES | MUL | NULL | |
| DB_ID | int(10)
unsigned | YES | | NULL | |
| _class |
varchar(64) | YES | | NULL | |
| _displayName |
text | YES | | NULL | |
| _doNotRelease |
enum('TRUE','FALSE') | YES | | NULL | |
| authored__displayName |
text | YES | | NULL | |
| authored_note |
text | YES | | NULL | |
| created__displayName |
text | YES | | NULL | |
| created_note |
text | YES | | NULL | |
| definition |
text | YES | | NULL | |
| evidenceType__displayName |
text | YES | | NULL | |
| evidenceType_definition |
text | YES | | NULL | |
| goBiologicalProcess__displayName |
text | YES | | NULL | |
| goBiologicalProcess_accession |
text | YES | | NULL | |
| goBiologicalProcess_definition |
text | YES | | NULL | |
| goBiologicalProcess_referenceDatabase__displayName |
text | YES | | NULL | |
| goBiologicalProcess_referenceDatabase_url |
text | YES | | NULL | |
| inferredProt |
text | YES | | NULL | |
| maxHomologues |
text | YES | | NULL | |
| releaseDate |
date | YES | | NULL | |
| reverseReaction | int(10)
unsigned | YES | | NULL | |
| reaction_stableIdentifier_key |
int(10) | YES | MUL | NULL | |
| totalProt |
text | YES | | NULL | |
| referencednasequence_concat |
longtext | YES | | NULL | |
| has_referencednasequence_info_bool |
bigint(1) | YES | | NULL | |
| referencemolecule_concat |
longtext | YES | | NULL | |
| has_referencemolecule_info_bool |
bigint(1) | YES | | NULL | |
| referencepeptidesequence_concat |
longtext | YES | | NULL | |
| has_referencepeptidesequence_info_bool |
bigint(1) | YES | | NULL | |
