pma.jiwcalendar.com / ls-02e97488f31333a91a9d4459ad99c4417f4d50ee.c1aizjqck3fi.us-east-2.rds.amazonaws.com / berkley_calendar

There are no favorite tables.

New
berkley
- calendar
- berkley_schema
berkleycms
bitnami_wordpress
bridit
cms
dbmaster
hollandcalendar
hollandcms
hollandcms2
hollandcms3
holland_calendar
- holland_calendar
- holland_calendar_tmp
information_schema
innodb
lom.jiwcalendar.com
mysql
performance_schema
sys
tmp
wholesale
- wholesale
- wholesale_staging

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Untitled *

v		berkley_calendar accepted
id : int(11)
email : varchar(255)
created_at : timestamp
updated_at : timestamp

v		berkley_calendar calledtimes
id : int(11)
user_id : int(11)
table_name : varchar(255)
brid_id : int(11)
calledonce : varchar(255)
calledtwice : varchar(255)
calledthird : varchar(255)
textmessage : varchar(255)
bookedtocalendar : varchar(255)
created_at : timestamp
updated_at : timestamp

v		berkley_calendar datacollection
id : int(11)
bride_name : varchar(255)
groom_first_name : varchar(255)
phone_number : varchar(255)
home_address : text
wedding_date : varchar(255)
estimate_budget : varchar(255)
wedding_dress_shopping_before : varchar(255)
preferred_appointment_date1 : varchar(255)
preferred_appointment_date2 : varchar(255)
preferred_appointment_date3 : varchar(255)
zipcode : varchar(255)
email : varchar(255)
likepage : tinyint(4)
sharepage : tinyint(4)
followinsta : tinyint(4)
city : varchar(255)
note : text
utm_source : varchar(255)
utm_medium : varchar(255)
utm_campaign : varchar(255)
utm_content : varchar(255)
utm_term : varchar(255)
device : varchar(255)
network : varchar(255)
matchtype : varchar(255)
Page_Url : varchar(255)
is_active : tinyint(1)
deleted_at : timestamp
created_at : timestamp
updated_at : timestamp

v		berkley_calendar datacollection_2018
id : int(11)
bride_name : varchar(255)
groom_first_name : varchar(255)
phone_number : varchar(255)
home_address : text
wedding_date : varchar(255)
estimate_budget : varchar(255)
wedding_dress_shopping_before : varchar(255)
preferred_appointment_date1 : varchar(255)
preferred_appointment_date2 : varchar(255)
preferred_appointment_date3 : varchar(255)
zipcode : varchar(255)
email : varchar(255)
likepage : tinyint(4)
sharepage : tinyint(4)
followinsta : tinyint(4)
city : varchar(255)
wedding_shopping2 : varchar(255)
created_date : varchar(255)
estimated_budget2 : varchar(255)

v		berkley_calendar datacollection_2019
id : int(11)
bride_name : varchar(255)
groom_first_name : varchar(255)
phone_number : varchar(255)
home_address : text
wedding_date : varchar(255)
estimate_budget : varchar(255)
wedding_dress_shopping_before : varchar(255)
preferred_appointment_date1 : varchar(255)
preferred_appointment_date2 : varchar(255)
preferred_appointment_date3 : varchar(255)
zipcode : varchar(255)
email : varchar(255)
likepage : tinyint(4)
sharepage : tinyint(4)
followinsta : tinyint(4)
city : varchar(255)
wedding_shopping2 : varchar(255)
wedding_shopping3 : varchar(255)
created_date : varchar(255)
estimated_budget2 : varchar(255)
note : text
utm_source : varchar(255)
utm_medium : varchar(255)
utm_campaign : varchar(255)
utm_content : varchar(255)
utm_term : varchar(255)
device : varchar(255)
network : varchar(255)
matchtype : varchar(255)
Page_Url : varchar(255)
deleted_at : timestamp
created_at : timestamp
updated_at : timestamp
is_active : tinyint(1)

v		berkley_calendar dataregister
id : int(11)
first_name : varchar(255)
last_name : varchar(255)
phone_number : varchar(255)
appointment_date : varchar(255)
email : varchar(255)
customer_profile : varchar(255)
profile_id : varchar(255)
charge_customer_profile : varchar(255)
charge_customer_profile_auth_code : varchar(255)
charge_customer_profile_trans_id : varchar(255)
description : varchar(255)

v		berkley_calendar dataregistermany
id : int(11)
first_name : varchar(255)
last_name : varchar(255)
phone_number : varchar(255)
appointment_date : varchar(255)
email : varchar(255)

