Exam_Exercise_1

Rodex_

Jun 21st, 2017

619

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

PostgreSQL 1.77 KB | None | 0 0

raw download clone embed print report

-- Aufgabe1-Tabellen.sql
------------------------
-- Fügen Sie hier Ihre CREATE TABLE Statements lt. angegebenen ER-Diagram ein
drop table if exists medien cascade;
drop table if exists artikel cascade;
drop table if exists audio cascade;
drop table if exists video cascade;
drop table if exists foto cascade;
drop table if exists medien_artikel cascade;
drop table if exists personal cascade;
create table medien(
medien_id serial,
name text not null,
erstellungsdatum timestamp not null,
speicherort text not null,
primary key(medien_id)
);
create table audio(
medien_id serial,
laenge text,
primary key(medien_id),
foreign key(medien_id) references medien(medien_id)
);
create table video(
medien_id serial,
laenge text,
primary key(medien_id),
foreign key(medien_id) references medien(medien_id)
);
create table foto(
medien_id serial,
primary key(medien_id),
foreign key(medien_id) references medien(medien_id)
);
create table personal(
personal_id serial,
vorname text not null,
nachname text not null,
email text,
fk_personal_personal_id int,
primary key(personal_id),
foreign key(fk_personal_personal_id) references personal(personal_id)
);
create table artikel(
artikel_id serial,
"text" text not null,
erstellungsdatum timestamp not null,
fk_personal_personal_id int not null,
primary key(artikel_id),
foreign key(fk_personal_personal_id) references personal(personal_id)
);
create table medien_artikel(
fk_medien_medien_id serial,
fk_artikel_artikel_id serial,
primary key(fk_artikel_artikel_id, fk_medien_medien_id),
foreign key(fk_artikel_artikel_id) references artikel(artikel_id),
foreign key(fk_medien_medien_id) references medien(medien_id)
);