Home
Lawyer
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
timestamps
timestamps
softDeletes
softDeletes
full_name
string
email
string
user_type_id
FK
bigInteger
birthdate
date
gender
enum
phone_number
string
profile_image
string
(125)
identity_image
string
office_manager_membership_number
integer
role
string
status
enum
offices
id
increments
timestamps
timestamps
softDeletes
softDeletes
office_name
string
(125)
office_description
text
office_email
string
office_website
string
office_location
timeTz
office_opening_date
date
office_logo
string
office_license
string
office_phone_1
string
(125)
office_phone_2
string
(125)
office_phone_3
string
(125)
case_settings
id
increments
timestamps
timestamps
softDeletes
softDeletes
subjects_items
id
increments
timestamps
timestamps
softDeletes
softDeletes
text
text
case_id
FK
bigInteger
court_names
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
court_types
id
increments
timestamps
timestamps
softDeletes
softDeletes
type
string
courts_items
id
increments
timestamps
timestamps
softDeletes
softDeletes
court_type_id
FK
bigInteger
court_name_id
FK
bigInteger
court_number
string
case_id
FK
bigInteger
case_files_items
id
increments
timestamps
timestamps
softDeletes
softDeletes
file
string
case_id
FK
bigInteger
Judgment
FK
bigInteger
Judgment
id
increments
timestamps
timestamps
softDeletes
softDeletes
case_id
FK
bigInteger
notes
text
case_status_id
FK
bigInteger
status
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
xcases
id
increments
timestamps
timestamps
softDeletes
softDeletes
case_uuid
string
(250)
client_id
FK
bigInteger
opponent_name
string
(250)
opponent_description
string
(250)
client_description
text
case_registration
string
(250)
case_registration_date
date
court_degree_id
FK
bigInteger
court_type_id
FK
bigInteger
office_id
FK
bigInteger
users_offices
id
increments
timestamps
timestamps
softDeletes
softDeletes
user_id
FK
bigInteger
office_id
FK
bigInteger
user_type
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
(125)
case_expenses
id
increments
timestamps
timestamps
softDeletes
softDeletes
deposit_by_user_id
FK
bigInteger
deposit_for_user_id
FK
bigInteger
amount_paid
float
case_id
FK
bigInteger
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01