table album
  columns: album_id integer, title character varying, artist_id integer
  foreign keys: artist_id -> artist.artist_id
  sample rows:
    (1, 'For Those About To Rock We Salute You', 1)
    (2, 'Balls to the Wall', 2)
    (3, 'Restless and Wild', 2)

table artist
  columns: artist_id integer, name character varying
  sample rows:
    (1, 'AC/DC')
    (2, 'Accept')
    (3, 'Aerosmith')

table customer
  columns: customer_id integer, first_name character varying, last_name character varying, company character varying, address character varying, city character varying, state character varying, country character varying, postal_code character varying, phone character varying, fax character varying, email character varying, support_rep_id integer
  foreign keys: support_rep_id -> employee.employee_id
  sample rows:
    (1, 'Luís', 'Gonçalves', 'Embraer - Empresa Brasileira de Aeroná…, 'Av. Brigadeiro Faria Lima, 2170', 'São José dos Campos', 'SP', 'Brazil', '12227-000', '+55 (12) 3923-5555', '+55 (12) 3923-5566', 'luisg@embraer.com.br', 3)
    (2, 'Leonie', 'Köhler', None, 'Theodor-Heuss-Straße 34', 'Stuttgart', None, 'Germany', '70174', '+49 0711 2842222', None, 'leonekohler@surfeu.de', 5)
    (3, 'François', 'Tremblay', None, '1498 rue Bélanger', 'Montréal', 'QC', 'Canada', 'H2G 1A7', '+1 (514) 721-4711', None, 'ftremblay@gmail.com', 3)

table employee
  columns: employee_id integer, last_name character varying, first_name character varying, title character varying, reports_to integer, birth_date timestamp without time zone, hire_date timestamp without time zone, address character varying, city character varying, state character varying, country character varying, postal_code character varying, phone character varying, fax character varying, email character varying
  foreign keys: reports_to -> employee.employee_id
  sample rows:
    (1, 'Adams', 'Andrew', 'General Manager', None, datetime.datetime(1962, 2, 18, 0, 0), datetime.datetime(2002, 8, 14, 0, 0), '11120 Jasper Ave NW', 'Edmonton', 'AB', 'Canada', 'T5K 2N1', '+1 (780) 428-9482', '+1 (780) 428-3457', 'andrew@chinookcorp.com')
    (2, 'Edwards', 'Nancy', 'Sales Manager', 1, datetime.datetime(1958, 12, 8, 0, 0), datetime.datetime(2002, 5, 1, 0, 0), '825 8 Ave SW', 'Calgary', 'AB', 'Canada', 'T2P 2T3', '+1 (403) 262-3443', '+1 (403) 262-3322', 'nancy@chinookcorp.com')
    (3, 'Peacock', 'Jane', 'Sales Support Agent', 2, datetime.datetime(1973, 8, 29, 0, 0), datetime.datetime(2002, 4, 1, 0, 0), '1111 6 Ave SW', 'Calgary', 'AB', 'Canada', 'T2P 5M5', '+1 (403) 262-3443', '+1 (403) 262-6712', 'jane@chinookcorp.com')

table genre
  columns: genre_id integer, name character varying
  sample rows:
    (1, 'Rock')
    (2, 'Jazz')
    (3, 'Metal')

table invoice
  columns: invoice_id integer, customer_id integer, invoice_date timestamp without time zone, billing_address character varying, billing_city character varying, billing_state character varying, billing_country character varying, billing_postal_code character varying, total numeric
  foreign keys: customer_id -> customer.customer_id
  sample rows:
    (1, 2, datetime.datetime(2021, 1, 1, 0, 0), 'Theodor-Heuss-Straße 34', 'Stuttgart', None, 'Germany', '70174', Decimal('1.98'))
    (2, 4, datetime.datetime(2021, 1, 2, 0, 0), 'Ullevålsveien 14', 'Oslo', None, 'Norway', '0171', Decimal('3.96'))
    (3, 8, datetime.datetime(2021, 1, 3, 0, 0), 'Grétrystraat 63', 'Brussels', None, 'Belgium', '1000', Decimal('5.94'))

table invoice_line
  columns: invoice_line_id integer, invoice_id integer, track_id integer, unit_price numeric, quantity integer
  foreign keys: invoice_id -> invoice.invoice_id; track_id -> track.track_id
  sample rows:
    (1, 1, 2, Decimal('0.99'), 1)
    (2, 1, 4, Decimal('0.99'), 1)
    (3, 2, 6, Decimal('0.99'), 1)

table media_type
  columns: media_type_id integer, name character varying
  sample rows:
    (1, 'MPEG audio file')
    (2, 'Protected AAC audio file')
    (3, 'Protected MPEG-4 video file')

table playlist
  columns: playlist_id integer, name character varying
  sample rows:
    (1, 'Music')
    (2, 'Movies')
    (3, 'TV Shows')

table playlist_track
  columns: playlist_id integer, track_id integer
  foreign keys: playlist_id -> playlist.playlist_id; track_id -> track.track_id
  sample rows:
    (1, 3402)
    (1, 3389)
    (1, 3390)

table track
  columns: track_id integer, name character varying, album_id integer, media_type_id integer, genre_id integer, composer character varying, milliseconds integer, bytes integer, unit_price numeric
  foreign keys: album_id -> album.album_id; genre_id -> genre.genre_id; media_type_id -> media_type.media_type_id
  sample rows:
    (1, 'For Those About To Rock (We Salute You…, 1, 1, 1, 'Angus Young, Malcolm Young, Brian John…, 343719, 11170334, Decimal('0.99'))
    (2, 'Balls to the Wall', 2, 2, 1, 'U. Dirkschneider, W. Hoffmann, H. Fran…, 342562, 5510424, Decimal('0.99'))
    (3, 'Fast As a Shark', 3, 2, 1, 'F. Baltes, S. Kaufman, U. Dirkscneider…, 230619, 3990994, Decimal('0.99'))