On 5 Jan 2007, at 13:21, David Croft wrote:
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.
the difference between two tables seem to be 5 attributes from the
Reaction table:
| inferredProt | text
| YES | | NULL | |
| maxHomologues | text
| YES | | NULL |
| reverseReaction | int(10)
unsigned | YES | | NULL | |
| reaction_stableIdentifier_key | int(10)
| YES | MUL | NULL | |
| totalProt
the reaction_stableidentifier_key will be ignored because it ends with
'_key'
are you saying that MEditor is ignoring the other 4 and you don't get
any attributes
or fitlers for them?
or you get them correctly but when querying, they get ignored?
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 | |
------------------------------------------------------------------------
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
------------------------------------------------------------------------
-------
