Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Tabel: Hold
- CREATE TABLE Hold
- (
- ID int NOT NULL IDENTITY,
- Holdnavn varchar(255) NOT NULL,
- )
- -- Tabel: Kampe
- CREATE TABLE Kampe
- (
- ID int NOT NULL IDENTITY,
- HjemmeholdID int NOT NULL,
- UdeholdID int NOT NULL,
- DatoTid TIMESTAMP NOT NULL,
- )
- ALTER TABLE Kampe
- ADD FOREIGN KEY (HjemmeholdID) REFERENCES PUBLIC.HOLD(ID)
- ALTER TABLE Kampe
- ADD FOREIGN KEY (UdeholdID) REFERENCES PUBLIC.HOLD(ID)
- -- Tabel: Event
- CREATE TABLE Event
- (
- ID int NOT NULL IDENTITY,
- event varchar(20) NOT NULL,
- HoldID int NOT NULL,
- KampID int NOT NULL,
- DatoTid TIMESTAMP NOT NULL,
- )
- ALTER TABLE event
- ADD FOREIGN KEY (HoldID) REFERENCES PUBLIC.HOLD(ID)
- ALTER TABLE event
- ADD FOREIGN KEY (KampID) REFERENCES PUBLIC.KAMPE(ID)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement