SQL-2-interactive-complete/DM-Sandbox-Schema.sql at main · suthyscott/SQL-2-interactive-complete · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
create table artist(
    name VARCHAR (120),
    artist_id INTEGER
    );

create table album(
    title VARCHAR (160),
    artist_id INTEGER NOT NULL REFERENCES artist(artist_id),
    album_id INTEGER
    );

create table customer(
    state VARCHAR (40),
    country VARCHAR (40),
    postal_code VARCHAR (10),
    phone VARCHAR (24),
    fax VARCHAR (24),
    email VARCHAR (60),
    support_rep_id INTEGER NOT NULL REFERENCES employee(employee_id),
    first_name VARCHAR (40),
    customer_id INTEGER,
    last_name VARCHAR (40),
    company VARCHAR (80),
    address VARCHAR (70),
    city VARCHAR (40));

create table employee (
    email VARCHAR (60),
    employee_id INTEGER,
    last_name VARCHAR (20),
    first_name VARCHAR (20),
    title VARCHAR (30),
    reports_to INTEGER NOT NULL REFERENCES employee(employee_id),
    birth_date TIMESTAMP,
    hire_date TIMESTAMP,
    address VARCHAR (70),
    city VARCHAR (40),
    state VARCHAR (40),
    country VARCHAR (40),
    postal_code VARCHAR (10),
    phone VARCHAR (24),
    fax VARCHAR (24));

create table genre(
    name VARCHAR (120),
    genre_id INTEGER);

create table invoice(
    invoice_id INTEGER,
    customer_id INTEGER NOT NULL REFERENCES customer(customer_id),
    invoice_date TIMESTAMP,
    billing_address VARCHAR (70),
    billing_city VARCHAR (40),
    billing_state VARCHAR (40),
    billing_postal_code VARCHAR (10),
    billing_country VARCHAR (40),
    total NUMERIC);

create table invoice_line(
    track_id INTEGER NOT NUL REFERENCES track(track_id),
    quantity INTEGER,
    invoice_line_id INTEGER,
    invoice_id INTEGER NOT NULL REFERENCES invoice(invoice_id),
    unit_price NUMERIC);

create table media_type (
    media_type_id INTEGER,
    name VARCHAR (120));

create table playlist(
    playlist_id INTEGER,
    name VARCHAR (120));

create table playlist_track(
    track_id INTEGER NOT NULL REFERENCES track(track_id),
    playlist_track_id INTEGER,
    playlist_id INTEGER NOT NULL REFERENCES playlist(playlist_id));

create table track(
    media_type_id INTEGER NOT NULL REFERENCES media_type(media_type_id),
    genre_id INTEGER NOT NULL REFERENCES genre(genre_id),
    composer VARCHAR (220),
    milliseconds INTEGER,
    bytes INTEGER,
    unit_price NUMERIC,
    track_id INTEGER,
    name VARCHAR (200),
    album_id INTEGER NOT NULL REFERENCES album(album_id));