TCRD v4.* =================== This README describes changes from v3.2.2. As with all major version udates, the database has been completely rebuilt from scratch. In addition, a few schema changes have been made as detailed below. The first release TCRD v4 is v4.3.2. Provenance -------- The biggest change in v4 is that the provenance of all TCRD data is now stored. - Added provenance table: mysql> desc provenance; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | dataset_id | int(11) | NO | MUL | NULL | | | table_name | varchar(255) | NO | | NULL | | | column_name | varchar(255) | YES | | NULL | | | where_clause | text | YES | | NULL | | | comment | text | YES | | NULL | | +--------------+--------------+------+-----+---------+----------------+ - Added dataset_id foreign key to xref and alias tables; Disease and Grant Info ---------------------- - The table target2disese was renamed disease. - The table target2grant was renamed grant. - Foreign keys to protein were added to both disease and grant tables. - Grant info is now included from 2000-2015 instead of 2010-2015. Target Family Designations -------------------------- - Removed target.idgfam column. - Added and populated target.fam and target.famext columns. These family designations correspond to what is in the NRDD manuscript and are - or will be shortly - in sync with DTO.