URBAN eat Trade Site - Laravel Schema Designer

store_account

id increments
store_account_number string
store_name string
store_address_line1 string
store_address_line2 string
store_city string
store_post_code string
timestamps timestamps
company_id ^FK bigInteger
product_scheme_id ^FK bigInteger
user_account_access_id bigInteger

user

id increments
user_date_created timestamps
user_email string
user_first_name string
user_surname string

companies

id increments
company_date_created timestamps
company_name string
company_address_line1 string
company_address_line string
company_city string
company_post_code string

ranges

id increments
range_date_created timestamps
range_name string
range_image string
range_desc string

products

id increments
range_id ^FK bigInteger
type_id ^FK bigInteger
filling_id ^FK bigInteger
products_date_created timestamps
product_title string
product_description string
product_image string
ni_energy_kj smallInteger
ni_energy_kcal smallInteger
ni_fat smallInteger
ni_saturates smallInteger
ni_carbs smallInteger
ni_sugars smallInteger
ni_fibre smallInteger
ni_protein smallInteger
ni_salt smallInteger

product_type

id increments
product_type_name string

product_filling

id increments
product_filling_name string

product_scheme

id increments
product_scheme_name string
timestamps timestamps

product_availability

id increments
product_id ^FK bigInteger
product_availability boolean
product_scheme_id ^FK bigInteger

published_ranges

range_id ^FK bigInteger
published boolean

published_products

product_id ^FK bigInteger
published boolean

roles

id increments
role_title string

permissions

id increments
permission_slug string

user_roles

role_id ^FK integer
user_id ^FK bigInteger

permission_roles

permission_id ^FK integer
role_id ^FK bigInteger

login_attempts

id increments
user_id ^FK bigInteger
user_ip string (15)
login_time timestamp

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