Home
solar_watch 4-20
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
sites
id
increments
city_id
FK
integer
country_id
FK
integer
region_id
FK
integer
zip_code
string
(254)
name
string
(254)
adress
string
(254)
latitude
string
(254)
longitude
string
(254)
timestamps
timestamps
softDeletes
softDeletes
datas
id
increments
account_id
FK
integer
account_type_id
FK
integer
city_id
FK
integer
gender_id
FK
integer
Country_id
FK
integer
region_id
FK
integer
piece_jointes_id
FK
integer
role
string
owner
string
(254)
SPV
string
(254)
Address
string
(254)
zip_code
string
(254)
first_name
string
(254)
name
string
(254)
cell_phone
string
(254)
fixed_phone
string
(254)
email
string
(254)
job_title
string
(254)
path
string
(254)
timestamps
timestamps
softDeletes
softDeletes
data_site
site_id
FK
integer
data_id
FK
integer
operations
id
increments
implantation_id
FK
integer
nature_id
FK
integer
productions_status_id
FK
integer
support_id
FK
integer
type_id
FK
integer
entry_service
string
(254)
expected_prod
string
(254)
expected_prod_value
float
installed_capacity
string
(254)
installed_capacity_value
float
land_surface
string
(254)
land_surface_value
float
overall_investment
string
(254)
overall_investment_value
float
purchase_price
string
(254)
purchase_price_value
float
timestamps
timestamps
softDeletes
softDeletes
implantations
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
label_fr
string
(255)
natures
id
increments
piece_jointe_nature_id
FK
integer
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
label_fr
string
(254)
supports
id
increments
label_en
string
label_fr
string
(255)
timestamps
timestamps
softDeletes
softDeletes
types
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
label_fr
string
(254)
pannels
id
increments
height_ground
float
pannel_model_id
FK
integer
string_id
FK
integer
fixation_value
float
fixation_id
FK
integer
timestamps
timestamps
softDeletes
softDeletes
strings
id
increments
orientation_id
FK
integer
rows
integer
columns
integer
height
float
width
float
nb_pannels
integer
aray_id
FK
integer
timestamps
timestamps
softDeletes
softDeletes
piece_jointes
id
increments
label
string
(255)
path
string
(254)
extension
string
(254)
timestamps
timestamps
softDeletes
softDeletes
countries
id
increments
name
string
(255)
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
label_fr
string
(254)
regions
id
increments
name
string
(255)
country_id
FK
integer
label_en
string
(254)
label_fr
string
(254)
timestamps
timestamps
softDeletes
softDeletes
cities
id
increments
name
string
(255)
region_id
FK
integer
author
string
(255)
label_en
string
(254)
label_fr
string
(254)
timestamps
timestamps
softDeletes
softDeletes
fixations
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
orientations
id
increments
softDeletes
softDeletes
timestamps
timestamps
label_en
string
(254)
label_fr
string
(254)
arays
id
increments
zone_id
FK
integer
name
string
(255)
distance
string
distance_value
float
nb_strings
integer
nb_pannels
integer
installed_capacity
string
installed_capacity_value
float
starting_point
enum
ending_point
enum
direction
enum
timestamps
timestamps
order
integer
softDeletes
softDeletes
zones
id
increments
site_id
FK
integer
label
string
(255)
surface
float
surface_value
float
installed_capacity
float
installed_capacity_value
float
author
string
(255)
timestamps
timestamps
softDeletes
softDeletes
shelters
id
increments
zone_id
FK
integer
label
string
(255)
length
string
lenght_value
float
width
string
width_value
float
surface
string
author
string
(255)
surface_value
float
timestamps
timestamps
softDeletes
softDeletes
perimetres
id
increments
name
string
(254)
distance
string
distance_value
float
perimeter_type_id
FK
integer
author
string
(255)
timestamps
timestamps
softDeletes
softDeletes
components
id
increments
component_model_id
FK
integer
shelter_id
FK
integer
component
string
(255)
name
string
(255)
from
integer
to
integer
author
string
(255)
timestamps
timestamps
softDeletes
softDeletes
pannels_models
id
increments
make_id
FK
integer
height
string
height_value
float
width
string
width_value
float
cells
integer
power
string
power_value
float
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
type_en
string
(254)
label_fr
string
(254)
type_fr
string
(254)
makes
id
increments
type
string
(255)
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
components_models
id
increments
make_id
FK
integer
power
string
power_value
float
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
label_fr
string
(254)
controles
id
increments
asset_id
FK
integer
inspection_frequency_id
FK
integer
installation_type_id
FK
integer
inspection_id
FK
integer
maintenance_type_id
FK
integer
related_servicing_id
FK
integer
phase_id
FK
integer
name
string
(255)
from
string
(255)
to
string
(255)
saison
string
(255)
author
string
(255)
label
string
(255)
softDeletes
softDeletes
timestamps
timestamps
inspections
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
label_fr
string
(254)
assets
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
label_fr
string
(254)
phases
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
label_fr
string
(254)
installation_types
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
label_fr
string
(254)
maintenance_types
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
related_servicing
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
inspection_frequencies
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
controle_site
controle_id
FK
integer
site_id
FK
integer
controle_points
id
increments
name
string
(255)
Expected_value_1
float
Expected_value_2
float
phase_point_controle_id
FK
integer
focuses_id
FK
integer
purposes_id
FK
integer
assessment_types_id
FK
integer
expected_accuracies_id
FK
integer
stakes_id
FK
integer
controle_types_id
FK
integer
controle_id
FK
integer
author
string
(255)
label
string
(255)
softDeletes
softDeletes
timestamps
timestamps
phase_point_controles
id
increments
label_en
string
(254)
label_fr
string
(254)
timestamps
timestamps
softDeletes
softDeletes
focuses
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(254)
label_fr
string
(254)
controle_types
id
increments
label_en
string
(254)
label_fr
string
(255)
softDeletes
softDeletes
timestamps
timestamps
purposes
id
increments
softDeletes
softDeletes
timestamps
timestamps
label_en
string
(255)
label_fr
string
(255)
stakes
id
increments
label_en
string
(254)
label_fr
string
(254)
timestamps
timestamps
softDeletes
softDeletes
assessment_types
id
increments
label_en
string
(254)
label_fr
string
(254)
timestamps
timestamps
softDeletes
softDeletes
expected_accuracies
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
unities
id
increments
category
string
(254)
label
string
(254)
symbole
string
(254)
html
string
(254)
timestamps
timestamps
softDeletes
softDeletes
check_controles
id
increments
softDeletes
softDeletes
timestamps
timestamps
label_en
string
(254)
label_fr
string
(254)
references
id
increments
softDeletes
softDeletes
timestamps
timestamps
label_en
string
(255)
label_fr
string
(255)
defect_types
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
confidences
id
increments
softDeletes
softDeletes
timestamps
timestamps
label_en
string
(255)
label_fr
string
(255)
criticalities
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
compliances
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
Defect_categorizations
id
increments
tolerance1
float
tolerance2
float
reference_id
FK
integer
defect_type_id
FK
integer
confidence_id
FK
integer
criticality_id
FK
integer
compliance_id
FK
integer
check_controle_id
FK
integer
label
string
(255)
author
string
(255)
controle_points_id
FK
integer
softDeletes
softDeletes
timestamps
timestamps
planifications
id
increments
maintenancetype_id
FK
integer
date
date
statut
string
(254)
asset_id
FK
integer
site_id
FK
integer
label
string
(255)
softDeletes
softDeletes
timestamps
timestamps
component_planings
id
increments
asset_id
FK
integer
label
string
(255)
component_id
integer
softDeletes
softDeletes
timestamps
timestamps
controle_planification
controle_id
FK
integer
planification_id
FK
integer
users
id
increments
name
string
(255)
email
string
(255)
login
string
(255)
password
string
(255)
role
integer
timestamps
timestamps
softDeletes
softDeletes
site_user
site_id
FK
integer
user_id
FK
integer
productions_status
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
genders
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
accounts
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
account_types
id
increments
timestamps
timestamps
softDeletes
softDeletes
label_en
string
(255)
label_fr
string
(255)
perimeter_types
id
increments
label_en
string
(254)
label_fr
string
(254)
timestamps
timestamps
softDeletes
softDeletes
stastiques
id
increments
timestamps
timestamps
author
string
(254)
ip
string
(254)
languages
id
increments
label
string
(255)
symbol
string
(255)
timestamps
timestamps
softDeletes
softDeletes
piece_jointe_natures
id
increments
label
string
(255)
path
string
(255)
extension
string
(255)
softDeletes
softDeletes
timestamps
timestamps
piece_jointe_documents
id
increments
label
string
(255)
path
string
(254)
extension
string
(254)
timestamps
timestamps
softDeletes
softDeletes
category
string
(255)
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01