CREATE TABLE IF NOT EXISTS "attribute"("content" VARCHAR,
attribute_name VARCHAR,
id BIGINT,
harmonized_name VARCHAR,
display_name VARCHAR,
unit VARCHAR);

CREATE TABLE biosample(submission_date VARCHAR,
last_update VARCHAR,
publication_date VARCHAR,
"access" VARCHAR,
id BIGINT,
accession VARCHAR,
is_reference VARCHAR);

CREATE TABLE contexts_to_normalized_strings(id INTEGER,
harmonized_name VARCHAR,
normalized_context_string_id INTEGER);

CREATE TABLE curation(curation_date VARCHAR,
curation_status VARCHAR,
id BIGINT);

CREATE TABLE curies_asserted(id BIGINT,
prefix_lc VARCHAR,
curie VARCHAR);

CREATE TABLE curies_ner(id BIGINT,
subject_string VARCHAR,
subject_start BIGINT,
subject_end BIGINT,
predicate_id VARCHAR,
curie VARCHAR,
object_string VARCHAR,
is_longest_match BOOLEAN,
subsumed BOOLEAN,
coverage_sum DOUBLE,
prefix_native VARCHAR);

CREATE TABLE etl_log(etl_key VARCHAR PRIMARY KEY,
etl_value VARCHAR);

CREATE TABLE id("content" VARCHAR,
db VARCHAR,
is_primary VARCHAR,
id BIGINT,
db_label VARCHAR,
is_hidden VARCHAR);

CREATE TABLE link("content" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
id BIGINT,
target VARCHAR,
submission_id VARCHAR);

CREATE TABLE model("content" VARCHAR,
id BIGINT,
"version" VARCHAR);

CREATE TABLE IF NOT EXISTS "name"("content" VARCHAR,
abbreviation VARCHAR,
id BIGINT,
url VARCHAR);

CREATE TABLE ncbi_package_info("name" VARCHAR,
display_name VARCHAR,
short_name VARCHAR,
env_package VARCHAR,
env_package_display VARCHAR,
wgs_batch_inappropriate VARCHAR,
wgs_diploid_inappropriate VARCHAR,
wgs_single_inappropriate VARCHAR,
description VARCHAR,
example VARCHAR,
"group" VARCHAR,
antibiogram VARCHAR);

CREATE TABLE normalized_context_strings(normalized_context_string_id INTEGER PRIMARY KEY,
normalized_context_string VARCHAR UNIQUE);

CREATE TABLE organism(taxonomy_id VARCHAR,
taxonomy_name VARCHAR,
id BIGINT);

CREATE TABLE organismname("content" VARCHAR,
id BIGINT);

CREATE TABLE package("content" VARCHAR,
display_name VARCHAR,
id BIGINT);

CREATE TABLE paragraph("content" VARCHAR,
id BIGINT);

CREATE TABLE status(status VARCHAR,
"when" VARCHAR,
id BIGINT);

CREATE TABLE synonym("content" VARCHAR,
db VARCHAR,
id BIGINT);

CREATE TABLE title("content" VARCHAR,
id BIGINT);
