search

T-aaron1 / Group-project

0 stars 0 forks source link

Data base schema #22

Closed nobeeakon closed 4 years ago

nobeeakon commented 4 years ago

We now have almost all kinase information. I think now it is possible to start working in the data table schema. And generate the kinase database/tables. First data tables should be cleaned. Any doubt about the columns just ask me (Daniel)

mahdm001 commented 4 years ago

Visual schema has been uploaded to give a better idea of how all our information will be linked but is subject to change once all tables have been cleaned and finalised

nobeeakon commented 4 years ago

I've created .sql file to generate the tables, after some last cleaning, possibly we need to clean further some of the tables. It is needed to check the schema, look for possible mistakes, and if possible create the visual representation of it.

nobeeakon commented 4 years ago

We can use this website to generate the visual representation of the tables-links [https://dbdiagram.io/d] The file to generate the tables is in :

The conection between Kinase-substrate table and the rest needs to be corrected, since I'm not sure it's fine.