v		berkley_calendar deleted_events
id : int(11)
event_id : int(11)
original_time : datetime
deleted_time : timestamp
details : text
display_time_slot : datetime

v		berkley_calendar ep_comment
ID : bigint(20)
post_id : bigint(20)
author : text
email : text
url : text
content : longtext

v		berkley_calendar events
id : int(11)
title : text
image : varchar(255)
description : text
start : datetime
end : datetime
url : text
color : text
brid_name : varchar(255)
wedding_date : varchar(255)
estimated_budget : varchar(255)
shopped_before : varchar(255)
Telephone : varchar(255)
Email : varchar(255)
brid_id : int(11)
retry : tinyint(1)
pickup : tinyint(1)
confirmed : tinyint(1)
created_date : date
updated_date : date
authorize.net_customer_profile_id : varchar(255)
bought : tinyint(1)
showedup : tinyint(1)
bookedaretry : tinyint(1)
utm_source : varchar(255)
utm_medium : varchar(255)
utm_campaign : varchar(255)
utm_content : varchar(255)
utm_term : varchar(255)
device : varchar(255)
network : varchar(255)
matchtype : varchar(255)
Page_Url : varchar(255)
is_active : tinyint(1)
deleted_at : timestamp
created_at : timestamp
updated_at : timestamp

v		berkley_calendar events_history
id : int(11)
event_id : int(11)
title : text
image : varchar(255)
description : text
start : datetime
end : datetime
url : text
color : text
bride_name : varchar(255)
wedding_date : varchar(255)
estimated_budget : varchar(255)
shopped_before : varchar(255)
Telephone : varchar(255)
Email : varchar(255)
brid_id : int(11)
retry : tinyint(1)
pickup : tinyint(1)
confirmed : tinyint(1)
created_date : date
updated_date : date
authorize.net_customer_profile_id : varchar(255)
bought : tinyint(1)
showedup : tinyint(1)
bookedaretry : tinyint(1)
utm_source : varchar(255)
utm_medium : varchar(255)
utm_campaign : varchar(255)
utm_content : varchar(255)
utm_term : varchar(255)
device : varchar(255)
network : varchar(255)
matchtype : varchar(255)
Page_Url : varchar(255)
is_active : tinyint(1)
deleted_at : timestamp
created_at : timestamp
updated_at : timestamp

v		berkley_calendar markers
id : int(11)
name : text
address : varchar(80)
lat : float(10,6)
lng : float(10,6)

v		berkley_calendar newsletter_template
id : int(11)
subject : varchar(255)
body : text
image : varchar(255)

v		berkley_calendar qad_cjtoolbox_authors
name : varchar(80)
email : varchar(100)
url : varchar(200)
attributes : int(11)
guid : varchar(16)
id : int(11)

v		berkley_calendar qad_cjtoolbox_backups
name : varchar(50)
type : varchar(20)
owner : int(11)
created : datetime
id : int(11)

v		berkley_calendar qad_cjtoolbox_blocks
name : varchar(50)
description : varchar(300)
owner : int(11)
created : datetime
lastModified : datetime
pinPoint : int(11)
state : enum('active','inactive')
location : enum('header','footer')
links : text
expressions : text
type : enum('block','revision','metabox')
backupId : int(11)
parent : int(11)
flag : int(11)
masterFile : int(11)
id : int(11)

v		berkley_calendar qad_cjtoolbox_block_files
id : int(11)
blockId : int(11)
name : varchar(100)
type : enum('css','javascript','php','html')
description : varchar(400)
code : text
order : smallint(6)
tag : text

v		berkley_calendar qad_cjtoolbox_block_pins
blockId : int(11)
pin : varchar(20)
value : int(11)
attributes : int(11)

v		berkley_calendar qad_cjtoolbox_block_templates
blockId : int(11)
templateId : int(11)

v		berkley_calendar qad_cjtoolbox_forms
blockId : int(11)
name : varchar(100)
groupType : varchar(20)

v		berkley_calendar qad_cjtoolbox_form_groups
id : int(11)
formId : int(11)
name : varchar(100)
description : text

v		berkley_calendar qad_cjtoolbox_form_group_parameters
groupId : int(11)
parameterId : int(11)
renderer : varchar(30)
description : text
helpText : varchar(200)

v		berkley_calendar qad_cjtoolbox_form_group_xfields
groupId : int(11)
text : text

