mysql
> show tables;
+----------------+| Tables_in_bank |
+----------------+| dysponuje |
| karta |
| klient |
| okreg |
| pozyczka |
| rachunek |
| transakcja |
| zlecenie |
+----------------+8 rows
in set (0.01 sec)
mysql
> describe dysponuje;
+--------+----------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |
+--------+----------------------+------+-----+---------+-------+| idD | smallint(5) unsigned | YES | | NULL | |
| idK | smallint(5) unsigned | NO | PRI | 0 | |
| nrR | smallint(5) unsigned | NO | PRI | 0 | |
| rodzaj | char(10) | NO | | | |
+--------+----------------------+------+-----+---------+-------+4 rows
in set (0.10 sec)
mysql
> describe karta;
+---------+----------------------+------+-----+-------------------+-------+| Field | Type | Null | Key | Default | Extra |
+---------+----------------------+------+-----+-------------------+-------+| nrK | smallint(5) unsigned | NO | PRI | | |
| nrD | smallint(5) unsigned | YES | | NULL | |
| typ | char(10) | NO | | | |
| waznosc | timestamp | NO | | CURRENT_TIMESTAMP | |
+---------+----------------------+------+-----+-------------------+-------+4 rows
in set (0.09 sec)
mysql
> describe klient;
+-----------+----------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |
+-----------+----------------------+------+-----+---------+-------+| idK | smallint(5) unsigned | NO | PRI | | |
| data_plec | char(6) | NO | | | |
| kod | tinyint(3) unsigned | YES | | NULL | |
+-----------+----------------------+------+-----+---------+-------+3 rows
in set (0.12 sec)
mysql
> describe okreg;
+----------------+-----------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |
+----------------+-----------------------+------+-----+---------+-------+| kod | tinyint(3) unsigned | NO | PRI | | |
| nazwa | char(25) | NO | | | |
| region | char(25) | NO | | | |
| mieszkancy | mediumint(8) unsigned | NO | | | |
| lm1 | tinyint(3) unsigned | NO | | | |
| lm2 | tinyint(3) unsigned | NO | | | |
| lm3 | tinyint(3) unsigned | NO | | | |
| lm4 | tinyint(3) unsigned | NO | | | |
| miasta | tinyint(3) unsigned | NO | | | |
| pmm | varchar(10) | YES | | NULL | |
| zarobki | mediumint(8) unsigned | NO | | | |
| bezrobotni1 | decimal(4,2) | NO | | | |
| bezrobotni2 | decimal(4,2) | NO | | | |
| przedsiebiorcy | smallint(5) unsigned | NO | | | |
| przestepstwa1 | mediumint(8) unsigned | NO | | | |
| przestepstwa2 | mediumint(8) unsigned | NO | | | |
+----------------+-----------------------+------+-----+---------+-------+16 rows
in set (0.06 sec)
mysql
> describe pozyczka;
+--------+----------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |
+--------+----------------------+------+-----+---------+-------+| idP | smallint(5) unsigned | NO | PRI | | |
| nrR | smallint(5) unsigned | YES | | NULL | |
| data | date | NO | | | |
| kwota | int(10) unsigned | NO | | | |
| okres | smallint(5) unsigned | NO | | | |
| rata | decimal(10,2) | NO | | | |
| status | char(1) | NO | | | |
+--------+----------------------+------+-----+---------+-------+7 rows
in set (0.16 sec)
mysql
> describe rachunek;
+---------+----------------------+------+-----+-------------------+-------+| Field | Type | Null | Key | Default | Extra |
+---------+----------------------+------+-----+-------------------+-------+| nrR | smallint(5) unsigned | NO | PRI | | |
| kod | tinyint(3) unsigned | NO | | | |
| wyciagi | char(25) | NO | | | |
| data | timestamp | NO | | CURRENT_TIMESTAMP | |
+---------+----------------------+------+-----+-------------------+-------+4 rows
in set (0.18 sec)
mysql
> describe transakcja;
+----------+----------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |
+----------+----------------------+------+-----+---------+-------+| idT | int(10) unsigned | NO | PRI | | |
| nrR | smallint(5) unsigned | YES | | NULL | |
| data | date | NO | | | |
| strona | char(25) | NO | | | |
| operacja | char(25) | YES | | NULL | |
| kwota | decimal(10,2) | NO | | | |
| saldo | decimal(10,2) | NO | | | |
| opis | char(25) | YES | | NULL | |
| bank | char(2) | NO | | | |
| odbiorca | varchar(255) | YES | | NULL | |
+----------+----------------------+------+-----+---------+-------+10 rows
in set (0.10 sec)
mysql
> describe zlecenie;
+----------+----------------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |
+----------+----------------------+------+-----+---------+-------+| idZ | smallint(5) unsigned | NO | PRI | | |
| nrR | smallint(5) unsigned | YES | | NULL | |
| bank | char(2) | NO | | | |
| odbiorca | int(10) unsigned | NO | | | |
| kwota | decimal(10,2) | NO | | | |
| opis | char(25) | YES | | NULL | |
+----------+----------------------+------+-----+-To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.