sql

Aktor
+-----------+----------+------+-----+---------+-------+
| FIELD     | TYPE     | NULL | KEY | DEFAULT | Extra |
+-----------+----------+------+-----+---------+-------+
| IdAktor   | INT(11)  | NO   | PRI | NULL    |       |
| Imiona    | CHAR(15) | YES  |     | NULL    |       |
| Nazwisko  | CHAR(20) | YES  |     | NULL    |       |
| Płeć      | CHAR(20) | YES  |     | NULL    |       |
| DataUrodz | DATE     | YES  |     | NULL    |       |
+-----------+----------+------+-----+---------+-------+
5 ROWS IN SET (0.00 sec)

Film
+-----------------+----------+------+-----+---------+-------+
| FIELD           | TYPE     | NULL | KEY | DEFAULT | Extra |
+-----------------+----------+------+-----+---------+-------+
| IdFilmu         | INT(11)  | NO   | PRI | NULL    |       |
| IdRodzaj        | INT(11)  | YES  | MUL | NULL    |       |
| Tytul           | CHAR(30) | YES  |     | NULL    |       |
| rok_produkcji   | INT(4)   | YES  |     | NULL    |       |
| 3D              | bit(1)   | YES  |     | NULL    |       |
| NazwaWytworni   | CHAR(30) | YES  | MUL | NULL    |       |
| CzasTrwanaFilmu | TIME     | YES  |     | NULL    |       |
+-----------------+----------+------+-----+---------+-------+

Rola

+---------+----------+------+-----+---------+-------+
| FIELD   | TYPE     | NULL | KEY | DEFAULT | Extra |
+---------+----------+------+-----+---------+-------+
| IdAktor | INT(11)  | YES  | MUL | NULL    |       |
| IdFilmu | INT(11)  | YES  | MUL | NULL    |       |
| rola    | CHAR(39) | YES  |     | NULL    |       |
+---------+----------+------+-----+---------+-------+

Rodzaj

+----------+----------+------+-----+---------+-------+
| FIELD    | TYPE     | NULL | KEY | DEFAULT | Extra |
+----------+----------+------+-----+---------+-------+
| IdRodzaj | INT(11)  | NO   | PRI | NULL    |       |
| rodzaj   | CHAR(20) | YES  |     | NULL    |       |
| IdFilmu  | INT(11)  | YES  | MUL | NULL    |       |
+----------+----------+------+-----+---------+-------+

Wytwornia

+---------------+----------+------+-----+---------+-------+
| FIELD         | TYPE     | NULL | KEY | DEFAULT | Extra |
+---------------+----------+------+-----+---------+-------+
| Nazwa         | CHAR(30) | NO   | PRI | NULL    |       |
| miasto        | CHAR(20) | YES  |     | NULL    |       |
| adres         | CHAR(20) | YES  |     | NULL    |       |
| dyrektor      | CHAR(20) | YES  |     | NULL    |       |
| dataPowstania | DATE     | YES  |     | NULL    |       |