Updated db schema! - Githubissues

katieskinner98 commented 4 years ago

To make sure the new database works with the website and to update the schema documents we have I'm just going to paste the tables I made changes to, and the specific lines I made changes to I'll put in bold and italic:

class Phosphosites(Base): __tablename__ = 'phosphosites' GENE = Column(String(20)) PROTEIN = Column(String(20)) ACC_ID = Column(String(19)) HU_CHR_LOC = Column(String(26)) MOD_RSD = Column(String(6)) SITE_GRP_ID = Column(String(10)) MW_kD = Column(Integer) DOMAIN = Column(String(30)) SITE_7_AA = Column(String(15)) LT_LIT = Column(Integer) MS_LIT = Column(Integer) MS_CST = Column(Integer) CST_CAT = Column(String(141)) SOURCE = Column(String(66)) SEQUENCE = Column(String(3500)) PMID = Column(String(8)) PHOS_ID5 = Column(String(24), primary_key=True) PHOS_ID = Column(String(31)) PHOS_ID2 = Column(String(26)) PHOS_ID3 = Column(String(32)) PHOSID4 = Column(String(25)) ISOFORM = Column(String(10))_ ID_PH = Column(String(9))

class PhosphositesDiseases(Base): __tablename__ = 'phosphosites_diseases' DISEASE = Column(String(92)) ALTERATION = Column(String(32)) ACC_ID = Column(String(16)) _PMIDs = Column(String(20)) LT_LIT = Column(String(20)) MS_LIT = Column(String(20)) MSCST = Column(String(20)) CST_CAT = Column(String(141)) NOTES = Column(String(314)) PHOS_ID = Column(String(22), ForeignKey('phosphosites.PHOS_ID5')) # duplicates ID_DP = Column(String(9), primary_key=True)

All the other tables are the same, and all the PMIDs from the other tables I left as strings in the end, but because we didn't change them before I've excluded them from here. Not many changes but hopefully nothing will be weird and corrupted in the table anymore!