v		berkley_calendar qad_cjtoolbox_packages
name : varchar(100)
author : varchar(150)
webSite : varchar(300)
description : text
license : text
readme : text
id : int(11)

v		berkley_calendar qad_cjtoolbox_package_objects
packageId : int(10) unsigned
objectId : int(10) unsigned
objectType : enum('block','template')
relType : enum('add','link')

v		berkley_calendar qad_cjtoolbox_parameters
id : int(10) unsigned
blockId : int(10) unsigned
parent : int(10) unsigned
name : varchar(60)
type : varchar(20)
defaultValue : text
required : tinyint(3) unsigned
contentParam : tinyint(3) unsigned

v		berkley_calendar qad_cjtoolbox_parameter_typedef
id : int(11)
parameterId : int(11)
text : text
value : text

v		berkley_calendar qad_cjtoolbox_parameter_typeparams
id : int(11)
parameterId : int(11)
name : text
value : text

v		berkley_calendar qad_cjtoolbox_templates
name : varchar(80)
queueName : varchar(80)
description : text
keywords : varchar(300)
license : text
type : enum('css','javascript','php','html')
email : varchar(90)
url : varchar(200)
creationDate : datetime
ownerId : int(11)
authorId : int(11)
state : enum('published','draft','trash')
attributes : int(11)
guid : varchar(16)
id : int(11)

v		berkley_calendar qad_cjtoolbox_template_revisions
templateId : int(11)
revisionNo : int(11)
version : varchar(15)
changeLog : varchar(600)
state : enum('release','beta','release-candidate','alpha','revision')
attributes : int(10) unsigned
dateCreated : datetime
file : varchar(400)
id : int(11)

v		berkley_calendar qad_commentmeta
meta_id : bigint(20) unsigned
comment_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		berkley_calendar qad_comments
comment_ID : bigint(20) unsigned
comment_post_ID : bigint(20) unsigned
comment_author : tinytext
comment_author_email : varchar(100)
comment_author_url : varchar(200)
comment_author_IP : varchar(100)
comment_date : datetime
comment_date_gmt : datetime
comment_content : text
comment_karma : int(11)
comment_approved : varchar(20)
comment_agent : varchar(255)
comment_type : varchar(20)
comment_parent : bigint(20) unsigned
user_id : bigint(20) unsigned

v		berkley_calendar qad_gallery_bank
id : int(11)
type : longtext
parent_id : int(11)

v		berkley_calendar qad_gallery_bank_meta
id : int(10) unsigned
meta_id : int(11)
meta_key : varchar(100)
meta_value : longtext
old_gallery_id : int(11)

v		berkley_calendar qad_links
link_id : bigint(20) unsigned
link_url : varchar(255)
link_name : varchar(255)
link_image : varchar(255)
link_target : varchar(25)
link_description : varchar(255)
link_visible : varchar(20)
link_owner : bigint(20) unsigned
link_rating : int(11)
link_updated : datetime
link_rel : varchar(255)
link_notes : mediumtext
link_rss : varchar(255)

v		berkley_calendar qad_ngg_album
id : bigint(20)
name : varchar(255)
slug : varchar(255)
previewpic : bigint(20)
albumdesc : mediumtext
sortorder : longtext
pageid : bigint(20)
extras_post_id : bigint(20)

v		berkley_calendar qad_ngg_gallery
gid : bigint(20)
name : varchar(255)
slug : varchar(255)
path : mediumtext
title : mediumtext
galdesc : mediumtext
pageid : bigint(20)
previewpic : bigint(20)
author : bigint(20)
extras_post_id : bigint(20)

v		berkley_calendar qad_ngg_pictures
pid : bigint(20)
image_slug : varchar(255)
post_id : bigint(20)
galleryid : bigint(20)
filename : varchar(255)
description : mediumtext
alttext : mediumtext
imagedate : datetime
exclude : tinyint(4)
sortorder : bigint(20)
meta_data : longtext
extras_post_id : bigint(20)
updated_at : bigint(20)

v		berkley_calendar qad_options
option_id : bigint(20) unsigned
option_name : varchar(191)
option_value : longtext
autoload : varchar(20)

