ProjectHorizon - Laravel Schema Designer

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

continents

id increments
timestamps timestamps
name string (255)
slug string (255)

states

id increments
timestamps timestamps
name string (255)

factories

id increments
timestamps timestamps
isIsland boolean
project_name string (255)
continent_id ^FK integer
country_id ^FK integer
state_id ^FK integer
city_id ^FK integer
rated_power float
energy_capacity float
discharge_duration float
status_id ^FK integer
revenue_id ^FK integer
connection_point_id ^FK integer
annoncement_date date
paired_grid_resource string
commissioning_date date
research_institution_id ^FK integer
off_taker_id ^FK integer
funding_source_id ^FK integer
decsription longText
verified boolean
verification_description longText
expected_commissioning_date date
company_id ^FK integer
enery_storage_technology string (255)
power_electronics_manufacturer string (255)
system_integrator string (255)
om_contractor string (255)
epc string (255)
developer string (255)
owner string (255)
hyperlink_1 string (255)
hyperlink_2 string
hyperlink_3 string

cities

id increments
timestamps timestamps
name string (255)

technologies

id increments
timestamps timestamps
name string (255)
technologycategory_id ^FK integer

technology_categories

id increments
timestamps timestamps
name string (255)

status

id increments
timestamps timestamps
name string

revenues

id increments
timestamps timestamps
name string (255)

connection_points

id increments
timestamps timestamps
name string (255)

research_institutions

id increments
timestamps timestamps
name string

off_takers

id increments
timestamps timestamps
name string (255)

funding_sources

id increments
timestamps timestamps
name string (255)

applications

id increments
timestamps timestamps
name string (255)

person_verification

id increments
timestamps timestamps
name string (255)

companies

id increments
timestamps timestamps
name string (255)

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