🗄️ Database Explorer

MariaDB / MySQL Database Structure Viewer

6
Databases
413
Total Tables
4529
Total Fields
▶ information_schema 79 tables
▶ ALL_PLUGINS 13 fields
Field Name Type Null Key Default Extra
PLUGIN_NAME varchar(64) NO NULL
PLUGIN_VERSION varchar(20) NO NULL
PLUGIN_STATUS varchar(16) NO NULL
PLUGIN_TYPE varchar(80) NO NULL
PLUGIN_TYPE_VERSION varchar(20) NO NULL
PLUGIN_LIBRARY varchar(64) YES NULL
PLUGIN_LIBRARY_VERSION varchar(20) YES NULL
PLUGIN_AUTHOR varchar(64) YES NULL
PLUGIN_DESCRIPTION longtext YES NULL
PLUGIN_LICENSE varchar(80) NO NULL
LOAD_OPTION varchar(64) NO NULL
PLUGIN_MATURITY varchar(12) NO NULL
PLUGIN_AUTH_VERSION varchar(80) YES NULL
▶ APPLICABLE_ROLES 4 fields
Field Name Type Null Key Default Extra
GRANTEE varchar(385) NO NULL
ROLE_NAME varchar(128) NO NULL
IS_GRANTABLE varchar(3) NO NULL
IS_DEFAULT varchar(3) YES NULL
▶ CHARACTER_SETS 4 fields
Field Name Type Null Key Default Extra
CHARACTER_SET_NAME varchar(32) NO NULL
DEFAULT_COLLATE_NAME varchar(32) NO NULL
DESCRIPTION varchar(60) NO NULL
MAXLEN bigint(3) NO NULL
▶ CHECK_CONSTRAINTS 6 fields
Field Name Type Null Key Default Extra
CONSTRAINT_CATALOG varchar(512) NO NULL
CONSTRAINT_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
CONSTRAINT_NAME varchar(64) NO NULL
LEVEL varchar(6) NO NULL
CHECK_CLAUSE longtext NO NULL
▶ COLLATIONS 6 fields
Field Name Type Null Key Default Extra
COLLATION_NAME varchar(32) NO NULL
CHARACTER_SET_NAME varchar(32) NO NULL
ID bigint(11) NO NULL
IS_DEFAULT varchar(3) NO NULL
IS_COMPILED varchar(3) NO NULL
SORTLEN bigint(3) NO NULL
▶ COLLATION_CHARACTER_SET_APPLICABILITY 2 fields
Field Name Type Null Key Default Extra
COLLATION_NAME varchar(32) NO NULL
CHARACTER_SET_NAME varchar(32) NO NULL
▶ COLUMNS 22 fields
Field Name Type Null Key Default Extra
TABLE_CATALOG varchar(512) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
COLUMN_NAME varchar(64) NO NULL
ORDINAL_POSITION bigint(21) unsigned NO NULL
COLUMN_DEFAULT longtext YES NULL
IS_NULLABLE varchar(3) NO NULL
DATA_TYPE varchar(64) NO NULL
CHARACTER_MAXIMUM_LENGTH bigint(21) unsigned YES NULL
CHARACTER_OCTET_LENGTH bigint(21) unsigned YES NULL
NUMERIC_PRECISION bigint(21) unsigned YES NULL
NUMERIC_SCALE bigint(21) unsigned YES NULL
DATETIME_PRECISION bigint(21) unsigned YES NULL
CHARACTER_SET_NAME varchar(32) YES NULL
COLLATION_NAME varchar(32) YES NULL
COLUMN_TYPE longtext NO NULL
COLUMN_KEY varchar(3) NO NULL
EXTRA varchar(80) NO NULL
PRIVILEGES varchar(80) NO NULL
COLUMN_COMMENT varchar(1024) NO NULL
IS_GENERATED varchar(6) NO NULL
GENERATION_EXPRESSION longtext YES NULL
▶ COLUMN_PRIVILEGES 7 fields
Field Name Type Null Key Default Extra
GRANTEE varchar(385) NO NULL
TABLE_CATALOG varchar(512) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
COLUMN_NAME varchar(64) NO NULL
PRIVILEGE_TYPE varchar(64) NO NULL
IS_GRANTABLE varchar(3) NO NULL
▶ ENABLED_ROLES 1 fields
Field Name Type Null Key Default Extra
ROLE_NAME varchar(128) YES NULL
▶ ENGINES 6 fields
Field Name Type Null Key Default Extra
ENGINE varchar(64) NO NULL
SUPPORT varchar(8) NO NULL
COMMENT varchar(160) NO NULL
TRANSACTIONS varchar(3) YES NULL
XA varchar(3) YES NULL
SAVEPOINTS varchar(3) YES NULL
▶ EVENTS 24 fields
Field Name Type Null Key Default Extra
EVENT_CATALOG varchar(64) NO NULL
EVENT_SCHEMA varchar(64) NO NULL
EVENT_NAME varchar(64) NO NULL
DEFINER varchar(384) NO NULL
TIME_ZONE varchar(64) NO NULL
EVENT_BODY varchar(8) NO NULL
EVENT_DEFINITION longtext NO NULL
EVENT_TYPE varchar(9) NO NULL
EXECUTE_AT datetime YES NULL
INTERVAL_VALUE varchar(256) YES NULL
INTERVAL_FIELD varchar(18) YES NULL
SQL_MODE varchar(8192) NO NULL
STARTS datetime YES NULL
ENDS datetime YES NULL
STATUS varchar(18) NO NULL
ON_COMPLETION varchar(12) NO NULL
CREATED datetime NO NULL
LAST_ALTERED datetime NO NULL
LAST_EXECUTED datetime YES NULL
EVENT_COMMENT varchar(64) NO NULL
ORIGINATOR bigint(10) NO NULL
CHARACTER_SET_CLIENT varchar(32) NO NULL
COLLATION_CONNECTION varchar(32) NO NULL
DATABASE_COLLATION varchar(32) NO NULL
▶ FILES 38 fields
Field Name Type Null Key Default Extra
FILE_ID bigint(4) NO NULL
FILE_NAME varchar(512) YES NULL
FILE_TYPE varchar(20) NO NULL
TABLESPACE_NAME varchar(64) YES NULL
TABLE_CATALOG varchar(64) NO NULL
TABLE_SCHEMA varchar(64) YES NULL
TABLE_NAME varchar(64) YES NULL
LOGFILE_GROUP_NAME varchar(64) YES NULL
LOGFILE_GROUP_NUMBER bigint(4) YES NULL
ENGINE varchar(64) NO NULL
FULLTEXT_KEYS varchar(64) YES NULL
DELETED_ROWS bigint(4) YES NULL
UPDATE_COUNT bigint(4) YES NULL
FREE_EXTENTS bigint(4) YES NULL
TOTAL_EXTENTS bigint(4) YES NULL
EXTENT_SIZE bigint(4) NO NULL
INITIAL_SIZE bigint(21) unsigned YES NULL
MAXIMUM_SIZE bigint(21) unsigned YES NULL
AUTOEXTEND_SIZE bigint(21) unsigned YES NULL
CREATION_TIME datetime YES NULL
LAST_UPDATE_TIME datetime YES NULL
LAST_ACCESS_TIME datetime YES NULL
RECOVER_TIME bigint(4) YES NULL
TRANSACTION_COUNTER bigint(4) YES NULL
VERSION bigint(21) unsigned YES NULL
ROW_FORMAT varchar(10) YES NULL
TABLE_ROWS bigint(21) unsigned YES NULL
AVG_ROW_LENGTH bigint(21) unsigned YES NULL
DATA_LENGTH bigint(21) unsigned YES NULL
MAX_DATA_LENGTH bigint(21) unsigned YES NULL
INDEX_LENGTH bigint(21) unsigned YES NULL
DATA_FREE bigint(21) unsigned YES NULL
CREATE_TIME datetime YES NULL
UPDATE_TIME datetime YES NULL
CHECK_TIME datetime YES NULL
CHECKSUM bigint(21) unsigned YES NULL
STATUS varchar(20) NO NULL
EXTRA varchar(255) YES NULL
▶ GLOBAL_STATUS 2 fields
Field Name Type Null Key Default Extra
VARIABLE_NAME varchar(64) NO NULL
VARIABLE_VALUE varchar(4096) NO NULL
▶ GLOBAL_VARIABLES 2 fields
Field Name Type Null Key Default Extra
VARIABLE_NAME varchar(64) NO NULL
VARIABLE_VALUE varchar(4096) NO NULL
▶ KEYWORDS 1 fields
Field Name Type Null Key Default Extra
WORD varchar(64) YES NULL
▶ KEY_CACHES 12 fields
Field Name Type Null Key Default Extra
KEY_CACHE_NAME varchar(192) NO NULL
SEGMENTS int(3) unsigned YES NULL
SEGMENT_NUMBER int(3) unsigned YES NULL
FULL_SIZE bigint(21) unsigned NO NULL
BLOCK_SIZE bigint(21) unsigned NO NULL
USED_BLOCKS bigint(21) unsigned NO NULL
UNUSED_BLOCKS bigint(21) unsigned NO NULL
DIRTY_BLOCKS bigint(21) unsigned NO NULL
READ_REQUESTS bigint(21) unsigned NO NULL
READS bigint(21) unsigned NO NULL
WRITE_REQUESTS bigint(21) unsigned NO NULL
WRITES bigint(21) unsigned NO NULL
▶ KEY_COLUMN_USAGE 12 fields
Field Name Type Null Key Default Extra
CONSTRAINT_CATALOG varchar(512) NO NULL
CONSTRAINT_SCHEMA varchar(64) NO NULL
CONSTRAINT_NAME varchar(64) NO NULL
TABLE_CATALOG varchar(512) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
COLUMN_NAME varchar(64) NO NULL
ORDINAL_POSITION bigint(10) NO NULL
POSITION_IN_UNIQUE_CONSTRAINT bigint(10) YES NULL
REFERENCED_TABLE_SCHEMA varchar(64) YES NULL
REFERENCED_TABLE_NAME varchar(64) YES NULL
REFERENCED_COLUMN_NAME varchar(64) YES NULL
▶ OPTIMIZER_TRACE 4 fields
Field Name Type Null Key Default Extra
QUERY longtext NO NULL
TRACE longtext NO NULL
MISSING_BYTES_BEYOND_MAX_MEM_SIZE int(20) NO NULL
INSUFFICIENT_PRIVILEGES tinyint(1) NO NULL
▶ PARAMETERS 16 fields
Field Name Type Null Key Default Extra
SPECIFIC_CATALOG varchar(512) NO NULL
SPECIFIC_SCHEMA varchar(64) NO NULL
SPECIFIC_NAME varchar(64) NO NULL
ORDINAL_POSITION int(21) NO NULL
PARAMETER_MODE varchar(5) YES NULL
PARAMETER_NAME varchar(64) YES NULL
DATA_TYPE varchar(64) NO NULL
CHARACTER_MAXIMUM_LENGTH int(21) YES NULL
CHARACTER_OCTET_LENGTH int(21) YES NULL
NUMERIC_PRECISION int(21) YES NULL
NUMERIC_SCALE int(21) YES NULL
DATETIME_PRECISION bigint(21) unsigned YES NULL
CHARACTER_SET_NAME varchar(64) YES NULL
COLLATION_NAME varchar(64) YES NULL
DTD_IDENTIFIER longtext NO NULL
ROUTINE_TYPE varchar(9) NO NULL
▶ PARTITIONS 25 fields
Field Name Type Null Key Default Extra
TABLE_CATALOG varchar(512) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
PARTITION_NAME varchar(64) YES NULL
SUBPARTITION_NAME varchar(64) YES NULL
PARTITION_ORDINAL_POSITION bigint(21) unsigned YES NULL
SUBPARTITION_ORDINAL_POSITION bigint(21) unsigned YES NULL
PARTITION_METHOD varchar(18) YES NULL
SUBPARTITION_METHOD varchar(12) YES NULL
PARTITION_EXPRESSION longtext YES NULL
SUBPARTITION_EXPRESSION longtext YES NULL
PARTITION_DESCRIPTION longtext YES NULL
TABLE_ROWS bigint(21) unsigned NO NULL
AVG_ROW_LENGTH bigint(21) unsigned NO NULL
DATA_LENGTH bigint(21) unsigned NO NULL
MAX_DATA_LENGTH bigint(21) unsigned YES NULL
INDEX_LENGTH bigint(21) unsigned NO NULL
DATA_FREE bigint(21) unsigned NO NULL
CREATE_TIME datetime YES NULL
UPDATE_TIME datetime YES NULL
CHECK_TIME datetime YES NULL
CHECKSUM bigint(21) unsigned YES NULL
PARTITION_COMMENT varchar(80) NO NULL
NODEGROUP varchar(12) NO NULL
TABLESPACE_NAME varchar(64) YES NULL
▶ PLUGINS 13 fields
Field Name Type Null Key Default Extra
PLUGIN_NAME varchar(64) NO NULL
PLUGIN_VERSION varchar(20) NO NULL
PLUGIN_STATUS varchar(16) NO NULL
PLUGIN_TYPE varchar(80) NO NULL
PLUGIN_TYPE_VERSION varchar(20) NO NULL
PLUGIN_LIBRARY varchar(64) YES NULL
PLUGIN_LIBRARY_VERSION varchar(20) YES NULL
PLUGIN_AUTHOR varchar(64) YES NULL
PLUGIN_DESCRIPTION longtext YES NULL
PLUGIN_LICENSE varchar(80) NO NULL
LOAD_OPTION varchar(64) NO NULL
PLUGIN_MATURITY varchar(12) NO NULL
PLUGIN_AUTH_VERSION varchar(80) YES NULL
▶ PROCESSLIST 18 fields
Field Name Type Null Key Default Extra
ID bigint(4) NO NULL
USER varchar(128) NO NULL
HOST varchar(64) NO NULL
DB varchar(64) YES NULL
COMMAND varchar(16) NO NULL
TIME int(7) NO NULL
STATE varchar(64) YES NULL
INFO longtext YES NULL
TIME_MS decimal(22,3) NO NULL
STAGE tinyint(2) NO NULL
MAX_STAGE tinyint(2) NO NULL
PROGRESS decimal(7,3) NO NULL
MEMORY_USED bigint(7) NO NULL
MAX_MEMORY_USED bigint(7) NO NULL
EXAMINED_ROWS int(7) NO NULL
QUERY_ID bigint(4) NO NULL
INFO_BINARY blob YES NULL
TID bigint(4) NO NULL
▶ PROFILING 18 fields
Field Name Type Null Key Default Extra
QUERY_ID int(20) NO NULL
SEQ int(20) NO NULL
STATE varchar(30) NO NULL
DURATION decimal(9,6) NO NULL
CPU_USER decimal(9,6) YES NULL
CPU_SYSTEM decimal(9,6) YES NULL
CONTEXT_VOLUNTARY int(20) YES NULL
CONTEXT_INVOLUNTARY int(20) YES NULL
BLOCK_OPS_IN int(20) YES NULL
BLOCK_OPS_OUT int(20) YES NULL
MESSAGES_SENT int(20) YES NULL
MESSAGES_RECEIVED int(20) YES NULL
PAGE_FAULTS_MAJOR int(20) YES NULL
PAGE_FAULTS_MINOR int(20) YES NULL
SWAPS int(20) YES NULL
SOURCE_FUNCTION varchar(30) YES NULL
SOURCE_FILE varchar(20) YES NULL
SOURCE_LINE int(20) YES NULL
▶ REFERENTIAL_CONSTRAINTS 11 fields
Field Name Type Null Key Default Extra
CONSTRAINT_CATALOG varchar(512) NO NULL
CONSTRAINT_SCHEMA varchar(64) NO NULL
CONSTRAINT_NAME varchar(64) NO NULL
UNIQUE_CONSTRAINT_CATALOG varchar(512) NO NULL
UNIQUE_CONSTRAINT_SCHEMA varchar(64) NO NULL
UNIQUE_CONSTRAINT_NAME varchar(64) YES NULL
MATCH_OPTION varchar(64) NO NULL
UPDATE_RULE varchar(64) NO NULL
DELETE_RULE varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
REFERENCED_TABLE_NAME varchar(64) YES NULL
▶ ROUTINES 31 fields
Field Name Type Null Key Default Extra
SPECIFIC_NAME varchar(64) NO NULL
ROUTINE_CATALOG varchar(512) NO NULL
ROUTINE_SCHEMA varchar(64) NO NULL
ROUTINE_NAME varchar(64) NO NULL
ROUTINE_TYPE varchar(13) NO NULL
DATA_TYPE varchar(64) NO NULL
CHARACTER_MAXIMUM_LENGTH int(21) YES NULL
CHARACTER_OCTET_LENGTH int(21) YES NULL
NUMERIC_PRECISION int(21) YES NULL
NUMERIC_SCALE int(21) YES NULL
DATETIME_PRECISION bigint(21) unsigned YES NULL
CHARACTER_SET_NAME varchar(64) YES NULL
COLLATION_NAME varchar(64) YES NULL
DTD_IDENTIFIER longtext YES NULL
ROUTINE_BODY varchar(8) NO NULL
ROUTINE_DEFINITION longtext YES NULL
EXTERNAL_NAME varchar(64) YES NULL
EXTERNAL_LANGUAGE varchar(64) YES NULL
PARAMETER_STYLE varchar(8) NO NULL
IS_DETERMINISTIC varchar(3) NO NULL
SQL_DATA_ACCESS varchar(64) NO NULL
SQL_PATH varchar(64) YES NULL
SECURITY_TYPE varchar(7) NO NULL
CREATED datetime NO NULL
LAST_ALTERED datetime NO NULL
SQL_MODE varchar(8192) NO NULL
ROUTINE_COMMENT longtext NO NULL
DEFINER varchar(384) NO NULL
CHARACTER_SET_CLIENT varchar(32) NO NULL
COLLATION_CONNECTION varchar(32) NO NULL
DATABASE_COLLATION varchar(32) NO NULL
▶ SCHEMATA 6 fields
Field Name Type Null Key Default Extra
CATALOG_NAME varchar(512) NO NULL
SCHEMA_NAME varchar(64) NO NULL
DEFAULT_CHARACTER_SET_NAME varchar(32) NO NULL
DEFAULT_COLLATION_NAME varchar(32) NO NULL
SQL_PATH varchar(512) YES NULL
SCHEMA_COMMENT varchar(1024) NO NULL
▶ SCHEMA_PRIVILEGES 5 fields
Field Name Type Null Key Default Extra
GRANTEE varchar(385) NO NULL
TABLE_CATALOG varchar(512) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
PRIVILEGE_TYPE varchar(64) NO NULL
IS_GRANTABLE varchar(3) NO NULL
▶ SESSION_STATUS 2 fields
Field Name Type Null Key Default Extra
VARIABLE_NAME varchar(64) NO NULL
VARIABLE_VALUE varchar(4096) NO NULL
▶ SESSION_VARIABLES 2 fields
Field Name Type Null Key Default Extra
VARIABLE_NAME varchar(64) NO NULL
VARIABLE_VALUE varchar(4096) NO NULL
▶ STATISTICS 17 fields
Field Name Type Null Key Default Extra
TABLE_CATALOG varchar(512) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
NON_UNIQUE bigint(1) NO NULL
INDEX_SCHEMA varchar(64) NO NULL
INDEX_NAME varchar(64) NO NULL
SEQ_IN_INDEX bigint(2) NO NULL
COLUMN_NAME varchar(64) NO NULL
COLLATION varchar(1) YES NULL
CARDINALITY bigint(21) YES NULL
SUB_PART bigint(3) YES NULL
PACKED varchar(10) YES NULL
NULLABLE varchar(3) NO NULL
INDEX_TYPE varchar(16) NO NULL
COMMENT varchar(16) YES NULL
INDEX_COMMENT varchar(1024) NO NULL
IGNORED varchar(3) NO NULL
▶ SQL_FUNCTIONS 1 fields
Field Name Type Null Key Default Extra
FUNCTION varchar(64) YES NULL
▶ SYSTEM_VARIABLES 15 fields
Field Name Type Null Key Default Extra
VARIABLE_NAME varchar(64) NO NULL
SESSION_VALUE varchar(2048) YES NULL
GLOBAL_VALUE varchar(2048) YES NULL
GLOBAL_VALUE_ORIGIN varchar(64) NO NULL
DEFAULT_VALUE varchar(2048) YES NULL
VARIABLE_SCOPE varchar(64) NO NULL
VARIABLE_TYPE varchar(64) NO NULL
VARIABLE_COMMENT varchar(2048) NO NULL
NUMERIC_MIN_VALUE varchar(21) YES NULL
NUMERIC_MAX_VALUE varchar(21) YES NULL
NUMERIC_BLOCK_SIZE varchar(21) YES NULL
ENUM_VALUE_LIST longtext YES NULL
READ_ONLY varchar(3) NO NULL
COMMAND_LINE_ARGUMENT varchar(64) YES NULL
GLOBAL_VALUE_PATH varchar(2048) YES NULL
▶ TABLES 23 fields
Field Name Type Null Key Default Extra
TABLE_CATALOG varchar(512) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
TABLE_TYPE varchar(64) NO NULL
ENGINE varchar(64) YES NULL
VERSION bigint(21) unsigned YES NULL
ROW_FORMAT varchar(10) YES NULL
TABLE_ROWS bigint(21) unsigned YES NULL
AVG_ROW_LENGTH bigint(21) unsigned YES NULL
DATA_LENGTH bigint(21) unsigned YES NULL
MAX_DATA_LENGTH bigint(21) unsigned YES NULL
INDEX_LENGTH bigint(21) unsigned YES NULL
DATA_FREE bigint(21) unsigned YES NULL
AUTO_INCREMENT bigint(21) unsigned YES NULL
CREATE_TIME datetime YES NULL
UPDATE_TIME datetime YES NULL
CHECK_TIME datetime YES NULL
TABLE_COLLATION varchar(32) YES NULL
CHECKSUM bigint(21) unsigned YES NULL
CREATE_OPTIONS varchar(2048) YES NULL
TABLE_COMMENT varchar(2048) NO NULL
MAX_INDEX_LENGTH bigint(21) unsigned YES NULL
TEMPORARY varchar(1) YES NULL
▶ TABLESPACES 9 fields
Field Name Type Null Key Default Extra
TABLESPACE_NAME varchar(64) NO NULL
ENGINE varchar(64) NO NULL
TABLESPACE_TYPE varchar(64) YES NULL
LOGFILE_GROUP_NAME varchar(64) YES NULL
EXTENT_SIZE bigint(21) unsigned YES NULL
AUTOEXTEND_SIZE bigint(21) unsigned YES NULL
MAXIMUM_SIZE bigint(21) unsigned YES NULL
NODEGROUP_ID bigint(21) unsigned YES NULL
TABLESPACE_COMMENT varchar(2048) YES NULL
▶ TABLE_CONSTRAINTS 6 fields
Field Name Type Null Key Default Extra
CONSTRAINT_CATALOG varchar(512) NO NULL
CONSTRAINT_SCHEMA varchar(64) NO NULL
CONSTRAINT_NAME varchar(64) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
CONSTRAINT_TYPE varchar(64) NO NULL
▶ TABLE_PRIVILEGES 6 fields
Field Name Type Null Key Default Extra
GRANTEE varchar(385) NO NULL
TABLE_CATALOG varchar(512) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
PRIVILEGE_TYPE varchar(64) NO NULL
IS_GRANTABLE varchar(3) NO NULL
▶ TRIGGERS 22 fields
Field Name Type Null Key Default Extra
TRIGGER_CATALOG varchar(512) NO NULL
TRIGGER_SCHEMA varchar(64) NO NULL
TRIGGER_NAME varchar(64) NO NULL
EVENT_MANIPULATION varchar(6) NO NULL
EVENT_OBJECT_CATALOG varchar(512) NO NULL
EVENT_OBJECT_SCHEMA varchar(64) NO NULL
EVENT_OBJECT_TABLE varchar(64) NO NULL
ACTION_ORDER bigint(4) NO NULL
ACTION_CONDITION longtext YES NULL
ACTION_STATEMENT longtext NO NULL
ACTION_ORIENTATION varchar(9) NO NULL
ACTION_TIMING varchar(6) NO NULL
ACTION_REFERENCE_OLD_TABLE varchar(64) YES NULL
ACTION_REFERENCE_NEW_TABLE varchar(64) YES NULL
ACTION_REFERENCE_OLD_ROW varchar(3) NO NULL
ACTION_REFERENCE_NEW_ROW varchar(3) NO NULL
CREATED datetime(2) YES NULL
SQL_MODE varchar(8192) NO NULL
DEFINER varchar(384) NO NULL
CHARACTER_SET_CLIENT varchar(32) NO NULL
COLLATION_CONNECTION varchar(32) NO NULL
DATABASE_COLLATION varchar(32) NO NULL
▶ USER_PRIVILEGES 4 fields
Field Name Type Null Key Default Extra
GRANTEE varchar(385) NO NULL
TABLE_CATALOG varchar(512) NO NULL
PRIVILEGE_TYPE varchar(64) NO NULL
IS_GRANTABLE varchar(3) NO NULL
▶ VIEWS 11 fields
Field Name Type Null Key Default Extra
TABLE_CATALOG varchar(512) NO NULL
TABLE_SCHEMA varchar(64) NO NULL
TABLE_NAME varchar(64) NO NULL
VIEW_DEFINITION longtext NO NULL
CHECK_OPTION varchar(8) NO NULL
IS_UPDATABLE varchar(3) NO NULL
DEFINER varchar(384) NO NULL
SECURITY_TYPE varchar(7) NO NULL
CHARACTER_SET_CLIENT varchar(32) NO NULL
COLLATION_CONNECTION varchar(32) NO NULL
ALGORITHM varchar(10) NO NULL
▶ CLIENT_STATISTICS 25 fields
Field Name Type Null Key Default Extra
CLIENT varchar(64) NO NULL
TOTAL_CONNECTIONS bigint(21) NO NULL
CONCURRENT_CONNECTIONS bigint(21) NO NULL
CONNECTED_TIME bigint(21) NO NULL
BUSY_TIME double NO NULL
CPU_TIME double NO NULL
BYTES_RECEIVED bigint(21) NO NULL
BYTES_SENT bigint(21) NO NULL
BINLOG_BYTES_WRITTEN bigint(21) NO NULL
ROWS_READ bigint(21) NO NULL
ROWS_SENT bigint(21) NO NULL
ROWS_DELETED bigint(21) NO NULL
ROWS_INSERTED bigint(21) NO NULL
ROWS_UPDATED bigint(21) NO NULL
SELECT_COMMANDS bigint(21) NO NULL
UPDATE_COMMANDS bigint(21) NO NULL
OTHER_COMMANDS bigint(21) NO NULL
COMMIT_TRANSACTIONS bigint(21) NO NULL
ROLLBACK_TRANSACTIONS bigint(21) NO NULL
DENIED_CONNECTIONS bigint(21) NO NULL
LOST_CONNECTIONS bigint(21) NO NULL
ACCESS_DENIED bigint(21) NO NULL
EMPTY_QUERIES bigint(21) NO NULL
TOTAL_SSL_CONNECTIONS bigint(21) unsigned NO NULL
MAX_STATEMENT_TIME_EXCEEDED bigint(21) NO NULL
▶ INDEX_STATISTICS 4 fields
Field Name Type Null Key Default Extra
TABLE_SCHEMA varchar(192) NO NULL
TABLE_NAME varchar(192) NO NULL
INDEX_NAME varchar(192) NO NULL
ROWS_READ bigint(21) NO NULL
▶ INNODB_FT_CONFIG 2 fields
Field Name Type Null Key Default Extra
KEY varchar(193) NO NULL
VALUE varchar(193) NO NULL
▶ GEOMETRY_COLUMNS 13 fields
Field Name Type Null Key Default Extra
F_TABLE_CATALOG varchar(512) NO NULL
F_TABLE_SCHEMA varchar(64) NO NULL
F_TABLE_NAME varchar(64) NO NULL
F_GEOMETRY_COLUMN varchar(64) NO NULL
G_TABLE_CATALOG varchar(512) NO NULL
G_TABLE_SCHEMA varchar(64) NO NULL
G_TABLE_NAME varchar(64) NO NULL
G_GEOMETRY_COLUMN varchar(64) NO NULL
STORAGE_TYPE tinyint(2) NO NULL
GEOMETRY_TYPE int(7) NO NULL
COORD_DIMENSION tinyint(2) NO NULL
MAX_PPR tinyint(2) NO NULL
SRID smallint(5) NO NULL
▶ INNODB_SYS_TABLESTATS 9 fields
Field Name Type Null Key Default Extra
TABLE_ID bigint(21) unsigned NO NULL
NAME varchar(64) NO NULL
STATS_INITIALIZED int(1) NO NULL
NUM_ROWS bigint(21) unsigned NO NULL
CLUST_INDEX_SIZE bigint(21) unsigned NO NULL
OTHER_INDEX_SIZE bigint(21) unsigned NO NULL
MODIFIED_COUNTER bigint(21) unsigned NO NULL
AUTOINC bigint(21) unsigned NO NULL
REF_COUNT int(11) NO NULL
▶ SPATIAL_REF_SYS 4 fields
Field Name Type Null Key Default Extra
SRID smallint(5) NO NULL
AUTH_NAME varchar(512) NO NULL
AUTH_SRID int(5) NO NULL
SRTEXT varchar(2048) NO NULL
▶ USER_STATISTICS 25 fields
Field Name Type Null Key Default Extra
USER varchar(128) NO NULL
TOTAL_CONNECTIONS int(11) NO NULL
CONCURRENT_CONNECTIONS int(11) NO NULL
CONNECTED_TIME int(11) NO NULL
BUSY_TIME double NO NULL
CPU_TIME double NO NULL
BYTES_RECEIVED bigint(21) NO NULL
BYTES_SENT bigint(21) NO NULL
BINLOG_BYTES_WRITTEN bigint(21) NO NULL
ROWS_READ bigint(21) NO NULL
ROWS_SENT bigint(21) NO NULL
ROWS_DELETED bigint(21) NO NULL
ROWS_INSERTED bigint(21) NO NULL
ROWS_UPDATED bigint(21) NO NULL
SELECT_COMMANDS bigint(21) NO NULL
UPDATE_COMMANDS bigint(21) NO NULL
OTHER_COMMANDS bigint(21) NO NULL
COMMIT_TRANSACTIONS bigint(21) NO NULL
ROLLBACK_TRANSACTIONS bigint(21) NO NULL
DENIED_CONNECTIONS bigint(21) NO NULL
LOST_CONNECTIONS bigint(21) NO NULL
ACCESS_DENIED bigint(21) NO NULL
EMPTY_QUERIES bigint(21) NO NULL
TOTAL_SSL_CONNECTIONS bigint(21) unsigned NO NULL
MAX_STATEMENT_TIME_EXCEEDED bigint(21) NO NULL
▶ INNODB_TRX 22 fields
Field Name Type Null Key Default Extra
trx_id bigint(21) unsigned NO NULL
trx_state varchar(13) NO NULL
trx_started datetime NO NULL
trx_requested_lock_id varchar(81) YES NULL
trx_wait_started datetime YES NULL
trx_weight bigint(21) unsigned NO NULL
trx_mysql_thread_id bigint(21) unsigned NO NULL
trx_query varchar(1024) YES NULL
trx_operation_state varchar(64) YES NULL
trx_tables_in_use bigint(21) unsigned NO NULL
trx_tables_locked bigint(21) unsigned NO NULL
trx_lock_structs bigint(21) unsigned NO NULL
trx_lock_memory_bytes bigint(21) unsigned NO NULL
trx_rows_locked bigint(21) unsigned NO NULL
trx_rows_modified bigint(21) unsigned NO NULL
trx_concurrency_tickets bigint(21) unsigned NO NULL
trx_isolation_level enum('READ UNCOMMITTED','READ COMMITTED','REPEATABLE READ','SERIALIZABLE') NO NULL
trx_unique_checks int(1) NO NULL
trx_foreign_key_checks int(1) NO NULL
trx_last_foreign_key_error varchar(256) YES NULL
trx_is_read_only int(1) NO NULL
trx_autocommit_non_locking int(1) NO NULL
▶ INNODB_CMP_PER_INDEX 8 fields
Field Name Type Null Key Default Extra
database_name varchar(64) NO NULL
table_name varchar(64) NO NULL
index_name varchar(64) NO NULL
compress_ops int(11) NO NULL
compress_ops_ok int(11) NO NULL
compress_time int(11) NO NULL
uncompress_ops int(11) NO NULL
uncompress_time int(11) NO NULL
▶ INNODB_METRICS 17 fields
Field Name Type Null Key Default Extra
NAME varchar(193) NO NULL
SUBSYSTEM varchar(193) NO NULL
COUNT bigint(21) NO NULL
MAX_COUNT bigint(21) YES NULL
MIN_COUNT bigint(21) YES NULL
AVG_COUNT float YES NULL
COUNT_RESET bigint(21) NO NULL
MAX_COUNT_RESET bigint(21) YES NULL
MIN_COUNT_RESET bigint(21) YES NULL
AVG_COUNT_RESET float YES NULL
TIME_ENABLED datetime YES NULL
TIME_DISABLED datetime YES NULL
TIME_ELAPSED bigint(21) YES NULL
TIME_RESET datetime YES NULL
ENABLED int(1) NO NULL
TYPE enum('value','status_counter','set_owner','set_member','counter') NO NULL
COMMENT varchar(193) NO NULL
▶ INNODB_FT_DELETED 1 fields
Field Name Type Null Key Default Extra
DOC_ID bigint(21) unsigned NO NULL
▶ INNODB_CMP 6 fields
Field Name Type Null Key Default Extra
page_size int(5) NO NULL
compress_ops int(11) NO NULL
compress_ops_ok int(11) NO NULL
compress_time int(11) NO NULL
uncompress_ops int(11) NO NULL
uncompress_time int(11) NO NULL
▶ THREAD_POOL_WAITS 2 fields
Field Name Type Null Key Default Extra
REASON varchar(16) NO NULL
COUNT bigint(19) NO NULL
▶ INNODB_CMP_RESET 6 fields
Field Name Type Null Key Default Extra
page_size int(5) NO NULL
compress_ops int(11) NO NULL
compress_ops_ok int(11) NO NULL
compress_time int(11) NO NULL
uncompress_ops int(11) NO NULL
uncompress_time int(11) NO NULL
▶ THREAD_POOL_QUEUES 5 fields
Field Name Type Null Key Default Extra
GROUP_ID int(6) NO NULL
POSITION int(6) NO NULL
PRIORITY int(1) NO NULL
CONNECTION_ID bigint(19) unsigned YES NULL
QUEUEING_TIME_MICROSECONDS bigint(19) NO NULL
▶ TABLE_STATISTICS 5 fields
Field Name Type Null Key Default Extra
TABLE_SCHEMA varchar(192) NO NULL
TABLE_NAME varchar(192) NO NULL
ROWS_READ bigint(21) NO NULL
ROWS_CHANGED bigint(21) NO NULL
ROWS_CHANGED_X_INDEXES bigint(21) NO NULL
▶ INNODB_SYS_FIELDS 3 fields
Field Name Type Null Key Default Extra
INDEX_ID bigint(21) unsigned NO NULL
NAME varchar(64) NO NULL
POS int(11) unsigned NO NULL
▶ INNODB_BUFFER_PAGE_LRU 20 fields
Field Name Type Null Key Default Extra
POOL_ID int(11) unsigned NO NULL
LRU_POSITION bigint(21) unsigned NO NULL
SPACE int(11) unsigned NO NULL
PAGE_NUMBER int(11) unsigned NO NULL
PAGE_TYPE varchar(64) YES NULL
FLUSH_TYPE int(11) unsigned NO NULL
FIX_COUNT int(11) unsigned NO NULL
IS_HASHED int(1) NO NULL
NEWEST_MODIFICATION bigint(21) unsigned NO NULL
OLDEST_MODIFICATION bigint(21) unsigned NO NULL
ACCESS_TIME bigint(21) unsigned NO NULL
TABLE_NAME varchar(1024) YES NULL
INDEX_NAME varchar(64) YES NULL
NUMBER_RECORDS bigint(21) unsigned NO NULL
DATA_SIZE bigint(21) unsigned NO NULL
COMPRESSED_SIZE bigint(21) unsigned NO NULL
COMPRESSED int(1) NO NULL
IO_FIX enum('IO_NONE','IO_READ','IO_WRITE') NO NULL
IS_OLD int(1) YES NULL
FREE_PAGE_CLOCK bigint(21) unsigned NO NULL
▶ INNODB_LOCKS 10 fields
Field Name Type Null Key Default Extra
lock_id varchar(81) NO NULL
lock_trx_id bigint(21) unsigned NO NULL
lock_mode enum('S','S,GAP','X','X,GAP','IS','IS,GAP','IX','IX,GAP','AUTO_INC') NO NULL
lock_type enum('RECORD','TABLE') NO NULL
lock_table varchar(1024) NO NULL
lock_index varchar(1024) YES NULL
lock_space int(11) unsigned YES NULL
lock_page int(11) unsigned YES NULL
lock_rec int(11) unsigned YES NULL
lock_data varchar(8192) YES NULL
▶ INNODB_FT_INDEX_TABLE 6 fields
Field Name Type Null Key Default Extra
WORD varchar(337) NO NULL
FIRST_DOC_ID bigint(21) unsigned NO NULL
LAST_DOC_ID bigint(21) unsigned NO NULL
DOC_COUNT bigint(21) unsigned NO NULL
DOC_ID bigint(21) unsigned NO NULL
POSITION bigint(21) unsigned NO NULL
▶ INNODB_CMPMEM 6 fields
Field Name Type Null Key Default Extra
page_size int(5) NO NULL
buffer_pool_instance int(11) NO NULL
pages_used int(11) NO NULL
pages_free int(11) NO NULL
relocation_ops bigint(21) NO NULL
relocation_time int(11) NO NULL
▶ THREAD_POOL_GROUPS 8 fields
Field Name Type Null Key Default Extra
GROUP_ID int(6) NO NULL
CONNECTIONS int(6) NO NULL
THREADS int(6) NO NULL
ACTIVE_THREADS int(6) NO NULL
STANDBY_THREADS int(6) NO NULL
QUEUE_LENGTH int(6) NO NULL
HAS_LISTENER tinyint(1) NO NULL
IS_STALLED tinyint(1) NO NULL
▶ INNODB_CMP_PER_INDEX_RESET 8 fields
Field Name Type Null Key Default Extra
database_name varchar(64) NO NULL
table_name varchar(64) NO NULL
index_name varchar(64) NO NULL
compress_ops int(11) NO NULL
compress_ops_ok int(11) NO NULL
compress_time int(11) NO NULL
uncompress_ops int(11) NO NULL
uncompress_time int(11) NO NULL
▶ INNODB_SYS_FOREIGN_COLS 4 fields
Field Name Type Null Key Default Extra
ID varchar(193) NO NULL
FOR_COL_NAME varchar(64) NO NULL
REF_COL_NAME varchar(64) NO NULL
POS int(11) unsigned NO NULL
▶ INNODB_FT_INDEX_CACHE 6 fields
Field Name Type Null Key Default Extra
WORD varchar(337) NO NULL
FIRST_DOC_ID bigint(21) unsigned NO NULL
LAST_DOC_ID bigint(21) unsigned NO NULL
DOC_COUNT bigint(21) unsigned NO NULL
DOC_ID bigint(21) unsigned NO NULL
POSITION bigint(21) unsigned NO NULL
▶ INNODB_BUFFER_POOL_STATS 32 fields
Field Name Type Null Key Default Extra
POOL_ID int(11) unsigned NO NULL
POOL_SIZE bigint(21) unsigned NO NULL
FREE_BUFFERS bigint(21) unsigned NO NULL
DATABASE_PAGES bigint(21) unsigned NO NULL
OLD_DATABASE_PAGES bigint(21) unsigned NO NULL
MODIFIED_DATABASE_PAGES bigint(21) unsigned NO NULL
PENDING_DECOMPRESS bigint(21) unsigned NO NULL
PENDING_READS bigint(21) unsigned NO NULL
PENDING_FLUSH_LRU bigint(21) unsigned NO NULL
PENDING_FLUSH_LIST bigint(21) unsigned NO NULL
PAGES_MADE_YOUNG bigint(21) unsigned NO NULL
PAGES_NOT_MADE_YOUNG bigint(21) unsigned NO NULL
PAGES_MADE_YOUNG_RATE float NO NULL
PAGES_MADE_NOT_YOUNG_RATE float NO NULL
NUMBER_PAGES_READ bigint(21) unsigned NO NULL
NUMBER_PAGES_CREATED bigint(21) unsigned NO NULL
NUMBER_PAGES_WRITTEN bigint(21) unsigned NO NULL
PAGES_READ_RATE float NO NULL
PAGES_CREATE_RATE float NO NULL
PAGES_WRITTEN_RATE float NO NULL
NUMBER_PAGES_GET bigint(21) unsigned NO NULL
HIT_RATE bigint(21) unsigned NO NULL
YOUNG_MAKE_PER_THOUSAND_GETS bigint(21) unsigned NO NULL
NOT_YOUNG_MAKE_PER_THOUSAND_GETS bigint(21) unsigned NO NULL
NUMBER_PAGES_READ_AHEAD bigint(21) unsigned NO NULL
NUMBER_READ_AHEAD_EVICTED bigint(21) unsigned NO NULL
READ_AHEAD_RATE float NO NULL
READ_AHEAD_EVICTED_RATE float NO NULL
LRU_IO_TOTAL bigint(21) unsigned NO NULL
LRU_IO_CURRENT bigint(21) unsigned NO NULL
UNCOMPRESS_TOTAL bigint(21) unsigned NO NULL
UNCOMPRESS_CURRENT bigint(21) unsigned NO NULL
▶ INNODB_FT_BEING_DELETED 1 fields
Field Name Type Null Key Default Extra
DOC_ID bigint(21) unsigned NO NULL
▶ INNODB_SYS_FOREIGN 5 fields
Field Name Type Null Key Default Extra
ID varchar(193) NO NULL
FOR_NAME varchar(193) NO NULL
REF_NAME varchar(193) NO NULL
N_COLS int(11) unsigned NO NULL
TYPE int(11) unsigned NO NULL
▶ INNODB_CMPMEM_RESET 6 fields
Field Name Type Null Key Default Extra
page_size int(5) NO NULL
buffer_pool_instance int(11) NO NULL
pages_used int(11) NO NULL
pages_free int(11) NO NULL
relocation_ops bigint(21) NO NULL
relocation_time int(11) NO NULL
▶ INNODB_FT_DEFAULT_STOPWORD 1 fields
Field Name Type Null Key Default Extra
value varchar(18) NO NULL
▶ INNODB_SYS_TABLES 8 fields
Field Name Type Null Key Default Extra
TABLE_ID bigint(21) unsigned NO NULL
NAME varchar(655) NO NULL
FLAG int(11) NO NULL
N_COLS int(11) unsigned NO NULL
SPACE int(11) unsigned NO NULL
ROW_FORMAT enum('Redundant','Compact','Compressed','Dynamic') YES NULL
ZIP_PAGE_SIZE int(11) unsigned NO NULL
SPACE_TYPE enum('Single','System') YES NULL
▶ INNODB_SYS_COLUMNS 6 fields
Field Name Type Null Key Default Extra
TABLE_ID bigint(21) unsigned NO NULL
NAME varchar(64) NO NULL
POS bigint(21) unsigned NO NULL
MTYPE int(11) NO NULL
PRTYPE int(11) NO NULL
LEN int(11) NO NULL
▶ INNODB_SYS_TABLESPACES 9 fields
Field Name Type Null Key Default Extra
SPACE int(11) unsigned NO NULL
NAME varchar(655) NO NULL
FLAG int(11) unsigned NO NULL
ROW_FORMAT varchar(22) YES NULL
PAGE_SIZE int(11) unsigned NO NULL
FILENAME varchar(512) NO NULL
FS_BLOCK_SIZE int(11) unsigned NO NULL
FILE_SIZE bigint(21) unsigned NO NULL
ALLOCATED_SIZE bigint(21) unsigned NO NULL
▶ INNODB_SYS_INDEXES 8 fields
Field Name Type Null Key Default Extra
INDEX_ID bigint(21) unsigned NO NULL
NAME varchar(64) NO NULL
TABLE_ID bigint(21) unsigned NO NULL
TYPE int(11) NO NULL
N_FIELDS int(11) NO NULL
PAGE_NO int(11) YES NULL
SPACE int(11) YES NULL
MERGE_THRESHOLD int(11) NO NULL
▶ INNODB_BUFFER_PAGE 20 fields
Field Name Type Null Key Default Extra
POOL_ID int(11) unsigned NO NULL
BLOCK_ID bigint(21) unsigned NO NULL
SPACE int(11) unsigned NO NULL
PAGE_NUMBER int(11) unsigned NO NULL
PAGE_TYPE varchar(64) YES NULL
FLUSH_TYPE int(11) unsigned NO NULL
FIX_COUNT int(11) unsigned NO NULL
IS_HASHED int(1) NO NULL
NEWEST_MODIFICATION bigint(21) unsigned NO NULL
OLDEST_MODIFICATION bigint(21) unsigned NO NULL
ACCESS_TIME bigint(21) unsigned NO NULL
TABLE_NAME varchar(1024) YES NULL
INDEX_NAME varchar(64) YES NULL
NUMBER_RECORDS bigint(21) unsigned NO NULL
DATA_SIZE bigint(21) unsigned NO NULL
COMPRESSED_SIZE bigint(21) unsigned NO NULL
PAGE_STATE enum('NOT_USED','MEMORY','REMOVE_HASH','FILE_PAGE') NO NULL
IO_FIX enum('IO_NONE','IO_READ','IO_WRITE') NO NULL
IS_OLD int(1) NO NULL
FREE_PAGE_CLOCK bigint(21) unsigned NO NULL
▶ INNODB_SYS_VIRTUAL 3 fields
Field Name Type Null Key Default Extra
TABLE_ID bigint(21) unsigned NO NULL
POS int(11) unsigned NO NULL
BASE_POS int(11) unsigned NO NULL
▶ user_variables 4 fields
Field Name Type Null Key Default Extra
VARIABLE_NAME varchar(64) NO NULL
VARIABLE_VALUE varchar(2048) YES NULL
VARIABLE_TYPE varchar(64) NO NULL
CHARACTER_SET_NAME varchar(32) YES NULL
▶ INNODB_TABLESPACES_ENCRYPTION 10 fields
Field Name Type Null Key Default Extra
SPACE int(11) unsigned NO NULL
NAME varchar(655) YES NULL
ENCRYPTION_SCHEME int(11) unsigned NO NULL
KEYSERVER_REQUESTS int(11) unsigned NO NULL
MIN_KEY_VERSION int(11) unsigned NO NULL
CURRENT_KEY_VERSION int(11) unsigned NO NULL
KEY_ROTATION_PAGE_NUMBER bigint(21) unsigned YES NULL
KEY_ROTATION_MAX_PAGE_NUMBER bigint(21) unsigned YES NULL
CURRENT_KEY_ID int(11) unsigned NO NULL
ROTATING_OR_FLUSHING int(1) NO NULL
▶ INNODB_LOCK_WAITS 4 fields
Field Name Type Null Key Default Extra
requesting_trx_id bigint(21) unsigned NO NULL
requested_lock_id varchar(81) NO NULL
blocking_trx_id bigint(21) unsigned NO NULL
blocking_lock_id varchar(81) NO NULL
▶ THREAD_POOL_STATS 11 fields
Field Name Type Null Key Default Extra
GROUP_ID int(6) NO NULL
THREAD_CREATIONS bigint(19) NO NULL
THREAD_CREATIONS_DUE_TO_STALL bigint(19) NO NULL
WAKES bigint(19) NO NULL
WAKES_DUE_TO_STALL bigint(19) NO NULL
THROTTLES bigint(19) NO NULL
STALLS bigint(19) NO NULL
POLLS_BY_LISTENER bigint(19) NO NULL
POLLS_BY_WORKER bigint(19) NO NULL
DEQUEUES_BY_LISTENER bigint(19) NO NULL
DEQUEUES_BY_WORKER bigint(19) NO NULL
▶ oasiscapfin_dealpool 7 tables
▶ ocf_agents 10 fields
Field Name Type Null Key Default Extra
index int(11) NO PRI NULL auto_increment
type varchar(50) NO NULL
territory varchar(150) NO NULL
name varchar(100) NO NULL
startdate date YES NULL
kyc-completed-date date YES NULL
address varchar(255) YES NULL
email varchar(255) YES NULL
contactnumber varchar(255) YES NULL
contactmobile varchar(255) YES NULL
▶ ocf_deals 29 fields
Field Name Type Null Key Default Extra
index int(11) NO PRI NULL auto_increment
type varchar(50) NO NULL
amount decimal(15,2) NO NULL
currency char(3) NO NULL
country varchar(100) NO NULL
notification-date date YES NULL
kyc-completed-date date YES NULL
common-name varchar(255) YES NULL
codename varchar(255) YES NULL
introducer varchar(255) YES NULL
introducer-intermediary varchar(255) YES NULL
client varchar(255) YES NULL
client-contact varchar(255) YES NULL
client-contact-email varchar(255) YES NULL
client-contact-phone varchar(50) YES NULL
ocgteam-leadcontact varchar(255) YES NULL
ocg-leadbanker-1 varchar(255) YES NULL
ocg-leadbanker-2 varchar(255) YES NULL
ocg-leadbanker-3 varchar(255) YES NULL
ocg-executionbanker-1 varchar(255) YES NULL
ocg-executionbanker-2 varchar(255) YES NULL
ocg-executionbanker-3 varchar(255) YES NULL
ocg-supportmanager-1 varchar(255) YES NULL
ocg-supportmanager-2 varchar(255) YES NULL
ocg-supportmanager-3 varchar(255) YES NULL
ocg-supportanalyst-1 varchar(255) YES NULL
ocg-supportanalyst-2 varchar(255) YES NULL
ocg-supportanalyst-3 varchar(255) YES NULL
deal_summary varchar(200) NO NULL
▶ ocf_introducers 9 fields
Field Name Type Null Key Default Extra
index int(11) NO PRI NULL auto_increment
type varchar(50) NO NULL
name varchar(100) NO NULL
startdate date YES NULL
kyc-completed-date date YES NULL
address varchar(255) YES NULL
email varchar(255) YES NULL
contactnumber varchar(255) YES NULL
contactmobile varchar(255) YES NULL
▶ ocf_roles 3 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
dealtype varchar(50) NO NULL
role-percent decimal(11,2) NO NULL
▶ ocf_splits 17 fields
Field Name Type Null Key Default Extra
index int(11) NO PRI NULL auto_increment
deal int(11) NO NULL
introducer varchar(255) YES NULL
client varchar(255) YES NULL
ocgteam-leadcontact decimal(11,2) YES 0.00
ocg-leadbanker-1 decimal(11,2) YES 0.00
ocg-leadbanker-2 decimal(11,2) YES 0.00
ocg-leadbanker-3 decimal(11,2) YES 0.00
ocg-executionbanker-1 decimal(11,2) YES 0.00
ocg-executionbanker-2 decimal(11,2) YES 0.00
ocg-executionbanker-3 decimal(11,2) YES 0.00
ocg-supportmanager-1 decimal(11,2) YES 0.00
ocg-supportmanager-2 decimal(11,2) YES 0.00
ocg-supportmanager-3 decimal(11,2) YES 0.00
ocg-supportanalyst-1 decimal(11,2) YES 0.00
ocg-supportanalyst-2 decimal(11,2) YES 0.00
ocg-supportanalyst-3 decimal(11,2) YES 0.00
▶ ocf_staff 10 fields
Field Name Type Null Key Default Extra
index int(11) NO PRI NULL auto_increment
type varchar(50) NO NULL
name varchar(100) NO NULL
accesslevel int(11) NO 2
startdate date YES NULL
kyc-completed-date date YES NULL
address varchar(255) YES NULL
email varchar(255) YES NULL
contactnumber varchar(255) YES NULL
contactmobile varchar(255) YES NULL
▶ ocf_types 3 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
dealtype varchar(50) NO NULL
dealdetail varchar(255) NO NULL
▶ oasiscapfin_investor_db 13 tables
▶ auth_activity_log 9 fields
Field Name Type Null Key Default Extra
log_id bigint(20) NO PRI NULL auto_increment
user_id int(11) YES MUL NULL
action varchar(100) NO MUL NULL
entity_type varchar(50) YES MUL NULL
entity_id int(11) YES NULL
description text YES NULL
ip_address varchar(45) YES NULL
user_agent text YES NULL
created_at timestamp NO MUL current_timestamp()
▶ auth_login_attempts 6 fields
Field Name Type Null Key Default Extra
attempt_id bigint(20) NO PRI NULL auto_increment
username varchar(50) NO MUL NULL
ip_address varchar(45) YES MUL NULL
success tinyint(1) NO NULL
failure_reason varchar(100) YES NULL
created_at timestamp NO MUL current_timestamp()
▶ auth_sessions 7 fields
Field Name Type Null Key Default Extra
session_id int(11) NO PRI NULL auto_increment
user_id int(11) NO MUL NULL
session_token varchar(64) NO UNI NULL
ip_address varchar(45) YES NULL
user_agent text YES NULL
expires_at timestamp NO MUL current_timestamp() on update current_timestamp()
created_at timestamp NO current_timestamp()
▶ auth_user_activity_summary 9 fields
Field Name Type Null Key Default Extra
user_id int(11) NO 0
username varchar(50) NO NULL
first_name varchar(100) NO NULL
last_name varchar(100) NO NULL
role enum('Admin','Manager','User','Viewer') YES User
last_login timestamp YES NULL
total_actions bigint(21) NO 0
actions_last_7_days bigint(21) NO 0
actions_last_30_days bigint(21) NO 0
▶ auth_users 22 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL auto_increment
username varchar(50) NO UNI NULL
email varchar(150) NO UNI NULL
password_hash varchar(255) NO NULL
first_name varchar(100) NO NULL
last_name varchar(100) NO NULL
phone varchar(20) YES NULL
role enum('Admin','Manager','User','Viewer') YES MUL User
staff_id int(11) YES MUL NULL
status enum('Active','Inactive','Suspended','Locked') YES MUL Active
email_verified tinyint(1) YES 0
failed_login_attempts int(11) YES 0
last_failed_login timestamp YES NULL
last_login timestamp YES NULL
last_password_change timestamp NO current_timestamp()
password_reset_token varchar(64) YES NULL
password_reset_expires timestamp YES NULL
remember_token varchar(64) YES NULL
created_at timestamp NO current_timestamp()
created_by int(11) YES NULL
updated_at timestamp NO current_timestamp() on update current_timestamp()
updated_by int(11) YES NULL
▶ clients 46 fields
Field Name Type Null Key Default Extra
client_id int(11) NO PRI NULL auto_increment
first_name varchar(100) NO NULL
last_name varchar(100) NO MUL NULL
email varchar(150) NO UNI NULL
phone varchar(20) YES NULL
mobile varchar(20) YES NULL
address_line1 varchar(200) YES NULL
address_line2 varchar(200) YES NULL
city varchar(100) YES NULL
state_province varchar(100) YES NULL
postal_code varchar(20) YES NULL
country varchar(100) YES NULL
kyc_status enum('Pending','In Progress','Completed','Expired') YES MUL Pending
kyc_completion_date date YES NULL
kyc_expiry_date date YES NULL
id_type varchar(50) YES NULL
id_number varchar(100) YES NULL
id_expiry_date date YES NULL
tax_id varchar(50) YES NULL
pep_status enum('Yes','No','Unknown') YES Unknown
risk_rating enum('Low','Medium','High') YES Medium
date_of_birth date YES NULL
age int(11) YES NULL
nationality varchar(100) YES NULL
occupation varchar(150) YES NULL
investor_profile text YES NULL
annual_income decimal(15,2) YES NULL
income_currency varchar(10) YES USD
source_of_income text YES NULL
total_net_worth decimal(15,2) YES NULL
net_worth_currency varchar(10) YES USD
liquid_assets decimal(15,2) YES NULL
current_investments text YES NULL
investment_experience enum('None','Limited','Moderate','Extensive') YES None
investment_interests text YES MUL NULL
investment_objectives text YES NULL
risk_tolerance enum('Conservative','Moderate','Aggressive') YES Moderate
investment_horizon enum('Short-term','Medium-term','Long-term') YES Medium-term
notes text YES NULL
client_status enum('Prospect','Active','Inactive','Closed') YES MUL Prospect
assigned_staff_id int(11) YES MUL NULL
introducer_id int(11) YES MUL NULL
owner_staff_id int(11) YES MUL NULL
created_at timestamp NO current_timestamp()
updated_at timestamp NO current_timestamp() on update current_timestamp()
last_contact_date timestamp YES NULL
▶ contact_records 11 fields
Field Name Type Null Key Default Extra
contact_id int(11) NO PRI NULL auto_increment
client_id int(11) NO MUL NULL
staff_id int(11) NO MUL NULL
contact_date timestamp NO MUL current_timestamp()
contact_type enum('Newsletter','Phone Call','Visit','Email','Video Conference','Other') NO MUL NULL
subject varchar(200) YES NULL
description text YES NULL
outcome text YES NULL
follow_up_required tinyint(1) YES 0
follow_up_date date YES NULL
created_at timestamp NO current_timestamp()
▶ import_logs 14 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
import_id varchar(50) NO UNI NULL
file_name varchar(255) NO NULL
file_path varchar(500) YES NULL
total_rows int(11) YES 0
imported int(11) YES 0
updated int(11) YES 0
skipped int(11) YES 0
errors_count int(11) YES 0
error_log_path varchar(500) YES NULL
status enum('pending','processing','completed','failed') YES pending
started_at datetime YES current_timestamp()
completed_at datetime YES NULL
mapping_data text YES NULL
▶ introducers 35 fields
Field Name Type Null Key Default Extra
introducer_id int(11) NO PRI NULL auto_increment
company_name varchar(200) YES MUL NULL
contact_person varchar(150) NO NULL
first_name varchar(100) YES NULL
last_name varchar(100) YES NULL
email varchar(150) NO UNI NULL
phone varchar(20) YES NULL
mobile varchar(20) YES NULL
address_line1 varchar(200) YES NULL
address_line2 varchar(200) YES NULL
city varchar(100) YES NULL
state_province varchar(100) YES NULL
postal_code varchar(20) YES NULL
country varchar(100) YES NULL
website varchar(200) YES NULL
kyc_status enum('Pending','In Progress','Completed','Expired') YES MUL Pending
kyc_completion_date date YES NULL
kyc_expiry_date date YES NULL
business_registration_number varchar(100) YES NULL
tax_id varchar(50) YES NULL
regulatory_license varchar(100) YES NULL
license_expiry_date date YES NULL
pep_status enum('Yes','No','Unknown') YES Unknown
risk_rating enum('Low','Medium','High') YES Medium
business_type varchar(100) YES NULL
years_in_business int(11) YES NULL
number_of_clients int(11) YES NULL
commission_rate decimal(5,2) YES NULL
commission_structure text YES NULL
notes text YES NULL
introducer_status enum('Active','Inactive','Suspended') YES MUL Active
assigned_staff_id int(11) YES MUL NULL
created_at timestamp NO current_timestamp()
updated_at timestamp NO current_timestamp() on update current_timestamp()
last_contact_date timestamp YES NULL
▶ login_attempts 6 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
username varchar(50) NO MUL NULL
ip_address varchar(45) NO MUL NULL
user_agent varchar(255) YES NULL
success tinyint(1) YES 0
attempted_at timestamp NO MUL current_timestamp()
▶ staff 10 fields
Field Name Type Null Key Default Extra
staff_id int(11) NO PRI NULL auto_increment
first_name varchar(100) NO NULL
last_name varchar(100) NO MUL NULL
email varchar(150) NO UNI NULL
phone varchar(20) YES NULL
department varchar(100) YES NULL
position varchar(100) YES NULL
active tinyint(1) YES MUL 1
created_at timestamp NO current_timestamp()
updated_at timestamp NO current_timestamp() on update current_timestamp()
▶ user_sessions 6 fields
Field Name Type Null Key Default Extra
session_id varchar(128) NO PRI NULL
user_id int(11) NO MUL NULL
ip_address varchar(45) NO NULL
user_agent varchar(255) YES NULL
last_activity datetime NO MUL NULL
created_at datetime YES current_timestamp()
▶ users 14 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL auto_increment
username varchar(50) NO UNI NULL
email varchar(150) NO UNI NULL
password_hash varchar(255) NO NULL
full_name varchar(150) YES NULL
role enum('admin','manager','user') YES MUL user
active tinyint(1) YES MUL 1
last_login datetime YES NULL
last_login_ip varchar(45) YES NULL
failed_login_attempts int(11) YES 0
locked_until datetime YES NULL
created_at timestamp NO current_timestamp()
updated_at timestamp NO current_timestamp() on update current_timestamp()
created_by int(11) YES NULL
▶ oasiscapfin_newsite 130 tables
▶ ocfns_action_log_config 7 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
type_title varchar(255) NO
type_alias varchar(255) NO
id_holder varchar(255) YES NULL
title_holder varchar(255) YES NULL
table_name varchar(255) YES NULL
text_prefix varchar(255) YES NULL
▶ ocfns_action_logs 8 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
message_language_key varchar(255) NO
message text NO NULL
log_date datetime NO NULL
extension varchar(50) NO MUL
user_id int(11) NO MUL 0
item_id int(11) NO 0
ip_address varchar(40) NO 0.0.0.0
▶ ocfns_action_logs_extensions 2 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
extension varchar(255) NO
▶ ocfns_action_logs_users 3 fields
Field Name Type Null Key Default Extra
user_id int(10) unsigned NO PRI NULL
notify tinyint(3) unsigned NO MUL NULL
extensions text NO NULL
▶ ocfns_acym_action 5 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
condition_id int(11) NO MUL NULL
actions longtext YES NULL
filters longtext YES NULL
order int(11) NO NULL
▶ ocfns_acym_automation 7 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
description longtext YES NULL
active tinyint(4) NO 0
report mediumtext YES NULL
tree longtext YES NULL
admin tinyint(4) YES NULL
▶ ocfns_acym_campaign 12 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
sending_date datetime YES NULL
draft tinyint(1) YES NULL
active tinyint(1) NO 1
mail_id int(11) YES MUL NULL
sent tinyint(1) NO 0
sending_type varchar(16) YES NULL
sending_params text YES NULL
parent_id int(11) YES NULL
last_generated int(11) YES NULL
next_trigger int(11) YES NULL
visible tinyint(1) NO 1
▶ ocfns_acym_condition 3 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
step_id int(11) NO MUL NULL
conditions longtext YES NULL
▶ ocfns_acym_configuration 2 fields
Field Name Type Null Key Default Extra
name varchar(190) NO PRI NULL
value mediumtext NO NULL
▶ ocfns_acym_custom_zone 4 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
content mediumtext NO NULL
image varchar(255) YES NULL
▶ ocfns_acym_field 16 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
type varchar(255) NO NULL
value longtext YES NULL
active tinyint(4) NO NULL
default_value longtext YES NULL
required tinyint(4) YES NULL
ordering int(11) NO NULL
option longtext YES NULL
core tinyint(4) YES NULL
backend_edition tinyint(4) YES NULL
backend_listing tinyint(4) YES NULL
frontend_edition tinyint(4) YES NULL
frontend_listing tinyint(4) YES NULL
namekey varchar(255) NO NULL
translation longtext YES NULL
▶ ocfns_acym_followup 13 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
display_name varchar(255) NO NULL
creation_date datetime NO NULL
trigger varchar(50) YES NULL
condition longtext YES NULL
active tinyint(1) NO 1
send_once tinyint(1) NO 1
list_id int(11) YES MUL NULL
last_trigger int(11) YES NULL
loop tinyint(1) NO 0
loop_delay int(11) YES NULL
loop_mail_skip varchar(255) YES NULL
▶ ocfns_acym_followup_has_mail 4 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
followup_id int(11) NO PRI NULL
delay int(11) NO NULL
delay_unit int(11) NO NULL
▶ ocfns_acym_form 8 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
creation_date datetime NO NULL
active tinyint(1) NO 1
type varchar(20) NO NULL
pages mediumtext YES NULL
settings mediumtext YES NULL
display_languages varchar(255) YES NULL
▶ ocfns_acym_history 8 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
date int(11) NO PRI NULL
ip varchar(50) YES NULL
action varchar(50) NO NULL
data mediumtext YES NULL
source mediumtext YES NULL
mail_id mediumint(9) YES NULL
unsubscribe_reason mediumtext YES NULL
▶ ocfns_acym_list 20 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
display_name varchar(255) YES NULL
active tinyint(1) NO 1
visible tinyint(1) NO 1
clean tinyint(1) YES NULL
color varchar(30) YES NULL
creation_date datetime YES NULL
welcome_id int(11) YES MUL NULL
unsubscribe_id int(11) YES MUL NULL
cms_user_id int(11) NO NULL
access varchar(50) NO
description mediumtext NO NULL
tracking tinyint(1) NO 1
type varchar(20) NO standard
translation longtext YES NULL
subscribers int(11) YES 0
unsubscribed_users int(11) YES 0
new_sub int(11) YES 0
new_unsub int(11) YES 0
▶ ocfns_acym_mail 28 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
creation_date datetime NO NULL
thumbnail longtext YES NULL
drag_editor tinyint(1) YES NULL
type varchar(30) NO MUL NULL
body longtext NO NULL
subject varchar(255) YES NULL
from_name varchar(100) YES NULL
from_email varchar(100) YES NULL
reply_to_name varchar(100) YES NULL
reply_to_email varchar(100) YES NULL
bcc varchar(255) YES NULL
settings mediumtext YES NULL
stylesheet mediumtext YES NULL
attachments mediumtext YES NULL
creator_id int(11) NO NULL
mail_settings mediumtext YES NULL
headers mediumtext YES NULL
autosave longtext YES NULL
preheader mediumtext YES NULL
links_language varchar(20) NO
access varchar(50) NO
tracking tinyint(1) NO 1
language varchar(20) NO
parent_id int(11) YES MUL NULL
translation mediumtext YES NULL
bounce_email varchar(100) YES NULL
▶ ocfns_acym_mail_archive 8 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
mail_id int(11) NO MUL NULL
date int(10) unsigned NO NULL
body longtext NO NULL
subject varchar(255) YES NULL
settings mediumtext YES NULL
stylesheet mediumtext YES NULL
attachments mediumtext YES NULL
▶ ocfns_acym_mail_has_list 2 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
list_id int(11) NO PRI NULL
▶ ocfns_acym_mail_override 7 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
mail_id int(11) NO MUL NULL
description varchar(255) NO NULL
source varchar(20) NO NULL
active tinyint(1) NO 1
base_subject mediumtext NO NULL
base_body mediumtext NO NULL
▶ ocfns_acym_mail_stat 14 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
total_subscribers int(11) NO 0
sent int(11) YES 0
send_date datetime YES NULL
fail int(11) YES 0
open_unique int(11) NO 0
open_total int(11) NO 0
bounce_unique mediumint(9) NO 0
bounce_details longtext YES NULL
unsubscribe_total int(11) NO 0
tracking_sale float YES NULL
currency varchar(5) YES NULL
click_unique int(11) NO 0
click_total int(11) NO 0
▶ ocfns_acym_mailbox_action 19 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
name varchar(255) YES MUL NULL
frequency int(10) unsigned NO 0
nextdate int(10) unsigned NO 0
description text YES NULL
server varchar(255) YES NULL
port varchar(50) YES NULL
connection_method enum('imap','pop3','pear') YES NULL
secure_method enum('ssl','tls') YES NULL
self_signed tinyint(4) YES NULL
username varchar(255) YES NULL
password varchar(50) YES NULL
conditions text YES NULL
actions text YES NULL
report text YES NULL
delete_wrong_emails tinyint(4) NO 0
senderfrom tinyint(4) NO 0
senderto tinyint(4) NO 0
active tinyint(4) NO 0
▶ ocfns_acym_plugin 12 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
title varchar(100) NO NULL
folder_name varchar(100) NO NULL
version varchar(10) YES NULL
active int(11) NO NULL
category varchar(100) NO NULL
level varchar(50) NO NULL
uptodate int(11) NO NULL
description longtext NO NULL
latest_version varchar(10) NO NULL
settings longtext YES NULL
type varchar(20) NO ADDON
▶ ocfns_acym_queue 6 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
user_id int(11) NO PRI NULL
sending_date datetime NO NULL
priority int(11) NO 2
try tinyint(4) NO 0
params text YES NULL
▶ ocfns_acym_rule 11 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(250) NO NULL
ordering smallint(6) YES NULL
regex mediumtext NO NULL
executed_on mediumtext NO NULL
action_message mediumtext NO NULL
action_user mediumtext NO NULL
active tinyint(4) NO NULL
increment_stats tinyint(4) NO NULL
execute_action_after int(11) NO NULL
description varchar(250) YES NULL
▶ ocfns_acym_scenario 6 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
trigger varchar(255) NO NULL
name varchar(255) NO NULL
active tinyint(1) NO 0
trigger_params text YES NULL
trigger_once tinyint(1) NO 0
▶ ocfns_acym_segment 5 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
creation_date datetime NO NULL
active tinyint(1) NO 1
filters longtext YES NULL
▶ ocfns_acym_step 6 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
triggers longtext YES NULL
automation_id int(11) NO MUL NULL
last_execution int(11) YES NULL
next_execution int(11) YES NULL
▶ ocfns_acym_tag 3 fields
Field Name Type Null Key Default Extra
name varchar(50) NO PRI NULL
type varchar(20) NO PRI NULL
id_element int(11) NO PRI NULL
▶ ocfns_acym_url 3 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name longtext YES NULL
url longtext NO NULL
▶ ocfns_acym_url_click 5 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
url_id int(11) NO PRI NULL
user_id int(11) NO PRI NULL
click int(11) NO 0
date_click datetime YES NULL
▶ ocfns_acym_user 17 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) YES NULL
email varchar(255) NO UNI NULL
creation_date datetime NO NULL
active tinyint(1) NO 1
cms_id int(11) NO MUL 0
source varchar(255) YES NULL
confirmed tinyint(1) NO 0
key varchar(40) YES NULL
automation varchar(50) NO
confirmation_date datetime YES NULL
confirmation_ip varchar(50) YES NULL
tracking tinyint(1) NO 1
language varchar(20) NO
last_sent_date datetime YES NULL
last_open_date datetime YES NULL
last_click_date datetime YES NULL
▶ ocfns_acym_user_has_field 3 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
field_id int(11) NO PRI NULL
value longtext YES NULL
▶ ocfns_acym_user_has_list 5 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
list_id int(11) NO PRI NULL
status tinyint(1) NO NULL
subscription_date datetime NO MUL NULL
unsubscribe_date datetime YES MUL NULL
▶ ocfns_acym_user_stat 14 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
mail_id int(11) NO PRI NULL
send_date datetime YES NULL
fail int(11) NO 0
sent int(11) NO 0
open int(11) NO 0
open_date datetime YES NULL
bounce tinyint(4) NO 0
bounce_rule varchar(255) YES NULL
tracking_sale float YES NULL
currency varchar(10) YES NULL
unsubscribe int(11) NO 0
device varchar(50) YES NULL
opened_with varchar(50) YES NULL
▶ ocfns_assets 8 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
parent_id int(11) NO MUL 0
lft int(11) NO MUL 0
rgt int(11) NO 0
level int(10) unsigned NO NULL
name varchar(50) NO UNI NULL
title varchar(100) NO NULL
rules varchar(5120) NO NULL
▶ ocfns_associations 3 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL
context varchar(50) NO PRI NULL
key char(32) NO MUL NULL
▶ ocfns_banner_clients 14 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO
contact varchar(255) NO
email varchar(255) NO
extrainfo mediumtext NO NULL
state tinyint(4) NO 0
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
metakey text YES NULL
own_prefix tinyint(4) NO MUL 0
metakey_prefix varchar(255) NO MUL
purchase_type tinyint(4) NO -1
track_clicks tinyint(4) NO -1
track_impressions tinyint(4) NO -1
▶ ocfns_banner_tracks 4 fields
Field Name Type Null Key Default Extra
track_date datetime NO PRI NULL
track_type int(10) unsigned NO PRI NULL
banner_id int(10) unsigned NO PRI NULL
count int(10) unsigned NO 0
▶ ocfns_banners 34 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
cid int(11) NO 0
type int(11) NO 0
name varchar(255) NO
alias varchar(400) NO
imptotal int(11) NO 0
impmade int(11) NO 0
clicks int(11) NO 0
clickurl varchar(2048) NO
state tinyint(4) NO MUL 0
catid int(10) unsigned NO MUL 0
description mediumtext NO NULL
custombannercode varchar(2048) NO NULL
sticky tinyint(3) unsigned NO 0
ordering int(11) NO 0
metakey text YES NULL
params mediumtext NO NULL
own_prefix tinyint(1) NO MUL 0
metakey_prefix varchar(400) NO MUL
purchase_type tinyint(4) NO -1
track_clicks tinyint(4) NO -1
track_impressions tinyint(4) NO -1
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
reset datetime YES NULL
created datetime NO NULL
language char(7) NO MUL
created_by int(10) unsigned NO 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
version int(10) unsigned NO 1
▶ ocfns_categories 27 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
parent_id int(10) unsigned NO 0
lft int(11) NO MUL 0
rgt int(11) NO 0
level int(10) unsigned NO 0
path varchar(400) NO MUL
extension varchar(50) NO MUL
title varchar(255) NO
alias varchar(400) NO MUL
note varchar(255) NO
description longtext YES NULL
published tinyint(1) NO 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
access int(10) unsigned NO MUL 0
params mediumtext YES NULL
metadesc varchar(1024) NO
metakey varchar(1024) NO
metadata varchar(2048) NO
created_user_id int(10) unsigned NO 0
created_time datetime NO NULL
modified_user_id int(10) unsigned NO 0
modified_time datetime NO NULL
hits int(10) unsigned NO 0
language char(7) NO MUL
version int(10) unsigned NO 1
▶ ocfns_contact_details 42 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
alias varchar(400) NO
con_position varchar(255) YES NULL
address mediumtext YES NULL
suburb varchar(100) YES NULL
state varchar(100) YES NULL
country varchar(100) YES NULL
postcode varchar(100) YES NULL
telephone varchar(255) YES NULL
fax varchar(255) YES NULL
misc longtext YES NULL
image varchar(255) YES NULL
email_to varchar(255) YES NULL
default_con tinyint(3) unsigned NO 0
published tinyint(1) NO MUL 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
ordering int(11) NO 0
params mediumtext NO NULL
user_id int(11) NO 0
catid int(11) NO MUL 0
access int(10) unsigned NO MUL 0
mobile varchar(255) NO
webpage varchar(255) NO
sortname1 varchar(255) NO
sortname2 varchar(255) NO
sortname3 varchar(255) NO
language varchar(7) NO MUL NULL
created datetime NO NULL
created_by int(10) unsigned NO MUL 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
metakey text YES NULL
metadesc mediumtext NO NULL
metadata mediumtext NO NULL
featured tinyint(3) unsigned NO MUL 0
publish_up datetime YES NULL
publish_down datetime YES NULL
version int(10) unsigned NO 1
hits int(10) unsigned NO 0
▶ ocfns_content 30 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
title varchar(255) NO
alias varchar(400) NO MUL
introtext longtext NO NULL
fulltext longtext NO NULL
state tinyint(4) NO MUL 0
catid int(10) unsigned NO MUL 0
created datetime NO NULL
created_by int(10) unsigned NO MUL 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
images mediumtext NO NULL
urls mediumtext NO NULL
attribs varchar(5120) NO NULL
version int(10) unsigned NO 1
ordering int(11) NO 0
metakey text YES NULL
metadesc mediumtext NO NULL
access int(10) unsigned NO MUL 0
hits int(10) unsigned NO 0
metadata mediumtext NO NULL
featured tinyint(3) unsigned NO MUL 0
language char(7) NO MUL NULL
note varchar(255) NO
▶ ocfns_content_frontpage 4 fields
Field Name Type Null Key Default Extra
content_id int(11) NO PRI 0
ordering int(11) NO 0
featured_up datetime YES NULL
featured_down datetime YES NULL
▶ ocfns_content_rating 4 fields
Field Name Type Null Key Default Extra
content_id int(11) NO PRI 0
rating_sum int(10) unsigned NO 0
rating_count int(10) unsigned NO 0
lastip varchar(50) NO
▶ ocfns_content_types 8 fields
Field Name Type Null Key Default Extra
type_id int(10) unsigned NO PRI NULL auto_increment
type_title varchar(255) NO
type_alias varchar(400) NO MUL
table varchar(2048) NO
rules mediumtext NO NULL
field_mappings mediumtext NO NULL
router varchar(255) NO
content_history_options varchar(5120) YES NULL
▶ ocfns_contentitem_tag_map 6 fields
Field Name Type Null Key Default Extra
type_alias varchar(255) NO
core_content_id int(10) unsigned NO MUL NULL
content_item_id int(11) NO PRI NULL
tag_id int(10) unsigned NO PRI NULL
tag_date timestamp NO MUL current_timestamp() on update current_timestamp()
type_id mediumint(9) NO PRI NULL
▶ ocfns_core_log_searches 2 fields
Field Name Type Null Key Default Extra
search_term varchar(128) NO
hits int(10) unsigned NO 0
▶ ocfns_extensions 20 fields
Field Name Type Null Key Default Extra
extension_id int(11) NO PRI NULL auto_increment
package_id int(11) NO 0
name varchar(100) NO NULL
type varchar(20) NO MUL NULL
element varchar(100) NO MUL NULL
changelogurl text YES NULL
folder varchar(100) NO NULL
client_id tinyint(4) NO NULL
enabled tinyint(4) NO 0
access int(10) unsigned NO 1
protected tinyint(4) NO 0
manifest_cache mediumtext NO NULL
params mediumtext NO NULL
custom_data mediumtext NO NULL
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
ordering int(11) YES 0
state int(11) YES 0
note varchar(255) YES NULL
locked tinyint(4) NO 0
▶ ocfns_fields 25 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
context varchar(255) NO MUL
group_id int(10) unsigned NO 0
title varchar(255) NO
name varchar(255) NO
label varchar(255) NO
default_value mediumtext YES NULL
type varchar(255) NO text
note varchar(255) NO
description text NO NULL
state tinyint(1) NO MUL 0
required tinyint(1) NO 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
ordering int(11) NO 0
params text NO NULL
fieldparams mediumtext NO NULL
language char(7) NO MUL
created_time datetime NO NULL
created_user_id int(10) unsigned NO MUL 0
modified_time datetime NO NULL
modified_by int(10) unsigned NO 0
access int(11) NO MUL 1
only_use_in_subform tinyint(4) NO 0
▶ ocfns_fields_categories 2 fields
Field Name Type Null Key Default Extra
field_id int(11) NO PRI 0
category_id int(11) NO PRI 0
▶ ocfns_fields_groups 17 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
context varchar(255) NO MUL
title varchar(255) NO
note varchar(255) NO
description text NO NULL
state tinyint(1) NO MUL 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
ordering int(11) NO 0
params mediumtext NO NULL
language char(7) NO MUL
created datetime NO NULL
created_by int(10) unsigned NO MUL 0
modified datetime NO NULL
modified_by int(10) unsigned NO 0
access int(11) NO MUL 1
▶ ocfns_fields_values 3 fields
Field Name Type Null Key Default Extra
field_id int(10) unsigned NO MUL NULL
item_id varchar(255) NO MUL NULL
value mediumtext YES NULL
▶ ocfns_finder_filters 14 fields
Field Name Type Null Key Default Extra
filter_id int(10) unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
alias varchar(255) NO NULL
state tinyint(1) NO 1
created datetime NO NULL
created_by int(10) unsigned NO 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
map_count int(10) unsigned NO 0
data mediumtext NO NULL
params longtext YES NULL
▶ ocfns_finder_links 19 fields
Field Name Type Null Key Default Extra
link_id int(10) unsigned NO PRI NULL auto_increment
url varchar(255) NO MUL NULL
route varchar(400) YES NULL
title varchar(400) YES MUL NULL
description mediumtext YES NULL
indexdate datetime NO NULL
md5sum varchar(32) YES MUL NULL
published tinyint(1) NO MUL 1
state int(11) NO 1
access int(11) NO 0
language char(7) NO MUL
publish_start_date datetime YES NULL
publish_end_date datetime YES NULL
start_date datetime YES NULL
end_date datetime YES NULL
list_price double unsigned NO 0
sale_price double unsigned NO 0
type_id int(11) NO MUL NULL
object mediumblob NO NULL
▶ ocfns_finder_links_terms 3 fields
Field Name Type Null Key Default Extra
link_id int(10) unsigned NO PRI NULL
term_id int(10) unsigned NO PRI NULL
weight float unsigned NO 0
▶ ocfns_finder_logging 5 fields
Field Name Type Null Key Default Extra
searchterm varchar(255) NO MUL
md5sum varchar(32) NO PRI
query blob NO NULL
hits int(11) NO 1
results int(11) NO 0
▶ ocfns_finder_taxonomy 11 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
parent_id int(10) unsigned NO MUL 0
lft int(11) NO MUL 0
rgt int(11) NO 0
level int(10) unsigned NO MUL 0
path varchar(400) NO MUL
title varchar(255) NO
alias varchar(400) NO MUL
state tinyint(3) unsigned NO MUL 1
access tinyint(3) unsigned NO MUL 1
language char(7) NO MUL
▶ ocfns_finder_taxonomy_map 2 fields
Field Name Type Null Key Default Extra
link_id int(10) unsigned NO PRI NULL
node_id int(10) unsigned NO PRI NULL
▶ ocfns_finder_terms 9 fields
Field Name Type Null Key Default Extra
term_id int(10) unsigned NO PRI NULL auto_increment
term varchar(75) NO MUL NULL
stem varchar(75) NO MUL
common tinyint(3) unsigned NO 0
phrase tinyint(3) unsigned NO 0
weight float unsigned NO 0
soundex varchar(75) NO MUL
links int(11) NO 0
language char(7) NO MUL
▶ ocfns_finder_terms_common 3 fields
Field Name Type Null Key Default Extra
term varchar(75) NO PRI
language char(7) NO PRI
custom int(11) NO 0
▶ ocfns_finder_tokens 7 fields
Field Name Type Null Key Default Extra
term varchar(75) NO MUL NULL
stem varchar(75) NO MUL
common tinyint(3) unsigned NO 0
phrase tinyint(3) unsigned NO 0
weight float unsigned NO 1
context tinyint(3) unsigned NO MUL 2
language char(7) NO MUL
▶ ocfns_finder_tokens_aggregate 10 fields
Field Name Type Null Key Default Extra
term_id int(10) unsigned NO MUL NULL
term varchar(75) NO MUL NULL
stem varchar(75) NO
common tinyint(3) unsigned NO 0
phrase tinyint(3) unsigned NO 0
term_weight float unsigned NO 0
context tinyint(3) unsigned NO 2
context_weight float unsigned NO 0
total_weight float unsigned NO 0
language char(7) NO
▶ ocfns_finder_types 3 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
title varchar(100) NO UNI NULL
mime varchar(100) NO
▶ ocfns_guidedtour_steps 20 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
tour_id int(11) NO MUL 0
title varchar(255) NO NULL
published tinyint(4) NO MUL 0
description text NO NULL
ordering int(11) NO 0
position varchar(255) NO NULL
target varchar(255) NO NULL
type int(11) NO NULL
interactive_type int(11) NO 1
url varchar(255) NO NULL
created datetime NO NULL
created_by int(10) unsigned NO 0
modified datetime NO NULL
modified_by int(10) unsigned NO 0
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES NULL
language varchar(7) NO MUL NULL
note varchar(255) NO
params text YES NULL
▶ ocfns_guidedtours 18 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
title varchar(255) NO
uid varchar(255) NO MUL NULL
description text NO NULL
ordering int(11) NO 0
extensions text NO NULL
url varchar(255) NO NULL
created datetime NO NULL
created_by int(11) NO 0
modified datetime NO NULL
modified_by int(11) NO 0
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES NULL
published tinyint(4) NO MUL 0
language varchar(7) NO MUL NULL
note varchar(255) NO
access int(10) unsigned NO MUL 0
autostart int(11) NO 0
▶ ocfns_history 11 fields
Field Name Type Null Key Default Extra
version_id int(10) unsigned NO PRI NULL auto_increment
item_id varchar(50) NO MUL NULL
version_note varchar(255) NO
save_date datetime NO MUL NULL
editor_user_id int(10) unsigned NO 0
character_count int(10) unsigned NO 0
sha1_hash varchar(50) NO
version_data mediumtext NO NULL
keep_forever tinyint(4) NO 0
is_current tinyint(4) NO 0
is_legacy tinyint(4) NO 0
▶ ocfns_languages 14 fields
Field Name Type Null Key Default Extra
lang_id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
lang_code char(7) NO UNI NULL
title varchar(50) NO NULL
title_native varchar(50) NO NULL
sef varchar(50) NO UNI NULL
image varchar(50) NO NULL
description varchar(512) NO NULL
metakey text YES NULL
metadesc mediumtext NO NULL
sitename varchar(1024) NO
published int(11) NO 0
access int(10) unsigned NO MUL 0
ordering int(11) NO MUL 0
▶ ocfns_mail_templates 8 fields
Field Name Type Null Key Default Extra
template_id varchar(127) NO PRI
extension varchar(127) NO
language char(7) NO PRI
subject varchar(255) NO
body text NO NULL
htmlbody mediumtext NO NULL
attachments text NO NULL
params text NO NULL
▶ ocfns_menu 26 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
menutype varchar(24) NO MUL NULL
title varchar(255) NO NULL
alias varchar(400) NO MUL NULL
note varchar(255) NO
path varchar(1024) NO MUL NULL
link varchar(1024) NO NULL
type varchar(16) NO NULL
published tinyint(4) NO 0
parent_id int(10) unsigned NO 1
level int(10) unsigned NO 0
component_id int(10) unsigned NO MUL 0
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
browserNav tinyint(4) NO 0
access int(10) unsigned NO 0
img varchar(255) NO NULL
template_style_id int(10) unsigned NO 0
params mediumtext NO NULL
lft int(11) NO MUL 0
rgt int(11) NO 0
home tinyint(3) unsigned NO 0
language char(7) NO MUL
client_id tinyint(4) NO MUL 0
publish_up datetime YES NULL
publish_down datetime YES NULL
▶ ocfns_menu_types 7 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
menutype varchar(24) NO UNI NULL
title varchar(48) NO NULL
description varchar(255) NO
client_id int(11) NO 0
ordering int(11) NO 0
▶ ocfns_messages 9 fields
Field Name Type Null Key Default Extra
message_id int(10) unsigned NO PRI NULL auto_increment
user_id_from int(10) unsigned NO 0
user_id_to int(10) unsigned NO MUL 0
folder_id tinyint(3) unsigned NO 0
date_time datetime NO NULL
state tinyint(1) NO 0
priority tinyint(3) unsigned NO 0
subject varchar(255) NO
message mediumtext NO NULL
▶ ocfns_messages_cfg 3 fields
Field Name Type Null Key Default Extra
user_id int(10) unsigned NO PRI 0
cfg_name varchar(100) NO PRI
cfg_value varchar(255) NO
▶ ocfns_modules 18 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
title varchar(100) NO
note varchar(255) NO
content text YES NULL
ordering int(11) NO 0
position varchar(50) NO
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
published tinyint(1) NO MUL 0
module varchar(50) YES MUL NULL
access int(10) unsigned NO 0
showtitle tinyint(3) unsigned NO 1
params mediumtext NO NULL
client_id tinyint(4) NO 0
language char(7) NO MUL NULL
▶ ocfns_modules_menu 2 fields
Field Name Type Null Key Default Extra
moduleid int(11) NO PRI 0
menuid int(11) NO PRI 0
▶ ocfns_newsfeeds 29 fields
Field Name Type Null Key Default Extra
catid int(11) NO MUL 0
id int(10) unsigned NO PRI NULL auto_increment
name varchar(100) NO
alias varchar(400) NO
link varchar(2048) NO NULL
published tinyint(1) NO MUL 0
numarticles int(10) unsigned NO 1
cache_time int(10) unsigned NO 3600
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
ordering int(11) NO 0
rtl tinyint(4) NO 0
access int(10) unsigned NO MUL 0
language char(7) NO MUL
params mediumtext NO NULL
created datetime NO NULL
created_by int(10) unsigned NO MUL 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
metakey text YES NULL
metadesc mediumtext NO NULL
metadata mediumtext NO NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
description mediumtext NO NULL
version int(10) unsigned NO 1
hits int(10) unsigned NO 0
images mediumtext NO NULL
▶ ocfns_overrider 4 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
constant varchar(255) NO NULL
string mediumtext NO NULL
file varchar(255) NO NULL
▶ ocfns_postinstall_messages 14 fields
Field Name Type Null Key Default Extra
postinstall_message_id bigint(20) unsigned NO PRI NULL auto_increment
extension_id bigint(20) NO 700
title_key varchar(255) NO
description_key varchar(255) NO
action_key varchar(255) NO
language_extension varchar(255) NO com_postinstall
language_client_id tinyint(4) NO 1
type varchar(10) NO link
action_file varchar(255) YES
action varchar(255) YES
condition_file varchar(255) YES NULL
condition_method varchar(255) YES NULL
version_introduced varchar(50) NO 3.2.0
enabled tinyint(4) NO 1
▶ ocfns_privacy_consents 8 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
user_id int(10) unsigned NO MUL 0
state int(11) NO 1
created datetime NO NULL
subject varchar(255) NO
body text NO NULL
remind tinyint(4) NO 0
token varchar(100) NO
▶ ocfns_privacy_requests 7 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
email varchar(100) NO
requested_at datetime NO NULL
status tinyint(4) NO 0
request_type varchar(25) NO
confirm_token varchar(100) NO
confirm_token_created_at datetime YES NULL
▶ ocfns_redirect_links 10 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
old_url varchar(2048) NO MUL NULL
new_url varchar(2048) YES NULL
referer varchar(2048) NO NULL
comment varchar(255) NO
hits int(10) unsigned NO 0
published tinyint(4) NO NULL
created_date datetime NO NULL
modified_date datetime NO MUL NULL
header smallint(6) NO 301
▶ ocfns_scheduler_logs 9 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
taskname varchar(255) NO MUL
tasktype varchar(128) NO MUL NULL
duration decimal(5,3) NO NULL
jobid int(10) unsigned NO NULL
taskid int(10) unsigned NO NULL
exitcode int(11) NO NULL
lastdate datetime YES MUL NULL
nextdate datetime YES MUL NULL
▶ ocfns_scheduler_tasks 22 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
title varchar(255) NO
type varchar(128) NO MUL NULL
execution_rules text YES NULL
cron_rules text YES NULL
state tinyint(4) NO MUL 0
last_exit_code int(11) NO MUL 0
last_execution datetime YES NULL
next_execution datetime YES MUL NULL
times_executed int(11) YES 0
times_failed int(11) YES 0
locked datetime YES MUL NULL
priority smallint(6) NO MUL 0
ordering int(11) NO 0
cli_exclusive smallint(6) NO MUL 0
params text NO NULL
note text YES NULL
created datetime NO NULL
created_by int(10) unsigned NO 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
▶ ocfns_schemaorg 5 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
itemId int(10) unsigned YES NULL
context varchar(100) YES NULL
schemaType varchar(100) YES NULL
schema text YES NULL
▶ ocfns_schemas 2 fields
Field Name Type Null Key Default Extra
extension_id int(11) NO NULL
version_id varchar(20) NO NULL
▶ ocfns_session 7 fields
Field Name Type Null Key Default Extra
session_id varbinary(192) NO PRI NULL
client_id tinyint(3) unsigned YES MUL NULL
guest tinyint(3) unsigned YES 1
time int(11) NO MUL 0
data longtext YES NULL
userid int(11) YES MUL 0
username varchar(150) YES
▶ ocfns_spmedia 14 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
title varchar(255) NO
path varchar(255) NO
thumb varchar(255) NO
alt varchar(255) NO
caption varchar(2048) NO
description mediumtext NO NULL
type varchar(100) NO image
media_attr varchar(5120) NO {}
extension varchar(100) NO
created_on datetime NO NULL
created_by bigint(20) NO 0
modified_on datetime NO NULL
modified_by bigint(20) NO 0
▶ ocfns_sppagebuilder 27 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
asset_id int(11) NO 0
title varchar(255) NO
text mediumtext NO NULL
content mediumtext YES NULL
extension varchar(255) NO com_sppagebuilder
extension_view varchar(255) NO page
view_id bigint(20) NO 0
active tinyint(1) NO 0
published tinyint(4) NO 1
catid int(11) NO 0
access int(11) NO 0
ordering int(11) NO 0
created_on datetime NO NULL
created_by bigint(20) NO 0
modified datetime NO NULL
modified_by bigint(20) NO 0
checked_out int(11) NO 0
checked_out_time datetime YES NULL
attribs varchar(5120) NO []
og_title varchar(255) NO
og_image varchar(255) NO
og_description varchar(255) NO
language char(7) NO
hits bigint(20) NO 0
css longtext NO NULL
version varchar(50) NO
▶ ocfns_sppagebuilder_addonlist 5 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
name varchar(255) NO NULL
ordering int(11) NO 0
status tinyint(1) NO 1
is_favorite tinyint(1) NO 0
▶ ocfns_sppagebuilder_addons 6 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
title varchar(255) NO
code mediumtext NO NULL
ordering int(11) NO 0
created datetime NO NULL
created_by bigint(20) NO 0
▶ ocfns_sppagebuilder_assets 10 fields
Field Name Type Null Key Default Extra
id bigint(20) NO PRI NULL auto_increment
type varchar(100) NO
name varchar(100) NO
title varchar(255) NO
assets text NO NULL
css_path text YES NULL
created datetime NO NULL
created_by int(11) NO NULL
published tinyint(1) NO 1
access int(11) NO 0
▶ ocfns_sppagebuilder_collection_fields 24 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
collection_id bigint(20) unsigned NO MUL NULL
name varchar(255) NO
type varchar(255) NO
description text YES NULL
options text YES NULL
max_length int(10) unsigned YES NULL
min_length int(10) unsigned YES NULL
default_value text YES NULL
placeholder varchar(255) YES NULL
required tinyint(4) NO 0
reference_collection_id bigint(20) unsigned YES NULL
is_textarea tinyint(4) NO 0
show_time tinyint(4) NO 0
file_extensions varchar(300) YES NULL
number_format varchar(100) YES NULL
allow_negative tinyint(4) NO 0
number_unit varchar(100) YES NULL
number_step decimal(13,2) YES NULL
ordering int(11) NO 0
created datetime NO NULL
created_by bigint(20) YES NULL
modified datetime NO current_timestamp()
modified_by bigint(20) YES NULL
▶ ocfns_sppagebuilder_collection_imports 5 fields
Field Name Type Null Key Default Extra
id bigint(20) NO PRI NULL auto_increment
data text YES NULL
created datetime NO current_timestamp()
created_by int(11) NO NULL
published tinyint(1) NO 1
▶ ocfns_sppagebuilder_collection_item_values 4 fields
Field Name Type Null Key Default Extra
item_id bigint(20) unsigned NO MUL NULL
field_id bigint(20) unsigned NO MUL NULL
value text YES NULL
reference_item_id bigint(20) unsigned YES MUL NULL
▶ ocfns_sppagebuilder_collection_items 11 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
asset_id bigint(20) unsigned NO 0
collection_id bigint(20) unsigned NO MUL NULL
published tinyint(4) NO 0
access int(10) unsigned NO 0
ordering int(11) NO 0
language char(7) NO *
created datetime NO NULL
created_by bigint(20) YES NULL
modified datetime NO current_timestamp()
modified_by bigint(20) YES NULL
▶ ocfns_sppagebuilder_collections 12 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
asset_id bigint(20) unsigned NO 0
title varchar(255) NO
alias varchar(255) NO
published tinyint(4) NO 1
access int(10) unsigned NO 0
ordering int(11) NO 0
language char(7) NO *
created datetime NO NULL
created_by bigint(20) YES NULL
modified datetime NO current_timestamp()
modified_by bigint(20) YES NULL
▶ ocfns_sppagebuilder_colors 6 fields
Field Name Type Null Key Default Extra
id bigint(20) NO PRI NULL auto_increment
name varchar(100) NO
colors text YES NULL
created datetime NO NULL
created_by int(11) NO NULL
published tinyint(1) NO 1
▶ ocfns_sppagebuilder_comments 15 fields
Field Name Type Null Key Default Extra
id bigint(20) NO PRI NULL auto_increment
source_type varchar(50) NO article
item_id bigint(20) unsigned NO NULL
created_by bigint(20) unsigned YES NULL
parent_id bigint(20) YES NULL
content text NO NULL
replies int(11) NO 0
ordering int(11) NO 0
published tinyint(1) NO 0
access int(10) unsigned NO 0
checked_out int(11) NO 0
checked_out_time datetime YES NULL
language char(7) NO
created_on datetime NO current_timestamp()
modified datetime NO current_timestamp()
▶ ocfns_sppagebuilder_fonts 7 fields
Field Name Type Null Key Default Extra
id bigint(20) NO PRI NULL auto_increment
family_name varchar(100) NO MUL
data text YES NULL
type enum('google','local') YES google
created datetime NO NULL
created_by int(11) NO NULL
published tinyint(1) NO 1
▶ ocfns_sppagebuilder_image_shapes 5 fields
Field Name Type Null Key Default Extra
id bigint(20) NO PRI NULL auto_increment
name varchar(100) NO
shape text YES NULL
created datetime NO NULL
created_by int(11) NO NULL
▶ ocfns_sppagebuilder_integrations 6 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
title varchar(255) NO
description mediumtext NO NULL
component varchar(255) NO
plugin mediumtext NO NULL
state tinyint(1) NO 0
▶ ocfns_sppagebuilder_languages 7 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
title varchar(255) NO
description mediumtext NO NULL
lang_tag varchar(255) NO
lang_key varchar(100) YES NULL
version varchar(255) NO
state tinyint(1) NO 0
▶ ocfns_sppagebuilder_likes 4 fields
Field Name Type Null Key Default Extra
id bigint(20) NO PRI NULL auto_increment
user_id bigint(20) NO NULL
comment_id bigint(20) NO MUL NULL
created datetime NO current_timestamp()
▶ ocfns_sppagebuilder_presets 8 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
title varchar(255) NO
addon_name varchar(255) NO
preset mediumtext NO NULL
is_default tinyint(1) NO 0
ordering int(11) NO 0
created datetime NO NULL
created_by bigint(20) NO 0
▶ ocfns_sppagebuilder_sections 6 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
title varchar(255) NO
section mediumtext NO NULL
ordering int(11) NO 0
created datetime NO NULL
created_by bigint(20) NO 0
▶ ocfns_sppagebuilder_typography 6 fields
Field Name Type Null Key Default Extra
id bigint(20) NO PRI NULL auto_increment
name varchar(100) NO
typography text YES NULL
created datetime NO current_timestamp()
created_by int(11) NO NULL
published tinyint(1) NO 1
▶ ocfns_spsimpleportfolio_items 22 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
alias varchar(55) NO NULL
catid int(11) NO NULL
image text NO NULL
thumbnail text NO NULL
video text NO NULL
description mediumtext YES NULL
client varchar(100) NO NULL
client_avatar text NO NULL
tagids text NO NULL
url text NO NULL
published tinyint(4) NO 1
language varchar(255) NO *
access int(11) NO 1
ordering int(11) NO 0
created_by bigint(20) NO 0
created datetime NO 0000-00-00 00:00:00
modified_by bigint(20) NO 0
modified datetime NO 0000-00-00 00:00:00
checked_out bigint(20) YES NULL
checked_out_time datetime YES NULL
▶ ocfns_spsimpleportfolio_tags 3 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
alias varchar(55) NO NULL
▶ ocfns_tags 30 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
parent_id int(10) unsigned NO 0
lft int(11) NO MUL 0
rgt int(11) NO 0
level int(10) unsigned NO 0
path varchar(400) NO MUL
title varchar(255) NO NULL
alias varchar(400) NO MUL
note varchar(255) NO
description longtext NO NULL
published tinyint(1) NO MUL 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
access int(10) unsigned NO MUL 0
params mediumtext NO NULL
metadesc varchar(1024) NO NULL
metakey varchar(1024) NO
metadata varchar(2048) NO NULL
created_user_id int(10) unsigned NO 0
created_time datetime NO NULL
created_by_alias varchar(255) NO
modified_user_id int(10) unsigned NO 0
modified_time datetime NO NULL
images mediumtext NO NULL
urls mediumtext NO NULL
hits int(10) unsigned NO 0
language char(7) NO MUL NULL
version int(10) unsigned NO 1
publish_up datetime YES NULL
publish_down datetime YES NULL
▶ ocfns_template_overrides 9 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
template varchar(50) NO MUL
hash_id varchar(255) NO
extension_id int(11) YES MUL 0
state tinyint(4) NO 0
action varchar(50) NO
client_id tinyint(3) unsigned NO 0
created_date datetime NO NULL
modified_date datetime YES NULL
▶ ocfns_template_styles 8 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
template varchar(50) NO MUL
client_id tinyint(3) unsigned NO MUL 0
home char(7) NO 0
title varchar(255) NO
params mediumtext NO NULL
inheritable tinyint(4) NO 0
parent varchar(50) YES
▶ ocfns_tuf_metadata 7 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
update_site_id int(11) YES 0
root text YES NULL
targets text YES NULL
snapshot text YES NULL
timestamp text YES NULL
mirrors text YES NULL
▶ ocfns_ucm_base 4 fields
Field Name Type Null Key Default Extra
ucm_id int(10) unsigned NO PRI NULL
ucm_item_id int(11) NO MUL NULL
ucm_type_id int(11) NO MUL NULL
ucm_language_id int(11) NO MUL NULL
▶ ocfns_ucm_content 32 fields
Field Name Type Null Key Default Extra
core_content_id int(10) unsigned NO PRI NULL auto_increment
core_type_alias varchar(400) NO MUL
core_title varchar(400) NO MUL
core_alias varchar(400) NO MUL
core_body longtext YES NULL
core_state tinyint(1) NO MUL 0
core_checked_out_time datetime YES NULL
core_checked_out_user_id int(10) unsigned YES MUL NULL
core_access int(10) unsigned NO MUL 0
core_params mediumtext YES NULL
core_featured tinyint(3) unsigned NO 0
core_metadata varchar(2048) NO
core_created_user_id int(10) unsigned NO MUL 0
core_created_by_alias varchar(255) NO
core_created_time datetime NO MUL NULL
core_modified_user_id int(10) unsigned NO MUL 0
core_modified_time datetime NO MUL NULL
core_language char(7) NO MUL
core_publish_up datetime YES NULL
core_publish_down datetime YES NULL
core_content_item_id int(10) unsigned NO 0
asset_id int(10) unsigned NO 0
core_images mediumtext YES NULL
core_urls mediumtext YES NULL
core_hits int(10) unsigned NO 0
core_version int(10) unsigned NO 1
core_ordering int(11) NO 0
core_metakey mediumtext YES NULL
core_metadesc mediumtext YES NULL
core_catid int(10) unsigned NO 0
core_xreference varchar(50) NO
core_type_id int(10) unsigned NO MUL 0
▶ ocfns_update_sites 9 fields
Field Name Type Null Key Default Extra
update_site_id int(11) NO PRI NULL auto_increment
name varchar(100) YES
type varchar(20) YES
location mediumtext NO NULL
enabled int(11) YES 0
last_check_timestamp bigint(20) YES 0
extra_query varchar(1000) YES
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
▶ ocfns_update_sites_extensions 2 fields
Field Name Type Null Key Default Extra
update_site_id int(11) NO PRI 0
extension_id int(11) NO PRI 0
▶ ocfns_updates 15 fields
Field Name Type Null Key Default Extra
update_id int(11) NO PRI NULL auto_increment
update_site_id int(11) YES 0
extension_id int(11) YES 0
name varchar(100) YES
description mediumtext NO NULL
element varchar(100) YES
type varchar(20) YES
folder varchar(20) YES
client_id tinyint(4) YES 0
version varchar(32) YES
data mediumtext NO NULL
detailsurl mediumtext NO NULL
infourl mediumtext NO NULL
changelogurl text YES NULL
extra_query varchar(1000) YES
▶ ocfns_user_keys 6 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
user_id varchar(150) NO MUL NULL
token varchar(255) NO NULL
series varchar(191) NO UNI NULL
time varchar(200) NO NULL
uastring varchar(255) NO NULL
▶ ocfns_user_mfa 10 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
user_id int(10) unsigned NO MUL NULL
title varchar(255) NO
method varchar(100) NO NULL
default tinyint(4) NO 0
options mediumtext NO NULL
created_on datetime NO NULL
last_used datetime YES NULL
tries int(11) NO 0
last_try datetime YES NULL
▶ ocfns_user_notes 15 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
user_id int(10) unsigned NO MUL 0
catid int(10) unsigned NO MUL 0
subject varchar(100) NO
body mediumtext NO NULL
state tinyint(4) NO 0
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
created_user_id int(10) unsigned NO 0
created_time datetime NO NULL
modified_user_id int(10) unsigned NO 0
modified_time datetime NO NULL
review_time datetime YES NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
▶ ocfns_user_profiles 4 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
profile_key varchar(100) NO PRI NULL
profile_value mediumtext NO NULL
ordering int(11) NO 0
▶ ocfns_user_usergroup_map 2 fields
Field Name Type Null Key Default Extra
user_id int(10) unsigned NO PRI 0
group_id int(10) unsigned NO PRI 0
▶ ocfns_usergroups 5 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
parent_id int(10) unsigned NO MUL 0
lft int(11) NO MUL 0
rgt int(11) NO 0
title varchar(100) NO MUL
▶ ocfns_users 17 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(400) NO MUL
username varchar(150) NO UNI
email varchar(100) NO MUL
password varchar(100) NO
block tinyint(4) NO MUL 0
sendEmail tinyint(4) YES 0
registerDate datetime NO NULL
lastvisitDate datetime YES NULL
activation varchar(100) NO
params mediumtext NO NULL
lastResetTime datetime YES NULL
resetCount int(11) NO 0
otpKey varchar(1000) NO
otep varchar(1000) NO
requireReset tinyint(4) NO 0
authProvider varchar(100) NO
▶ ocfns_viewlevels 4 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
title varchar(100) NO UNI
ordering int(11) NO 0
rules varchar(5120) NO NULL
▶ ocfns_webauthn_credentials 4 fields
Field Name Type Null Key Default Extra
id varchar(1000) NO PRI NULL
user_id varchar(128) NO MUL NULL
label varchar(190) NO NULL
credential mediumtext NO NULL
▶ ocfns_workflow_associations 3 fields
Field Name Type Null Key Default Extra
item_id int(11) NO PRI 0
stage_id int(11) NO MUL NULL
extension varchar(50) NO PRI NULL
▶ ocfns_workflow_stages 10 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(11) YES MUL 0
ordering int(11) NO 0
workflow_id int(11) NO MUL NULL
published tinyint(4) NO 0
title varchar(255) NO MUL NULL
description text NO NULL
default tinyint(4) NO MUL 0
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES MUL NULL
▶ ocfns_workflow_transitions 12 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(11) YES MUL 0
ordering int(11) NO 0
workflow_id int(11) NO MUL NULL
published tinyint(4) NO 0
title varchar(255) NO MUL NULL
description text NO NULL
from_stage_id int(11) NO MUL NULL
to_stage_id int(11) NO MUL NULL
options text NO NULL
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES MUL NULL
▶ ocfns_workflows 14 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(11) YES MUL 0
published tinyint(4) NO 0
title varchar(255) NO MUL NULL
description text NO NULL
extension varchar(50) NO MUL NULL
default tinyint(4) NO MUL 0
ordering int(11) NO 0
created datetime NO MUL NULL
created_by int(11) NO MUL 0
modified datetime NO MUL NULL
modified_by int(11) NO MUL 0
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES MUL NULL
▶ oasiscapfin_oasis_capital_finance_2025 5 tables
▶ commissions 13 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
deal_id int(11) NO NULL
introducer_id int(11) NO NULL
staff_id int(11) YES NULL
commission_type enum('introducer','banker','manager','support') NO NULL
commission_percentage decimal(5,2) NO NULL
commission_amount decimal(12,2) NO NULL
payment_status enum('pending','approved','paid','disputed','cancelled') NO pending
payment_date date YES NULL
payment_reference varchar(100) YES NULL
notes text YES NULL
created_at timestamp NO current_timestamp()
updated_at timestamp NO current_timestamp() on update current_timestamp()
▶ deals 16 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
deal_reference varchar(50) NO NULL
client_name varchar(255) NO NULL
deal_amount decimal(15,2) NO NULL
deal_type enum('acquisition','merger','ipo','debt_financing','equity_financing','refinancing','restructuring') NO NULL
status enum('prospecting','due_diligence','negotiation','documentation','completed','cancelled') NO prospecting
completion_date date YES NULL
primary_banker_id int(11) YES NULL
secondary_banker_id int(11) YES NULL
introducer_id int(11) YES NULL
revenue_share_percentage decimal(5,2) YES 0.00
total_fees decimal(12,2) YES 0.00
bank_revenue decimal(12,2) YES 0.00
introducer_commission decimal(12,2) YES 0.00
created_at timestamp NO current_timestamp()
updated_at timestamp NO current_timestamp() on update current_timestamp()
▶ introducers 17 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
introducer_code varchar(20) NO NULL
company_name varchar(255) NO NULL
contact_name varchar(255) NO NULL
email varchar(255) NO NULL
phone varchar(50) YES NULL
commission_rate decimal(5,2) NO 15.00
tier enum('bronze','standard','premium','platinum') NO standard
status enum('active','pending','inactive','suspended') NO pending
contract_signed tinyint(1) YES 0
total_introductions int(11) YES 0
total_commission_paid decimal(12,2) YES 0.00
year_to_date_commission decimal(12,2) YES 0.00
last_introduction_date date YES NULL
notes text YES NULL
created_at timestamp NO current_timestamp()
updated_at timestamp NO current_timestamp() on update current_timestamp()
▶ staff 18 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
email varchar(255) NO NULL
role enum('admin','lead_banker','manager','execution_banker','support_staff','readonly') NO support_staff
department varchar(100) YES NULL
position varchar(150) YES NULL
phone varchar(50) YES NULL
hire_date date YES NULL
salary decimal(10,2) YES 0.00
commission_percentage decimal(5,2) YES 0.00
total_deals int(11) YES 0
total_revenue decimal(15,2) YES 0.00
total_commission decimal(12,2) YES 0.00
ytd_commission decimal(12,2) YES 0.00
performance_rating decimal(3,1) YES 3.0
is_active tinyint(1) YES 1
created_at timestamp NO current_timestamp()
updated_at timestamp NO current_timestamp() on update current_timestamp()
▶ users 9 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
email varchar(255) NO UNI NULL
password_hash varchar(255) NO NULL
name varchar(255) NO NULL
role enum('admin','manager','user','readonly') NO user
is_active tinyint(1) YES 1
last_login timestamp YES NULL
created_at timestamp NO current_timestamp()
updated_at timestamp NO current_timestamp() on update current_timestamp()
▶ oasiscapfin_site 179 tables
▶ ocapfin_action_log_config 7 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
type_title varchar(255) NO
type_alias varchar(255) NO
id_holder varchar(255) YES NULL
title_holder varchar(255) YES NULL
table_name varchar(255) YES NULL
text_prefix varchar(255) YES NULL
▶ ocapfin_action_logs 8 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
message_language_key varchar(255) NO
message text NO NULL
log_date datetime NO NULL
extension varchar(50) NO MUL
user_id int(11) NO MUL 0
item_id int(11) NO 0
ip_address varchar(40) NO 0.0.0.0
▶ ocapfin_action_logs_extensions 2 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
extension varchar(255) NO
▶ ocapfin_action_logs_users 3 fields
Field Name Type Null Key Default Extra
user_id int(11) unsigned NO PRI NULL
notify tinyint(1) unsigned NO MUL NULL
extensions text NO NULL
▶ ocapfin_acym_action 5 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
condition_id int(11) NO MUL NULL
actions longtext YES NULL
filters longtext YES NULL
order int(11) NO NULL
▶ ocapfin_acym_automation 7 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
description longtext YES NULL
active tinyint(3) NO NULL
report text YES NULL
tree longtext YES NULL
admin tinyint(3) YES NULL
▶ ocapfin_acym_campaign 12 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
sending_date datetime YES NULL
draft tinyint(1) YES NULL
active tinyint(1) NO 1
mail_id int(11) YES MUL NULL
sent tinyint(1) NO 0
sending_type varchar(16) YES NULL
sending_params text YES NULL
parent_id int(11) YES NULL
last_generated int(11) YES NULL
next_trigger int(11) YES NULL
visible tinyint(1) NO 1
▶ ocapfin_acym_condition 3 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
step_id int(11) NO MUL NULL
conditions longtext YES NULL
▶ ocapfin_acym_configuration 2 fields
Field Name Type Null Key Default Extra
name varchar(255) NO PRI NULL
value text NO NULL
▶ ocapfin_acym_custom_zone 4 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
content text NO NULL
image varchar(255) YES NULL
▶ ocapfin_acym_field 17 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
type varchar(255) NO NULL
value longtext YES NULL
active tinyint(3) NO NULL
default_value longtext YES NULL
required tinyint(3) YES NULL
ordering int(11) NO NULL
option longtext YES NULL
core tinyint(3) YES NULL
backend_edition tinyint(3) YES NULL
backend_listing tinyint(3) YES NULL
frontend_edition tinyint(3) YES NULL
frontend_listing tinyint(3) YES NULL
access varchar(255) YES NULL
namekey varchar(255) NO NULL
translation longtext YES NULL
▶ ocapfin_acym_followup 10 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
display_name varchar(255) NO NULL
creation_date datetime NO NULL
trigger varchar(50) YES NULL
condition longtext YES NULL
active tinyint(1) NO 1
send_once tinyint(1) NO 1
list_id int(11) YES MUL NULL
last_trigger int(11) YES NULL
▶ ocapfin_acym_followup_has_mail 4 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
followup_id int(11) NO PRI NULL
delay int(11) NO NULL
delay_unit int(11) NO NULL
▶ ocapfin_acym_form 16 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
creation_date datetime NO NULL
active tinyint(1) NO 1
type varchar(20) NO NULL
lists_options longtext YES NULL
fields_options longtext YES NULL
style_options longtext YES NULL
button_options longtext YES NULL
image_options longtext YES NULL
termspolicy_options longtext YES NULL
cookie varchar(30) YES NULL
pages text YES NULL
redirection_options text YES NULL
message_options text YES NULL
display_options text YES NULL
▶ ocapfin_acym_history 8 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
date int(11) NO PRI NULL
ip varchar(50) YES NULL
action varchar(50) NO NULL
data text YES NULL
source text YES NULL
mail_id mediumint(9) YES NULL
unsubscribe_reason text YES NULL
▶ ocapfin_acym_list 16 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
display_name varchar(255) YES NULL
active tinyint(1) NO 1
visible tinyint(1) NO 1
clean tinyint(1) YES NULL
color varchar(30) YES NULL
creation_date datetime YES NULL
welcome_id int(11) YES MUL NULL
unsubscribe_id int(11) YES MUL NULL
cms_user_id int(11) NO NULL
access varchar(50) NO
description text NO NULL
tracking tinyint(1) NO 1
type varchar(20) NO standard
translation longtext YES NULL
▶ ocapfin_acym_mail 27 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
creation_date datetime NO NULL
thumbnail longtext YES NULL
drag_editor tinyint(1) YES NULL
type varchar(30) NO NULL
body longtext NO NULL
subject varchar(255) YES NULL
from_name varchar(100) YES NULL
from_email varchar(100) YES NULL
reply_to_name varchar(100) YES NULL
reply_to_email varchar(100) YES NULL
bcc varchar(255) YES NULL
settings text YES NULL
stylesheet text YES NULL
attachments text YES NULL
creator_id int(11) NO NULL
mail_settings text YES NULL
headers text YES NULL
autosave longtext YES NULL
preheader text YES NULL
links_language varchar(20) NO
access varchar(50) NO
tracking tinyint(1) NO 1
language varchar(20) NO
parent_id int(11) YES MUL NULL
translation text YES NULL
▶ ocapfin_acym_mail_has_list 2 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
list_id int(11) NO PRI NULL
▶ ocapfin_acym_mail_override 7 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
mail_id int(11) NO MUL NULL
description varchar(255) NO NULL
source varchar(20) NO NULL
active tinyint(1) NO 1
base_subject text NO NULL
base_body text NO NULL
▶ ocapfin_acym_mail_stat 12 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
total_subscribers int(11) NO 0
sent int(11) YES 0
send_date datetime YES NULL
fail int(11) YES 0
open_unique int(11) NO 0
open_total int(11) NO 0
bounce_unique mediumint(8) NO 0
bounce_details longtext YES NULL
unsubscribe_total int(11) NO 0
tracking_sale float YES NULL
currency varchar(5) YES NULL
▶ ocapfin_acym_plugin 13 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
title varchar(100) NO NULL
folder_name varchar(100) NO NULL
version varchar(10) YES NULL
active int(11) NO NULL
category varchar(100) NO NULL
level varchar(50) NO NULL
uptodate int(11) NO NULL
features varchar(255) NO NULL
description longtext NO NULL
latest_version varchar(10) NO NULL
settings longtext YES NULL
type varchar(20) NO ADDON
▶ ocapfin_acym_queue 5 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
user_id int(11) NO PRI NULL
sending_date datetime NO NULL
priority int(11) NO 2
try tinyint(4) NO 0
▶ ocapfin_acym_rule 10 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(250) NO NULL
ordering smallint(6) YES NULL
regex text NO NULL
executed_on text NO NULL
action_message text NO NULL
action_user text NO NULL
active tinyint(3) NO NULL
increment_stats tinyint(3) NO NULL
execute_action_after int(11) NO NULL
▶ ocapfin_acym_segment 5 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
creation_date datetime NO NULL
active tinyint(1) NO 1
filters longtext YES NULL
▶ ocapfin_acym_step 6 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
triggers longtext YES NULL
automation_id int(11) NO MUL NULL
last_execution int(11) YES NULL
next_execution int(11) YES NULL
▶ ocapfin_acym_tag 3 fields
Field Name Type Null Key Default Extra
name varchar(50) NO PRI NULL
type varchar(20) NO PRI NULL
id_element int(11) NO PRI NULL
▶ ocapfin_acym_url 3 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name longtext YES NULL
url longtext NO NULL
▶ ocapfin_acym_url_click 5 fields
Field Name Type Null Key Default Extra
mail_id int(11) NO PRI NULL
url_id int(11) NO PRI NULL
user_id int(11) NO PRI NULL
click int(11) NO 0
date_click datetime YES NULL
▶ ocapfin_acym_user 14 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) YES NULL
email varchar(255) NO UNI NULL
creation_date datetime NO NULL
active tinyint(1) NO 1
cms_id int(11) NO 0
source varchar(255) YES NULL
confirmed tinyint(1) NO 0
key varchar(30) YES NULL
automation varchar(50) NO
confirmation_date datetime YES NULL
confirmation_ip varchar(50) YES NULL
tracking tinyint(1) NO 1
language varchar(20) NO
▶ ocapfin_acym_user_has_field 3 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
field_id int(11) NO PRI NULL
value longtext YES NULL
▶ ocapfin_acym_user_has_list 5 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
list_id int(11) NO PRI NULL
status tinyint(1) NO NULL
subscription_date datetime NO MUL NULL
unsubscribe_date datetime YES MUL NULL
▶ ocapfin_acym_user_stat 14 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
mail_id int(11) NO PRI NULL
send_date datetime YES NULL
fail int(11) NO 0
sent int(11) NO 0
open int(11) NO 0
open_date datetime YES NULL
bounce tinyint(4) NO 0
bounce_rule varchar(255) YES NULL
tracking_sale float YES NULL
currency varchar(10) YES NULL
unsubscribe int(11) NO 0
device varchar(50) YES NULL
opened_with varchar(50) YES NULL
▶ ocapfin_assets 8 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
parent_id int(11) NO MUL 0
lft int(11) NO MUL 0
rgt int(11) NO 0
level int(10) unsigned NO NULL
name varchar(50) NO UNI NULL
title varchar(100) NO NULL
rules varchar(5120) NO NULL
▶ ocapfin_associations 3 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL
context varchar(50) NO PRI NULL
key char(32) NO MUL NULL
▶ ocapfin_banner_clients 14 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO
contact varchar(255) NO
email varchar(255) NO
extrainfo mediumtext NO NULL
state tinyint(3) NO 0
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
metakey text YES NULL
own_prefix tinyint(4) NO MUL 0
metakey_prefix varchar(255) NO MUL
purchase_type tinyint(4) NO -1
track_clicks tinyint(4) NO -1
track_impressions tinyint(4) NO -1
▶ ocapfin_banner_tracks 4 fields
Field Name Type Null Key Default Extra
track_date datetime NO PRI NULL
track_type int(10) unsigned NO PRI NULL
banner_id int(10) unsigned NO PRI NULL
count int(10) unsigned NO 0
▶ ocapfin_banners 34 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
cid int(11) NO 0
type int(11) NO 0
name varchar(255) NO
alias varchar(400) NO
imptotal int(11) NO 0
impmade int(11) NO 0
clicks int(11) NO 0
clickurl varchar(2048) NO
state tinyint(3) NO MUL 0
catid int(10) unsigned NO MUL 0
description mediumtext NO NULL
custombannercode varchar(2048) NO NULL
sticky tinyint(1) unsigned NO 0
ordering int(11) NO 0
metakey text YES NULL
params mediumtext NO NULL
own_prefix tinyint(1) NO MUL 0
metakey_prefix varchar(400) NO MUL
purchase_type tinyint(4) NO -1
track_clicks tinyint(4) NO -1
track_impressions tinyint(4) NO -1
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
reset datetime YES NULL
created datetime NO NULL
language char(7) NO MUL
created_by int(10) unsigned NO 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
version int(10) unsigned NO 1
▶ ocapfin_categories 27 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
parent_id int(10) unsigned NO 0
lft int(11) NO MUL 0
rgt int(11) NO 0
level int(10) unsigned NO 0
path varchar(400) NO MUL
extension varchar(50) NO MUL
title varchar(255) NO
alias varchar(400) NO MUL
note varchar(255) NO
description longtext YES NULL
published tinyint(1) NO 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
access int(10) unsigned NO MUL 0
params mediumtext YES NULL
metadesc varchar(1024) NO
metakey varchar(1024) NO
metadata varchar(2048) NO
created_user_id int(10) unsigned NO 0
created_time datetime NO NULL
modified_user_id int(10) unsigned NO 0
modified_time datetime NO NULL
hits int(10) unsigned NO 0
language char(7) NO MUL
version int(10) unsigned NO 1
▶ ocapfin_contact_details 42 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(255) NO NULL
alias varchar(400) NO
con_position varchar(255) YES NULL
address mediumtext YES NULL
suburb varchar(100) YES NULL
state varchar(100) YES NULL
country varchar(100) YES NULL
postcode varchar(100) YES NULL
telephone varchar(255) YES NULL
fax varchar(255) YES NULL
misc longtext YES NULL
image varchar(255) YES NULL
email_to varchar(255) YES NULL
default_con tinyint(1) unsigned NO 0
published tinyint(1) NO MUL 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
ordering int(11) NO 0
params mediumtext NO NULL
user_id int(11) NO 0
catid int(11) NO MUL 0
access int(10) unsigned NO MUL 0
mobile varchar(255) NO
webpage varchar(255) NO
sortname1 varchar(255) NO
sortname2 varchar(255) NO
sortname3 varchar(255) NO
language varchar(7) NO MUL NULL
created datetime NO NULL
created_by int(10) unsigned NO MUL 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
metakey text YES NULL
metadesc mediumtext NO NULL
metadata mediumtext NO NULL
featured tinyint(3) unsigned NO MUL 0
publish_up datetime YES NULL
publish_down datetime YES NULL
version int(10) unsigned NO 1
hits int(10) unsigned NO 0
▶ ocapfin_content 30 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
title varchar(255) NO
alias varchar(400) NO MUL
introtext longtext NO NULL
fulltext longtext NO NULL
state tinyint(3) NO MUL 0
catid int(10) unsigned NO MUL 0
created datetime NO NULL
created_by int(10) unsigned NO MUL 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
images mediumtext NO NULL
urls mediumtext NO NULL
attribs varchar(5120) NO NULL
version int(10) unsigned NO 1
ordering int(11) NO 0
metakey text YES NULL
metadesc mediumtext NO NULL
access int(10) unsigned NO MUL 0
hits int(10) unsigned NO 0
metadata mediumtext NO NULL
featured tinyint(3) unsigned NO MUL 0
language char(7) NO MUL NULL
note varchar(255) NO
▶ ocapfin_content_frontpage 4 fields
Field Name Type Null Key Default Extra
content_id int(11) NO PRI 0
ordering int(11) NO 0
featured_up datetime YES NULL
featured_down datetime YES NULL
▶ ocapfin_content_rating 4 fields
Field Name Type Null Key Default Extra
content_id int(11) NO PRI 0
rating_sum int(10) unsigned NO 0
rating_count int(10) unsigned NO 0
lastip varchar(50) NO
▶ ocapfin_content_types 8 fields
Field Name Type Null Key Default Extra
type_id int(10) unsigned NO PRI NULL auto_increment
type_title varchar(255) NO
type_alias varchar(400) NO MUL
table varchar(2048) NO
rules mediumtext NO NULL
field_mappings mediumtext NO NULL
router varchar(255) NO
content_history_options varchar(5120) YES NULL
▶ ocapfin_contentitem_tag_map 6 fields
Field Name Type Null Key Default Extra
type_alias varchar(255) NO
core_content_id int(10) unsigned NO MUL NULL
content_item_id int(11) NO PRI NULL
tag_id int(10) unsigned NO PRI NULL
tag_date timestamp NO MUL current_timestamp() on update current_timestamp()
type_id mediumint(8) NO PRI NULL
▶ ocapfin_core_log_searches 2 fields
Field Name Type Null Key Default Extra
search_term varchar(128) NO
hits int(10) unsigned NO 0
▶ ocapfin_extensions 20 fields
Field Name Type Null Key Default Extra
extension_id int(11) NO PRI NULL auto_increment
package_id int(11) NO 0
name varchar(100) NO NULL
type varchar(20) NO MUL NULL
element varchar(100) NO MUL NULL
changelogurl text YES NULL
folder varchar(100) NO NULL
client_id tinyint(3) NO NULL
enabled tinyint(3) NO 0
access int(10) unsigned NO 1
protected tinyint(4) NO 0
manifest_cache mediumtext NO NULL
params mediumtext NO NULL
custom_data mediumtext NO NULL
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
ordering int(11) YES 0
state int(11) YES 0
note varchar(255) YES NULL
locked tinyint(4) NO 0
▶ ocapfin_fields 25 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
context varchar(255) NO MUL
group_id int(10) unsigned NO 0
title varchar(255) NO
name varchar(255) NO
label varchar(255) NO
default_value mediumtext YES NULL
type varchar(255) NO text
note varchar(255) NO
description text NO NULL
state tinyint(1) NO MUL 0
required tinyint(1) NO 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
ordering int(11) NO 0
params text NO NULL
fieldparams text NO NULL
language char(7) NO MUL
created_time datetime NO NULL
created_user_id int(10) unsigned NO MUL 0
modified_time datetime NO NULL
modified_by int(10) unsigned NO 0
access int(11) NO MUL 1
only_use_in_subform tinyint(4) NO 0
▶ ocapfin_fields_categories 2 fields
Field Name Type Null Key Default Extra
field_id int(11) NO PRI 0
category_id int(11) NO PRI 0
▶ ocapfin_fields_groups 17 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
context varchar(255) NO MUL
title varchar(255) NO
note varchar(255) NO
description text NO NULL
state tinyint(1) NO MUL 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
ordering int(11) NO 0
params mediumtext NO NULL
language char(7) NO MUL
created datetime NO NULL
created_by int(10) unsigned NO MUL 0
modified datetime NO NULL
modified_by int(10) unsigned NO 0
access int(11) NO MUL 1
▶ ocapfin_fields_values 3 fields
Field Name Type Null Key Default Extra
field_id int(10) unsigned NO MUL NULL
item_id varchar(255) NO MUL NULL
value mediumtext YES NULL
▶ ocapfin_finder_filters 14 fields
Field Name Type Null Key Default Extra
filter_id int(10) unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
alias varchar(255) NO NULL
state tinyint(1) NO 1
created datetime NO NULL
created_by int(10) unsigned NO 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
map_count int(10) unsigned NO 0
data mediumtext NO NULL
params longtext YES NULL
▶ ocapfin_finder_links 19 fields
Field Name Type Null Key Default Extra
link_id int(10) unsigned NO PRI NULL auto_increment
url varchar(255) NO MUL NULL
route varchar(400) YES NULL
title varchar(400) YES MUL NULL
description mediumtext YES NULL
indexdate datetime NO NULL
md5sum varchar(32) YES MUL NULL
published tinyint(1) NO MUL 1
state int(11) NO 1
access int(11) NO 0
language char(7) NO MUL
publish_start_date datetime YES NULL
publish_end_date datetime YES NULL
start_date datetime YES NULL
end_date datetime YES NULL
list_price double unsigned NO 0
sale_price double unsigned NO 0
type_id int(11) NO MUL NULL
object mediumblob NO NULL
▶ ocapfin_finder_links_terms 3 fields
Field Name Type Null Key Default Extra
link_id int(10) unsigned NO PRI NULL
term_id int(10) unsigned NO PRI NULL
weight float unsigned NO 0
▶ ocapfin_finder_logging 5 fields
Field Name Type Null Key Default Extra
searchterm varchar(255) NO MUL
md5sum varchar(32) NO PRI
query blob NO NULL
hits int(11) NO 1
results int(11) NO 0
▶ ocapfin_finder_taxonomy 11 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
parent_id int(10) unsigned NO MUL 0
lft int(11) NO MUL 0
rgt int(11) NO 0
level int(10) unsigned NO MUL 0
path varchar(400) NO MUL
title varchar(255) NO
alias varchar(400) NO MUL
state tinyint(3) unsigned NO MUL 1
access tinyint(3) unsigned NO MUL 1
language char(7) NO MUL
▶ ocapfin_finder_taxonomy_map 2 fields
Field Name Type Null Key Default Extra
link_id int(10) unsigned NO PRI NULL
node_id int(10) unsigned NO PRI NULL
▶ ocapfin_finder_terms 9 fields
Field Name Type Null Key Default Extra
term_id int(10) unsigned NO PRI NULL auto_increment
term varchar(75) NO MUL NULL
stem varchar(75) NO MUL
common tinyint(1) unsigned NO 0
phrase tinyint(1) unsigned NO 0
weight float unsigned NO 0
soundex varchar(75) NO MUL
links int(10) NO 0
language char(7) NO MUL
▶ ocapfin_finder_terms_common 3 fields
Field Name Type Null Key Default Extra
term varchar(75) NO PRI
language char(7) NO PRI
custom int(11) NO 0
▶ ocapfin_finder_tokens 7 fields
Field Name Type Null Key Default Extra
term varchar(75) NO MUL NULL
stem varchar(75) NO MUL
common tinyint(1) unsigned NO 0
phrase tinyint(1) unsigned NO 0
weight float unsigned NO 1
context tinyint(1) unsigned NO MUL 2
language char(7) NO MUL
▶ ocapfin_finder_tokens_aggregate 10 fields
Field Name Type Null Key Default Extra
term_id int(10) unsigned NO MUL NULL
term varchar(75) NO MUL NULL
stem varchar(75) NO
common tinyint(1) unsigned NO 0
phrase tinyint(1) unsigned NO 0
term_weight float unsigned NO 0
context tinyint(1) unsigned NO 2
context_weight float unsigned NO 0
total_weight float unsigned NO 0
language char(7) NO
▶ ocapfin_finder_types 3 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
title varchar(100) NO UNI NULL
mime varchar(100) NO
▶ ocapfin_guidedtour_steps 19 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
tour_id int(11) NO MUL 0
title varchar(255) NO NULL
published tinyint(4) NO MUL 0
description text NO NULL
ordering int(11) NO 0
position varchar(255) NO NULL
target varchar(255) NO NULL
type int(11) NO NULL
interactive_type int(11) NO 1
url varchar(255) NO NULL
created datetime NO NULL
created_by int(10) unsigned NO 0
modified datetime NO NULL
modified_by int(10) unsigned NO 0
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES NULL
language varchar(7) NO MUL NULL
note varchar(255) NO
▶ ocapfin_guidedtours 16 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
title varchar(255) NO
description text NO NULL
ordering int(11) NO 0
extensions text NO NULL
url varchar(255) NO NULL
created datetime NO NULL
created_by int(11) NO 0
modified datetime NO NULL
modified_by int(11) NO 0
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES NULL
published tinyint(4) NO MUL 0
language varchar(7) NO MUL NULL
note varchar(255) NO
access int(10) unsigned NO MUL 0
▶ ocapfin_history 9 fields
Field Name Type Null Key Default Extra
version_id int(10) unsigned NO PRI NULL auto_increment
item_id varchar(50) NO MUL NULL
version_note varchar(255) NO
save_date datetime NO MUL NULL
editor_user_id int(10) unsigned NO 0
character_count int(10) unsigned NO 0
sha1_hash varchar(50) NO
version_data mediumtext NO NULL
keep_forever tinyint(4) NO 0
▶ ocapfin_languages 14 fields
Field Name Type Null Key Default Extra
lang_id int(11) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
lang_code char(7) NO UNI NULL
title varchar(50) NO NULL
title_native varchar(50) NO NULL
sef varchar(50) NO UNI NULL
image varchar(50) NO NULL
description varchar(512) NO NULL
metakey text YES NULL
metadesc mediumtext NO NULL
sitename varchar(1024) NO
published int(11) NO 0
access int(10) unsigned NO MUL 0
ordering int(11) NO MUL 0
▶ ocapfin_mail_templates 8 fields
Field Name Type Null Key Default Extra
template_id varchar(127) NO PRI
extension varchar(127) NO
language char(7) NO PRI
subject varchar(255) NO
body text NO NULL
htmlbody mediumtext NO NULL
attachments text NO NULL
params text NO NULL
▶ ocapfin_menu 26 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
menutype varchar(24) NO MUL NULL
title varchar(255) NO NULL
alias varchar(400) NO MUL NULL
note varchar(255) NO
path varchar(1024) NO MUL NULL
link varchar(1024) NO NULL
type varchar(16) NO NULL
published tinyint(4) NO 0
parent_id int(10) unsigned NO 1
level int(10) unsigned NO 0
component_id int(10) unsigned NO MUL 0
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
browserNav tinyint(4) NO 0
access int(10) unsigned NO 0
img varchar(255) NO NULL
template_style_id int(10) unsigned NO 0
params mediumtext NO NULL
lft int(11) NO MUL 0
rgt int(11) NO 0
home tinyint(3) unsigned NO 0
language char(7) NO MUL
client_id tinyint(4) NO MUL 0
publish_up datetime YES NULL
publish_down datetime YES NULL
▶ ocapfin_menu_types 6 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
menutype varchar(24) NO UNI NULL
title varchar(48) NO NULL
description varchar(255) NO
client_id int(11) NO 0
▶ ocapfin_messages 9 fields
Field Name Type Null Key Default Extra
message_id int(10) unsigned NO PRI NULL auto_increment
user_id_from int(10) unsigned NO 0
user_id_to int(10) unsigned NO MUL 0
folder_id tinyint(3) unsigned NO 0
date_time datetime NO NULL
state tinyint(1) NO 0
priority tinyint(1) unsigned NO 0
subject varchar(255) NO
message mediumtext NO NULL
▶ ocapfin_messages_cfg 3 fields
Field Name Type Null Key Default Extra
user_id int(10) unsigned NO PRI 0
cfg_name varchar(100) NO PRI
cfg_value varchar(255) NO
▶ ocapfin_modules 18 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
title varchar(100) NO
note varchar(255) NO
content text YES NULL
ordering int(11) NO 0
position varchar(50) NO
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
published tinyint(1) NO MUL 0
module varchar(50) YES MUL NULL
access int(10) unsigned NO 0
showtitle tinyint(3) unsigned NO 1
params mediumtext NO NULL
client_id tinyint(4) NO 0
language char(7) NO MUL NULL
▶ ocapfin_modules_menu 2 fields
Field Name Type Null Key Default Extra
moduleid int(11) NO PRI 0
menuid int(11) NO PRI 0
▶ ocapfin_newsfeeds 29 fields
Field Name Type Null Key Default Extra
catid int(11) NO MUL 0
id int(10) unsigned NO PRI NULL auto_increment
name varchar(100) NO
alias varchar(400) NO
link varchar(2048) NO NULL
published tinyint(1) NO MUL 0
numarticles int(10) unsigned NO 1
cache_time int(10) unsigned NO 3600
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
ordering int(11) NO 0
rtl tinyint(4) NO 0
access int(10) unsigned NO MUL 0
language char(7) NO MUL
params mediumtext NO NULL
created datetime NO NULL
created_by int(10) unsigned NO MUL 0
created_by_alias varchar(255) NO
modified datetime NO NULL
modified_by int(10) unsigned NO 0
metakey text YES NULL
metadesc mediumtext NO NULL
metadata mediumtext NO NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
description mediumtext NO NULL
version int(10) unsigned NO 1
hits int(10) unsigned NO 0
images mediumtext NO NULL
▶ ocapfin_overrider 4 fields
Field Name Type Null Key Default Extra
id int(10) NO PRI NULL auto_increment
constant varchar(255) NO NULL
string mediumtext NO NULL
file varchar(255) NO NULL
▶ ocapfin_plg_system_eprivacy_log 4 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
ip varchar(15) NO NULL
state varchar(255) NO NULL
accepted datetime NO NULL
▶ ocapfin_postinstall_messages 14 fields
Field Name Type Null Key Default Extra
postinstall_message_id bigint(20) unsigned NO PRI NULL auto_increment
extension_id bigint(20) NO 700
title_key varchar(255) NO
description_key varchar(255) NO
action_key varchar(255) NO
language_extension varchar(255) NO com_postinstall
language_client_id tinyint(3) NO 1
type varchar(10) NO link
action_file varchar(255) YES
action varchar(255) YES
condition_file varchar(255) YES NULL
condition_method varchar(255) YES NULL
version_introduced varchar(50) NO 3.2.0
enabled tinyint(3) NO 1
▶ ocapfin_privacy_consents 8 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
user_id int(10) unsigned NO MUL 0
state int(10) NO 1
created datetime NO NULL
subject varchar(255) NO
body text NO NULL
remind tinyint(4) NO 0
token varchar(100) NO
▶ ocapfin_privacy_requests 7 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
email varchar(100) NO
requested_at datetime NO NULL
status tinyint(4) NO 0
request_type varchar(25) NO
confirm_token varchar(100) NO
confirm_token_created_at datetime YES NULL
▶ ocapfin_redirect_links 10 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
old_url varchar(2048) NO MUL NULL
new_url varchar(2048) YES NULL
referer varchar(2048) NO NULL
comment varchar(255) NO
hits int(10) unsigned NO 0
published tinyint(4) NO NULL
created_date datetime NO NULL
modified_date datetime NO MUL NULL
header smallint(3) NO 301
▶ ocapfin_scheduler_tasks 22 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
asset_id int(10) unsigned NO 0
title varchar(255) NO
type varchar(128) NO MUL NULL
execution_rules text YES NULL
cron_rules text YES NULL
state tinyint(4) NO MUL 0
last_exit_code int(11) NO MUL 0
last_execution datetime YES NULL
next_execution datetime YES MUL NULL
times_executed int(11) YES 0
times_failed int(11) YES 0
locked datetime YES MUL NULL
priority smallint(6) NO MUL 0
ordering int(11) NO 0
cli_exclusive smallint(6) NO MUL 0
params text NO NULL
note text YES NULL
created datetime NO NULL
created_by int(10) unsigned NO 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
▶ ocapfin_schemas 2 fields
Field Name Type Null Key Default Extra
extension_id int(11) NO NULL
version_id varchar(20) NO NULL
▶ ocapfin_session 7 fields
Field Name Type Null Key Default Extra
session_id varbinary(192) NO PRI NULL
client_id tinyint(3) unsigned YES MUL NULL
guest tinyint(3) unsigned YES 1
time int(11) NO MUL 0
data mediumtext YES NULL
userid int(11) YES MUL 0
username varchar(150) YES
▶ ocapfin_spmedia 14 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
title varchar(255) NO
path varchar(255) NO
thumb varchar(255) NO
alt varchar(255) NO
caption varchar(2048) NO
description mediumtext NO NULL
type varchar(100) NO image
media_attr varchar(5120) NO {}
extension varchar(100) NO
created_on datetime NO 0000-00-00 00:00:00
created_by bigint(20) NO 0
modified_on datetime NO 0000-00-00 00:00:00
modified_by bigint(20) NO 0
▶ ocapfin_sppagebuilder 25 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
asset_id int(11) NO 0
title varchar(255) NO
text mediumtext NO NULL
extension varchar(255) NO com_sppagebuilder
extension_view varchar(255) NO page
view_id bigint(20) NO 0
active tinyint(1) NO 0
published tinyint(3) NO 1
catid int(10) NO 0
access int(10) NO 0
ordering int(11) NO 0
created_on datetime NO 0000-00-00 00:00:00
created_by bigint(20) NO 0
modified datetime NO 0000-00-00 00:00:00
modified_by bigint(20) NO 0
checked_out int(10) NO 0
checked_out_time datetime NO 0000-00-00 00:00:00
attribs varchar(5120) NO []
og_title varchar(255) NO
og_image varchar(255) NO
og_description varchar(255) NO
language char(7) NO
hits bigint(20) NO 0
css longtext NO NULL
▶ ocapfin_sppagebuilder_addonlist 4 fields
Field Name Type Null Key Default Extra
id int(5) unsigned NO PRI NULL auto_increment
name varchar(255) NO NULL
ordering int(5) NO 0
status tinyint(1) NO 1
▶ ocapfin_sppagebuilder_addons 5 fields
Field Name Type Null Key Default Extra
id int(5) unsigned NO PRI NULL auto_increment
title varchar(255) NO
code mediumtext NO NULL
created datetime NO 0000-00-00 00:00:00
created_by bigint(20) NO 0
▶ ocapfin_sppagebuilder_assets 10 fields
Field Name Type Null Key Default Extra
id bigint(20) NO PRI NULL auto_increment
type varchar(100) NO
name varchar(100) NO
title varchar(255) NO
assets text NO NULL
css_path text YES NULL
created datetime NO NULL
created_by int(11) NO NULL
published tinyint(1) NO 1
access int(11) NO 0
▶ ocapfin_sppagebuilder_integrations 6 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
title varchar(255) NO
description mediumtext NO NULL
component varchar(255) NO
plugin mediumtext NO NULL
state tinyint(1) NO 0
▶ ocapfin_sppagebuilder_languages 7 fields
Field Name Type Null Key Default Extra
id int(5) unsigned NO PRI NULL auto_increment
title varchar(255) NO
description mediumtext NO NULL
lang_tag varchar(255) NO
lang_key varchar(100) YES NULL
version varchar(255) NO
state tinyint(1) NO 0
▶ ocapfin_sppagebuilder_sections 5 fields
Field Name Type Null Key Default Extra
id int(5) unsigned NO PRI NULL auto_increment
title varchar(255) NO
section mediumtext NO NULL
created datetime NO 0000-00-00 00:00:00
created_by bigint(20) NO 0
▶ ocapfin_spsimpleportfolio_items 22 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
alias varchar(55) NO NULL
catid int(11) NO NULL
image text NO NULL
thumbnail text NO NULL
video text NO NULL
description mediumtext YES NULL
client varchar(100) NO NULL
client_avatar text NO NULL
tagids text NO NULL
url text NO NULL
published tinyint(3) NO 1
language varchar(255) NO *
access int(5) NO 1
ordering int(10) NO 0
created_by bigint(20) NO 0
created datetime NO 0000-00-00 00:00:00
modified_by bigint(20) NO 0
modified datetime NO 0000-00-00 00:00:00
checked_out bigint(20) NO 0
checked_out_time datetime NO 0000-00-00 00:00:00
▶ ocapfin_spsimpleportfolio_tags 3 fields
Field Name Type Null Key Default Extra
id bigint(20) unsigned NO PRI NULL auto_increment
title varchar(255) NO NULL
alias varchar(55) NO NULL
▶ ocapfin_tags 30 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
parent_id int(10) unsigned NO 0
lft int(11) NO MUL 0
rgt int(11) NO 0
level int(10) unsigned NO 0
path varchar(400) NO MUL
title varchar(255) NO NULL
alias varchar(400) NO MUL
note varchar(255) NO
description longtext NO NULL
published tinyint(1) NO MUL 0
checked_out int(10) unsigned YES MUL NULL
checked_out_time datetime YES NULL
access int(10) unsigned NO MUL 0
params mediumtext NO NULL
metadesc varchar(1024) NO NULL
metakey varchar(1024) NO
metadata varchar(2048) NO NULL
created_user_id int(10) unsigned NO 0
created_time datetime NO NULL
created_by_alias varchar(255) NO
modified_user_id int(10) unsigned NO 0
modified_time datetime NO NULL
images mediumtext NO NULL
urls mediumtext NO NULL
hits int(10) unsigned NO 0
language char(7) NO MUL NULL
version int(10) unsigned NO 1
publish_up datetime YES NULL
publish_down datetime YES NULL
▶ ocapfin_template_overrides 9 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
template varchar(50) NO MUL
hash_id varchar(255) NO
extension_id int(11) YES MUL 0
state tinyint(4) NO 0
action varchar(50) NO
client_id tinyint(3) unsigned NO 0
created_date datetime NO NULL
modified_date datetime YES NULL
▶ ocapfin_template_styles 8 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
template varchar(50) NO MUL
client_id tinyint(1) unsigned NO MUL 0
home char(7) NO 0
title varchar(255) NO
params mediumtext NO NULL
inheritable tinyint(4) NO 0
parent varchar(50) YES
▶ ocapfin_ucm_base 4 fields
Field Name Type Null Key Default Extra
ucm_id int(10) unsigned NO PRI NULL
ucm_item_id int(10) NO MUL NULL
ucm_type_id int(11) NO MUL NULL
ucm_language_id int(11) NO MUL NULL
▶ ocapfin_ucm_content 32 fields
Field Name Type Null Key Default Extra
core_content_id int(10) unsigned NO PRI NULL auto_increment
core_type_alias varchar(400) NO MUL
core_title varchar(400) NO MUL
core_alias varchar(400) NO MUL
core_body longtext YES NULL
core_state tinyint(1) NO MUL 0
core_checked_out_time datetime YES NULL
core_checked_out_user_id int(10) unsigned YES MUL NULL
core_access int(10) unsigned NO MUL 0
core_params mediumtext YES NULL
core_featured tinyint(4) unsigned NO 0
core_metadata varchar(2048) NO
core_created_user_id int(10) unsigned NO MUL 0
core_created_by_alias varchar(255) NO
core_created_time datetime NO MUL NULL
core_modified_user_id int(10) unsigned NO MUL 0
core_modified_time datetime NO MUL NULL
core_language char(7) NO MUL
core_publish_up datetime YES NULL
core_publish_down datetime YES NULL
core_content_item_id int(10) unsigned NO 0
asset_id int(10) unsigned NO 0
core_images mediumtext YES NULL
core_urls mediumtext YES NULL
core_hits int(10) unsigned NO 0
core_version int(10) unsigned NO 1
core_ordering int(11) NO 0
core_metakey mediumtext YES NULL
core_metadesc mediumtext YES NULL
core_catid int(10) unsigned NO 0
core_xreference varchar(50) NO
core_type_id int(10) unsigned NO MUL 0
▶ ocapfin_update_sites 9 fields
Field Name Type Null Key Default Extra
update_site_id int(11) NO PRI NULL auto_increment
name varchar(100) YES
type varchar(20) YES
location mediumtext NO NULL
enabled int(11) YES 0
last_check_timestamp bigint(20) YES 0
extra_query varchar(1000) YES
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
▶ ocapfin_update_sites_extensions 2 fields
Field Name Type Null Key Default Extra
update_site_id int(11) NO PRI 0
extension_id int(11) NO PRI 0
▶ ocapfin_updates 15 fields
Field Name Type Null Key Default Extra
update_id int(11) NO PRI NULL auto_increment
update_site_id int(11) YES 0
extension_id int(11) YES 0
name varchar(100) YES
description mediumtext NO NULL
element varchar(100) YES
type varchar(20) YES
folder varchar(20) YES
client_id tinyint(3) YES 0
version varchar(32) YES
data mediumtext NO NULL
detailsurl mediumtext NO NULL
infourl mediumtext NO NULL
changelogurl text YES NULL
extra_query varchar(1000) YES
▶ ocapfin_user_keys 6 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
user_id varchar(150) NO MUL NULL
token varchar(255) NO NULL
series varchar(191) NO UNI NULL
time varchar(200) NO NULL
uastring varchar(255) NO NULL
▶ ocapfin_user_mfa 10 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
user_id int(10) unsigned NO MUL NULL
title varchar(255) NO
method varchar(100) NO NULL
default tinyint(4) NO 0
options mediumtext NO NULL
created_on datetime NO NULL
last_used datetime YES NULL
tries int(11) NO 0
last_try datetime YES NULL
▶ ocapfin_user_notes 15 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
user_id int(10) unsigned NO MUL 0
catid int(10) unsigned NO MUL 0
subject varchar(100) NO
body mediumtext NO NULL
state tinyint(3) NO 0
checked_out int(10) unsigned YES NULL
checked_out_time datetime YES NULL
created_user_id int(10) unsigned NO 0
created_time datetime NO NULL
modified_user_id int(10) unsigned NO 0
modified_time datetime NO NULL
review_time datetime YES NULL
publish_up datetime YES NULL
publish_down datetime YES NULL
▶ ocapfin_user_profiles 4 fields
Field Name Type Null Key Default Extra
user_id int(11) NO PRI NULL
profile_key varchar(100) NO PRI NULL
profile_value mediumtext NO NULL
ordering int(11) NO 0
▶ ocapfin_user_usergroup_map 2 fields
Field Name Type Null Key Default Extra
user_id int(10) unsigned NO PRI 0
group_id int(10) unsigned NO PRI 0
▶ ocapfin_usergroups 5 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
parent_id int(10) unsigned NO MUL 0
lft int(11) NO MUL 0
rgt int(11) NO 0
title varchar(100) NO MUL
▶ ocapfin_users 17 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
name varchar(400) NO MUL
username varchar(150) NO UNI
email varchar(100) NO MUL
password varchar(100) NO
block tinyint(4) NO MUL 0
sendEmail tinyint(4) YES 0
registerDate datetime NO NULL
lastvisitDate datetime YES NULL
activation varchar(100) NO
params mediumtext NO NULL
lastResetTime datetime YES NULL
resetCount int(11) NO 0
otpKey varchar(1000) NO
otep varchar(1000) NO
requireReset tinyint(4) NO 0
authProvider varchar(100) NO
▶ ocapfin_viewlevels 4 fields
Field Name Type Null Key Default Extra
id int(10) unsigned NO PRI NULL auto_increment
title varchar(100) NO UNI
ordering int(11) NO 0
rules varchar(5120) NO NULL
▶ ocapfin_virtuemart_adminmenuentries 13 fields
Field Name Type Null Key Default Extra
id tinyint(1) unsigned NO PRI NULL auto_increment
module_id tinyint(1) unsigned NO MUL 0
parent_id tinyint(1) unsigned NO 0
name char(64) NO 0
link char(64) NO 0
depends char(64) NO
icon_class char(96) YES NULL
uikit_icon char(96) YES NULL
ordering int(1) NO MUL 0
published tinyint(1) NO MUL 1
tooltip char(128) YES NULL
view char(32) YES NULL
task char(32) YES NULL
▶ ocapfin_virtuemart_calc_categories 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_calc_id int(1) unsigned NO MUL 0
virtuemart_category_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_calc_countries 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_calc_id int(1) unsigned NO MUL 0
virtuemart_country_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_calc_manufacturers 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_calc_id int(1) unsigned NO MUL 0
virtuemart_manufacturer_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_calc_shoppergroups 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_calc_id int(1) unsigned NO MUL 0
virtuemart_shoppergroup_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_calc_states 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_calc_id int(1) unsigned NO MUL 0
virtuemart_state_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_calcs 29 fields
Field Name Type Null Key Default Extra
virtuemart_calc_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
calc_jplugin_id int(1) NO 0
calc_name varchar(64) NO
calc_descr varchar(128) NO
calc_kind varchar(16) NO MUL
calc_value_mathop varchar(8) NO
calc_value decimal(10,4) NO 0.0000
calc_currency smallint(1) unsigned NO 0
calc_shopper_published tinyint(1) NO 0
calc_vendor_published tinyint(1) NO 0
publish_up datetime YES MUL NULL
publish_down datetime YES MUL NULL
for_override tinyint(1) NO 0
has_categories tinyint(1) YES NULL
has_shoppergroups tinyint(1) YES NULL
has_manufacturers tinyint(1) YES NULL
has_countries tinyint(1) YES NULL
has_states tinyint(1) YES NULL
calc_params varchar(15359) NO
ordering int(1) NO 0
shared tinyint(1) NO MUL 0
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_carts 8 fields
Field Name Type Null Key Default Extra
virtuemart_cart_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_user_id int(1) unsigned NO MUL NULL
virtuemart_vendor_id int(1) unsigned NO MUL NULL
cartData varbinary(50000) YES NULL
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
▶ ocapfin_virtuemart_categories 24 fields
Field Name Type Null Key Default Extra
virtuemart_category_id int(1) unsigned NO PRI NULL auto_increment
category_parent_id int(1) unsigned YES MUL NULL
virtuemart_vendor_id int(1) unsigned NO MUL 1
category_template varchar(128) YES NULL
category_layout varchar(64) YES NULL
category_product_layout varchar(64) YES NULL
products_per_row varchar(1) NO
limit_list_step varchar(32) YES NULL
limit_list_initial smallint(1) unsigned YES NULL
hits int(1) unsigned NO 0
cat_params varchar(15359) NO
metarobot varchar(40) NO
metaauthor varchar(64) NO
ordering int(1) NO MUL 0
shared tinyint(1) NO MUL 0
published tinyint(1) NO MUL 1
has_children tinyint(1) YES NULL
has_medias tinyint(1) YES NULL
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_categories_en_gb 7 fields
Field Name Type Null Key Default Extra
virtuemart_category_id int(1) unsigned NO PRI NULL
category_name varchar(180) NO
category_description text YES NULL
metadesc varchar(400) NO
metakey varchar(400) NO
customtitle varchar(255) NO
slug varchar(191) NO UNI
▶ ocapfin_virtuemart_category_categories 4 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
category_parent_id int(1) unsigned NO MUL 0
category_child_id int(1) unsigned NO MUL 0
ordering int(1) NO MUL 0
▶ ocapfin_virtuemart_category_medias 4 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_category_id int(1) unsigned NO MUL 0
virtuemart_media_id int(1) unsigned NO MUL 0
ordering int(1) NO 0
▶ ocapfin_virtuemart_configs 8 fields
Field Name Type Null Key Default Extra
virtuemart_config_id tinyint(1) unsigned NO PRI NULL auto_increment
config text YES NULL
created_on datetime NO 0000-00-00 00:00:00
created_by int(11) NO 0
modified_on datetime NO 0000-00-00 00:00:00
modified_by int(11) NO 0
locked_on datetime NO 0000-00-00 00:00:00
locked_by int(11) NO 0
▶ ocapfin_virtuemart_countries 14 fields
Field Name Type Null Key Default Extra
virtuemart_country_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_worldzone_id tinyint(1) NO 1
country_name varchar(64) YES MUL NULL
country_3_code char(3) YES MUL NULL
country_2_code char(2) YES MUL NULL
country_num_code char(3) YES UNI NULL
ordering int(1) NO MUL 0
published tinyint(1) NO MUL 0
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_coupons 23 fields
Field Name Type Null Key Default Extra
virtuemart_coupon_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL NULL
coupon_code varchar(32) NO MUL
percent_or_total enum('percent','total') NO percent
coupon_type enum('gift','permanent') NO MUL gift
coupon_value decimal(15,5) NO 0.00000
coupon_start_date datetime YES NULL
coupon_expiry_date datetime YES NULL
coupon_value_valid decimal(15,5) NO 0.00000
coupon_used varchar(200) NO
coupon_value_max decimal(15,5) NO 0.00000
virtuemart_shoppergroup_ids text YES NULL
virtuemart_shopper_ids text YES NULL
virtuemart_product_ids text YES NULL
virtuemart_category_ids text YES NULL
virtuemart_coupon_max_attempt_per_user tinyint(4) NO NULL
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_currencies 22 fields
Field Name Type Null Key Default Extra
virtuemart_currency_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
currency_name varchar(64) YES MUL NULL
currency_code_2 char(2) YES NULL
currency_code_3 char(3) YES UNI NULL
currency_numeric_code int(4) YES MUL NULL
currency_exchange_rate decimal(12,5) YES NULL
currency_symbol varchar(8) YES NULL
currency_decimal_place varchar(8) YES NULL
currency_decimal_symbol varchar(8) YES NULL
currency_thousands varchar(8) YES NULL
currency_positive_style varchar(64) YES NULL
currency_negative_style varchar(64) YES NULL
ordering int(1) NO MUL 0
shared tinyint(1) NO MUL 1
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_customs 29 fields
Field Name Type Null Key Default Extra
virtuemart_custom_id int(1) unsigned NO PRI NULL auto_increment
custom_parent_id int(1) unsigned NO MUL 0
virtuemart_vendor_id int(1) unsigned NO MUL 1
custom_jplugin_id int(1) NO 0
custom_element varchar(50) NO MUL
admin_only tinyint(1) NO 0
custom_title varchar(255) NO
show_title tinyint(1) NO 1
custom_tip varchar(255) NO
custom_value varchar(4095) YES NULL
custom_desc varchar(4095) YES NULL
field_type varchar(2) NO MUL 0
is_list tinyint(1) NO 0
is_hidden tinyint(1) NO 0
is_cart_attribute tinyint(1) NO MUL 0
is_input tinyint(1) NO MUL 0
searchable tinyint(1) NO MUL 0
layout_pos varchar(24) YES NULL
custom_params text YES NULL
virtuemart_shoppergroup_id varchar(255) NO NULL
shared tinyint(1) NO MUL 0
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
ordering int(1) NO MUL 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_invoices 14 fields
Field Name Type Null Key Default Extra
virtuemart_invoice_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
virtuemart_order_id int(1) unsigned YES MUL NULL
invoice_number varchar(64) YES MUL NULL
order_status char(3) YES NULL
xhtml text YES NULL
o_hash varchar(33) YES NULL
created_on datetime YES NULL
inv_hash varchar(33) YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_manufacturer_medias 4 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_manufacturer_id int(1) unsigned NO MUL 0
virtuemart_media_id int(1) unsigned NO MUL 0
ordering int(1) NO MUL 0
▶ ocapfin_virtuemart_manufacturercategories 8 fields
Field Name Type Null Key Default Extra
virtuemart_manufacturercategories_id int(1) unsigned NO PRI NULL auto_increment
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_manufacturercategories_en_gb 4 fields
Field Name Type Null Key Default Extra
virtuemart_manufacturercategories_id int(1) unsigned NO PRI NULL
mf_category_name varchar(180) NO
mf_category_desc text YES NULL
slug varchar(191) NO UNI
▶ ocapfin_virtuemart_manufacturers 12 fields
Field Name Type Null Key Default Extra
virtuemart_manufacturer_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_manufacturercategories_id int(1) YES NULL
metarobot varchar(400) YES NULL
metaauthor varchar(400) YES NULL
hits int(1) unsigned NO 0
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_manufacturers_en_gb 9 fields
Field Name Type Null Key Default Extra
virtuemart_manufacturer_id int(1) unsigned NO PRI NULL
mf_name varchar(180) NO
mf_email varchar(255) NO
mf_desc text YES NULL
mf_url varchar(255) NO
metadesc varchar(400) NO
metakey varchar(400) NO
customtitle varchar(255) NO
slug varchar(191) NO UNI
▶ ocapfin_virtuemart_medias 23 fields
Field Name Type Null Key Default Extra
virtuemart_media_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
file_title varchar(126) NO
file_description varchar(254) NO
file_meta varchar(254) NO
file_class varchar(64) NO
file_mimetype varchar(64) NO
file_type varchar(32) NO MUL
file_url varchar(900) NO
file_url_thumb varchar(900) NO
file_is_product_image tinyint(1) NO 0
file_is_downloadable tinyint(1) NO 0
file_is_forSale tinyint(1) NO 0
file_params varchar(12287) NO
file_lang varchar(500) NO
shared tinyint(1) NO MUL 0
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_migration_oldtonew_ids 13 fields
Field Name Type Null Key Default Extra
id smallint(1) unsigned NO PRI NULL auto_increment
cats longblob YES NULL
catsxref blob YES NULL
manus longblob YES NULL
mfcats blob YES NULL
shoppergroups longblob YES NULL
products longblob YES NULL
products_start int(1) YES NULL
orderstates blob YES NULL
orders longblob YES NULL
attributes longblob YES NULL
relatedproducts longblob YES NULL
orders_start int(1) YES NULL
▶ ocapfin_virtuemart_modules 7 fields
Field Name Type Null Key Default Extra
module_id int(1) unsigned NO PRI NULL auto_increment
module_name char(191) YES MUL NULL
module_description varchar(15359) YES NULL
module_perms char(191) YES NULL
published tinyint(1) NO MUL 1
is_admin enum('0','1') NO 0
ordering int(1) NO MUL 0
▶ ocapfin_virtuemart_order_calc_rules 19 fields
Field Name Type Null Key Default Extra
virtuemart_order_calc_rule_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_calc_id int(1) unsigned YES MUL NULL
virtuemart_order_id int(1) unsigned YES MUL NULL
virtuemart_vendor_id int(1) unsigned NO MUL 1
virtuemart_order_item_id int(1) YES NULL
calc_rule_name varchar(64) NO
calc_kind varchar(16) NO
calc_mathop varchar(16) NO
calc_amount decimal(15,5) NO 0.00000
calc_result decimal(15,5) NO 0.00000
calc_value decimal(15,5) NO 0.00000
calc_currency int(1) YES NULL
calc_params varchar(15359) NO
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_order_histories 14 fields
Field Name Type Null Key Default Extra
virtuemart_order_history_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_order_id int(1) unsigned NO MUL 0
order_status_code char(1) NO 0
customer_notified tinyint(1) NO 0
comments varchar(15359) YES NULL
paid decimal(15,5) NO 0.00000
o_hash varchar(33) YES NULL
created_on datetime YES NULL
published tinyint(1) NO 1
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_order_item_histories 29 fields
Field Name Type Null Key Default Extra
virtuemart_order_item_history_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_order_item_id int(1) unsigned NO NULL
virtuemart_order_id int(1) unsigned YES MUL NULL
virtuemart_vendor_id int(1) unsigned NO 1
virtuemart_product_id int(1) YES NULL
action varchar(191) NO
order_item_sku varchar(255) NO
order_item_name varchar(4096) NO
product_quantity int(1) YES NULL
product_item_price decimal(15,5) YES NULL
product_priceWithoutTax decimal(15,5) YES NULL
product_tax decimal(15,5) YES NULL
product_basePriceWithTax decimal(15,5) YES NULL
product_discountedPriceWithoutTax decimal(15,5) YES NULL
product_final_price decimal(15,5) NO 0.00000
product_subtotal_discount decimal(15,5) NO 0.00000
product_subtotal_with_tax decimal(15,5) NO 0.00000
order_item_currency int(1) YES NULL
order_status char(3) YES NULL
product_attribute mediumtext YES NULL
delivery_date varchar(200) YES NULL
paid decimal(15,5) NO 0.00000
oi_hash varchar(33) YES NULL
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_order_items 27 fields
Field Name Type Null Key Default Extra
virtuemart_order_item_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_order_id int(1) unsigned YES MUL NULL
virtuemart_vendor_id int(1) unsigned NO MUL 1
virtuemart_product_id int(1) YES MUL NULL
order_item_sku varchar(255) NO
order_item_name varchar(4096) NO
product_quantity int(1) YES NULL
product_item_price decimal(15,5) YES NULL
product_priceWithoutTax decimal(15,5) YES NULL
product_tax decimal(15,5) YES NULL
product_basePriceWithTax decimal(15,5) YES NULL
product_discountedPriceWithoutTax decimal(15,5) YES NULL
product_final_price decimal(15,5) NO 0.00000
product_subtotal_discount decimal(15,5) NO 0.00000
product_subtotal_with_tax decimal(15,5) NO 0.00000
order_item_currency int(1) YES NULL
order_status char(3) YES MUL NULL
product_attribute mediumtext YES NULL
delivery_date varchar(200) YES NULL
paid decimal(15,5) NO 0.00000
oi_hash varchar(33) YES NULL
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_order_userinfos 29 fields
Field Name Type Null Key Default Extra
virtuemart_order_userinfo_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_order_id int(1) unsigned NO MUL 0
virtuemart_user_id int(1) unsigned NO MUL 0
address_type char(2) YES MUL NULL
address_type_name varchar(32) YES NULL
company varchar(64) YES NULL
title varchar(32) YES NULL
last_name varchar(96) YES NULL
first_name varchar(96) YES NULL
middle_name varchar(96) YES NULL
phone_1 varchar(32) YES NULL
phone_2 varchar(32) YES NULL
fax varchar(32) YES NULL
address_1 varchar(96) NO
address_2 varchar(64) YES NULL
city varchar(96) NO
virtuemart_state_id smallint(1) unsigned NO 0
virtuemart_country_id smallint(1) unsigned NO 0
zip varchar(32) NO
email varchar(128) YES NULL
agreed tinyint(1) NO 0
tos tinyint(1) NO 0
customer_note varchar(5000) NO
created_on datetime NO 0000-00-00 00:00:00
created_by int(1) NO 0
modified_on datetime NO 0000-00-00 00:00:00
modified_by int(1) NO 0
locked_on datetime NO 0000-00-00 00:00:00
locked_by int(1) NO 0
▶ ocapfin_virtuemart_orders 46 fields
Field Name Type Null Key Default Extra
virtuemart_order_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_user_id int(1) unsigned NO MUL 0
virtuemart_vendor_id int(1) unsigned NO MUL 0
order_note varchar(5000) YES NULL
order_number varchar(64) YES MUL NULL
customer_number varchar(32) YES NULL
order_pass varchar(34) YES NULL
order_create_invoice_pass varchar(32) YES NULL
invoice_locked tinyint(1) NO 0
order_total decimal(15,5) NO 0.00000
order_salesPrice decimal(15,5) NO 0.00000
order_billTaxAmount decimal(15,5) NO 0.00000
order_billTax varchar(400) YES NULL
order_billDiscountAmount decimal(15,5) NO 0.00000
order_discountAmount decimal(15,5) NO 0.00000
order_subtotal decimal(15,5) YES NULL
order_tax decimal(12,5) YES NULL
order_shipment decimal(12,5) YES NULL
order_shipment_tax decimal(10,5) YES NULL
order_payment decimal(12,2) YES NULL
order_payment_tax decimal(10,5) YES NULL
coupon_discount decimal(12,2) NO 0.00
coupon_code varchar(32) YES NULL
order_discount decimal(12,2) NO 0.00
order_currency smallint(1) YES NULL
order_status char(3) YES MUL NULL
user_currency_id smallint(1) YES NULL
user_currency_rate decimal(12,6) NO 1.000000
user_shoppergroups varchar(30) YES NULL
payment_currency_id smallint(1) YES NULL
payment_currency_rate decimal(12,6) NO 1.000000
virtuemart_paymentmethod_id int(1) unsigned YES MUL NULL
virtuemart_shipmentmethod_id int(1) unsigned YES MUL NULL
delivery_date varchar(200) YES NULL
order_language varchar(7) YES NULL
ip_address char(45) NO
STsameAsBT tinyint(1) NO 0
paid decimal(15,5) NO 0.00000
paid_on datetime YES NULL
o_hash varchar(33) YES NULL
created_on datetime YES MUL NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_orderstates 16 fields
Field Name Type Null Key Default Extra
virtuemart_orderstate_id tinyint(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
order_status_code char(3) NO UNI
order_status_name varchar(64) YES NULL
order_status_color varchar(64) YES NULL
order_status_description varchar(12359) YES NULL
order_stock_handle char(1) NO A
order_status_email_layout varchar(128) NO
ordering int(1) NO MUL 0
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_payment_plg_paypal 45 fields
Field Name Type Null Key Default Extra
id int(11) unsigned NO PRI NULL auto_increment
virtuemart_order_id int(1) unsigned YES NULL
order_number char(64) YES NULL
virtuemart_paymentmethod_id mediumint(1) unsigned YES NULL
payment_name varchar(5000) YES NULL
payment_order_total decimal(15,5) NO NULL
payment_currency smallint(1) YES NULL
email_currency smallint(1) YES NULL
cost_per_transaction decimal(10,2) YES NULL
cost_percent_total decimal(10,2) YES NULL
tax_id smallint(1) YES NULL
paypal_custom varchar(255) YES NULL
paypal_method varchar(200) YES NULL
paypal_response_mc_gross decimal(10,2) YES NULL
paypal_response_mc_currency char(10) YES NULL
paypal_response_invoice char(32) YES NULL
paypal_response_protection_eligibility char(128) YES NULL
paypal_response_payer_id char(13) YES NULL
paypal_response_tax decimal(10,2) YES NULL
paypal_response_payment_date char(28) YES NULL
paypal_response_payment_status char(50) YES NULL
paypal_response_pending_reason char(50) YES NULL
paypal_response_mc_fee decimal(10,2) YES NULL
paypal_response_payer_email char(128) YES NULL
paypal_response_last_name char(64) YES NULL
paypal_response_first_name char(64) YES NULL
paypal_response_business char(128) YES NULL
paypal_response_receiver_email char(128) YES NULL
paypal_response_transaction_subject char(128) YES NULL
paypal_response_residence_country char(2) YES NULL
paypal_response_txn_id char(32) YES NULL
paypal_response_txn_type char(32) YES NULL
paypal_response_parent_txn_id char(32) YES NULL
paypal_response_case_creation_date char(32) YES NULL
paypal_response_case_id char(32) YES NULL
paypal_response_case_type char(32) YES NULL
paypal_response_reason_code char(32) YES NULL
paypalresponse_raw varchar(512) YES NULL
paypal_fullresponse text YES NULL
created_on datetime YES NULL
created_by int(11) NO 0
modified_on datetime YES NULL
modified_by int(11) NO 0
locked_on datetime YES NULL
locked_by int(11) NO 0
▶ ocapfin_virtuemart_payment_plg_standard 18 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_order_id int(1) unsigned YES NULL
order_number char(64) YES NULL
virtuemart_paymentmethod_id mediumint(1) unsigned YES NULL
payment_name varchar(5000) YES NULL
payment_order_total decimal(15,5) NO 0.00000
payment_currency char(3) YES NULL
email_currency char(3) YES NULL
cost_per_transaction decimal(10,2) YES NULL
cost_min_transaction decimal(10,2) YES NULL
cost_percent_total decimal(10,2) YES NULL
tax_id smallint(1) YES NULL
created_on datetime YES NULL
created_by int(11) NO 0
modified_on datetime YES NULL
modified_by int(11) NO 0
locked_on datetime YES NULL
locked_by int(11) NO 0
▶ ocapfin_virtuemart_paymentmethod_shoppergroups 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_paymentmethod_id int(1) unsigned NO MUL 0
virtuemart_shoppergroup_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_paymentmethods 15 fields
Field Name Type Null Key Default Extra
virtuemart_paymentmethod_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
payment_jplugin_id int(1) NO MUL 0
payment_element varchar(50) NO MUL
payment_params text YES NULL
currency_id int(1) unsigned YES NULL
shared tinyint(1) NO 0
ordering int(1) NO MUL 0
published tinyint(1) NO 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_paymentmethods_en_gb 4 fields
Field Name Type Null Key Default Extra
virtuemart_paymentmethod_id int(1) unsigned NO PRI NULL
payment_name varchar(180) NO
payment_desc text YES NULL
slug varchar(191) NO UNI
▶ ocapfin_virtuemart_product_categories 4 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_product_id int(1) unsigned NO MUL 0
virtuemart_category_id int(1) unsigned NO MUL 0
ordering int(1) NO MUL 0
▶ ocapfin_virtuemart_product_customfields 20 fields
Field Name Type Null Key Default Extra
virtuemart_customfield_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_product_id int(1) NO MUL 0
virtuemart_custom_id int(1) NO MUL 1
customfield_value varchar(2500) YES MUL NULL
customfield_price decimal(15,6) YES NULL
disabler int(1) unsigned NO 0
override int(1) unsigned NO 0
noninheritable int(1) unsigned NO 0
customfield_params text YES NULL
product_sku varchar(64) YES NULL
product_gtin varchar(64) YES NULL
product_mpn varchar(64) YES NULL
published tinyint(1) NO MUL 1
created_on datetime NO 0000-00-00 00:00:00
created_by int(1) unsigned NO 0
modified_on datetime NO 0000-00-00 00:00:00
modified_by int(1) unsigned NO 0
locked_on datetime NO 0000-00-00 00:00:00
locked_by int(1) unsigned NO 0
ordering int(1) NO MUL 0
▶ ocapfin_virtuemart_product_manufacturers 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_product_id int(1) YES MUL NULL
virtuemart_manufacturer_id int(1) unsigned YES MUL NULL
▶ ocapfin_virtuemart_product_medias 4 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_product_id int(1) unsigned NO MUL 0
virtuemart_media_id int(1) unsigned NO MUL 0
ordering int(1) NO 0
▶ ocapfin_virtuemart_product_prices 19 fields
Field Name Type Null Key Default Extra
virtuemart_product_price_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_product_id int(1) unsigned NO MUL 0
virtuemart_shoppergroup_id int(1) unsigned NO MUL 0
product_price decimal(15,6) YES MUL NULL
override tinyint(1) YES NULL
product_override_price decimal(15,5) YES NULL
product_tax_id int(1) YES NULL
product_discount_id int(1) YES NULL
product_currency smallint(1) YES NULL
product_price_publish_up datetime YES MUL NULL
product_price_publish_down datetime YES MUL NULL
price_quantity_start int(1) unsigned NO MUL 0
price_quantity_end int(1) unsigned NO MUL 0
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_product_shoppergroups 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_product_id int(1) unsigned NO MUL 0
virtuemart_shoppergroup_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_products 44 fields
Field Name Type Null Key Default Extra
virtuemart_product_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
product_parent_id int(1) unsigned NO MUL 0
product_sku varchar(192) YES MUL NULL
product_gtin varchar(64) YES NULL
product_mpn varchar(64) YES NULL
product_weight decimal(10,4) YES NULL
product_weight_uom varchar(7) YES NULL
product_length decimal(10,4) YES NULL
product_width decimal(10,4) YES NULL
product_height decimal(10,4) YES NULL
product_lwh_uom varchar(7) YES NULL
product_url varchar(255) YES NULL
product_in_stock int(1) NO MUL 0
product_ordered int(1) NO MUL 0
product_stockhandle varchar(24) NO 0
low_stock_notification int(1) unsigned NO 0
product_available_date datetime YES NULL
product_availability varchar(32) YES NULL
product_special tinyint(1) NO MUL 0
product_discontinued tinyint(1) NO MUL 0
product_sales int(1) NO 0
product_unit varchar(8) YES NULL
product_packaging decimal(8,4) unsigned YES NULL
product_params varchar(255) NO NULL
product_canon_category_id int(1) YES NULL
hits int(1) unsigned YES NULL
intnotes text YES NULL
metarobot varchar(400) YES NULL
metaauthor varchar(400) YES NULL
layout varchar(16) YES NULL
published tinyint(1) NO MUL 0
pordering int(1) unsigned NO MUL 0
has_categories tinyint(1) YES NULL
has_manufacturers tinyint(1) YES NULL
has_medias tinyint(1) YES NULL
has_prices tinyint(1) YES NULL
has_shoppergroups tinyint(1) YES NULL
created_on datetime YES MUL NULL
created_by int(1) NO 0
modified_on datetime YES MUL NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_products_en_gb 8 fields
Field Name Type Null Key Default Extra
virtuemart_product_id int(1) unsigned NO PRI NULL
product_s_desc varchar(2000) NO
product_desc text YES NULL
product_name varchar(180) NO
metadesc varchar(400) NO
metakey varchar(400) NO
customtitle varchar(255) NO
slug varchar(191) NO UNI
▶ ocapfin_virtuemart_rating_reviews 19 fields
Field Name Type Null Key Default Extra
virtuemart_rating_review_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_rating_vote_id int(1) unsigned YES MUL NULL
virtuemart_product_id int(1) unsigned NO MUL 0
comment varchar(15359) YES NULL
review_ok tinyint(1) NO 0
review_rates int(1) unsigned NO 0
review_ratingcount int(1) unsigned NO 0
review_rating decimal(10,2) NO 0.00
review_language varchar(10) YES NULL
review_editable tinyint(1) NO 1
lastip char(50) NO 0
published tinyint(1) NO MUL 1
customer varchar(128) NO
created_on datetime YES MUL NULL
created_by int(1) NO MUL 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_rating_votes 8 fields
Field Name Type Null Key Default Extra
virtuemart_rating_vote_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_product_id int(1) unsigned NO MUL 0
vote int(1) NO 0
lastip char(50) NO 0
created_on datetime YES MUL NULL
created_by int(1) NO MUL 0
modified_on datetime YES NULL
modified_by int(1) NO 0
▶ ocapfin_virtuemart_ratings 10 fields
Field Name Type Null Key Default Extra
virtuemart_rating_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_product_id int(1) unsigned NO MUL 0
rates int(1) NO 0
ratingcount int(1) unsigned NO 0
rating decimal(10,1) NO 0.0
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
▶ ocapfin_virtuemart_shipment_plg_weight_countries 16 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_order_id int(11) unsigned YES NULL
order_number char(32) YES NULL
virtuemart_shipmentmethod_id mediumint(1) unsigned YES NULL
shipment_name varchar(5000) YES NULL
order_weight decimal(10,4) YES NULL
shipment_weight_unit char(3) YES KG
shipment_cost decimal(10,2) YES NULL
shipment_package_fee decimal(10,2) YES NULL
tax_id smallint(1) YES NULL
created_on datetime YES NULL
created_by int(11) NO 0
modified_on datetime YES NULL
modified_by int(11) NO 0
locked_on datetime YES NULL
locked_by int(11) NO 0
▶ ocapfin_virtuemart_shipmentmethod_shoppergroups 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_shipmentmethod_id int(1) unsigned NO MUL 0
virtuemart_shoppergroup_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_shipmentmethods 15 fields
Field Name Type Null Key Default Extra
virtuemart_shipmentmethod_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO 1
shipment_jplugin_id int(1) NO MUL 0
shipment_element varchar(50) NO MUL
shipment_params text YES NULL
currency_id int(1) unsigned YES NULL
ordering int(1) NO MUL 0
shared tinyint(1) NO 0
published tinyint(1) NO 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_shipmentmethods_en_gb 4 fields
Field Name Type Null Key Default Extra
virtuemart_shipmentmethod_id int(1) unsigned NO PRI NULL
shipment_name varchar(180) NO
shipment_desc text YES NULL
slug varchar(191) NO UNI
▶ ocapfin_virtuemart_shoppergroups 17 fields
Field Name Type Null Key Default Extra
virtuemart_shoppergroup_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
shopper_group_name varchar(128) YES MUL NULL
shopper_group_desc varchar(255) YES NULL
custom_price_display tinyint(1) NO 0
price_display blob NO NULL
default tinyint(1) NO 0
sgrp_additional tinyint(1) NO 0
ordering int(1) NO MUL 0
shared tinyint(1) NO MUL 0
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_states 16 fields
Field Name Type Null Key Default Extra
virtuemart_state_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
virtuemart_country_id int(1) unsigned NO MUL 0
virtuemart_worldzone_id int(1) unsigned NO 0
state_name varchar(64) YES NULL
state_3_code char(3) YES NULL
state_2_code char(2) YES NULL
ordering int(1) NO MUL 0
shared tinyint(1) NO MUL 1
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_userfield_values 12 fields
Field Name Type Null Key Default Extra
virtuemart_userfield_value_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_userfield_id int(1) unsigned NO MUL 0
fieldtitle varchar(255) NO
fieldvalue varchar(255) NO
sys tinyint(4) NO 0
ordering int(1) NO 0
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_userfields 32 fields
Field Name Type Null Key Default Extra
virtuemart_userfield_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 1
userfield_jplugin_id int(1) NO 0
name varchar(250) NO UNI
title varchar(255) NO
description varchar(2048) YES NULL
type varchar(70) NO
maxlength int(1) YES NULL
size int(1) YES NULL
required tinyint(4) NO 0
cols int(1) YES NULL
rows int(1) YES NULL
value varchar(255) YES NULL
default varchar(255) YES NULL
placeholder varchar(255) YES NULL
registration tinyint(1) NO 0
shipment tinyint(1) NO MUL 0
account tinyint(1) NO MUL 1
cart tinyint(1) NO MUL 0
readonly tinyint(1) NO 0
calculated tinyint(1) NO 0
sys tinyint(4) NO 0
userfield_params text YES NULL
ordering int(1) NO MUL 0
shared tinyint(1) NO MUL 0
published tinyint(1) NO MUL 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_userinfos 27 fields
Field Name Type Null Key Default Extra
virtuemart_userinfo_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_user_id int(1) unsigned NO MUL 0
address_type char(2) NO MUL
address_type_name varchar(32) NO MUL
company varchar(64) YES NULL
title varchar(32) YES NULL
last_name varchar(96) YES NULL
first_name varchar(96) YES NULL
middle_name varchar(96) YES NULL
phone_1 varchar(32) YES NULL
phone_2 varchar(32) YES NULL
fax varchar(32) YES NULL
address_1 varchar(96) NO
address_2 varchar(64) YES NULL
city varchar(96) NO
virtuemart_state_id smallint(1) unsigned NO 0
virtuemart_country_id smallint(1) unsigned NO 0
zip varchar(32) NO
agreed tinyint(1) NO 0
tos tinyint(1) NO 0
customer_note varchar(5000) NO
created_on datetime NO 0000-00-00 00:00:00
created_by int(1) NO 0
modified_on datetime NO 0000-00-00 00:00:00
modified_by int(1) NO 0
locked_on datetime NO 0000-00-00 00:00:00
locked_by int(1) NO 0
▶ ocapfin_virtuemart_vendor_medias 4 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 0
virtuemart_media_id int(1) unsigned NO 0
ordering int(1) NO 0
▶ ocapfin_virtuemart_vendor_users 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_user_id int(1) unsigned NO MUL 0
virtuemart_user_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_vendors 13 fields
Field Name Type Null Key Default Extra
virtuemart_vendor_id int(1) unsigned NO PRI NULL auto_increment
vendor_name varchar(64) YES MUL NULL
vendor_currency int(1) YES MUL NULL
vendor_accepted_currencies varchar(1536) NO
vendor_params varchar(14335) NO
metarobot varchar(20) YES NULL
metaauthor varchar(64) YES NULL
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_vendors_en_gb 19 fields
Field Name Type Null Key Default Extra
virtuemart_vendor_id int(1) unsigned NO PRI NULL
vendor_store_desc text YES NULL
vendor_terms_of_service mediumtext YES NULL
vendor_legal_info text YES NULL
vendor_letter_css text YES NULL
vendor_letter_header_html varchar(6500) NO <H1>{VM:VENDORNAME}</H1><P>{VM:VENDORADDRESS}</P>
vendor_letter_footer_html varchar(6500) NO <P>{VM:VENDORLEGALINFO}<BR />PAGE {VM:PAGENUM}/{VM:PAGECOUNT}</P>
vendor_store_name varchar(180) NO
vendor_phone varchar(26) NO
vendor_url varchar(255) NO
metadesc varchar(400) NO
metakey varchar(400) NO
customtitle varchar(255) NO
vendor_invoice_free1 varchar(255) NO
vendor_invoice_free2 varchar(255) NO
vendor_mail_free1 varchar(255) NO
vendor_mail_free2 varchar(255) NO
vendor_mail_css varchar(255) NO
slug varchar(191) NO UNI
▶ ocapfin_virtuemart_vmuser_shoppergroups 3 fields
Field Name Type Null Key Default Extra
id int(1) unsigned NO PRI NULL auto_increment
virtuemart_user_id int(1) unsigned NO MUL 0
virtuemart_shoppergroup_id int(1) unsigned NO 0
▶ ocapfin_virtuemart_vmusers 13 fields
Field Name Type Null Key Default Extra
virtuemart_user_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned NO MUL 0
user_is_vendor tinyint(1) NO MUL 0
customer_number varchar(32) YES NULL
virtuemart_paymentmethod_id int(1) unsigned YES NULL
virtuemart_shipmentmethod_id int(1) unsigned YES NULL
agreed tinyint(1) NO 0
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_waitingusers 13 fields
Field Name Type Null Key Default Extra
virtuemart_waitinguser_id int(1) unsigned NO PRI NULL auto_increment
virtuemart_product_id int(1) unsigned NO MUL 0
virtuemart_user_id int(1) unsigned NO 0
notify_email varchar(150) NO MUL
notified tinyint(1) NO 0
notify_date timestamp NO current_timestamp() on update current_timestamp()
ordering int(1) NO 0
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_virtuemart_worldzones 16 fields
Field Name Type Null Key Default Extra
virtuemart_worldzone_id smallint(1) unsigned NO PRI NULL auto_increment
virtuemart_vendor_id int(1) unsigned YES MUL NULL
zone_name varchar(255) YES NULL
zone_cost decimal(10,2) YES NULL
zone_limit decimal(10,2) YES NULL
zone_description varchar(14335) YES NULL
zone_tax_rate int(1) unsigned NO 0
ordering int(1) NO 0
shared tinyint(1) NO 0
published tinyint(1) NO 1
created_on datetime YES NULL
created_by int(1) NO 0
modified_on datetime YES NULL
modified_by int(1) NO 0
locked_on datetime YES NULL
locked_by int(1) NO 0
▶ ocapfin_webauthn_credentials 4 fields
Field Name Type Null Key Default Extra
id varchar(1000) NO PRI NULL
user_id varchar(128) NO MUL NULL
label varchar(190) NO NULL
credential mediumtext NO NULL
▶ ocapfin_workflow_associations 3 fields
Field Name Type Null Key Default Extra
item_id int(11) NO PRI 0
stage_id int(11) NO MUL NULL
extension varchar(50) NO PRI NULL
▶ ocapfin_workflow_stages 10 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(11) YES MUL 0
ordering int(11) NO 0
workflow_id int(11) NO MUL NULL
published tinyint(4) NO 0
title varchar(255) NO MUL NULL
description text NO NULL
default tinyint(4) NO MUL 0
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES MUL NULL
▶ ocapfin_workflow_transitions 12 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(11) YES MUL 0
ordering int(11) NO 0
workflow_id int(11) NO MUL NULL
published tinyint(4) NO 0
title varchar(255) NO MUL NULL
description text NO NULL
from_stage_id int(11) NO MUL NULL
to_stage_id int(11) NO MUL NULL
options text NO NULL
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES MUL NULL
▶ ocapfin_workflows 14 fields
Field Name Type Null Key Default Extra
id int(11) NO PRI NULL auto_increment
asset_id int(11) YES MUL 0
published tinyint(4) NO 0
title varchar(255) NO MUL NULL
description text NO NULL
extension varchar(50) NO MUL NULL
default tinyint(4) NO MUL 0
ordering int(11) NO 0
created datetime NO MUL NULL
created_by int(11) NO MUL 0
modified datetime NO MUL NULL
modified_by int(11) NO MUL 0
checked_out_time datetime YES NULL
checked_out int(10) unsigned YES MUL NULL