v		berkley_calendar qad_postmeta
meta_id : bigint(20) unsigned
post_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		berkley_calendar qad_posts
ID : bigint(20) unsigned
post_author : bigint(20) unsigned
post_date : datetime
post_date_gmt : datetime
post_content : longtext
post_title : text
post_excerpt : text
post_status : varchar(20)
comment_status : varchar(20)
ping_status : varchar(20)
post_password : varchar(255)
post_name : varchar(200)
to_ping : text
pinged : text
post_modified : datetime
post_modified_gmt : datetime
post_content_filtered : longtext
post_parent : bigint(20) unsigned
guid : varchar(255)
menu_order : int(11)
post_type : varchar(20)
post_mime_type : varchar(100)
comment_count : bigint(20)

v		berkley_calendar qad_reflex_gallery
Id : int(11)
name : varchar(30)
slug : varchar(30)
description : text
thumbwidth : int(11)
thumbheight : int(11)

v		berkley_calendar qad_reflex_gallery_images
Id : int(11)
gid : int(11)
imagePath : longtext
title : varchar(50)
description : longtext
sortOrder : int(11)

v		berkley_calendar qad_revslider_css
id : int(11)
handle : text
settings : text
hover : text
params : text

v		berkley_calendar qad_revslider_layer_animations
id : int(11)
handle : text
params : text

v		berkley_calendar qad_revslider_settings
id : int(11)
general : text
params : text

v		berkley_calendar qad_revslider_sliders
id : int(11)
title : tinytext
alias : tinytext
params : text

v		berkley_calendar qad_revslider_slides
id : int(11)
slider_id : int(11)
slide_order : int(11)
params : text
layers : text

v		berkley_calendar qad_revslider_static_slides
id : int(11)
slider_id : int(11)
params : text
layers : text

v		berkley_calendar qad_termmeta
meta_id : bigint(20) unsigned
term_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		berkley_calendar qad_terms
term_id : bigint(20) unsigned
name : varchar(200)
slug : varchar(200)
term_group : bigint(20)

v		berkley_calendar qad_term_relationships
object_id : bigint(20) unsigned
term_taxonomy_id : bigint(20) unsigned
term_order : int(11)

v		berkley_calendar qad_term_taxonomy
term_taxonomy_id : bigint(20) unsigned
term_id : bigint(20) unsigned
taxonomy : varchar(32)
description : longtext
parent : bigint(20) unsigned
count : bigint(20)

v		berkley_calendar qad_usermeta
umeta_id : bigint(20) unsigned
user_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		berkley_calendar qad_users
ID : bigint(20) unsigned
user_login : varchar(60)
user_pass : varchar(255)
user_nicename : varchar(50)
user_email : varchar(100)
user_url : varchar(100)
user_registered : datetime
user_activation_key : varchar(255)
user_status : int(11)
display_name : varchar(250)

v		berkley_calendar qad_wfauditevents
id : bigint(20) unsigned
type : varchar(255)
data : text
event_time : double(14,4)
request_id : bigint(20) unsigned
state : enum('new','sending','sent')
state_timestamp : timestamp

v		berkley_calendar qad_wfAuditEvents
id : bigint(20) unsigned
type : varchar(255)
data : text
event_time : double(14,4)
request_id : bigint(20) unsigned
state : enum('new','sending','sent')
state_timestamp : timestamp

v		berkley_calendar qad_wfblockediplog
IP : binary(16)
countryCode : varchar(2)
blockCount : int(10) unsigned
unixday : int(10) unsigned
blockType : varchar(50)

v		berkley_calendar qad_wfBlockedIPLog
IP : binary(16)
countryCode : varchar(2)
blockCount : int(10) unsigned
unixday : int(10) unsigned
blockType : varchar(50)

v		berkley_calendar qad_wfblocks7
id : bigint(20) unsigned
type : int(10) unsigned
IP : binary(16)
blockedTime : bigint(20)
reason : varchar(255)
lastAttempt : int(10) unsigned
blockedHits : int(10) unsigned
expiration : bigint(20) unsigned
parameters : text

v		berkley_calendar qad_wfconfig
name : varchar(100)
val : longblob
autoload : enum('no','yes')

v		berkley_calendar qad_wfcrawlers
IP : binary(16)
patternSig : binary(16)
status : char(8)
lastUpdate : int(10) unsigned
PTR : varchar(255)

v		berkley_calendar qad_wffilechanges
filenameHash : char(64)
file : varchar(1000)
md5 : char(32)

v		berkley_calendar qad_wffilemods
filenameMD5 : binary(16)
filename : varchar(1000)
real_path : text
knownFile : tinyint(3) unsigned
oldMD5 : binary(16)
newMD5 : binary(16)
SHAC : binary(32)
stoppedOnSignature : varchar(255)
stoppedOnPosition : int(10) unsigned
isSafeFile : varchar(1)

