Genie - Laravel Schema Designer

intros

id increments
timestamps timestamps
title string (191)
details text
image string (191)

faq_categories

id increments
timestamps timestamps
title string (191)

faqs

id increments
timestamps timestamps
title string (191)
details text
faq_category_id ^FK bigInteger

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
country_code string (191)
phone string (191)
image string (191)
gender enum
email string (191)
active boolean
block boolean
facebook_token text
google_token text
country_id ^FK bigInteger
code string (191)
password string (255)
points bigInteger

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
exemption_from_shipping_cost float
minimum_order_to_show_gifts float
image string (191)
currency_exchange_rate string (191)
status enum
currency string (191)
item_wrapping_price bigInteger
delivery_time bigInteger

country_roles

id increments
timestamps timestamps
softDeletes softDeletes
country_id ^FK bigInteger

country_permissions

id increments
timestamps timestamps
country_id ^FK bigInteger
country_role_id ^FK bigInteger
permissions string (191)

country_admins

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
country_id ^FK bigInteger
country_role_id ^FK bigInteger
country_code string (191)
phone string (191)
email string (191)
password string (191)
image string (191)
active boolean
block boolean
type enum

site_settings

id increments
timestamps timestamps
key string (191)
value text

addresses

id increments
timestamps timestamps
address_name string (191)
latitude decimal
longitude decimal
address text
country string (191)
city string (191)

tags

id increments
timestamps timestamps
title string (191)
meta_details text

category_product

id increments
timestamps timestamps
softDeletes softDeletes
category_id ^FK bigInteger
product_id ^FK bigInteger

sub_category_product

id increments
timestamps timestamps
product_id ^FK bigInteger
sub_category_id ^FK bigInteger

wishlists

id increments
timestamps timestamps
product_id ^FK bigInteger
user_id ^FK bigInteger

product_images

id increments
timestamps timestamps
product_id ^FK bigInteger
image string (191)

sizes

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)

size_product

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK bigInteger
size_id ^FK bigInteger

coupons

id increments
timestamps timestamps
softDeletes softDeletes
code string (191)
offer_name string (191)
offer_details text
end_at timestamp
add_to_offers boolean
type enum
discount_type enum
free_shipping boolean
get_free_product_count integer
usage_count integer
expire_date timestamp
count_usage_for_person integer
minimum_order float
country_id ^FK bigInteger

badges

id increments
timestamps timestamps
name string (191)

excluded_coupon_countries

id increments
timestamps timestamps
coupon_id ^FK bigInteger
country_id ^FK bigInteger

coupon_product

id increments
timestamps timestamps
product_id ^FK bigInteger
coupon_id ^FK bigInteger

welcome_messages

id increments
timestamps timestamps
details text
country_id ^FK bigInteger

excluded_product_countries

id increments
timestamps timestamps
product_id ^FK bigInteger
country_id ^FK bigInteger

point_types

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
points bigInteger

user_points

id increments
timestamps timestamps
user_id ^FK bigInteger
point_type_id ^FK bigInteger
amount bigInteger

point_discount_ranges

id increments
timestamps timestamps
type enum
range_from bigInteger
range_to bigInteger

country_banks

id increments
timestamps timestamps
country_id ^FK bigInteger
bank_name string (191)
bank_account_name string (191)
bank_account_number text
bank_iban_number text

payment_methods

id increments
timestamps timestamps
type enum

payment_method_country

id increments
timestamps timestamps
country_id ^FK bigInteger
payment_method_id ^FK bigInteger

orders

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
token text
status enum
item_discount float
tax bigInteger
tax_amount float
shipping float
total double
coupon string (191)
coupon_id ^FK bigInteger
payment_type enum
payment_at timestamp
cancelled_at timestamp
delivered_at timestamp
currency_exchange_rate float
country_id ^FK bigInteger
receipt_from_branch boolean
address text
latitude decimal
longitude decimal
city string (191)

order_items

id increments
timestamps timestamps
order_id ^FK bigInteger
product_id ^FK bigInteger
price float
discount float
quantity bigInteger

carts

id increments
timestamps timestamps
user_id ^FK bigInteger
token string (191)
product_id ^FK bigInteger
price float
discount float
quantity bigInteger
country_id ^FK bigInteger

admins

id increments
timestamps timestamps
name string (191)
email string (191)
phone string (191)
password string (191)
block boolean