Skip to content
Snippets Groups Projects

schema modification - atm one conecpt per column

Merged schema modification - atm one conecpt per column
141-fix-mdbcolumnconcept into dev
Merged
Cornelia Michlitsrequested to merge
141-fix-mdbcolumnconcept into dev
Compare
and
1 file
+ 1
− 1
Compare changes
  • Side-by-side
  • Inline
fda-metadata-db/setup-schema.sql
+ 1
− 1
@@ -353,7 +353,7 @@ CREATE TABLE IF NOT EXISTS mdb_columns_concepts
@@ -353,7 +353,7 @@ CREATE TABLE IF NOT EXISTS mdb_columns_concepts
URI TEXT REFERENCES mdb_concepts (URI),
URI TEXT REFERENCES mdb_concepts (URI),
created timestamp without time zone NOT NULL DEFAULT NOW(),
created timestamp without time zone NOT NULL DEFAULT NOW(),
FOREIGN KEY (cDBID, tID, cID) REFERENCES mdb_COLUMNS (cDBID, tID, ID),
FOREIGN KEY (cDBID, tID, cID) REFERENCES mdb_COLUMNS (cDBID, tID, ID),
PRIMARY KEY (cDBID, tID, cID, URI)
PRIMARY KEY (cDBID, tID, cID)
);
);
CREATE TABLE IF NOT EXISTS mdb_VIEW
CREATE TABLE IF NOT EXISTS mdb_VIEW