v		berkley_calendar qad_wfhits
id : int(10) unsigned
attackLogTime : double(17,6) unsigned
ctime : double(17,6) unsigned
IP : binary(16)
jsRun : tinyint(4)
statusCode : int(11)
isGoogle : tinyint(4)
userID : int(10) unsigned
newVisit : tinyint(3) unsigned
URL : text
referer : text
UA : text
action : varchar(64)
actionDescription : text
actionData : text

v		berkley_calendar qad_wfhoover
id : int(10) unsigned
owner : text
host : text
path : text
hostKey : varbinary(124)

v		berkley_calendar qad_wfissues
id : int(10) unsigned
time : int(10) unsigned
lastUpdated : int(10) unsigned
status : varchar(10)
type : varchar(20)
severity : tinyint(3) unsigned
ignoreP : char(32)
ignoreC : char(32)
shortMsg : varchar(255)
longMsg : text
data : text

v		berkley_calendar qad_wfknownfilelist
id : int(11) unsigned
path : text
wordpress_path : text

v		berkley_calendar qad_wflivetraffichuman
IP : binary(16)
identifier : binary(32)
expiration : int(10) unsigned

v		berkley_calendar qad_wflocs
IP : binary(16)
ctime : int(10) unsigned
failed : tinyint(3) unsigned
city : varchar(255)
region : varchar(255)
countryName : varchar(255)
countryCode : char(2)
lat : float(10,7)
lon : float(10,7)

v		berkley_calendar qad_wflogins
id : int(10) unsigned
hitID : int(11)
ctime : double(17,6) unsigned
fail : tinyint(3) unsigned
action : varchar(40)
username : varchar(255)
userID : int(10) unsigned
IP : binary(16)
UA : text

v		berkley_calendar qad_wfls_2fa_secrets
id : int(11) unsigned
user_id : bigint(20) unsigned
secret : tinyblob
recovery : blob
ctime : int(10) unsigned
vtime : int(10) unsigned
mode : enum('authenticator')

v		berkley_calendar qad_wfls_passkeys
id : bigint(20) unsigned
user_id : bigint(20) unsigned
credential_id : varbinary(1023)
credential_id_hash : binary(32)
public_key : blob
sign_count : bigint(20) unsigned
transports : varchar(255)
label : varchar(255)
user_handle : varbinary(255)
ctime : int(10) unsigned
mtime : int(10) unsigned
last_used_at : int(10) unsigned

v		berkley_calendar qad_wfls_role_counts
serialized_roles : varbinary(255)
two_factor_inactive : tinyint(1)
passkey_inactive : tinyint(1)
user_count : bigint(20) unsigned

v		berkley_calendar qad_wfls_settings
name : varchar(191)
value : longblob
autoload : enum('no','yes')

v		berkley_calendar qad_wfnotifications
id : varchar(32)
new : tinyint(3) unsigned
category : varchar(255)
priority : int(11)
ctime : int(10) unsigned
html : text
links : text

v		berkley_calendar qad_wfpendingissues
id : int(10) unsigned
time : int(10) unsigned
lastUpdated : int(10) unsigned
status : varchar(10)
type : varchar(20)
severity : tinyint(3) unsigned
ignoreP : char(32)
ignoreC : char(32)
shortMsg : varchar(255)
longMsg : text
data : text

v		berkley_calendar qad_wfreversecache
IP : binary(16)
host : varchar(255)
lastUpdate : int(10) unsigned

v		berkley_calendar qad_wfsecurityevents
id : bigint(20) unsigned
type : varchar(255)
data : text
event_time : double(14,4)
state : enum('new','sending','sent')
state_timestamp : timestamp

v		berkley_calendar qad_wfsnipcache
id : int(10) unsigned
IP : varchar(45)
expiration : timestamp
body : varchar(255)
count : int(10) unsigned
type : int(10) unsigned

v		berkley_calendar qad_wfstatus
id : bigint(20) unsigned
ctime : double(17,6) unsigned
level : tinyint(3) unsigned
type : char(5)
msg : varchar(1000)

v		berkley_calendar qad_wftrafficrates
eMin : int(10) unsigned
IP : binary(16)
hitType : enum('hit','404')
hits : int(10) unsigned

v		berkley_calendar qad_wfwaffailures
id : int(10) unsigned
throwable : text
rule_id : int(10) unsigned
timestamp : timestamp

Create relationship
FOREIGN KEY
on delete
on update