seopilot - Laravel Schema Designer

users

id increments
timestamps timestamps

sites

id increments
uuid string
user_id ^FK bigInteger
websitename string
url string
industry integer
description longText
language integer
country integer
brandname string
slogan string
phone string
email string
address string
facebookurl string
twitterurl string
instagramurl string
youtubeurl string
wordsblacklist longText
tone integer
pointofview integer
crawlerexclude longText
crawlerinclude longText
gscauthtoken string
gscrefreshtoken string
pagescount integer
status integer
wpapikey string
automations longText
timestamps timestamps

pages

id increments
site_id ^FK bigInteger
url string
title string
description longText
status integer
timestamps timestamps

keywords

id increments
page_id ^FK bigInteger
name string
active integer
timestamps timestamps

optimizations

id increments
page_id ^FK bigInteger
type integer
oldvalue longText
newvalue longText
alternatives longText
timestamps timestamps

activitylogs

id increments
site_id ^FK bigInteger
page_id ^FK bigInteger
timestamps timestamps
activity string

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