Home
biosafe
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
franchisees
id
bigIncrements
name
string
(250)
rfc
string
(13)
street
string
(200)
ext_num
string
(10)
int_num
string
(10)
city
string
(100)
state_id
FK
bigInteger
country_id
FK
bigInteger
zip
string
(7)
phone
string
(10)
contact_name
string
(100)
contact_last_name
string
(100)
contact_email
string
(100)
contact_phone
string
(10)
timestamps
timestamps
softDeletes
softDeletes
states
id
bigIncrements
name
string
(150)
short_name
string
(10)
apha_2
string
(2)
country_id
FK
bigInteger
timestamps
timestamps
softDeletes
softDeletes
countries
id
bigIncrements
name_en
string
(150)
name_es
string
(150)
alpha_2
string
(2)
alpha_3
string
(3)
timestamps
timestamps
softDeletes
softDeletes
clients
id
bigIncrements
name
string
(150)
rfc
string
(13)
street
string
(200)
ext_num
string
(10)
int_num
string
(10)
city
string
(100)
state_id
FK
bigInteger
country_id
FK
bigInteger
zip
string
(7)
phone
string
(10)
contact_name
string
(100)
contact_last_name
string
(100)
email_contacto
string
(100)
telefono_contacto
integer
timestamps
timestamps
softDeletes
softDeletes
machines
id
increments
station_id
FK
bigInteger
status_id
FK
bigInteger
inputs
integer
outputs
integer
pump_on_time
integer
timestamps
timestamps
softDeletes
softDeletes
stations
id
increments
franchisee_id
FK
bigInteger
name
string
(250)
calle
string
(200)
num_ext
string
(10)
num_int
string
(10)
ciudad
string
(100)
id_estado
integer
id_pais
integer
codigo_postal
string
(7)
telefono
string
(10)
nombre_contacto
string
(100)
apellido_contacto
string
(100)
email_contacto
string
(100)
telefono_contacto
integer
timestamps
timestamps
softDeletes
softDeletes
washes
id
increments
machine_id
FK
bigInteger
client_id
FK
bigInteger
stop_flag
char
(1)
washed_type_id
FK
bigInteger
trailer_number
string
(100)
trailer_plates
string
(100)
level
integer
start_date
datetime
end_date
datetime
cancel_date
datetime
register_user_id
bigInteger
cancel_user_id
bigInteger
certificate_number
string
(50)
timestamps
timestamps
softDeletes
softDeletes
status
id
increments
description
string
(150)
timestamps
timestamps
softDeletes
softDeletes
washed_types
id
increments
timestamps
timestamps
softDeletes
softDeletes
description
string
(150)
washed_events
id
increments
washed_id
FK
bigInteger
description
string
(150)
user_id
bigInteger
timestamps
timestamps
softDeletes
softDeletes
supply_history
id
increments
station_id
FK
bigInteger
supply_type_id
FK
bigInteger
quantity
decimal
(11,2)
washed_id
FK
bigInteger
user_id
bigInteger
timestamps
timestamps
softDeletes
softDeletes
supplies
id
increments
description
string
(150)
timestamps
timestamps
softDeletes
softDeletes
×
Comments for biosafe
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01