Figure 4.

The SQL database scheme of SignaLink 2. The core of the database is the interaction table. Interactions can be between proteins or one protein and one miRNA. Each record in the protein or mirna tables represents one real protein or miRNA, and one real entity represented only by one record. There can be more than one interaction between two nodes, but only one within each layer. Within layers, interactions have sources (what databases are they originated from) and reference annotations (what publications do contain information about them) Interaction_source table connects interaction and source tables, while interaction_reference table connects interaction and reference tables. Each interaction has the attributes whether it is direct or indirect (interaction.is_direct), directed or undirected (interaction.is_directed), stimulatory or inhibitory (interaction.is_stimulation) stored in the interaction table. The interaction table is connected to the score_interaction table, in which binding and confidence scores are stores. Other supplementary tables contain names and IDs of proteins. See the main text for details.

Fazekas et al. BMC Systems Biology 2013 7:7   doi:10.1186/1752-0509-7-7
Download authors' original image