ryadti - Laravel Schema Designer

Trainer

id increments
fields json
gender string
nationality string
years_of_exp string
identity string
session_type string
categories json
user_id ^FK bigInteger
timestamps timestamps

restaurant

id increments
manager_identity string
start_work time
end_work time
off_days json
user_id ^FK bigInteger
timestamps timestamps

gyms

id increments
manager_identity string (20)
fields json
facilities json
start_work time
end_work time
off_days string
user_id ^FK bigInteger
timestamps timestamps

nutritionists

id increments
gender string
nationality string
years_of_exp string
identity string
session_type string
user_id ^FK bigInteger
timestamps timestamps

users

id increments
name string (100)
email string (100)
password string (191)
phone string
bio json
status enum
lat string
lng string
address string
city_id string
place_id string
gallary string
commercial_registration string
vat_registration string
sports_license string
logo string
banner string
timestamps timestamps

packages

id increments
name string
price float
duration_type enum
duration integer
qty integer
features json
icon string
user_id ^FK bigInteger
timestamps timestamps

coupons

id increments
name string
price float
duration_type enum
duration integer
max_usage integer
qty integer
features json
icon string
user_id ^FK integer
timestamps timestamps

bank_informations

id increments
beneficiary_name string
account_number string
bank_name string
swift_code string
iban string
iban_certificate string
user_id ^FK bigInteger
timestamps timestamps

availabilities

id increments
times json
user_id ^FK bigInteger
timestamps timestamps

package_subscriptions

id increments
package_id ^FK bigInteger
user_id ^FK bigInteger
start_date datetime
end_date datetime
timestamps timestamps

coupon_subscriptions

id increments
timestamps timestamps
coupon_id ^FK bigInteger
user_id ^FK bigInteger
start_date datetime
end_date datetime
max_usage integer

coupon_usages

id increments
coupon_subscription_id ^FK bigInteger
date_of_usage datetime
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01