WRN-Clienten-tabel - Laravel Schema Designer

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