[sql] Trab
Viewer
- CREATE TABLE Publicacao (
- ISSN VARCHAR(50) PRIMARY KEY,
- TituloP VARCHAR(50) NOT NULL,
- Editor VARCHAR(50),
- URL VARCHAR(100));
- CREATE TABLE Area(
- AreaID NUMBER PRIMARY KEY,
- DescricaoA VARCHAR(50) NOT NULL);
- CREATE TABLE Artigo (
- ArtigoID NUMBER PRIMARY KEY,
- TituloA VARCHAR(50) NOT NULL UNIQUE,
- ISSN VARCHAR(50) NOT NULL,
- Ano DATE,
- NumeroDePaginas NUMBER CHECK(NumeroDePaginas > 0),
- AreaID NUMBER,
- CONSTRAINT FK_AreaID_Area FOREIGN KEY(AreaID) REFERENCES Area(AreaID),
- CONSTRAINT FK_ISSN_Publicacao FOREIGN KEY(ISSN) REFERENCES Publicacao(ISSN));
- CREATE TABLE PalavraChave (
- PC NUMBER PRIMARY KEY,
- DescricaoPC VARCHAR(50));
- CREATE TABLE ArtigoPC (
- ArtigoID NUMBER,
- PC NUMBER,
- CONSTRAINT PKArtigoPC PRIMARY KEY(ArtigoID),
- CONSTRAINT FK_ArtigoID_Artigo FOREIGN KEY(ArtigoID) REFERENCES Artigo(ArtigoID),
- CONSTRAINT FK_PC_PalavraChave FOREIGN KEY(PC) REFERENCES PalavraChave(PC));
Editor
You can edit this paste and save as new: