25 |
Udlånid serial primary key, |
Udlånid serial primary key, |
26 |
Personid int NOT NULL, |
Personid int NOT NULL, |
27 |
Stregkode bigint NOT NULL, |
Stregkode bigint NOT NULL, |
28 |
Startdato date NOT NULL, |
Startdato timestamp NOT NULL, |
29 |
Afleveringsdato date, |
Afleveringsdato timestamp, |
30 |
Antaldage int NOT NULL |
Antaldage int NOT NULL |
31 |
); |
); |
32 |
|
|
34 |
resevationid serial primary key, |
resevationid serial primary key, |
35 |
Personid int NOT NULL, |
Personid int NOT NULL, |
36 |
Stregkode bigint NOT NULL, |
Stregkode bigint NOT NULL, |
37 |
Startdato date NOT NULL |
Startdato timestamp NOT NULL |
38 |
); |
); |
39 |
|
|
40 |
create table Status ( |
create table Status ( |