ontrack.sql.V6__437_project_favourites.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ontrack-database Show documentation

Ontrack module: ontrack-database

There is a newer version: 4.4.5

-- 32. Project favourites (#437)

CREATE TABLE PROJECT_FAVOURITES (
  ID        SERIAL  NOT NULL,
  ACCOUNTID INTEGER NOT NULL,
  PROJECTID INTEGER NOT NULL,
  CONSTRAINT PROJECT_FAVOURITES_PK PRIMARY KEY (ID),
  CONSTRAINT PROJECT_FAVOURITES_UQ UNIQUE (ACCOUNTID, PROJECTID),
  CONSTRAINT PROJECT_FAVOURITES_FK_ACCOUNT FOREIGN KEY (ACCOUNTID) REFERENCES ACCOUNTS (ID) ON DELETE CASCADE,
  CONSTRAINT PROJECT_FAVOURITES_FK_PROJECT FOREIGN KEY (PROJECTID) REFERENCES PROJECTS (ID) ON DELETE CASCADE
);