mhdbFJrj

1DROP TABLE IF EXISTS ordrevare;
2DROP TABLE IF EXISTS ordre;
3DROP TABLE IF EXISTS chauffoer;
4DROP TABLE IF EXISTS kunde;
5DROP TABLE IF EXISTS vare;
6DROP TABLE IF EXISTS varetype;
7DROP TABLE IF EXISTS lager;
8DROP TABLE IF EXISTS fragtmand;
9
10CREATE TABLE kunde (
11    kundrenr INT PRIMARY KEY,
12    kundenavn VARCHAR(64),
13    kundeadresse VARCHAR(255),
14    kundetlf VARCHAR(8)
15)
16
17CREATE TABLE fragtmand (
18    SEnr VARCHAR(32) PRIMARY KEY,
19    firmanavn VARCHAR(64),
20    telefon VARCHAR(8)
21)
22
23CREATE TABLE chauffoer (
24    chauffoernavn VARCHAR(64),
25    mobilnr VARCHAR(8) PRIMARY KEY,
26    fragmand VARCHAR(32) FOREIGN KEY REFERENCES fragtmand
27)
28
29CREATE TABLE ordre (
30    ordrenr INT PRIMARY KEY,
31    ordredato DATETIME,
32    leveringspris INT,
33    kundenr INT FOREIGN KEY REFERENCES kunde,
34    chauffoernr VARCHAR(8) FOREIGN KEY REFERENCES chauffoer
35)
36
37CREATE TABLE lager (
38    lagernr INT PRIMARY KEY,
39    lageradresse VARCHAR(64)
40)
41
42CREATE TABLE varetype (
43    varetypenr INT PRIMARY KEY,
44    betegnelse VARCHAR(64),
45    lager INT FOREIGN KEY REFERENCES lager
46)
47
48CREATE TABLE vare (
49    varenr INT PRIMARY KEY,
50    varenavn VARCHAR(64),
51    pris INT,
52    varetype INT FOREIGN KEY REFERENCES varetype NOT NULL
53)
54
55CREATE TABLE ordrevare (
56    ordrevarenr INT PRIMARY KEY,
57    ordrenr INT FOREIGN KEY REFERENCES ordre,
58    varenr INT FOREIGN KEY REFERENCES vare
59)