Database Table Columns

The following is an outline and description of the database tables created during the standard installation of Socialveo. The database structure and the diagram below were last updated in version 1.03.

At the moment the only database supported by Socialveo is MySQL version 5.6 or greater, or any version of MariaDB.

Because Socialveo interfaces with this database by itself, you as an end user, shouldn?t have to worry much about its structure. If you?re writing custom add-on however, you may be interested in learning how Socialveo stores its data and relationships. If you have already attempted to use the existing Socialveo API to access the data you need but have determined it?s not possible without accessing the database directly, WordPress provides the Models class to make this task easy.

Table details

This section is the overview of all the tables created during the Socialveo standard installation, in alphabetical order. It is followed by specific information of what is in each table.

Table Children Parents Columns Comments
circle 1 1 8
comment 1 20
connection 1 3 13
connection_circle 2 7
cron_schedule 7
google_geocode_cache 5
google_map_cache 5
index 2 11
invitation 10
karma 1 13
karma_badge 10
location 4 3 15
location_country 3 5
location_locality 1 2 9
location_region 2 1 7
log 1 10
media 3 23
messages 2 12
messages_dialogs 3 1 11
messages_dialogs_users 2 7
migration 3
network 4 3 26
network_fields 7
network_reviews 2 9
notification 1 16
oauth_access_tokens 6
oauth_clients 4
oauth_refresh_tokens 5
oauth_scopes 2
password_recovery 1 7
payment 3 1 20
payment_history 1 14
post 3 29
spam 1 11
static_pages 18
tag 1 13
tag_association 2 19
user 19 1 37
user_socialprofile 11
wallet 1 1 11
wallet_history 1 12
web_event 10

Relationships