34c07fa95c834c1377e4e185b1a9e19499a0d536
kate
  Tue Jan 30 15:48:56 2018 -0800
Update schema, based on input from Braney. Improve map boxes. refs #17512

diff --git src/hg/lib/interact.sql src/hg/lib/interact.sql
index a940a56..dfebb42 100644
--- src/hg/lib/interact.sql
+++ src/hg/lib/interact.sql
@@ -1,26 +1,28 @@
 # interact.sql was originally generated by the autoSql program, which also 
 # generated interact.c and interact.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Interaction between two regions
 CREATE TABLE interact (
     bin smallint not null,              # Bin number for browser speedup
     chrom varchar(255) not null,	# Chromosome (or contig, scaffold, etc.). For interchromosomal, use 2 records
     chromStart int unsigned not null,	# Start position in chromosome of lower region
     chromEnd int unsigned not null,	# End position in chromosome of upper region. For interchromosomal, set to chromStart+1
     name varchar(255) not null,	# Name of item, for display.  Usually 'name1/name2' or empty
     score int unsigned not null,	# Score from 0-1000
-    strand char(1) not null,	# Direction of interaction (+ or -)
-    color int unsigned not null,	# Item color, as itemRgb in bed9
-    chrom1 varchar(255) not null,	# Chromosome of first region
-    chromStart1 int unsigned not null,	# Start position in chromosome of first region
-    chromEnd1 int unsigned not null,	# End position in chromosome of first region
-    name1 varchar(255) not null,	# Identifier of first region. Can be used as link to related table
-    chrom2 varchar(255) not null,	# Chromosome of second region
-    chromStart2 int unsigned not null,	# Start position in chromosome of second region
-    chromEnd2 int unsigned not null,	# End position in chromosome of second region
-    name2 varchar(255) not null,	# Identifier of second region. Can be used as link to related table
+    value double not null,	# Strength of interaction or other data value. Typically basis for score
+    exp varchar(255) not null,	# Experiment name (metadata for filtering) or empty.
+    color int unsigned not null,	# Item color, as itemRgb in bed9. Typically based on strenght or filter
+    sourceChrom varchar(255) not null,	# Chromosome of source region (directional) or lower region.
+    sourceStart int unsigned not null,	# Start position in chromosome of source/lower region
+    sourceEnd int unsigned not null,	# End position in chromosome of source/lower region
+    sourceName varchar(255) not null,	# Identifier of source/lower region. Can be used as link to related table
+    targetChrom varchar(255) not null,	# Chromosome of target region (directional) or upper region
+    targetStart int unsigned not null,	# Start position in chromosome of target/upper region
+    targetEnd int unsigned not null,	# End position in chromosome of target/upper region
+    targetName varchar(255) not null,	# Identifier of target/upper region. Can be used as link to related table
               #Indices
-    INDEX(chrom(20), chromStart)
+    INDEX(chrom(20), chromStart),
+    INDEX(name)
 );