election - Laravel Schema Designer

elections

id increments
name string (250)
election_type integer
start_date_time datetime
end_date_time datetime
email string (300)
phone string (100)
description string (500)
address text
status integer
timestamps timestamps
softDeletes softDeletes

candidates

id increments
timestamps timestamps
name string (250)
status integer
address string (250)
country ^FK integer
state ^FK integer
city ^FK integer
email string (300)
phone bigInteger
party ^FK integer
date_of_birth date

candidate_polling_areas

id increments
timestamps timestamps
softDeletes softDeletes
election_polling_area_id integer
candidate_id integer

polling_areas

id increments
name string (250)
location string
country integer
state integer
city integer
softDeletes softDeletes
timestamps timestamps

voter_details

id increments
voter_area_id integer
name string (300)
voucher_id integer
phone bigInteger
email string (300)
date_of_brith date
timestamps timestamps
softDeletes softDeletes

election_polling_areas

id increments
timestamps timestamps
softDeletes softDeletes
election_id ^FK integer
polling_area_id ^FK integer

election_type

id increments
name string (250)
status integer
timestamps timestamps
softDeletes softDeletes

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string (300)

states

id increments
timestamps timestamps
softDeletes softDeletes
name string (250)
country_id integer

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string (300)
state_id integer

votings

id increments
voucher_id string
first_preference integer
second_preference integer
third_preference integer
timestamps timestamps
softDeletes softDeletes
election_polling_area_id integer

results

id increments
election_polling_area_id integer
first_preference_voting string (200)
second_preference_voting string (200)
third_preference_voting string (200)
timestamps timestamps
softDeletes softDeletes

voter_files

id increments
polling_area_id integer
name string (250)
timestamps timestamps
softDeletes softDeletes

voter_sms

id increments
timestamps timestamps
softDeletes softDeletes
message string (500)
polling_area_id integer
status integer

parties

id increments
timestamps timestamps
softDeletes softDeletes
name string (250)
status tinyInteger

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01