tako - Laravel Schema Designer

users

id increments
role_id ^FK bigInteger
first_name string
last_name string
email string
email_verified_at timestamp
mobile_phone_number string
mobile_phone_number_verified_at timestamp
timestamps timestamps
softDeletes softDeletes
company_id integer

roles

id increments
name string
description string
softDeletes softDeletes

abilities

id increments
name string
description string
softDeletes softDeletes

ability_role

id increments
ability_id ^FK bigInteger
role_id ^FK bigInteger
softDeletes softDeletes

ability_user

id increments
ability_id ^FK bigInteger
user_id ^FK bigInteger
softDeletes softDeletes

companies

id increments
user_id ^FK bigInteger
name string
email string
address string
fax string
mobile_phone_number string
phone_number string
tax_number string
tax_office string
logo string
latitude string
longitude string
timestamps timestamps
softDeletes softDeletes

cargo_firms

id increments
name string
website string
phone_number string
softDeletes softDeletes
timestamps timestamps

cargo_firms_integration

id increments
company_id ^FK bigInteger
cargo_firm_id bigInteger
type string
data text
is_system_defined tinyInteger
is_default tinyInteger
softDeletes softDeletes
timestamps timestamps

cities

id increments
name string
normalized_name string
plate string
softDeletes softDeletes

districts

id increments
city_id ^FK bigInteger
name string
normalized_name string
softDeletes softDeletes

off_zones

id increments
cargo_firm_id ^FK bigInteger
city_id ^FK bigInteger
district_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

orders

id increments
company_id ^FK integer
creator_user_id bigInteger
status_id integer
order_type_id integer
operation_status_id integer
cargo_firm_integration_id integer
special_unique_id string
company_warehouse_id integer
uuid string
name string
status smallInteger
tracking_number string
special_tracking_number string
items_count smallInteger
source string
payment_price decimal
payment_type string
order_price decimal
reference_number string
reference_number2 string
reference_number3 string
order_price_3rd string
last_moving_at timestamp
first_estimated_at timestamp
second_estimated_at timestamp
cargo_created_at timestamp
completed_at timestamp
timestamps timestamps
softDeletes softDeletes

order_barcodes

id increments
order_id ^FK bigInteger
barcode text
timestamps timestamps
softDeletes softDeletes

order_logs

id increments
type string
order_id string
priority smallInteger
timestamps timestamps
softDeletes softDeletes

order_items

id increments
order_id ^FK bigInteger
code string
status string
delivered_at timestamp
completed_at timestamp
timestamps timestamps
softDeletes softDeletes
weight string
width string
height string
length string

order_locations

id increments
order_id ^FK bigInteger
city_id ^FK integer
district_id ^FK integer
email string
name string
address string
neighbourhood string
building_number string
zip_code string
phone_number string
longitude string
latitude string
timestamps timestamps
softDeletes softDeletes

order_receivers

id increments
order_id ^FK bigInteger
reason string
signature string
image string
status string
receiver string
timestamps timestamps
softDeletes softDeletes

documents

id increments
documentable_id bigInteger
documentable_type string
content string
softDeletes softDeletes
timestamps timestamps

order_requests

id increments
order_id ^FK bigInteger
cargo_firm_integration_id bigInteger
builder string
resolver string
request text
response text
timestamps timestamps
softDeletes softDeletes

quotas

id increments
name string
timestamps timestamps
softDeletes softDeletes

situations

id increments
name string
description string
is_operational tinyInteger
timestamps timestamps
softDeletes softDeletes

order_types

id increments
name string
description string
timestamps timestamps
softDeletes softDeletes

order_request_error

id increments
order_id integer
cargo_firm_integration_id string
builder string
request text
resolver string
response string
softDeletes softDeletes
timestamps timestamps

cargo_firm_integration_tokens

id increments
cargo_firm_integration_id bigInteger
token text
refresh_token text
status tinyInteger
resolver string
response text
expired_at timestamp
timestamps timestamps
softDeletes softDeletes

company_warehouses

id increments
name string
company_id bigInteger
longitude string
latitude string
district_id integer
city_id integer
address string
mobile_phone_number string
phone_number string
timestamps timestamps
softDeletes softDeletes

decis

id increments
min smallInteger
max smallInteger
timestamps timestamps
softDeletes softDeletes

deci_distributions

id increments
deci_id integer
city_id string
district_id string
timestamps timestamps
softDeletes softDeletes

quota_distributions

id increments
quota_id integer
city_id string
district_id string
timestamps timestamps
softDeletes softDeletes

order_notes

id increments
order_id bigInteger
note text
timestamps timestamps
softDeletes softDeletes

tickets

id increments
order_id integer
user_id integer
priority_id integer
last_replied_at timestamp
last_seen_at timestamp
subject text
timestamps timestamps
softDeletes softDeletes

ticket_messages

id increments
user_id integer
ticket_id integer
content text
timestamps timestamps
softDeletes softDeletes

ticket_priorities

id increments
name string
description string
color string
softDeletes softDeletes