tawasil - Laravel Schema Designer

users

id increments
name string (225)
phone string
email string
password string
active boolean
coordinates string
timestamps timestamps

slider

id increments
title json
timestamps timestamps
type string

user_infos

id increments
gender string
timestamps timestamps
user_id bigInteger

application_categories

id increments
timestamps timestamps
title json

user_addresses

id increments
name string (225)
address string
coordinates string
radius double
notes string
is_default boolean
user_id ^FK integer
timestamps timestamps

user_subscriptions

id increments
timestamps timestamps
user_id ^FK integer
package_id ^FK integer

packages

id increments
title json
period integer
period_type string
properties json
timestamps timestamps
type string
price string

user_device_tokens

id increments
token string
user_id integer
timestamps timestamps

otps

id increments
phone string
email string
code string
is_sent tinyInteger
sent_at date
timestamps timestamps

captains

id increments
name string
email string
phone string
password string
type json
registration_type string
active boolean
online boolean
coordinates string
timestamps timestamps

captain_infos

id increments
timestamps timestamps
identification_number string
gender string
birthday date
bank_name string
account_number string
iban_number string
captain_id integer

captain_cars

id increments
timestamps timestamps
car_brand_id integer
car_model_id integer
car_color_id string
car_year_date date
plate_number string
car_type string
plate_letters string
form_expiration_date date
insurance_expiry_date date
periodic_examination_end_date date
captain_id integer

car_brands

id increments
title json
timestamps timestamps

car_models

id increments
title json
timestamps timestamps

car_colors

id increments
title json
timestamps timestamps

chats

id increments
last_message_id bigInteger
user_id integer
captain_id integer
type string
order_id integer
timestamps timestamps

chat_messages

id increments
from_id integer
from_type string
to_id integer
to_type string
message_text string
readed_at date
timestamps timestamps
chat_id integer

orders

id increments
subtotal_price double
total_price double
timestamps timestamps
paid_at datetime
type string
status string
payment_method string
source_coordinates string
destination_coordinates string
distance string
time time
user_address json
source_address string
destination_address string

order_infos

id increments
timestamps timestamps
order_id integer
car_type string
captain_gender string
package_id integer
full_name string
phone string
nots text
mall_name string

order_delivery_typs

id increments
timestamps timestamps
title json

order_faz3a_types

id increments
timestamps timestamps
title json

order_repeats

id increments
timestamps timestamps
start_at timestamp
days_repetition json
order_id integer

order_captain_offers

id increments
timestamps timestamps
status string
price double
user_id bigInteger
order_id integer
captain_id integer

pages

id increments
timestamps timestamps
key string
title json
body json

settings

id increments
timestamps timestamps
key string
name string
value string

captain_device_tokens

id increments
token string
captain_id integer
timestamps timestamps

order_cancel_reasons

id increments
timestamps timestamps
order_id integer
title json
type string
order_type string
active string