SK365 - Laravel Schema Designer

Accounts

id increments
name string (255)
email string (255)
password string (255)
avatar string (255)
gender tinyInteger
birthday date
mobile string (20)
address string (255)
facebook_id string (255)
google_id string
created_at datetime
updated_at datetime

Health_profiles

id increments
account_id ^FK integer
name string (255)
gender tinyInteger
relationship string (20)
birthday date
mobile string (20)
accesser text
owner text
blood_type string (10)
note string (255)
created_at datetime
updated_at datetime

Smart_scales

id increments
profile_id ^FK integer
user_id ^FK integer
user text
ageOfBody string (10)
ageOfBodyRange text
bmi string (32)
bmiRange text
bmiWHORange text
bmr string (10)
bmrRange text
bodyShape string (10)
desirableWeight string (32)
fatFreeBodyWeight string (32)
fatToControl string (32)
levelOfVisceralFat string (32)
levelOfVisceralFatRange text
idealWeight string (32)
obesityLevel string (32)
rateOfBurnFat text
ratioOfFat string (32)
ratioOfMuscle string (32)
ratioOfFatRange text
ratioOfMuscleRange text
ratioOfWater string (32)
ratioOfWaterRange text
created_at datetime
updated_at datetime

Heights

id increments
profile_id ^FK integer
user_id ^FK integer
device_id ^FK integer
value string (10)
raw_data text
created_at datetime
updated_at datetime

Medical_histories

id increments
profile_id ^FK integer
user_id ^FK integer
name string (255)
type string (255)
start_date date
end_date date
note string (255)
created_at datetime
updated_at datetime

Heartbeats

id increments
profile_id ^FK integer
user_id ^FK integer
device_id ^FK integer
value string (10)
raw_data text
created_at datetime
updated_at datetime

Temperatures

id increments
profile_id ^FK integer
user_id ^FK integer
device_id ^FK integer
value string (10)
raw_data text
created_at datetime
updated_at datetime

Blood_pressures

id increments
profile_id ^FK integer
user_id ^FK integer
device_id ^FK integer
value string (255)
raw_data text
created_at datetime
updated_at datetime

Files

id increments
profile_id ^FK integer
user_id ^FK integer
link string (255)
type string (10)
category_id integer
note string (255)
created_at datetime
updated_at datetime

Users

id increments
name string (255)
email string (255)
password string (255)
avatar string (255)
mobile string (20)
address string (255)
company string (255)
service_id ^FK integer
created_at datetime
updated_at datetime

Categories

id increments
name string (255)
description string (255)
type string (10)
image string (255)
status integer
created_at datetime
updated_at datetime

Services

id increments
name string (255)
type string (10)
service_code string (10)
price integer
admin ^FK integer
payment_account_id ^FK integer
created_at datetime
updated_at datetime

Payment_accounts

id increments
name string (255)
bank_name string (255)
branch string (255)
account_number string (255)
created_at datetime
updated_at datetime

Chat_rooms

id increments
room_id string (10)
user_id ^FK integer
created_at datetime
updated_at datetime

Chat_messages

id increments
account_id ^FK integer
user_id ^FK integer
content string (255)
category_id ^FK integer
file string (255)
room_id ^FK integer
created_at datetime
updated_at datetime

Articles

id increments
title string (255)
image string (255)
description string (255)
content text
status integer
type string (10)
service_id ^FK integer
created_by ^FK integer
confirmed_by ^FK integer
confirmed_at datetime
published_by ^FK integer
published_at datetime
deleted_at datetime
created_at datetime
updated_at datetime

Tags

id increments
name string (255)
type string (10)
created_at datetime
updated_at datetime

Article_tag

id increments
article_id ^FK integer
tag_id ^FK integer

Roles

id increments
name string (255)
created_at datetime
updated_at datetime

Permissions

id increments
name string (255)
created_at datetime
updated_at datetime

Role_Permission

id increments
role_id ^FK integer
permission_id ^FK integer

User_role

id increments
user_id ^FK integer
role_id ^FK integer

Devices

id increments
name string (255)
type string
created_at datetime
updated_at datetime

Article_category

id increments
article_id ^FK integer
category_id ^FK integer

Article_right

id increments
article_id ^FK integer
list_access text
list_hidden text

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