Home
qwick
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (1)
Users
id
increments
timestamps
timestamps
name
string
(255)
email
string
(255)
password
string
(255)
remember_token
string
(255)
user_photo
string
(255)
birthday
datetime
status
tinyInteger
permission
enum
last_access_at
datetime
currency
string
(5)
phone
string
(20)
EmailNotifications
id
increments
timestamps
timestamps
milestone_id
FK
integer
sent_at
datetime
status
enum
Projects
id
increments
timestamps
timestamps
email
string
email_verified_at
datetime
status
tinyInteger
finished_at
datetime
name
string
(150)
authorization
string
client_id
FK
integer
authorization_confirmed_at
datetime
authorization_expire_at
datetime
Selections
id
increments
timestamps
timestamps
title
string
(150)
description
string
(100)
created_by
FK
integer
project_id
FK
integer
deadline
datetime
status
tinyInteger
CourseStartDate
date
Files
id
increments
timestamps
timestamps
Contracts
id
increments
timestamps
timestamps
customer_id
FK
integer
status
tinyInteger
last_updated_at
date
enable
tinyInteger
plan_id
FK
integer
Plans
id
increments
timestamps
timestamps
name
string
(20)
short_description
string
(50)
price
decimal
(10,2)
status
enum
MonthlyPayments
id
increments
timestamps
timestamps
contract_id
FK
integer
status
enum
total_paid
decimal
(10,2)
Profiles
id
increments
timestamps
timestamps
name
string
(20)
description
string
(50)
adminPermissions
json
customerPermissions
json
status
enum
Settings
id
increments
timestamps
timestamps
description
string
(30)
quantity
smallInteger
status
smallInteger
SettingsList
id
increments
timestamps
timestamps
plan
FK
integer
setting
FK
integer
status
smallInteger
ProfilesList
id
increments
timestamps
timestamps
profile
FK
integer
plan
FK
integer
status
smallInteger
Milestones
id
increments
timestamps
timestamps
selection_id
FK
integer
requirement_id
FK
integer
start_at
date
end_at
date
status
enum
type
enum
Requirements
id
increments
timestamps
timestamps
title
string
description
text
ReadEmailNotifications
id
increments
timestamps
timestamps
ControlEmailNotifications
id
increments
timestamps
timestamps
emailNotification_id
FK
integer
code
string
(32)
Notifications
id
increments
timestamps
timestamps
Type
string
×
Comments for qwick
phzao . 13 October 2018
Usuário final é vinculado a algum usuario administrador através da coluna owner_id. @Users
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01