zellsa - Laravel Schema Designer

users

id increments
uuid uuid (40)
username string (50)
phone string (11)
email string
password string
name string
last_name string
status enum
metadata json
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

institutions

id increments
name string
namespace string
status enum
metadata json
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

plans

id increments
name string
description text
namespace string
price double
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

subscriptions

id increments
institution_id ^FK integer
name string
metadata json
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

groups

id increments
institution_id ^FK integer
name string
metadata json
permissions json
timestamps timestamps
created_by ^FK integer
updated_by ^FK integer
softDeletes softDeletes

leads

id increments
title string
metadata json
status string
captured_ad ^FK integer
institution_id ^FK integer
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

history

id increments
lead_id ^FK integer
metadata json
type string
status enum
created_by ^FK integer
updated_by ^FK integer
timestamps timestamps
softDeletes softDeletes

products

id increments
user_id ^FK integer
institution_id ^FK integer
name string (255)
price double (8,2)
metadata json
timestamps timestamps
softDeletes softDeletes

invites

id increments
timestamps timestamps
created_by ^FK integer
identifier string (45)
email string (128)
phone string (11)

accounts

id increments
vendor string (128)
metadata json
institution_id ^FK integer
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

campaigns

id increments
name string (255)
start_date datetime
end_date datetime
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

sets

id increments
name string
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

templates

id increments
vendor string
metadata json
created_by ^FK integer
timestamps timestamps
updated_by ^FK integer
softDeletes softDeletes

ads

id increments
uuid uuid
template_id ^FK integer
set_id ^FK integer
campaign_id ^FK integer
account_id ^FK integer
timestamps timestamps
softDeletes softDeletes

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