EL-matajar - Laravel Schema Designer

country

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

city

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
country_id integer
geofence text

store_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
store_id integer
parent_id boolean

store

id increments
timestamps timestamps
softDeletes softDeletes
available enum
parent_id boolean
country_id integer
password string
name_en string
name_ar string
phone string
email string
store_category_id integer
min_charge double
status enum
rate integer
latitude string
longitude string
city_id integer
address_en string
address_ar string
delivery_type enum
min_delivery double
duration enum
from integer
to integer
description_en text
description_ar text
com_email string
com_phone string
package_id integer
user_id integer

product

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
category_id integer
price double
prepared_time integer
max_pieces integer
max_days integer
description_en text
description_ar text
show boolean
price_discount double
store_id integer
product_code string

store_city

id increments
timestamps timestamps
softDeletes softDeletes
city_id integer
store_id integer

option_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
min integer
max integer
description_en text
description_ar text
store_id integer

option

id increments
timestamps timestamps
softDeletes softDeletes
option_category_id integer
name_en string
name_ar string
description_en text
description_ar string

product_option

id increments
timestamps timestamps
softDeletes softDeletes
product_id integer
option_category_id integer
option_id integer
price double

package

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

offer

id increments
timestamps timestamps
softDeletes softDeletes
name string
from_date datetime
to_date datetime
category_id integer
store_id integer

schedule

id increments
timestamps timestamps
softDeletes softDeletes
from_hour string
to_hour string
day_off enum
store_id integer

delivery_schedule

id increments
timestamps timestamps
softDeletes softDeletes
from_hour string
to_hour string
day_off enum
store_id integer

delivery_internal

id increments
timestamps timestamps
softDeletes softDeletes
store_id integer
level_id integer
price double

delivery_level

id increments
timestamps timestamps
softDeletes softDeletes
from integer
to integer
name string

delivery_external

id increments
timestamps timestamps
softDeletes softDeletes
level_id integer
price double

client

id increments
timestamps timestamps
softDeletes softDeletes
name string
phone string
email string
city_id integer
point integer
rate integer
user_id integer

address

id increments
timestamps timestamps
softDeletes softDeletes
adress string
latitude string
longitude string
client_id integer

payment_method

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

user

timestamps timestamps
softDeletes softDeletes

order

timestamps timestamps
softDeletes softDeletes
id increments
delivery_date datetime
user_id integer
client_id integer
address_id integer
driver_id integer
store_id integer
payment_id integer
status string
sub_total double
delivery_fees double
total double
discount_id integer
from string
to string
note text
client_rate integer
store_rate integer
driver_rate integer
review text

order_product

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
product_id integer
price double

order_option

id increments
timestamps timestamps
softDeletes softDeletes
order_product_id integer
option_id integer
price double

driver

id increments
timestamps timestamps
softDeletes softDeletes
name string
phone string
email string
status enum
password string
rate integer
city_id integer
address text
store_id integer
user_id integer
latitude string
longitude string

take_from

id increments
timestamps timestamps
softDeletes softDeletes
driver_id integer
city_id integer

delivery_to

id increments
timestamps timestamps
softDeletes softDeletes
driver_id integer
city_id integer

reject_reason

id increments
timestamps timestamps
softDeletes softDeletes
name_en text
name_ar text

discount

id increments
timestamps timestamps
softDeletes softDeletes
store_id integer
name string
code string
discount_type enum
amount integer
from_date datetime
to_date datetime

cancel_reason

id increments
timestamps timestamps
softDeletes softDeletes
name_en text
name_ar text

order_reject

id increments
timestamps timestamps
softDeletes softDeletes
reason_id integer
order_id integer
review text

order_cancel

id increments
timestamps timestamps
softDeletes softDeletes
reason_id integer
order_id integer
review text

store_payment

id increments
timestamps timestamps
softDeletes softDeletes
payment_id integer
store_id integer

promotion

id increments
timestamps timestamps
softDeletes softDeletes
name string
from_date datetime
to_date datetime
store_id integer

help_question

id increments
timestamps timestamps
softDeletes softDeletes
help_category_id integer
question_en text
answer_en text
question_ar text
answer_ar text

help_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

message

id increments
timestamps timestamps
softDeletes softDeletes
from_user integer
to_user integer
type enum
message longText
order_id integer