Baza danych została wykonana z użyciem technologii postgresql. Instrukcja importu bazy z poziomu terminala:
>psql create database workers;
>psql workers < ZUT_ZTPJ/database/workers.db;
Adres, nazwa użytkownika oraz hasło są zapisane "na sztywno" w pliku ConnectionPool.java
Table "public.positions"
Column | Type | Collation | Nullable |
--------+-------------------+-----------+----------+
id | integer | | not null |
name | character varying | | not null |
Table "public.workers"
Column | Type | Collation | Nullable |
---------------------+-------------------+-----------+----------+
id | integer | | not null |
first_name | character varying | | not null |
last_name | character varying | | not null |
pesel | character varying | | not null |
position_id | integer | | not null |
phone_number | character varying | | |
service_card_number | character varying | | |
salary | integer | | not null |
Table "public.directors_allowances"
Column | Type | Collation | Nullable |
--------------------+---------+-----------+----------+
id | integer | | not null |
worker_id | integer | | not null |
business_allowance | integer | | not null |
monthly_cost_limit | integer | | not null |
Table "public.tradesmans_commissions"
Column | Type | Collation | Nullable |
--------------------------+---------+-----------+----------+
id | integer | | not null |
worker_id | integer | | not null |
commission | integer | | not null |
monthly_commission_limit | integer | | not null |
- lista pracowników
- dodawanie pracownika
- usuwanie pracownika
- kopia zapasowa
- pobieranie danych z sieci
- autoryzacja przez RMI
- annotacje XML
- webserwis SOAP