network
Tables (9)
drug_interactions (약물 네트워크 (약물간의 반응))
- id — BIGSERIAL — Primary key — NOT NULL
- gene_id — INT
- first — INT
- second — INT
drugs (약물)
- id — BIGSERIAL — Primary key — NOT NULL
- drug_id — VARCHAR(16)
- db — VARCHAR(16)
- cb — VARCHAR(32)
- sid — VARCHAR(16) []
- cid — VARCHAR(16) []
- smiles — VARCHAR(4096)
- mol_wt — VARCHAR(32)
- num_h_donor — VARCHAR(8)
- num_h_acceptor — VARCHAR(8)
- log_p — VARCHAR(32)
- ro5 — SMALLINT
protein_drug_interactions (단백질-약물 네트워크 (단백질과 약물간의 반응))
- id — BIGSERIAL — Primary key — NOT NULL
- drug_id — VARCHAR(16)
- gene_id — INT
- is_target — BOOLEAN
- is_enzyme — BOOLEAN
- is_carrier — BOOLEAN
- is_transporter — BOOLEAN
- action_type — VARCHAR(16)[]
- description — VARCHAR(256)
- ref — VARCHAR(256)
protein_interaction_pairs (단백질 네트워크쌍)
- id — BIGINT — Primary key — NOT NULL
- first — INT
- second — INT
protein_interactions (단백질 네트워크 (단백질 간의 반응))
- id — BIGSERIAL — Primary key — NOT NULL
- key — BIGINT — Foreign key → protein_interaction_pairs.id — NOT NULL
- experiment — VARCHAR(128)
- is_physical — BOOLEAN
- is_genetic — BOOLEAN
- is_colocalization — BOOLEAN
- is_pathway — BOOLEAN
- paths — VARCHAR(16)[]
protein_names (프로틴네임)
- id — BIGSERIAL — Primary key — NOT NULL
- uniprot — VARCHAR(32)
- names — VARCHAR(4096)
proteins (단백질)
- id — BIGSERIAL — Primary key — NOT NULL
- gene_id — INT
- pdb_id — VARCHAR(16)
- symbol — VARCHAR(32)
- synonyms — VARCHAR(32) []
- uniprots — VARCHAR(32) []
- ensembles — VARCHAR(32) []
reactomes (리액톰)
- id — BIGSERIAL — Primary key — NOT NULL
- path_id — VARCHAR(16)
- reactome_id — VARCHAR(32)
- path_name — VARCHAR(256)
wiki_infos (패스웨이 위키정보)
- id — BIGSERIAL — Primary key — NOT NULL
- path_id — VARCHAR(16)
- path_name — VARCHAR(256)
- url — VARCHAR(256)