tpa_database - Laravel Schema Designer

tpa_ports

id increments
timestamps timestamps
region_id ^FK integer
name string
address string
imo_number string
port_type string
coord_lat decimal (3,10)
teus float
coord_lon decimal (3,10)
remark longText

tpa_services

id increments
timestamps timestamps
name string
description string
icon string
active tinyInteger

tpa_provider_service

id increments
timestamps timestamps
provider_id ^FK integer
service_type_id ^FK integer
details string
image string
price double
currency_id ^FK integer
invoice_payment_term_id ^FK integer

tpa_region

id increments
timestamps timestamps
city string
country string
name string

tpa_fields_type

id increments
timestamps timestamps
name string

tpa_service_field

service_id ^FK integer
field_id ^FK integer
timestamps timestamps

users

id increments
timestamps timestamps
company_id ^FK integer
firstName string
lastName string
email string
active tinyInteger
last_login date
phone string
type enum

tpa_company

id increments
timestamps timestamps
type string
name string
address string
region_id ^FK integer
phone string (15)
company_identification string
identification_type_id ^FK integer
url string
sector_id ^FK integer
active tinyInteger

tpa_vessel

id increments
timestamps timestamps
company_id ^FK integer
name string
imo_number string
vessel_type_id integer
nmsi_number string
built_date date
registred_country string
gross_tonnage double
summer_dwt double
pcsopep date
derrating date

tpa_request_quotation

id increments
timestamps timestamps
buyer_id ^FK integer
vessel_id ^FK integer
port_id ^FK integer
trausty_user_id ^FK integer
buyer_user_id ^FK integer
due_date datetime
anchorage binary
eta_date datetime
ets_date datetime
contact_number string

tpa_service_port

timestamps timestamps
provider_service_id ^FK integer
port_id ^FK integer

tpa_providers_request

id increments
timestamps timestamps
provider_service_id ^FK integer
request_service_id ^FK integer
quotation string
status string
reply-date datetime
reservation integer
assigne_id ^FK integer
prevalidate tinyInteger
service_start_date datetime
rating_provider integer
rating_comment text

tpa_checkpoint

id increments
timestamps timestamps
name string
description string
responsible_type string

tpa_workflow

timestamps timestamps
service_id ^FK integer
check_point_id ^FK integer
order integer

tpa_execution_wf

id increments
timestamps timestamps
check_point_id ^FK integer
status string
work_order_id ^FK integer
check_date datetime
responsible_id ^FK integer
service_id ^FK integer
done integer

tpa_work_order

id increments
timestamps timestamps
work_order_doc string
rating integer
rating_comments string
status string
tpa_payment_order_doc string
provider_request_id ^FK integer

tpa_documents

id increments
timestamps timestamps
work_order_id ^FK integer

tpa_notifications

id increments
timestamps timestamps
work_order_id ^FK integer
type enum
viewed boolean

tpa_company_documents

id increments
timestamps timestamps
company_id ^FK integer
name string
expiration_date date
document string

tpa_vessel_documents

id increments
timestamps timestamps
vessel_id ^FK integer
name string
expiration_date date
document string

tpa_vessel_type

id increments
timestamps timestamps
name string

tpa_identification_type

id increments
timestamps timestamps
name string

tpa_company_sectors

id increments
timestamps timestamps
name string

tpa_request_field

id increments
timestamps timestamps
request_service_id ^FK integer
service_id ^FK integer
field_id ^FK integer
value string

tpa_request_service

id increments
timestamps timestamps
service_id ^FK integer
status string
request_quotation_id ^FK integer
rating_buyer integer
rating_comment text
details text

tpa_faq

id increments
timestamps timestamps
question string
answer string
category enum

tpa_settings

id increments
timestamps timestamps
parametro string
valor string
user_id ^FK integer

tpa_service_type

id increments
timestamps timestamps
name string
service_id ^FK integer

tpa_rate_agreement

id increments
timestamps timestamps
provider_service_id ^FK integer
buyer_id ^FK integer
price double
contract_number string

tpa_currencies

id increments
timestamps timestamps
name string
description string

tpa_invoice_payment_terms

id increments
timestamps timestamps
name string
description string

tpa_service_documents

id increments
timestamps timestamps
document_id ^FK integer
required tinyInteger
service_type_id ^FK integer
port_id ^FK integer

tpa_provider_service_documents

id increments
timestamps timestamps
service_document_id ^FK integer
provider_service_id ^FK integer
path string
expired_date date

tpa_required_documents

id increments
timestamps timestamps
name string
description string