pwcsd-cp - Laravel Schema Designer

projects

id increments
customer_id ^FK integer
name string (255)
type enum
timestamps timestamps
softDeletes softDeletes

projects_branches

id increments
project_id ^FK integer
project_database_id ^FK integer
name string (255)
timestamps timestamps
softDeletes softDeletes

projects_branches_commits

id increments
description text
project_branch_id ^FK integer
timestamps timestamps

users

id increments
timestamps timestamps
softDeletes softDeletes

projects_releases

id increments
project_id ^FK integer
project_branch_commit_id integer
version integer
timestamps timestamps

customers

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

domains

id increments
customer_id ^FK integer
email_server_id ^FK integer
name string (255)
manage_dns boolean
timestamps timestamps
softDeletes softDeletes

projects_databases

id increments
project_id ^FK integer
name string (255)
timestamps timestamps
softDeletes softDeletes

servers

id increments
name string (255)
ipaddress string (255)
ssh_key text
service_web boolean
service_database boolean
service_email boolean
timestamps timestamps
softDeletes softDeletes

domains_subdomains

id increments
domain_id ^FK integer
database_server_id ^FK integer
web_server_id ^FK integer
name string (255)
nginx_config text
timestamps timestamps
softDeletes softDeletes

domains_emails

id increments
domain_id ^FK integer
name string (255)
size integer
timestamps timestamps
softDeletes softDeletes

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