Chado
Chado copied to clipboard
GMOD
the GMOD database schema
Issue #142 ## Description This PR does the following things: - [x] Update docker to use the most recent version of Ubuntu + Flybase. - [x] Update docker to act...
Issue #145 This PR builds on and is dependant on PR #143. It alters the dockerfile to allow you to name the schema you want chado installed in and creates...
Now that we have automated testing in #143 and Tripal is discussing how to use/access the migrations already available (https://github.com/tripal/tripal/issues/1876), it would be good to have automated testing focused on...
## DRAFT / NOT COMPLETE This PR is not complete plus it is dependant on #143. ## Description This PR adds a nullable type_id and rank column to all linker...
We haven't had a lot of time to reviews and there have been instances of errors sneaking in because of this. I think some automated testing workflows would greatly alleviate...
For https://github.com/GMOD/Chado/issues/122, this adds the contact_dbxref table. I believe I have followed the correct syntax and formatting for everything, please indicate otherwise. Also indicate if there are additional steps I...
I propose adding linking tables from the `eimage` table to `organism`, `stock`, and `biomaterial` for germplasm etc. images, and to `project`, `study`, and `analysis` tables to handle images resulting from...
It would be really good to have an optional type_id added to all linker tables in chado consistently. That way we could indicate what type of link is being made...
In Postgresql 13 (though with any version probably) you can add more than one duplicate organism to the organism table The Tripal issue about this: https://github.com/tripal/tripal/issues/1592 Briefly, you can do...
create table nd_geolocation_dbxref ( nd_geolocation_dbxref_id bigserial not null, nd_geolocation_id bigint not null, dbxref_id bigint not null, is_current boolean not null default 'true', primary key (nd_geolocation_dbxref_id), foreign key (dbxref_id) references dbxref...
