Home
WRN-Clienten-tabel
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
clients
id
increments
timestamps
timestamps
softDeletes
softDeletes
epd_id
string
(255)
lastname
string
(255)
lastname_prefix
string
(255)
firstnames
string
(255)
birthdate
date
sex
tinyInteger
email
string
(255)
telnr
string
(15)
telnr_alt
string
(15)
address_state_id
FK
integer
zipcode
string
(10)
housenumber
string
(10)
extension
string
(10)
streetname
string
(255)
city
string
(255)
country_id
FK
integer
address_alt
text
identification_id
FK
integer
identification_nr
string
(255)
identification_alt
text
citizen_nr
string
(255)
marital_status_id
FK
integer
nationality_id
FK
integer
birthcountry
FK
integer
gp_agb_id
integer
gp_state_id
FK
integer
gp_name
string
(255)
gp_email
string
(255)
gp_tel
string
(20)
gp_address
string
(255)
gp_zip
string
(10)
gp_city
string
(255)
gp_country_id
FK
integer
insurance_id
FK
integer
insurance_state_id
FK
integer
insurance_nr
string
(255)
insurance_alt
text
insurance_country_id
FK
integer
address_state
id
increments
timestamps
timestamps
countries
id
increments
timestamps
timestamps
identification
id
increments
timestamps
timestamps
nationalities
id
increments
timestamps
timestamps
softDeletes
softDeletes
marital_status
id
increments
timestamps
timestamps
softDeletes
softDeletes
gp_state
id
increments
timestamps
timestamps
gp_state_translation
id
increments
timestamps
timestamps
marital_status_translation
id
increments
timestamps
timestamps
identification_translation
id
increments
timestamps
timestamps
gp_agb
id
increments
timestamps
timestamps
softDeletes
softDeletes
insurance
id
increments
timestamps
timestamps
insurance_state
id
increments
timestamps
timestamps
insurance_state_translation
id
increments
timestamps
timestamps
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01