RdsDiagram
Requests
request_id: INTEGER
request_date_added: DATE
request_date_close: DATE
request_type: BOOLEAN
request_comment: CHARACTER(250)
request_status_id: INTEGER
tenant_id: INTEGER
service_id: INTEGER
worker_id: INTEGER
Request status
request_status_id: INTEGER
request_status_name: CHARACTER(250)
request_status_description: CHARACTER(300)
Tenants
tenant_id: INTEGER
tenant_firstname: CHARACTER(50)
tenant_lastname: CHARACTER(50)
tenant_phone: CHARACTER(50)
tenant_mail: CHARACTER(100)
individual_id: INTEGER
Individuals
individual_id: INTEGER
individual_address: CHARACTER(150)
individual_payment: BOOLEAN
individual_status_id: INTEGER
Individual status
individual_status_id: INTEGER
individual_status_name: CHARACTER(250)
individual_status_description: CHARACTER(300)
Services
service_id: INTEGER
service_name: CHARACTER(150)
service_description: CHARACTER(200)
service_price: DOUBLE
service_type_id: INTEGER
Service types
service_type_id: INTEGER
service_type_name: CHARACTER(150)
service_type_description: CHARACTER(200)
Payments
payment_id: INTEGER
payment_date: DATE
payment_ammount: DOUBLE
payment_comment: CHARACTER(100)
request_id: INTEGER
tenant_id: INTEGER
Users
user_id: INTEGER
user_login: CHARACTER(50)
user_password: CHARACTER(100)
tenant_id: INTEGER
Workers
worker_id: INTEGER
worker_firstname: CHARACTER(30)
worker_lastname: CHARACTER(30)
worker_profession: CHARACTER(30)
worker_description: CHARACTER(150)