Hi Arek,
you need to give us more details about the two main tables that you
have there.
There are some constraints under which Editor can work with two main
tables.
Any chance of doing 'describe' on them and sending it to us
Well, if you like punishment, here are the 'describe's:
test_reactome_18__pathway__main:
| 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 | |
| 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 | |
test_reactome_18__reaction__main:
| 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 | |
| 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 | |
Cheers,
David.
