[KLANT]

klantID | naam              | email
--------+-------------------+----------------------
0       | Tim Texel         | [email protected]
1       | Jan schmit        | [email protected]
2       | Mike Hunt         | [email protected]
3       | DJ Wesley         | [email protected]
4       | Mascha Derp       | [email protected]
5       | Piet Puk          | [email protected]


[DEBITEUR]

klantID | reisID | naam        | email
--------+----------------------+----------------------
0       | 4      | Tim Texel   | [email protected]
1       | 1      | Jan schmit  | [email protected]


[WERKNEMER]

werknemerID | rang | naam          | email            | salaris
------------+------+---------------+------------------+---------
0           | 0    | SA            | root@localhost   | 3500
1           | 1    | Jan Samson    | [email protected]    | 3000
2           | 1    | Susan Rox     | [email protected]  | 2800

[BESTEMMING]

bestemmingID | vervoerID | hotelID | land             | plaats
-------------+-----------+---------+------------------+--------------
0			 | 1         | 2       | Italië           | Rome
1			 | 0         | 1       | Portugal         | Albufeira
2			 | 2         | 1       | Australië        | Melbourne
3            | 1         | 2       | Nederland        | Amsterdam

[HOTEL]

hotelID | naam          | zwembad
--------+---------------+---------
0       | Sunvalley     | True
1       | Tropical Beach| True
2       | Golden Hotel  | False

[VERVOERSMIDDEL]

vervoerID | maatschappijID | type
----------+----------------+-----
0         | 1              | Bus
1         | 0              | Vliegtuig
2         | 2              | Vliegtuig

[VERVOERSMAATSCHAPPIJ]

maatschappijID | naam
---------------+--------------------
0              | European Earlines
1              | Budget Travel
2              | Budget Travel

[VERBINDING]

maatschappijID | vertrekTijd        | vertrekbestemmingID | aankomstbestemmingID
---------------+--------------------+---------------------+---------------------
 0             | 13.40 13-03-2012   | 2                   | 1
 1             | 00.20 15-03-2012   | 0                   | 1
 2             | 19.55 17-03-2012   | 1                   | 2

[REIS]

 reisID | bestemmingID | vervoerID | vertrekTijd          | retourTijd          | prijs
--------+--------------+-----------+----------------------+---------------------+--------
 0      | 2            | 2         | 14.22 19-03-2012     | 18.30 28-03-2012    | 9000
 1      | 1            | 0         | 00.30 20-03-2012     | 13.20 01-04-2012    | 2500
 2      | 3            | 1         | 09.15 17-03-2012     | 17.05 27-03-2012    | 1500
 3      | 0            | 1         | 19.00 27-04-2012     | 02.35 04-04-2012    | 3200

[BOEKING]

klantID | werknemersID | reisID | aantalPersonen
--------+--------------+--------+---------------
0       | 2            | 1      | 3
1       | 1            | 3      | 4
2       | 2            | 0      | 1
3       | 0            | 2      | 2