Search by table name, column name, or datatype. By default, the search will be for
table name. Add a period (or start with a period) to search by column name. Add a
colon (or start with a colon) to search by datatype. Basic
regular expressions
are supported. Want to run this locally? Just save this file locally and open it with your
browser; no internet required. Adding "#query" to the end of the URL will automatically
perform that search when the page is loaded, so you can share links to specific searches.
| Example | Search for... |
|---|
| foobar | table names containing "foobar" |
| .foobar | column names containing "foobar" |
| :int | columns with datatype containing "int" |
| :concept.concept_id | columns that are a foreign key to concept.concept_id |
| foobar.baz | column names containing "baz" within tables with names containing "foobar" |
| ^foo$ | table with exact name "foo" |
| .^bar$ | columns with exact name "bar" |
| :^int$ | columns with exact datatype "int" |
| ^foo.*bar$ | tables with names starting with "foo" and ending with "bar" |
| foo.*bar.^baz:varchar | column names starting with "baz" and datatype containing "varchar" within tables containing "foo" followed by "bar" |
hotkeys: "/" jumps to search box, "?" toggle help. Click on help to dismiss.
concept_reference_term_map
concept_reference_term_map_id
integer (10)
term_a_id
concept_reference_term.concept_reference_term_id
term_b_id
concept_reference_term.concept_reference_term_id
a_is_to_b_id
concept_map_type.concept_map_type_id
date_created
timestamp (19)
date_changed
timestamp (19)
 translate(-5,-5)'><path d='M68.1,28.3c-2.4-2.5-5.6-3.9-9.1-4c-3.7-0.1-7.1,1.5-9.7,4.1l-6,6c1.4-0.3,2.9-0.3,4.3-0.1c0.7,0.1,1.3,0.2,2,0.4 c0,0,0,0,0,0c0.8,0.3,1.7,0.1,2.3-0.5l1.6-1.6c1.2-1.2,2.8-2.1,4.6-2.2c2.3-0.2,4.4,0.7,5.9,2.5c2.4,2.8,2,7-0.6,9.6l-8,8 c-0.8,0.8-1.9,1.4-3,1.8c-0.6,0.2-1.1,0.2-1.7,0.3l-0.2,0c-0.5,0-0.9,0-1.4-0.1c-1.3-0.3-2.5-0.9-3.5-1.9c-0.8-0.8-1.4-1.9-1.8-3 c-0.3,0.2-0.6,0.4-0.9,0.7l-1.6,1.6c-1.4,1.4-1.4,3.6-0.1,4.9c0,0,0,0,0,0c1.1,1.1,2.3,1.9,3.6,2.5c0.5,0.3,1.1,0.5,1.8,0.7 c0.7,0.2,1.3,0.4,2,0.4c0.6,0.1,1.2,0.1,1.8,0.1c2.1,0,4.2-0.5,6.1-1.5c1-0.5,1.9-1.2,2.6-1.9c0.2-0.1,0.3-0.3,0.5-0.4l7.9-7.9 C72.6,41.7,73,33.5,68.1,28.3z'/><path d='M48.7,61.8c-0.7-0.1-1.3-0.2-2-0.4c0,0,0,0,0,0c-1-0.3-2.1-0.1-2.9,0.7l-1.5,1.5c-1.2,1.2-2.8,2-4.5,2.2 c-2.1,0.2-4.1-0.5-5.5-2c-1.5-1.5-2.2-3.5-2-5.5c0.1-1.7,1-3.3,2.2-4.5l8-8c0.8-0.8,1.9-1.4,3-1.8c0.5-0.2,1.1-0.2,1.7-0.3l0.3,0 c0.5,0,0.9,0,1.4,0.1c1.3,0.3,2.5,0.9,3.5,1.9c0.8,0.8,1.4,1.9,1.7,3c0.3-0.2,0.6-0.4,0.8-0.7l1.6-1.6c1.3-1.3,1.4-3.6,0.1-4.9 c0,0,0,0,0,0c-1.1-1.1-2.3-1.9-3.6-2.5c-0.5-0.3-1.1-0.5-1.8-0.7c-0.7-0.2-1.3-0.4-2-0.4c-2.7-0.4-5.5,0.1-7.9,1.4 c-1,0.5-1.9,1.2-2.6,1.8c-0.2,0.1-0.3,0.2-0.5,0.4l-7.9,7.9c-5,5-5.4,13.2-0.5,18.3c2.4,2.5,5.6,3.9,9.1,4c3.7,0.1,7.1-1.5,9.7-4.1 l5.8-5.8c-0.7,0.1-1.3,0.2-2,0.2C49.9,61.9,49.3,61.9,48.7,61.8z'/></g></svg>)