[sql] Test
Viewer
- DROP TABLE Person CASCADE CONSTRAINTS;
- DROP TABLE Termin CASCADE CONSTRAINTS;
- DROP TABLE Fach CASCADE CONSTRAINTS;
- DROP TABLE Dateien CASCADE CONSTRAINTS;
- DROP TABLE Datei_Termin CASCADE CONSTRAINTS;
- DROP TABLE Kalender CASCADE CONSTRAINTS;
- CREATE TABLE Person(
- Person_id INTEGER PRIMARY KEY NOT NULL,
- Name CHAR(50) NOT NULL
- );
- CREATE TABLE Fach(
- Fach_id INTEGER PRIMARY KEY NOT NULL,
- Fachname CHAR(50) NOT NULL
- );
- CREATE TABLE Termin(
- Termin_id INTEGER PRIMARY KEY NOT NULL,
- Abgabetermin TIMESTAMP NOT NULL,
- Name CHAR(50) NOT NULL,
- Priorität INT
- );
- CREATE TABLE Dateien(
- Datei_id INTEGER PRIMARY KEY NOT NULL,
- Dateipfad VARCHAR2(255) NOT NULL,
- Datum TIMESTAMP NOT NULL,
- Priorität INT,
- Lernmedium VARCHAR2(255) NOT NULL,
- Fach_ID INT,
- CONSTRAINT Fach FOREIGN KEY (Fach_ID)
- REFERENCES Fach(Fach_id)
- );
- CREATE TABLE Kalennder(
- Person_id INT,
- Termin_id INT,
- CONSTRAINT Person_id FOREIGN KEY (Person_id)
- REFERENCES Person(Person_id),
- CONSTRAINT Termin_id FOREIGN KEY (Termin_id)
- REFERENCES Termin(Termin_id)
- );
- COMMIT;
Editor
You can edit this paste and save as new:
File Description
- Test
- Paste Code
- 04 May-2021
- 1.13 Kb
You can Share it: