WSAI Database Catalog
Status: Full local MariaDB discovery catalog
Generated: 2026-06-03 21:41:06 UTC
Scope: All non-system MariaDB databases visible through local socket/root discovery.
Databases
| Database | Tables | Views | Rows Estimate |
|---|---|---|---|
| phpmyadmin | 19 | 0 | 0 |
| roundcube | 17 | 0 | 11 |
| wordpress-db | 148 | 0 | 2875 |
| wsai_ops | 67 | 51 | 1820 |
Schema Elements
Database: phpmyadmin
Tables and Views
| Object | Type | Rows Estimate | Engine |
|---|---|---|---|
| pma__bookmark | BASE TABLE | 0 | InnoDB |
| pma__central_columns | BASE TABLE | 0 | InnoDB |
| pma__column_info | BASE TABLE | 0 | InnoDB |
| pma__designer_settings | BASE TABLE | 0 | InnoDB |
| pma__export_templates | BASE TABLE | 0 | InnoDB |
| pma__favorite | BASE TABLE | 0 | InnoDB |
| pma__history | BASE TABLE | 0 | InnoDB |
| pma__navigationhiding | BASE TABLE | 0 | InnoDB |
| pma__pdf_pages | BASE TABLE | 0 | InnoDB |
| pma__recent | BASE TABLE | 0 | InnoDB |
| pma__relation | BASE TABLE | 0 | InnoDB |
| pma__savedsearches | BASE TABLE | 0 | InnoDB |
| pma__table_coords | BASE TABLE | 0 | InnoDB |
| pma__table_info | BASE TABLE | 0 | InnoDB |
| pma__table_uiprefs | BASE TABLE | 0 | InnoDB |
| pma__tracking | BASE TABLE | 0 | InnoDB |
| pma__userconfig | BASE TABLE | 0 | InnoDB |
| pma__usergroups | BASE TABLE | 0 | InnoDB |
| pma__users | BASE TABLE | 0 | InnoDB |
Columns
| Table | Column | Type | Nullable | Key | Default |
|---|---|---|---|---|---|
| pma__bookmark | id | int(10) unsigned | NO | PRI | |
| pma__bookmark | dbase | varchar(255) | NO | '' | |
| pma__bookmark | user | varchar(255) | NO | '' | |
| pma__bookmark | label | varchar(255) | NO | '' | |
| pma__bookmark | query | text | NO | ||
| pma__central_columns | db_name | varchar(64) | NO | PRI | |
| pma__central_columns | col_name | varchar(64) | NO | PRI | |
| pma__central_columns | col_type | varchar(64) | NO | ||
| pma__central_columns | col_length | text | YES | NULL | |
| pma__central_columns | col_collation | varchar(64) | NO | ||
| pma__central_columns | col_isNull | tinyint(1) | NO | ||
| pma__central_columns | col_extra | varchar(255) | YES | '' | |
| pma__central_columns | col_default | text | YES | NULL | |
| pma__column_info | id | int(5) unsigned | NO | PRI | |
| pma__column_info | db_name | varchar(64) | NO | MUL | '' |
| pma__column_info | table_name | varchar(64) | NO | '' | |
| pma__column_info | column_name | varchar(64) | NO | '' | |
| pma__column_info | comment | varchar(255) | NO | '' | |
| pma__column_info | mimetype | varchar(255) | NO | '' | |
| pma__column_info | transformation | varchar(255) | NO | '' | |
| pma__column_info | transformation_options | varchar(255) | NO | '' | |
| pma__column_info | input_transformation | varchar(255) | NO | '' | |
| pma__column_info | input_transformation_options | varchar(255) | NO | '' | |
| pma__designer_settings | username | varchar(64) | NO | PRI | |
| pma__designer_settings | settings_data | text | NO | ||
| pma__export_templates | id | int(5) unsigned | NO | PRI | |
| pma__export_templates | username | varchar(64) | NO | MUL | |
| pma__export_templates | export_type | varchar(10) | NO | ||
| pma__export_templates | template_name | varchar(64) | NO | ||
| pma__export_templates | template_data | text | NO | ||
| pma__favorite | username | varchar(64) | NO | PRI | |
| pma__favorite | tables | text | NO | ||
| pma__history | id | bigint(20) unsigned | NO | PRI | |
| pma__history | username | varchar(64) | NO | MUL | '' |
| pma__history | db | varchar(64) | NO | '' | |
| pma__history | table | varchar(64) | NO | '' | |
| pma__history | timevalue | timestamp | NO | current_timestamp() | |
| pma__history | sqlquery | text | NO | ||
| pma__navigationhiding | username | varchar(64) | NO | PRI | |
| pma__navigationhiding | item_name | varchar(64) | NO | PRI | |
| pma__navigationhiding | item_type | varchar(64) | NO | PRI | |
| pma__navigationhiding | db_name | varchar(64) | NO | PRI | |
| pma__navigationhiding | table_name | varchar(64) | NO | PRI | |
| pma__pdf_pages | db_name | varchar(64) | NO | MUL | '' |
| pma__pdf_pages | page_nr | int(10) unsigned | NO | PRI | |
| pma__pdf_pages | page_descr | varchar(50) | NO | '' | |
| pma__recent | username | varchar(64) | NO | PRI | |
| pma__recent | tables | text | NO | ||
| pma__relation | master_db | varchar(64) | NO | PRI | '' |
| pma__relation | master_table | varchar(64) | NO | PRI | '' |
| pma__relation | master_field | varchar(64) | NO | PRI | '' |
| pma__relation | foreign_db | varchar(64) | NO | MUL | '' |
| pma__relation | foreign_table | varchar(64) | NO | '' | |
| pma__relation | foreign_field | varchar(64) | NO | '' | |
| pma__savedsearches | id | int(5) unsigned | NO | PRI | |
| pma__savedsearches | username | varchar(64) | NO | MUL | '' |
| pma__savedsearches | db_name | varchar(64) | NO | '' | |
| pma__savedsearches | search_name | varchar(64) | NO | '' | |
| pma__savedsearches | search_data | text | NO | ||
| pma__table_coords | db_name | varchar(64) | NO | PRI | '' |
| pma__table_coords | table_name | varchar(64) | NO | PRI | '' |
| pma__table_coords | pdf_page_number | int(11) | NO | PRI | 0 |
| pma__table_coords | x | float unsigned | NO | 0 | |
| pma__table_coords | y | float unsigned | NO | 0 | |
| pma__table_info | db_name | varchar(64) | NO | PRI | '' |
| pma__table_info | table_name | varchar(64) | NO | PRI | '' |
| pma__table_info | display_field | varchar(64) | NO | '' | |
| pma__table_uiprefs | username | varchar(64) | NO | PRI | |
| pma__table_uiprefs | db_name | varchar(64) | NO | PRI | |
| pma__table_uiprefs | table_name | varchar(64) | NO | PRI | |
| pma__table_uiprefs | prefs | text | NO | ||
| pma__table_uiprefs | last_update | timestamp | NO | current_timestamp() | |
| pma__tracking | db_name | varchar(64) | NO | PRI | |
| pma__tracking | table_name | varchar(64) | NO | PRI | |
| pma__tracking | version | int(10) unsigned | NO | PRI | |
| pma__tracking | date_created | datetime | NO | ||
| pma__tracking | date_updated | datetime | NO | ||
| pma__tracking | schema_snapshot | text | NO | ||
| pma__tracking | schema_sql | text | YES | NULL | |
| pma__tracking | data_sql | longtext | YES | NULL | |
| pma__tracking | tracking | set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') | YES | NULL | |
| pma__tracking | tracking_active | int(1) unsigned | NO | 1 | |
| pma__userconfig | username | varchar(64) | NO | PRI | |
| pma__userconfig | timevalue | timestamp | NO | current_timestamp() | |
| pma__userconfig | config_data | text | NO | ||
| pma__usergroups | usergroup | varchar(64) | NO | PRI | |
| pma__usergroups | tab | varchar(64) | NO | PRI | |
| pma__usergroups | allowed | enum('Y','N') | NO | PRI | 'N' |
| pma__users | username | varchar(64) | NO | PRI | |
| pma__users | usergroup | varchar(64) | NO | PRI |
Declared Foreign Keys
| Table | Column | References |
|---|
Common Link Candidates
| Table | Column | Type |
|---|
Database: roundcube
Tables and Views
| Object | Type | Rows Estimate | Engine |
|---|---|---|---|
| cache | BASE TABLE | 0 | InnoDB |
| cache_index | BASE TABLE | 0 | InnoDB |
| cache_messages | BASE TABLE | 0 | InnoDB |
| cache_shared | BASE TABLE | 0 | InnoDB |
| cache_thread | BASE TABLE | 0 | InnoDB |
| collected_addresses | BASE TABLE | 5 | InnoDB |
| contactgroupmembers | BASE TABLE | 0 | InnoDB |
| contactgroups | BASE TABLE | 0 | InnoDB |
| contacts | BASE TABLE | 0 | InnoDB |
| dictionary | BASE TABLE | 0 | InnoDB |
| filestore | BASE TABLE | 0 | InnoDB |
| identities | BASE TABLE | 3 | InnoDB |
| responses | BASE TABLE | 0 | InnoDB |
| searches | BASE TABLE | 0 | InnoDB |
| session | BASE TABLE | 0 | InnoDB |
| system | BASE TABLE | 1 | InnoDB |
| users | BASE TABLE | 2 | InnoDB |
Columns
| Table | Column | Type | Nullable | Key | Default |
|---|---|---|---|---|---|
| cache | user_id | int(10) unsigned | NO | PRI | |
| cache | cache_key | varchar(128) | NO | PRI | |
| cache | expires | datetime | YES | MUL | NULL |
| cache | data | longtext | NO | ||
| cache_index | user_id | int(10) unsigned | NO | PRI | |
| cache_index | mailbox | varchar(255) | NO | PRI | |
| cache_index | expires | datetime | YES | MUL | NULL |
| cache_index | valid | tinyint(1) | NO | 0 | |
| cache_index | data | longtext | NO | ||
| cache_messages | user_id | int(10) unsigned | NO | PRI | |
| cache_messages | mailbox | varchar(255) | NO | PRI | |
| cache_messages | uid | int(11) unsigned | NO | PRI | 0 |
| cache_messages | expires | datetime | YES | MUL | NULL |
| cache_messages | data | longtext | NO | ||
| cache_messages | flags | int(11) | NO | 0 | |
| cache_shared | cache_key | varchar(255) | NO | PRI | |
| cache_shared | expires | datetime | YES | MUL | NULL |
| cache_shared | data | longtext | NO | ||
| cache_thread | user_id | int(10) unsigned | NO | PRI | |
| cache_thread | mailbox | varchar(255) | NO | PRI | |
| cache_thread | expires | datetime | YES | MUL | NULL |
| cache_thread | data | longtext | NO | ||
| collected_addresses | address_id | int(10) unsigned | NO | PRI | |
| collected_addresses | changed | datetime | NO | '1000-01-01 00:00:00' | |
| collected_addresses | name | varchar(255) | NO | '' | |
| collected_addresses | varchar(255) | NO | |||
| collected_addresses | user_id | int(10) unsigned | NO | MUL | |
| collected_addresses | type | int(10) unsigned | NO | ||
| contactgroupmembers | contactgroup_id | int(10) unsigned | NO | PRI | |
| contactgroupmembers | contact_id | int(10) unsigned | NO | PRI | |
| contactgroupmembers | created | datetime | NO | '1000-01-01 00:00:00' | |
| contactgroups | contactgroup_id | int(10) unsigned | NO | PRI | |
| contactgroups | user_id | int(10) unsigned | NO | MUL | |
| contactgroups | changed | datetime | NO | '1000-01-01 00:00:00' | |
| contactgroups | del | tinyint(1) | NO | 0 | |
| contactgroups | name | varchar(128) | NO | '' | |
| contacts | contact_id | int(10) unsigned | NO | PRI | |
| contacts | changed | datetime | NO | '1000-01-01 00:00:00' | |
| contacts | del | tinyint(1) | NO | 0 | |
| contacts | name | varchar(128) | NO | '' | |
| contacts | text | NO | |||
| contacts | firstname | varchar(128) | NO | '' | |
| contacts | surname | varchar(128) | NO | '' | |
| contacts | vcard | longtext | YES | NULL | |
| contacts | words | text | YES | NULL | |
| contacts | user_id | int(10) unsigned | NO | MUL | |
| dictionary | id | int(10) unsigned | NO | PRI | |
| dictionary | user_id | int(10) unsigned | YES | MUL | NULL |
| dictionary | language | varchar(16) | NO | ||
| dictionary | data | longtext | NO | ||
| filestore | file_id | int(10) unsigned | NO | PRI | |
| filestore | user_id | int(10) unsigned | NO | MUL | |
| filestore | context | varchar(32) | NO | ||
| filestore | filename | varchar(128) | NO | ||
| filestore | mtime | int(10) | NO | ||
| filestore | data | longtext | NO | ||
| identities | identity_id | int(10) unsigned | NO | PRI | |
| identities | user_id | int(10) unsigned | NO | MUL | |
| identities | changed | datetime | NO | '1000-01-01 00:00:00' | |
| identities | del | tinyint(1) | NO | 0 | |
| identities | standard | tinyint(1) | NO | 0 | |
| identities | name | varchar(128) | NO | ||
| identities | organization | varchar(128) | NO | '' | |
| identities | varchar(128) | NO | MUL | ||
| identities | reply-to | varchar(128) | NO | '' | |
| identities | bcc | varchar(128) | NO | '' | |
| identities | signature | longtext | YES | NULL | |
| identities | html_signature | tinyint(1) | NO | 0 | |
| responses | response_id | int(10) unsigned | NO | PRI | |
| responses | user_id | int(10) unsigned | NO | MUL | |
| responses | name | varchar(255) | NO | ||
| responses | data | longtext | NO | ||
| responses | is_html | tinyint(1) | NO | 0 | |
| responses | changed | datetime | NO | '1000-01-01 00:00:00' | |
| responses | del | tinyint(1) | NO | 0 | |
| searches | search_id | int(10) unsigned | NO | PRI | |
| searches | user_id | int(10) unsigned | NO | MUL | |
| searches | type | int(3) | NO | 0 | |
| searches | name | varchar(128) | NO | ||
| searches | data | text | YES | NULL | |
| session | sess_id | varchar(128) | NO | PRI | |
| session | changed | datetime | NO | MUL | '1000-01-01 00:00:00' |
| session | ip | varchar(40) | NO | ||
| session | vars | mediumtext | NO | ||
| system | name | varchar(64) | NO | PRI | |
| system | value | mediumtext | YES | NULL | |
| users | user_id | int(10) unsigned | NO | PRI | |
| users | username | varchar(128) | NO | MUL | |
| users | mail_host | varchar(128) | NO | ||
| users | created | datetime | NO | '1000-01-01 00:00:00' | |
| users | last_login | datetime | YES | NULL | |
| users | failed_login | datetime | YES | NULL | |
| users | failed_login_counter | int(10) unsigned | YES | NULL | |
| users | language | varchar(16) | YES | NULL | |
| users | preferences | longtext | YES | NULL |
Declared Foreign Keys
| Table | Column | References |
|---|---|---|
| cache | user_id | roundcube.users.user_id |
| cache_index | user_id | roundcube.users.user_id |
| cache_messages | user_id | roundcube.users.user_id |
| cache_thread | user_id | roundcube.users.user_id |
| collected_addresses | user_id | roundcube.users.user_id |
| contactgroupmembers | contactgroup_id | roundcube.contactgroups.contactgroup_id |
| contactgroupmembers | contact_id | roundcube.contacts.contact_id |
| contactgroups | user_id | roundcube.users.user_id |
| contacts | user_id | roundcube.users.user_id |
| dictionary | user_id | roundcube.users.user_id |
| filestore | user_id | roundcube.users.user_id |
| identities | user_id | roundcube.users.user_id |
| responses | user_id | roundcube.users.user_id |
| searches | user_id | roundcube.users.user_id |
Common Link Candidates
| Table | Column | Type |
|---|---|---|
| collected_addresses | address_id | int(10) unsigned |
| contactgroupmembers | contactgroup_id | int(10) unsigned |
| contactgroups | contactgroup_id | int(10) unsigned |
| contactgroupmembers | contact_id | int(10) unsigned |
| contacts | contact_id | int(10) unsigned |
| filestore | file_id | int(10) unsigned |
| identities | identity_id | int(10) unsigned |
| responses | response_id | int(10) unsigned |
| searches | search_id | int(10) unsigned |
| session | sess_id | varchar(128) |
| cache | user_id | int(10) unsigned |
| cache_index | user_id | int(10) unsigned |
| cache_messages | user_id | int(10) unsigned |
| cache_thread | user_id | int(10) unsigned |
| collected_addresses | user_id | int(10) unsigned |
| contactgroups | user_id | int(10) unsigned |
| contacts | user_id | int(10) unsigned |
| dictionary | user_id | int(10) unsigned |
| filestore | user_id | int(10) unsigned |
| identities | user_id | int(10) unsigned |
| responses | user_id | int(10) unsigned |
| searches | user_id | int(10) unsigned |
| users | user_id | int(10) unsigned |
Database: wordpress-db
Tables and Views
| Object | Type | Rows Estimate | Engine |
|---|---|---|---|
| wp_2_actionscheduler_actions | BASE TABLE | 13 | InnoDB |
| wp_2_actionscheduler_claims | BASE TABLE | 0 | InnoDB |
| wp_2_actionscheduler_groups | BASE TABLE | 3 | InnoDB |
| wp_2_actionscheduler_logs | BASE TABLE | 35 | InnoDB |
| wp_2_commentmeta | BASE TABLE | 0 | InnoDB |
| wp_2_comments | BASE TABLE | 0 | InnoDB |
| wp_2_links | BASE TABLE | 0 | InnoDB |
| wp_2_options | BASE TABLE | 150 | InnoDB |
| wp_2_postmeta | BASE TABLE | 40 | InnoDB |
| wp_2_posts | BASE TABLE | 24 | InnoDB |
| wp_2_termmeta | BASE TABLE | 0 | InnoDB |
| wp_2_terms | BASE TABLE | 26 | InnoDB |
| wp_2_term_relationships | BASE TABLE | 6 | InnoDB |
| wp_2_term_taxonomy | BASE TABLE | 26 | InnoDB |
| wp_2_wpmailsmtp_debug_events | BASE TABLE | 0 | InnoDB |
| wp_2_wpmailsmtp_emails_log | BASE TABLE | 0 | InnoDB |
| wp_2_wpmailsmtp_tasks_meta | BASE TABLE | 0 | InnoDB |
| wp_3_actionscheduler_actions | BASE TABLE | 13 | InnoDB |
| wp_3_actionscheduler_claims | BASE TABLE | 0 | InnoDB |
| wp_3_actionscheduler_groups | BASE TABLE | 3 | InnoDB |
| wp_3_actionscheduler_logs | BASE TABLE | 35 | InnoDB |
| wp_3_commentmeta | BASE TABLE | 0 | InnoDB |
| wp_3_comments | BASE TABLE | 0 | InnoDB |
| wp_3_links | BASE TABLE | 0 | InnoDB |
| wp_3_options | BASE TABLE | 151 | InnoDB |
| wp_3_postmeta | BASE TABLE | 40 | InnoDB |
| wp_3_posts | BASE TABLE | 22 | InnoDB |
| wp_3_termmeta | BASE TABLE | 0 | InnoDB |
| wp_3_terms | BASE TABLE | 24 | InnoDB |
| wp_3_term_relationships | BASE TABLE | 7 | InnoDB |
| wp_3_term_taxonomy | BASE TABLE | 24 | InnoDB |
| wp_3_wpmailsmtp_debug_events | BASE TABLE | 0 | InnoDB |
| wp_3_wpmailsmtp_emails_log | BASE TABLE | 0 | InnoDB |
| wp_3_wpmailsmtp_tasks_meta | BASE TABLE | 0 | InnoDB |
| wp_4_actionscheduler_actions | BASE TABLE | 20 | InnoDB |
| wp_4_actionscheduler_claims | BASE TABLE | 0 | InnoDB |
| wp_4_actionscheduler_groups | BASE TABLE | 2 | InnoDB |
| wp_4_actionscheduler_logs | BASE TABLE | 56 | InnoDB |
| wp_4_commentmeta | BASE TABLE | 0 | InnoDB |
| wp_4_comments | BASE TABLE | 0 | InnoDB |
| wp_4_links | BASE TABLE | 0 | InnoDB |
| wp_4_options | BASE TABLE | 152 | InnoDB |
| wp_4_postmeta | BASE TABLE | 40 | InnoDB |
| wp_4_posts | BASE TABLE | 23 | InnoDB |
| wp_4_termmeta | BASE TABLE | 0 | InnoDB |
| wp_4_terms | BASE TABLE | 22 | InnoDB |
| wp_4_term_relationships | BASE TABLE | 6 | InnoDB |
| wp_4_term_taxonomy | BASE TABLE | 22 | InnoDB |
| wp_4_wpmailsmtp_debug_events | BASE TABLE | 0 | InnoDB |
| wp_4_wpmailsmtp_emails_log | BASE TABLE | 0 | InnoDB |
| wp_4_wpmailsmtp_tasks_meta | BASE TABLE | 0 | InnoDB |
| wp_5_actionscheduler_actions | BASE TABLE | 10 | InnoDB |
| wp_5_actionscheduler_claims | BASE TABLE | 0 | InnoDB |
| wp_5_actionscheduler_groups | BASE TABLE | 1 | InnoDB |
| wp_5_actionscheduler_logs | BASE TABLE | 26 | InnoDB |
| wp_5_commentmeta | BASE TABLE | 0 | InnoDB |
| wp_5_comments | BASE TABLE | 0 | InnoDB |
| wp_5_links | BASE TABLE | 0 | InnoDB |
| wp_5_options | BASE TABLE | 148 | InnoDB |
| wp_5_postmeta | BASE TABLE | 40 | InnoDB |
| wp_5_posts | BASE TABLE | 22 | InnoDB |
| wp_5_termmeta | BASE TABLE | 0 | InnoDB |
| wp_5_terms | BASE TABLE | 22 | InnoDB |
| wp_5_term_relationships | BASE TABLE | 6 | InnoDB |
| wp_5_term_taxonomy | BASE TABLE | 22 | InnoDB |
| wp_5_wpmailsmtp_debug_events | BASE TABLE | 0 | InnoDB |
| wp_5_wpmailsmtp_emails_log | BASE TABLE | 0 | InnoDB |
| wp_5_wpmailsmtp_tasks_meta | BASE TABLE | 0 | InnoDB |
| wp_6_actionscheduler_actions | BASE TABLE | 9 | InnoDB |
| wp_6_actionscheduler_claims | BASE TABLE | 0 | InnoDB |
| wp_6_actionscheduler_groups | BASE TABLE | 3 | InnoDB |
| wp_6_actionscheduler_logs | BASE TABLE | 23 | InnoDB |
| wp_6_commentmeta | BASE TABLE | 0 | InnoDB |
| wp_6_comments | BASE TABLE | 0 | InnoDB |
| wp_6_links | BASE TABLE | 0 | InnoDB |
| wp_6_options | BASE TABLE | 152 | InnoDB |
| wp_6_postmeta | BASE TABLE | 40 | InnoDB |
| wp_6_posts | BASE TABLE | 22 | InnoDB |
| wp_6_termmeta | BASE TABLE | 0 | InnoDB |
| wp_6_terms | BASE TABLE | 22 | InnoDB |
| wp_6_term_relationships | BASE TABLE | 6 | InnoDB |
| wp_6_term_taxonomy | BASE TABLE | 22 | InnoDB |
| wp_6_wpmailsmtp_debug_events | BASE TABLE | 0 | InnoDB |
| wp_6_wpmailsmtp_emails_log | BASE TABLE | 0 | InnoDB |
| wp_6_wpmailsmtp_tasks_meta | BASE TABLE | 0 | InnoDB |
| wp_7_wpmailsmtp_debug_events | BASE TABLE | 0 | InnoDB |
| wp_7_wpmailsmtp_emails_log | BASE TABLE | 0 | InnoDB |
| wp_7_wpmailsmtp_tasks_meta | BASE TABLE | 0 | InnoDB |
| wp_8_actionscheduler_actions | BASE TABLE | 1 | InnoDB |
| wp_8_actionscheduler_claims | BASE TABLE | 0 | InnoDB |
| wp_8_actionscheduler_groups | BASE TABLE | 1 | InnoDB |
| wp_8_actionscheduler_logs | BASE TABLE | 1 | InnoDB |
| wp_8_commentmeta | BASE TABLE | 0 | InnoDB |
| wp_8_comments | BASE TABLE | 1 | InnoDB |
| wp_8_links | BASE TABLE | 0 | InnoDB |
| wp_8_options | BASE TABLE | 134 | InnoDB |
| wp_8_postmeta | BASE TABLE | 1 | InnoDB |
| wp_8_posts | BASE TABLE | 2 | InnoDB |
| wp_8_termmeta | BASE TABLE | 0 | InnoDB |
| wp_8_terms | BASE TABLE | 1 | InnoDB |
| wp_8_term_relationships | BASE TABLE | 1 | InnoDB |
| wp_8_term_taxonomy | BASE TABLE | 1 | InnoDB |
| wp_8_wpmailsmtp_debug_events | BASE TABLE | 0 | InnoDB |
| wp_8_wpmailsmtp_emails_log | BASE TABLE | 0 | InnoDB |
| wp_8_wpmailsmtp_tasks_meta | BASE TABLE | 0 | InnoDB |
| wp_9_actionscheduler_actions | BASE TABLE | 1 | InnoDB |
| wp_9_actionscheduler_claims | BASE TABLE | 0 | InnoDB |
| wp_9_actionscheduler_groups | BASE TABLE | 1 | InnoDB |
| wp_9_actionscheduler_logs | BASE TABLE | 1 | InnoDB |
| wp_9_commentmeta | BASE TABLE | 0 | InnoDB |
| wp_9_comments | BASE TABLE | 1 | InnoDB |
| wp_9_links | BASE TABLE | 0 | InnoDB |
| wp_9_options | BASE TABLE | 134 | InnoDB |
| wp_9_postmeta | BASE TABLE | 1 | InnoDB |
| wp_9_posts | BASE TABLE | 2 | InnoDB |
| wp_9_termmeta | BASE TABLE | 0 | InnoDB |
| wp_9_terms | BASE TABLE | 1 | InnoDB |
| wp_9_term_relationships | BASE TABLE | 1 | InnoDB |
| wp_9_term_taxonomy | BASE TABLE | 1 | InnoDB |
| wp_9_wpmailsmtp_debug_events | BASE TABLE | 0 | InnoDB |
| wp_9_wpmailsmtp_emails_log | BASE TABLE | 0 | InnoDB |
| wp_9_wpmailsmtp_tasks_meta | BASE TABLE | 0 | InnoDB |
| wp_actionscheduler_actions | BASE TABLE | 41 | InnoDB |
| wp_actionscheduler_claims | BASE TABLE | 0 | InnoDB |
| wp_actionscheduler_groups | BASE TABLE | 2 | InnoDB |
| wp_actionscheduler_logs | BASE TABLE | 115 | InnoDB |
| wp_blogmeta | BASE TABLE | 2 | InnoDB |
| wp_blogs | BASE TABLE | 8 | InnoDB |
| wp_commentmeta | BASE TABLE | 0 | InnoDB |
| wp_comments | BASE TABLE | 4 | InnoDB |
| wp_links | BASE TABLE | 0 | InnoDB |
| wp_options | BASE TABLE | 170 | InnoDB |
| wp_postmeta | BASE TABLE | 282 | InnoDB |
| wp_posts | BASE TABLE | 148 | InnoDB |
| wp_registration_log | BASE TABLE | 8 | InnoDB |
| wp_signups | BASE TABLE | 0 | InnoDB |
| wp_site | BASE TABLE | 0 | InnoDB |
| wp_sitemeta | BASE TABLE | 54 | InnoDB |
| wp_termmeta | BASE TABLE | 0 | InnoDB |
| wp_terms | BASE TABLE | 19 | InnoDB |
| wp_term_relationships | BASE TABLE | 8 | InnoDB |
| wp_term_taxonomy | BASE TABLE | 19 | InnoDB |
| wp_usermeta | BASE TABLE | 78 | InnoDB |
| wp_users | BASE TABLE | 3 | InnoDB |
| wp_wpmailsmtp_debug_events | BASE TABLE | 11 | InnoDB |
| wp_wpmailsmtp_emails_log | BASE TABLE | 20 | InnoDB |
| wp_wpmailsmtp_tasks_meta | BASE TABLE | 0 | InnoDB |
| wsai_program_backlog | BASE TABLE | 14 | InnoDB |
Columns
| Table | Column | Type | Nullable | Key | Default |
|---|---|---|---|---|---|
| wp_2_actionscheduler_actions | action_id | bigint(20) unsigned | NO | PRI | |
| wp_2_actionscheduler_actions | hook | varchar(191) | NO | MUL | |
| wp_2_actionscheduler_actions | status | varchar(20) | NO | MUL | |
| wp_2_actionscheduler_actions | scheduled_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_2_actionscheduler_actions | scheduled_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_2_actionscheduler_actions | priority | tinyint(3) unsigned | NO | 10 | |
| wp_2_actionscheduler_actions | args | varchar(191) | YES | MUL | NULL |
| wp_2_actionscheduler_actions | schedule | longtext | YES | NULL | |
| wp_2_actionscheduler_actions | group_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_actionscheduler_actions | attempts | int(11) | NO | 0 | |
| wp_2_actionscheduler_actions | last_attempt_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_2_actionscheduler_actions | last_attempt_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_2_actionscheduler_actions | claim_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_actionscheduler_actions | extended_args | varchar(8000) | YES | NULL | |
| wp_2_actionscheduler_claims | claim_id | bigint(20) unsigned | NO | PRI | |
| wp_2_actionscheduler_claims | date_created_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_2_actionscheduler_groups | group_id | bigint(20) unsigned | NO | PRI | |
| wp_2_actionscheduler_groups | slug | varchar(255) | NO | MUL | |
| wp_2_actionscheduler_logs | log_id | bigint(20) unsigned | NO | PRI | |
| wp_2_actionscheduler_logs | action_id | bigint(20) unsigned | NO | MUL | |
| wp_2_actionscheduler_logs | message | text | NO | ||
| wp_2_actionscheduler_logs | log_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_2_actionscheduler_logs | log_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_2_commentmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_2_commentmeta | comment_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_commentmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_2_commentmeta | meta_value | longtext | YES | NULL | |
| wp_2_comments | comment_ID | bigint(20) unsigned | NO | PRI | |
| wp_2_comments | comment_post_ID | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_comments | comment_author | tinytext | NO | ||
| wp_2_comments | comment_author_email | varchar(100) | NO | MUL | '' |
| wp_2_comments | comment_author_url | varchar(200) | NO | '' | |
| wp_2_comments | comment_author_IP | varchar(100) | NO | '' | |
| wp_2_comments | comment_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_2_comments | comment_date_gmt | datetime | NO | MUL | '0000-00-00 00:00:00' |
| wp_2_comments | comment_content | text | NO | ||
| wp_2_comments | comment_karma | int(11) | NO | 0 | |
| wp_2_comments | comment_approved | varchar(20) | NO | MUL | '1' |
| wp_2_comments | comment_agent | varchar(255) | NO | '' | |
| wp_2_comments | comment_type | varchar(20) | NO | 'comment' | |
| wp_2_comments | comment_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_comments | user_id | bigint(20) unsigned | NO | 0 | |
| wp_2_links | link_id | bigint(20) unsigned | NO | PRI | |
| wp_2_links | link_url | varchar(255) | NO | '' | |
| wp_2_links | link_name | varchar(255) | NO | '' | |
| wp_2_links | link_image | varchar(255) | NO | '' | |
| wp_2_links | link_target | varchar(25) | NO | '' | |
| wp_2_links | link_description | varchar(255) | NO | '' | |
| wp_2_links | link_visible | varchar(20) | NO | MUL | 'Y' |
| wp_2_links | link_owner | bigint(20) unsigned | NO | 1 | |
| wp_2_links | link_rating | int(11) | NO | 0 | |
| wp_2_links | link_updated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_2_links | link_rel | varchar(255) | NO | '' | |
| wp_2_links | link_notes | mediumtext | NO | ||
| wp_2_links | link_rss | varchar(255) | NO | '' | |
| wp_2_options | option_id | bigint(20) unsigned | NO | PRI | |
| wp_2_options | option_name | varchar(191) | NO | UNI | '' |
| wp_2_options | option_value | longtext | NO | ||
| wp_2_options | autoload | varchar(20) | NO | MUL | 'yes' |
| wp_2_postmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_2_postmeta | post_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_postmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_2_postmeta | meta_value | longtext | YES | NULL | |
| wp_2_posts | ID | bigint(20) unsigned | NO | PRI | |
| wp_2_posts | post_author | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_posts | post_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_2_posts | post_date_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_2_posts | post_content | longtext | NO | ||
| wp_2_posts | post_title | text | NO | ||
| wp_2_posts | post_excerpt | text | NO | ||
| wp_2_posts | post_status | varchar(20) | NO | 'publish' | |
| wp_2_posts | comment_status | varchar(20) | NO | 'open' | |
| wp_2_posts | ping_status | varchar(20) | NO | 'open' | |
| wp_2_posts | post_password | varchar(255) | NO | '' | |
| wp_2_posts | post_name | varchar(200) | NO | MUL | '' |
| wp_2_posts | to_ping | text | NO | ||
| wp_2_posts | pinged | text | NO | ||
| wp_2_posts | post_modified | datetime | NO | '0000-00-00 00:00:00' | |
| wp_2_posts | post_modified_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_2_posts | post_content_filtered | longtext | NO | ||
| wp_2_posts | post_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_posts | guid | varchar(255) | NO | '' | |
| wp_2_posts | menu_order | int(11) | NO | 0 | |
| wp_2_posts | post_type | varchar(20) | NO | MUL | 'post' |
| wp_2_posts | post_mime_type | varchar(100) | NO | '' | |
| wp_2_posts | comment_count | bigint(20) | NO | 0 | |
| wp_2_termmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_2_termmeta | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_termmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_2_termmeta | meta_value | longtext | YES | NULL | |
| wp_2_terms | term_id | bigint(20) unsigned | NO | PRI | |
| wp_2_terms | name | varchar(200) | NO | MUL | '' |
| wp_2_terms | slug | varchar(200) | NO | MUL | '' |
| wp_2_terms | term_group | bigint(10) | NO | 0 | |
| wp_2_term_relationships | object_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_2_term_relationships | term_taxonomy_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_2_term_relationships | term_order | int(11) | NO | 0 | |
| wp_2_term_taxonomy | term_taxonomy_id | bigint(20) unsigned | NO | PRI | |
| wp_2_term_taxonomy | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_2_term_taxonomy | taxonomy | varchar(32) | NO | MUL | '' |
| wp_2_term_taxonomy | description | longtext | NO | ||
| wp_2_term_taxonomy | parent | bigint(20) unsigned | NO | 0 | |
| wp_2_term_taxonomy | count | bigint(20) | NO | 0 | |
| wp_2_wpmailsmtp_debug_events | id | int(10) unsigned | NO | PRI | |
| wp_2_wpmailsmtp_debug_events | content | text | YES | NULL | |
| wp_2_wpmailsmtp_debug_events | initiator | text | YES | NULL | |
| wp_2_wpmailsmtp_debug_events | event_type | tinyint(3) unsigned | NO | 0 | |
| wp_2_wpmailsmtp_debug_events | created_at | timestamp | NO | current_timestamp() | |
| wp_2_wpmailsmtp_emails_log | id | int(10) unsigned | NO | PRI | |
| wp_2_wpmailsmtp_emails_log | message_id | varchar(255) | YES | MUL | NULL |
| wp_2_wpmailsmtp_emails_log | subject | varchar(191) | NO | MUL | |
| wp_2_wpmailsmtp_emails_log | people | text | NO | ||
| wp_2_wpmailsmtp_emails_log | headers | text | NO | ||
| wp_2_wpmailsmtp_emails_log | error_text | text | YES | NULL | |
| wp_2_wpmailsmtp_emails_log | content_plain | longtext | NO | ||
| wp_2_wpmailsmtp_emails_log | content_html | longtext | NO | ||
| wp_2_wpmailsmtp_emails_log | status | tinyint(3) unsigned | NO | MUL | 0 |
| wp_2_wpmailsmtp_emails_log | date_sent | timestamp | NO | MUL | current_timestamp() |
| wp_2_wpmailsmtp_emails_log | mailer | varchar(255) | NO | ||
| wp_2_wpmailsmtp_emails_log | attachments | tinyint(3) unsigned | NO | 0 | |
| wp_2_wpmailsmtp_emails_log | initiator_name | varchar(255) | YES | NULL | |
| wp_2_wpmailsmtp_emails_log | initiator_file | text | YES | NULL | |
| wp_2_wpmailsmtp_emails_log | parent_id | int(10) unsigned | NO | 0 | |
| wp_2_wpmailsmtp_tasks_meta | id | bigint(20) | NO | PRI | |
| wp_2_wpmailsmtp_tasks_meta | action | varchar(255) | NO | ||
| wp_2_wpmailsmtp_tasks_meta | data | longtext | NO | ||
| wp_2_wpmailsmtp_tasks_meta | date | datetime | NO | ||
| wp_3_actionscheduler_actions | action_id | bigint(20) unsigned | NO | PRI | |
| wp_3_actionscheduler_actions | hook | varchar(191) | NO | MUL | |
| wp_3_actionscheduler_actions | status | varchar(20) | NO | MUL | |
| wp_3_actionscheduler_actions | scheduled_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_3_actionscheduler_actions | scheduled_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_3_actionscheduler_actions | priority | tinyint(3) unsigned | NO | 10 | |
| wp_3_actionscheduler_actions | args | varchar(191) | YES | MUL | NULL |
| wp_3_actionscheduler_actions | schedule | longtext | YES | NULL | |
| wp_3_actionscheduler_actions | group_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_actionscheduler_actions | attempts | int(11) | NO | 0 | |
| wp_3_actionscheduler_actions | last_attempt_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_3_actionscheduler_actions | last_attempt_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_3_actionscheduler_actions | claim_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_actionscheduler_actions | extended_args | varchar(8000) | YES | NULL | |
| wp_3_actionscheduler_claims | claim_id | bigint(20) unsigned | NO | PRI | |
| wp_3_actionscheduler_claims | date_created_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_3_actionscheduler_groups | group_id | bigint(20) unsigned | NO | PRI | |
| wp_3_actionscheduler_groups | slug | varchar(255) | NO | MUL | |
| wp_3_actionscheduler_logs | log_id | bigint(20) unsigned | NO | PRI | |
| wp_3_actionscheduler_logs | action_id | bigint(20) unsigned | NO | MUL | |
| wp_3_actionscheduler_logs | message | text | NO | ||
| wp_3_actionscheduler_logs | log_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_3_actionscheduler_logs | log_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_3_commentmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_3_commentmeta | comment_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_commentmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_3_commentmeta | meta_value | longtext | YES | NULL | |
| wp_3_comments | comment_ID | bigint(20) unsigned | NO | PRI | |
| wp_3_comments | comment_post_ID | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_comments | comment_author | tinytext | NO | ||
| wp_3_comments | comment_author_email | varchar(100) | NO | MUL | '' |
| wp_3_comments | comment_author_url | varchar(200) | NO | '' | |
| wp_3_comments | comment_author_IP | varchar(100) | NO | '' | |
| wp_3_comments | comment_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_3_comments | comment_date_gmt | datetime | NO | MUL | '0000-00-00 00:00:00' |
| wp_3_comments | comment_content | text | NO | ||
| wp_3_comments | comment_karma | int(11) | NO | 0 | |
| wp_3_comments | comment_approved | varchar(20) | NO | MUL | '1' |
| wp_3_comments | comment_agent | varchar(255) | NO | '' | |
| wp_3_comments | comment_type | varchar(20) | NO | 'comment' | |
| wp_3_comments | comment_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_comments | user_id | bigint(20) unsigned | NO | 0 | |
| wp_3_links | link_id | bigint(20) unsigned | NO | PRI | |
| wp_3_links | link_url | varchar(255) | NO | '' | |
| wp_3_links | link_name | varchar(255) | NO | '' | |
| wp_3_links | link_image | varchar(255) | NO | '' | |
| wp_3_links | link_target | varchar(25) | NO | '' | |
| wp_3_links | link_description | varchar(255) | NO | '' | |
| wp_3_links | link_visible | varchar(20) | NO | MUL | 'Y' |
| wp_3_links | link_owner | bigint(20) unsigned | NO | 1 | |
| wp_3_links | link_rating | int(11) | NO | 0 | |
| wp_3_links | link_updated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_3_links | link_rel | varchar(255) | NO | '' | |
| wp_3_links | link_notes | mediumtext | NO | ||
| wp_3_links | link_rss | varchar(255) | NO | '' | |
| wp_3_options | option_id | bigint(20) unsigned | NO | PRI | |
| wp_3_options | option_name | varchar(191) | NO | UNI | '' |
| wp_3_options | option_value | longtext | NO | ||
| wp_3_options | autoload | varchar(20) | NO | MUL | 'yes' |
| wp_3_postmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_3_postmeta | post_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_postmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_3_postmeta | meta_value | longtext | YES | NULL | |
| wp_3_posts | ID | bigint(20) unsigned | NO | PRI | |
| wp_3_posts | post_author | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_posts | post_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_3_posts | post_date_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_3_posts | post_content | longtext | NO | ||
| wp_3_posts | post_title | text | NO | ||
| wp_3_posts | post_excerpt | text | NO | ||
| wp_3_posts | post_status | varchar(20) | NO | 'publish' | |
| wp_3_posts | comment_status | varchar(20) | NO | 'open' | |
| wp_3_posts | ping_status | varchar(20) | NO | 'open' | |
| wp_3_posts | post_password | varchar(255) | NO | '' | |
| wp_3_posts | post_name | varchar(200) | NO | MUL | '' |
| wp_3_posts | to_ping | text | NO | ||
| wp_3_posts | pinged | text | NO | ||
| wp_3_posts | post_modified | datetime | NO | '0000-00-00 00:00:00' | |
| wp_3_posts | post_modified_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_3_posts | post_content_filtered | longtext | NO | ||
| wp_3_posts | post_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_posts | guid | varchar(255) | NO | '' | |
| wp_3_posts | menu_order | int(11) | NO | 0 | |
| wp_3_posts | post_type | varchar(20) | NO | MUL | 'post' |
| wp_3_posts | post_mime_type | varchar(100) | NO | '' | |
| wp_3_posts | comment_count | bigint(20) | NO | 0 | |
| wp_3_termmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_3_termmeta | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_termmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_3_termmeta | meta_value | longtext | YES | NULL | |
| wp_3_terms | term_id | bigint(20) unsigned | NO | PRI | |
| wp_3_terms | name | varchar(200) | NO | MUL | '' |
| wp_3_terms | slug | varchar(200) | NO | MUL | '' |
| wp_3_terms | term_group | bigint(10) | NO | 0 | |
| wp_3_term_relationships | object_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_3_term_relationships | term_taxonomy_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_3_term_relationships | term_order | int(11) | NO | 0 | |
| wp_3_term_taxonomy | term_taxonomy_id | bigint(20) unsigned | NO | PRI | |
| wp_3_term_taxonomy | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_3_term_taxonomy | taxonomy | varchar(32) | NO | MUL | '' |
| wp_3_term_taxonomy | description | longtext | NO | ||
| wp_3_term_taxonomy | parent | bigint(20) unsigned | NO | 0 | |
| wp_3_term_taxonomy | count | bigint(20) | NO | 0 | |
| wp_3_wpmailsmtp_debug_events | id | int(10) unsigned | NO | PRI | |
| wp_3_wpmailsmtp_debug_events | content | text | YES | NULL | |
| wp_3_wpmailsmtp_debug_events | initiator | text | YES | NULL | |
| wp_3_wpmailsmtp_debug_events | event_type | tinyint(3) unsigned | NO | 0 | |
| wp_3_wpmailsmtp_debug_events | created_at | timestamp | NO | current_timestamp() | |
| wp_3_wpmailsmtp_emails_log | id | int(10) unsigned | NO | PRI | |
| wp_3_wpmailsmtp_emails_log | subject | varchar(191) | NO | MUL | |
| wp_3_wpmailsmtp_emails_log | message_id | varchar(255) | YES | MUL | NULL |
| wp_3_wpmailsmtp_emails_log | people | text | NO | ||
| wp_3_wpmailsmtp_emails_log | headers | text | NO | ||
| wp_3_wpmailsmtp_emails_log | error_text | text | YES | NULL | |
| wp_3_wpmailsmtp_emails_log | content_plain | longtext | NO | ||
| wp_3_wpmailsmtp_emails_log | content_html | longtext | NO | ||
| wp_3_wpmailsmtp_emails_log | status | tinyint(3) unsigned | NO | MUL | 0 |
| wp_3_wpmailsmtp_emails_log | date_sent | timestamp | NO | MUL | current_timestamp() |
| wp_3_wpmailsmtp_emails_log | mailer | varchar(255) | NO | ||
| wp_3_wpmailsmtp_emails_log | attachments | tinyint(3) unsigned | NO | 0 | |
| wp_3_wpmailsmtp_emails_log | initiator_name | varchar(255) | YES | NULL | |
| wp_3_wpmailsmtp_emails_log | initiator_file | text | YES | NULL | |
| wp_3_wpmailsmtp_emails_log | parent_id | int(10) unsigned | NO | 0 | |
| wp_3_wpmailsmtp_tasks_meta | id | bigint(20) | NO | PRI | |
| wp_3_wpmailsmtp_tasks_meta | action | varchar(255) | NO | ||
| wp_3_wpmailsmtp_tasks_meta | data | longtext | NO | ||
| wp_3_wpmailsmtp_tasks_meta | date | datetime | NO | ||
| wp_4_actionscheduler_actions | action_id | bigint(20) unsigned | NO | PRI | |
| wp_4_actionscheduler_actions | hook | varchar(191) | NO | MUL | |
| wp_4_actionscheduler_actions | status | varchar(20) | NO | MUL | |
| wp_4_actionscheduler_actions | scheduled_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_4_actionscheduler_actions | scheduled_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_4_actionscheduler_actions | priority | tinyint(3) unsigned | NO | 10 | |
| wp_4_actionscheduler_actions | args | varchar(191) | YES | MUL | NULL |
| wp_4_actionscheduler_actions | schedule | longtext | YES | NULL | |
| wp_4_actionscheduler_actions | group_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_actionscheduler_actions | attempts | int(11) | NO | 0 | |
| wp_4_actionscheduler_actions | last_attempt_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_4_actionscheduler_actions | last_attempt_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_4_actionscheduler_actions | claim_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_actionscheduler_actions | extended_args | varchar(8000) | YES | NULL | |
| wp_4_actionscheduler_claims | claim_id | bigint(20) unsigned | NO | PRI | |
| wp_4_actionscheduler_claims | date_created_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_4_actionscheduler_groups | group_id | bigint(20) unsigned | NO | PRI | |
| wp_4_actionscheduler_groups | slug | varchar(255) | NO | MUL | |
| wp_4_actionscheduler_logs | log_id | bigint(20) unsigned | NO | PRI | |
| wp_4_actionscheduler_logs | action_id | bigint(20) unsigned | NO | MUL | |
| wp_4_actionscheduler_logs | message | text | NO | ||
| wp_4_actionscheduler_logs | log_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_4_actionscheduler_logs | log_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_4_commentmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_4_commentmeta | comment_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_commentmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_4_commentmeta | meta_value | longtext | YES | NULL | |
| wp_4_comments | comment_ID | bigint(20) unsigned | NO | PRI | |
| wp_4_comments | comment_post_ID | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_comments | comment_author | tinytext | NO | ||
| wp_4_comments | comment_author_email | varchar(100) | NO | MUL | '' |
| wp_4_comments | comment_author_url | varchar(200) | NO | '' | |
| wp_4_comments | comment_author_IP | varchar(100) | NO | '' | |
| wp_4_comments | comment_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_4_comments | comment_date_gmt | datetime | NO | MUL | '0000-00-00 00:00:00' |
| wp_4_comments | comment_content | text | NO | ||
| wp_4_comments | comment_karma | int(11) | NO | 0 | |
| wp_4_comments | comment_approved | varchar(20) | NO | MUL | '1' |
| wp_4_comments | comment_agent | varchar(255) | NO | '' | |
| wp_4_comments | comment_type | varchar(20) | NO | 'comment' | |
| wp_4_comments | comment_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_comments | user_id | bigint(20) unsigned | NO | 0 | |
| wp_4_links | link_id | bigint(20) unsigned | NO | PRI | |
| wp_4_links | link_url | varchar(255) | NO | '' | |
| wp_4_links | link_name | varchar(255) | NO | '' | |
| wp_4_links | link_image | varchar(255) | NO | '' | |
| wp_4_links | link_target | varchar(25) | NO | '' | |
| wp_4_links | link_description | varchar(255) | NO | '' | |
| wp_4_links | link_visible | varchar(20) | NO | MUL | 'Y' |
| wp_4_links | link_owner | bigint(20) unsigned | NO | 1 | |
| wp_4_links | link_rating | int(11) | NO | 0 | |
| wp_4_links | link_updated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_4_links | link_rel | varchar(255) | NO | '' | |
| wp_4_links | link_notes | mediumtext | NO | ||
| wp_4_links | link_rss | varchar(255) | NO | '' | |
| wp_4_options | option_id | bigint(20) unsigned | NO | PRI | |
| wp_4_options | option_name | varchar(191) | NO | UNI | '' |
| wp_4_options | option_value | longtext | NO | ||
| wp_4_options | autoload | varchar(20) | NO | MUL | 'yes' |
| wp_4_postmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_4_postmeta | post_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_postmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_4_postmeta | meta_value | longtext | YES | NULL | |
| wp_4_posts | ID | bigint(20) unsigned | NO | PRI | |
| wp_4_posts | post_author | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_posts | post_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_4_posts | post_date_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_4_posts | post_content | longtext | NO | ||
| wp_4_posts | post_title | text | NO | ||
| wp_4_posts | post_excerpt | text | NO | ||
| wp_4_posts | post_status | varchar(20) | NO | 'publish' | |
| wp_4_posts | comment_status | varchar(20) | NO | 'open' | |
| wp_4_posts | ping_status | varchar(20) | NO | 'open' | |
| wp_4_posts | post_password | varchar(255) | NO | '' | |
| wp_4_posts | post_name | varchar(200) | NO | MUL | '' |
| wp_4_posts | to_ping | text | NO | ||
| wp_4_posts | pinged | text | NO | ||
| wp_4_posts | post_modified | datetime | NO | '0000-00-00 00:00:00' | |
| wp_4_posts | post_modified_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_4_posts | post_content_filtered | longtext | NO | ||
| wp_4_posts | post_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_posts | guid | varchar(255) | NO | '' | |
| wp_4_posts | menu_order | int(11) | NO | 0 | |
| wp_4_posts | post_type | varchar(20) | NO | MUL | 'post' |
| wp_4_posts | post_mime_type | varchar(100) | NO | '' | |
| wp_4_posts | comment_count | bigint(20) | NO | 0 | |
| wp_4_termmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_4_termmeta | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_termmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_4_termmeta | meta_value | longtext | YES | NULL | |
| wp_4_terms | term_id | bigint(20) unsigned | NO | PRI | |
| wp_4_terms | name | varchar(200) | NO | MUL | '' |
| wp_4_terms | slug | varchar(200) | NO | MUL | '' |
| wp_4_terms | term_group | bigint(10) | NO | 0 | |
| wp_4_term_relationships | object_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_4_term_relationships | term_taxonomy_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_4_term_relationships | term_order | int(11) | NO | 0 | |
| wp_4_term_taxonomy | term_taxonomy_id | bigint(20) unsigned | NO | PRI | |
| wp_4_term_taxonomy | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_4_term_taxonomy | taxonomy | varchar(32) | NO | MUL | '' |
| wp_4_term_taxonomy | description | longtext | NO | ||
| wp_4_term_taxonomy | parent | bigint(20) unsigned | NO | 0 | |
| wp_4_term_taxonomy | count | bigint(20) | NO | 0 | |
| wp_4_wpmailsmtp_debug_events | id | int(10) unsigned | NO | PRI | |
| wp_4_wpmailsmtp_debug_events | content | text | YES | NULL | |
| wp_4_wpmailsmtp_debug_events | initiator | text | YES | NULL | |
| wp_4_wpmailsmtp_debug_events | event_type | tinyint(3) unsigned | NO | 0 | |
| wp_4_wpmailsmtp_debug_events | created_at | timestamp | NO | current_timestamp() | |
| wp_4_wpmailsmtp_emails_log | id | int(10) unsigned | NO | PRI | |
| wp_4_wpmailsmtp_emails_log | subject | varchar(191) | NO | MUL | |
| wp_4_wpmailsmtp_emails_log | message_id | varchar(255) | YES | MUL | NULL |
| wp_4_wpmailsmtp_emails_log | people | text | NO | ||
| wp_4_wpmailsmtp_emails_log | headers | text | NO | ||
| wp_4_wpmailsmtp_emails_log | error_text | text | YES | NULL | |
| wp_4_wpmailsmtp_emails_log | content_plain | longtext | NO | ||
| wp_4_wpmailsmtp_emails_log | content_html | longtext | NO | ||
| wp_4_wpmailsmtp_emails_log | status | tinyint(3) unsigned | NO | MUL | 0 |
| wp_4_wpmailsmtp_emails_log | date_sent | timestamp | NO | MUL | current_timestamp() |
| wp_4_wpmailsmtp_emails_log | mailer | varchar(255) | NO | ||
| wp_4_wpmailsmtp_emails_log | attachments | tinyint(3) unsigned | NO | 0 | |
| wp_4_wpmailsmtp_emails_log | initiator_name | varchar(255) | YES | NULL | |
| wp_4_wpmailsmtp_emails_log | initiator_file | text | YES | NULL | |
| wp_4_wpmailsmtp_emails_log | parent_id | int(10) unsigned | NO | 0 | |
| wp_4_wpmailsmtp_tasks_meta | id | bigint(20) | NO | PRI | |
| wp_4_wpmailsmtp_tasks_meta | action | varchar(255) | NO | ||
| wp_4_wpmailsmtp_tasks_meta | data | longtext | NO | ||
| wp_4_wpmailsmtp_tasks_meta | date | datetime | NO | ||
| wp_5_actionscheduler_actions | action_id | bigint(20) unsigned | NO | PRI | |
| wp_5_actionscheduler_actions | hook | varchar(191) | NO | MUL | |
| wp_5_actionscheduler_actions | status | varchar(20) | NO | MUL | |
| wp_5_actionscheduler_actions | scheduled_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_5_actionscheduler_actions | scheduled_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_5_actionscheduler_actions | priority | tinyint(3) unsigned | NO | 10 | |
| wp_5_actionscheduler_actions | args | varchar(191) | YES | MUL | NULL |
| wp_5_actionscheduler_actions | schedule | longtext | YES | NULL | |
| wp_5_actionscheduler_actions | group_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_actionscheduler_actions | attempts | int(11) | NO | 0 | |
| wp_5_actionscheduler_actions | last_attempt_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_5_actionscheduler_actions | last_attempt_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_5_actionscheduler_actions | claim_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_actionscheduler_actions | extended_args | varchar(8000) | YES | NULL | |
| wp_5_actionscheduler_claims | claim_id | bigint(20) unsigned | NO | PRI | |
| wp_5_actionscheduler_claims | date_created_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_5_actionscheduler_groups | group_id | bigint(20) unsigned | NO | PRI | |
| wp_5_actionscheduler_groups | slug | varchar(255) | NO | MUL | |
| wp_5_actionscheduler_logs | log_id | bigint(20) unsigned | NO | PRI | |
| wp_5_actionscheduler_logs | action_id | bigint(20) unsigned | NO | MUL | |
| wp_5_actionscheduler_logs | message | text | NO | ||
| wp_5_actionscheduler_logs | log_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_5_actionscheduler_logs | log_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_5_commentmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_5_commentmeta | comment_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_commentmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_5_commentmeta | meta_value | longtext | YES | NULL | |
| wp_5_comments | comment_ID | bigint(20) unsigned | NO | PRI | |
| wp_5_comments | comment_post_ID | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_comments | comment_author | tinytext | NO | ||
| wp_5_comments | comment_author_email | varchar(100) | NO | MUL | '' |
| wp_5_comments | comment_author_url | varchar(200) | NO | '' | |
| wp_5_comments | comment_author_IP | varchar(100) | NO | '' | |
| wp_5_comments | comment_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_5_comments | comment_date_gmt | datetime | NO | MUL | '0000-00-00 00:00:00' |
| wp_5_comments | comment_content | text | NO | ||
| wp_5_comments | comment_karma | int(11) | NO | 0 | |
| wp_5_comments | comment_approved | varchar(20) | NO | MUL | '1' |
| wp_5_comments | comment_agent | varchar(255) | NO | '' | |
| wp_5_comments | comment_type | varchar(20) | NO | 'comment' | |
| wp_5_comments | comment_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_comments | user_id | bigint(20) unsigned | NO | 0 | |
| wp_5_links | link_id | bigint(20) unsigned | NO | PRI | |
| wp_5_links | link_url | varchar(255) | NO | '' | |
| wp_5_links | link_name | varchar(255) | NO | '' | |
| wp_5_links | link_image | varchar(255) | NO | '' | |
| wp_5_links | link_target | varchar(25) | NO | '' | |
| wp_5_links | link_description | varchar(255) | NO | '' | |
| wp_5_links | link_visible | varchar(20) | NO | MUL | 'Y' |
| wp_5_links | link_owner | bigint(20) unsigned | NO | 1 | |
| wp_5_links | link_rating | int(11) | NO | 0 | |
| wp_5_links | link_updated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_5_links | link_rel | varchar(255) | NO | '' | |
| wp_5_links | link_notes | mediumtext | NO | ||
| wp_5_links | link_rss | varchar(255) | NO | '' | |
| wp_5_options | option_id | bigint(20) unsigned | NO | PRI | |
| wp_5_options | option_name | varchar(191) | NO | UNI | '' |
| wp_5_options | option_value | longtext | NO | ||
| wp_5_options | autoload | varchar(20) | NO | MUL | 'yes' |
| wp_5_postmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_5_postmeta | post_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_postmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_5_postmeta | meta_value | longtext | YES | NULL | |
| wp_5_posts | ID | bigint(20) unsigned | NO | PRI | |
| wp_5_posts | post_author | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_posts | post_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_5_posts | post_date_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_5_posts | post_content | longtext | NO | ||
| wp_5_posts | post_title | text | NO | ||
| wp_5_posts | post_excerpt | text | NO | ||
| wp_5_posts | post_status | varchar(20) | NO | 'publish' | |
| wp_5_posts | comment_status | varchar(20) | NO | 'open' | |
| wp_5_posts | ping_status | varchar(20) | NO | 'open' | |
| wp_5_posts | post_password | varchar(255) | NO | '' | |
| wp_5_posts | post_name | varchar(200) | NO | MUL | '' |
| wp_5_posts | to_ping | text | NO | ||
| wp_5_posts | pinged | text | NO | ||
| wp_5_posts | post_modified | datetime | NO | '0000-00-00 00:00:00' | |
| wp_5_posts | post_modified_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_5_posts | post_content_filtered | longtext | NO | ||
| wp_5_posts | post_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_posts | guid | varchar(255) | NO | '' | |
| wp_5_posts | menu_order | int(11) | NO | 0 | |
| wp_5_posts | post_type | varchar(20) | NO | MUL | 'post' |
| wp_5_posts | post_mime_type | varchar(100) | NO | '' | |
| wp_5_posts | comment_count | bigint(20) | NO | 0 | |
| wp_5_termmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_5_termmeta | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_termmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_5_termmeta | meta_value | longtext | YES | NULL | |
| wp_5_terms | term_id | bigint(20) unsigned | NO | PRI | |
| wp_5_terms | name | varchar(200) | NO | MUL | '' |
| wp_5_terms | slug | varchar(200) | NO | MUL | '' |
| wp_5_terms | term_group | bigint(10) | NO | 0 | |
| wp_5_term_relationships | object_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_5_term_relationships | term_taxonomy_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_5_term_relationships | term_order | int(11) | NO | 0 | |
| wp_5_term_taxonomy | term_taxonomy_id | bigint(20) unsigned | NO | PRI | |
| wp_5_term_taxonomy | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_5_term_taxonomy | taxonomy | varchar(32) | NO | MUL | '' |
| wp_5_term_taxonomy | description | longtext | NO | ||
| wp_5_term_taxonomy | parent | bigint(20) unsigned | NO | 0 | |
| wp_5_term_taxonomy | count | bigint(20) | NO | 0 | |
| wp_5_wpmailsmtp_debug_events | id | int(10) unsigned | NO | PRI | |
| wp_5_wpmailsmtp_debug_events | content | text | YES | NULL | |
| wp_5_wpmailsmtp_debug_events | initiator | text | YES | NULL | |
| wp_5_wpmailsmtp_debug_events | event_type | tinyint(3) unsigned | NO | 0 | |
| wp_5_wpmailsmtp_debug_events | created_at | timestamp | NO | current_timestamp() | |
| wp_5_wpmailsmtp_emails_log | id | int(10) unsigned | NO | PRI | |
| wp_5_wpmailsmtp_emails_log | message_id | varchar(255) | YES | MUL | NULL |
| wp_5_wpmailsmtp_emails_log | subject | varchar(191) | NO | MUL | |
| wp_5_wpmailsmtp_emails_log | people | text | NO | ||
| wp_5_wpmailsmtp_emails_log | headers | text | NO | ||
| wp_5_wpmailsmtp_emails_log | error_text | text | YES | NULL | |
| wp_5_wpmailsmtp_emails_log | content_plain | longtext | NO | ||
| wp_5_wpmailsmtp_emails_log | content_html | longtext | NO | ||
| wp_5_wpmailsmtp_emails_log | status | tinyint(3) unsigned | NO | MUL | 0 |
| wp_5_wpmailsmtp_emails_log | date_sent | timestamp | NO | MUL | current_timestamp() |
| wp_5_wpmailsmtp_emails_log | mailer | varchar(255) | NO | ||
| wp_5_wpmailsmtp_emails_log | attachments | tinyint(3) unsigned | NO | 0 | |
| wp_5_wpmailsmtp_emails_log | initiator_name | varchar(255) | YES | NULL | |
| wp_5_wpmailsmtp_emails_log | initiator_file | text | YES | NULL | |
| wp_5_wpmailsmtp_emails_log | parent_id | int(10) unsigned | NO | 0 | |
| wp_5_wpmailsmtp_tasks_meta | id | bigint(20) | NO | PRI | |
| wp_5_wpmailsmtp_tasks_meta | action | varchar(255) | NO | ||
| wp_5_wpmailsmtp_tasks_meta | data | longtext | NO | ||
| wp_5_wpmailsmtp_tasks_meta | date | datetime | NO | ||
| wp_6_actionscheduler_actions | action_id | bigint(20) unsigned | NO | PRI | |
| wp_6_actionscheduler_actions | hook | varchar(191) | NO | MUL | |
| wp_6_actionscheduler_actions | status | varchar(20) | NO | MUL | |
| wp_6_actionscheduler_actions | scheduled_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_6_actionscheduler_actions | scheduled_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_6_actionscheduler_actions | priority | tinyint(3) unsigned | NO | 10 | |
| wp_6_actionscheduler_actions | args | varchar(191) | YES | MUL | NULL |
| wp_6_actionscheduler_actions | schedule | longtext | YES | NULL | |
| wp_6_actionscheduler_actions | group_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_actionscheduler_actions | attempts | int(11) | NO | 0 | |
| wp_6_actionscheduler_actions | last_attempt_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_6_actionscheduler_actions | last_attempt_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_6_actionscheduler_actions | claim_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_actionscheduler_actions | extended_args | varchar(8000) | YES | NULL | |
| wp_6_actionscheduler_claims | claim_id | bigint(20) unsigned | NO | PRI | |
| wp_6_actionscheduler_claims | date_created_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_6_actionscheduler_groups | group_id | bigint(20) unsigned | NO | PRI | |
| wp_6_actionscheduler_groups | slug | varchar(255) | NO | MUL | |
| wp_6_actionscheduler_logs | log_id | bigint(20) unsigned | NO | PRI | |
| wp_6_actionscheduler_logs | action_id | bigint(20) unsigned | NO | MUL | |
| wp_6_actionscheduler_logs | message | text | NO | ||
| wp_6_actionscheduler_logs | log_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_6_actionscheduler_logs | log_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_6_commentmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_6_commentmeta | comment_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_commentmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_6_commentmeta | meta_value | longtext | YES | NULL | |
| wp_6_comments | comment_ID | bigint(20) unsigned | NO | PRI | |
| wp_6_comments | comment_post_ID | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_comments | comment_author | tinytext | NO | ||
| wp_6_comments | comment_author_email | varchar(100) | NO | MUL | '' |
| wp_6_comments | comment_author_url | varchar(200) | NO | '' | |
| wp_6_comments | comment_author_IP | varchar(100) | NO | '' | |
| wp_6_comments | comment_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_6_comments | comment_date_gmt | datetime | NO | MUL | '0000-00-00 00:00:00' |
| wp_6_comments | comment_content | text | NO | ||
| wp_6_comments | comment_karma | int(11) | NO | 0 | |
| wp_6_comments | comment_approved | varchar(20) | NO | MUL | '1' |
| wp_6_comments | comment_agent | varchar(255) | NO | '' | |
| wp_6_comments | comment_type | varchar(20) | NO | 'comment' | |
| wp_6_comments | comment_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_comments | user_id | bigint(20) unsigned | NO | 0 | |
| wp_6_links | link_id | bigint(20) unsigned | NO | PRI | |
| wp_6_links | link_url | varchar(255) | NO | '' | |
| wp_6_links | link_name | varchar(255) | NO | '' | |
| wp_6_links | link_image | varchar(255) | NO | '' | |
| wp_6_links | link_target | varchar(25) | NO | '' | |
| wp_6_links | link_description | varchar(255) | NO | '' | |
| wp_6_links | link_visible | varchar(20) | NO | MUL | 'Y' |
| wp_6_links | link_owner | bigint(20) unsigned | NO | 1 | |
| wp_6_links | link_rating | int(11) | NO | 0 | |
| wp_6_links | link_updated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_6_links | link_rel | varchar(255) | NO | '' | |
| wp_6_links | link_notes | mediumtext | NO | ||
| wp_6_links | link_rss | varchar(255) | NO | '' | |
| wp_6_options | option_id | bigint(20) unsigned | NO | PRI | |
| wp_6_options | option_name | varchar(191) | NO | UNI | '' |
| wp_6_options | option_value | longtext | NO | ||
| wp_6_options | autoload | varchar(20) | NO | MUL | 'yes' |
| wp_6_postmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_6_postmeta | post_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_postmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_6_postmeta | meta_value | longtext | YES | NULL | |
| wp_6_posts | ID | bigint(20) unsigned | NO | PRI | |
| wp_6_posts | post_author | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_posts | post_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_6_posts | post_date_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_6_posts | post_content | longtext | NO | ||
| wp_6_posts | post_title | text | NO | ||
| wp_6_posts | post_excerpt | text | NO | ||
| wp_6_posts | post_status | varchar(20) | NO | 'publish' | |
| wp_6_posts | comment_status | varchar(20) | NO | 'open' | |
| wp_6_posts | ping_status | varchar(20) | NO | 'open' | |
| wp_6_posts | post_password | varchar(255) | NO | '' | |
| wp_6_posts | post_name | varchar(200) | NO | MUL | '' |
| wp_6_posts | to_ping | text | NO | ||
| wp_6_posts | pinged | text | NO | ||
| wp_6_posts | post_modified | datetime | NO | '0000-00-00 00:00:00' | |
| wp_6_posts | post_modified_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_6_posts | post_content_filtered | longtext | NO | ||
| wp_6_posts | post_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_posts | guid | varchar(255) | NO | '' | |
| wp_6_posts | menu_order | int(11) | NO | 0 | |
| wp_6_posts | post_type | varchar(20) | NO | MUL | 'post' |
| wp_6_posts | post_mime_type | varchar(100) | NO | '' | |
| wp_6_posts | comment_count | bigint(20) | NO | 0 | |
| wp_6_termmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_6_termmeta | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_termmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_6_termmeta | meta_value | longtext | YES | NULL | |
| wp_6_terms | term_id | bigint(20) unsigned | NO | PRI | |
| wp_6_terms | name | varchar(200) | NO | MUL | '' |
| wp_6_terms | slug | varchar(200) | NO | MUL | '' |
| wp_6_terms | term_group | bigint(10) | NO | 0 | |
| wp_6_term_relationships | object_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_6_term_relationships | term_taxonomy_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_6_term_relationships | term_order | int(11) | NO | 0 | |
| wp_6_term_taxonomy | term_taxonomy_id | bigint(20) unsigned | NO | PRI | |
| wp_6_term_taxonomy | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_6_term_taxonomy | taxonomy | varchar(32) | NO | MUL | '' |
| wp_6_term_taxonomy | description | longtext | NO | ||
| wp_6_term_taxonomy | parent | bigint(20) unsigned | NO | 0 | |
| wp_6_term_taxonomy | count | bigint(20) | NO | 0 | |
| wp_6_wpmailsmtp_debug_events | id | int(10) unsigned | NO | PRI | |
| wp_6_wpmailsmtp_debug_events | content | text | YES | NULL | |
| wp_6_wpmailsmtp_debug_events | initiator | text | YES | NULL | |
| wp_6_wpmailsmtp_debug_events | event_type | tinyint(3) unsigned | NO | 0 | |
| wp_6_wpmailsmtp_debug_events | created_at | timestamp | NO | current_timestamp() | |
| wp_6_wpmailsmtp_emails_log | id | int(10) unsigned | NO | PRI | |
| wp_6_wpmailsmtp_emails_log | message_id | varchar(255) | YES | MUL | NULL |
| wp_6_wpmailsmtp_emails_log | subject | varchar(191) | NO | MUL | |
| wp_6_wpmailsmtp_emails_log | people | text | NO | ||
| wp_6_wpmailsmtp_emails_log | headers | text | NO | ||
| wp_6_wpmailsmtp_emails_log | error_text | text | YES | NULL | |
| wp_6_wpmailsmtp_emails_log | content_plain | longtext | NO | ||
| wp_6_wpmailsmtp_emails_log | content_html | longtext | NO | ||
| wp_6_wpmailsmtp_emails_log | status | tinyint(3) unsigned | NO | MUL | 0 |
| wp_6_wpmailsmtp_emails_log | date_sent | timestamp | NO | MUL | current_timestamp() |
| wp_6_wpmailsmtp_emails_log | mailer | varchar(255) | NO | ||
| wp_6_wpmailsmtp_emails_log | attachments | tinyint(3) unsigned | NO | 0 | |
| wp_6_wpmailsmtp_emails_log | initiator_name | varchar(255) | YES | NULL | |
| wp_6_wpmailsmtp_emails_log | initiator_file | text | YES | NULL | |
| wp_6_wpmailsmtp_emails_log | parent_id | int(10) unsigned | NO | 0 | |
| wp_6_wpmailsmtp_tasks_meta | id | bigint(20) | NO | PRI | |
| wp_6_wpmailsmtp_tasks_meta | action | varchar(255) | NO | ||
| wp_6_wpmailsmtp_tasks_meta | data | longtext | NO | ||
| wp_6_wpmailsmtp_tasks_meta | date | datetime | NO | ||
| wp_7_wpmailsmtp_debug_events | id | int(10) unsigned | NO | PRI | |
| wp_7_wpmailsmtp_debug_events | content | text | YES | NULL | |
| wp_7_wpmailsmtp_debug_events | initiator | text | YES | NULL | |
| wp_7_wpmailsmtp_debug_events | event_type | tinyint(3) unsigned | NO | 0 | |
| wp_7_wpmailsmtp_debug_events | created_at | timestamp | NO | current_timestamp() | |
| wp_7_wpmailsmtp_emails_log | id | int(10) unsigned | NO | PRI | |
| wp_7_wpmailsmtp_emails_log | message_id | varchar(255) | YES | MUL | NULL |
| wp_7_wpmailsmtp_emails_log | subject | varchar(191) | NO | MUL | |
| wp_7_wpmailsmtp_emails_log | people | text | NO | ||
| wp_7_wpmailsmtp_emails_log | headers | text | NO | ||
| wp_7_wpmailsmtp_emails_log | error_text | text | YES | NULL | |
| wp_7_wpmailsmtp_emails_log | content_plain | longtext | NO | ||
| wp_7_wpmailsmtp_emails_log | content_html | longtext | NO | ||
| wp_7_wpmailsmtp_emails_log | status | tinyint(3) unsigned | NO | MUL | 0 |
| wp_7_wpmailsmtp_emails_log | date_sent | timestamp | NO | MUL | current_timestamp() |
| wp_7_wpmailsmtp_emails_log | mailer | varchar(255) | NO | ||
| wp_7_wpmailsmtp_emails_log | attachments | tinyint(3) unsigned | NO | 0 | |
| wp_7_wpmailsmtp_emails_log | initiator_name | varchar(255) | YES | NULL | |
| wp_7_wpmailsmtp_emails_log | initiator_file | text | YES | NULL | |
| wp_7_wpmailsmtp_emails_log | parent_id | int(10) unsigned | NO | 0 | |
| wp_7_wpmailsmtp_tasks_meta | id | bigint(20) | NO | PRI | |
| wp_7_wpmailsmtp_tasks_meta | action | varchar(255) | NO | ||
| wp_7_wpmailsmtp_tasks_meta | data | longtext | NO | ||
| wp_7_wpmailsmtp_tasks_meta | date | datetime | NO | ||
| wp_8_actionscheduler_actions | action_id | bigint(20) unsigned | NO | PRI | |
| wp_8_actionscheduler_actions | hook | varchar(191) | NO | MUL | |
| wp_8_actionscheduler_actions | status | varchar(20) | NO | MUL | |
| wp_8_actionscheduler_actions | scheduled_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_8_actionscheduler_actions | scheduled_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_8_actionscheduler_actions | priority | tinyint(3) unsigned | NO | 10 | |
| wp_8_actionscheduler_actions | args | varchar(191) | YES | MUL | NULL |
| wp_8_actionscheduler_actions | schedule | longtext | YES | NULL | |
| wp_8_actionscheduler_actions | group_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_actionscheduler_actions | attempts | int(11) | NO | 0 | |
| wp_8_actionscheduler_actions | last_attempt_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_8_actionscheduler_actions | last_attempt_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_8_actionscheduler_actions | claim_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_actionscheduler_actions | extended_args | varchar(8000) | YES | NULL | |
| wp_8_actionscheduler_claims | claim_id | bigint(20) unsigned | NO | PRI | |
| wp_8_actionscheduler_claims | date_created_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_8_actionscheduler_groups | group_id | bigint(20) unsigned | NO | PRI | |
| wp_8_actionscheduler_groups | slug | varchar(255) | NO | MUL | |
| wp_8_actionscheduler_logs | log_id | bigint(20) unsigned | NO | PRI | |
| wp_8_actionscheduler_logs | action_id | bigint(20) unsigned | NO | MUL | |
| wp_8_actionscheduler_logs | message | text | NO | ||
| wp_8_actionscheduler_logs | log_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_8_actionscheduler_logs | log_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_8_commentmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_8_commentmeta | comment_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_commentmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_8_commentmeta | meta_value | longtext | YES | NULL | |
| wp_8_comments | comment_ID | bigint(20) unsigned | NO | PRI | |
| wp_8_comments | comment_post_ID | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_comments | comment_author | tinytext | NO | ||
| wp_8_comments | comment_author_email | varchar(100) | NO | MUL | '' |
| wp_8_comments | comment_author_url | varchar(200) | NO | '' | |
| wp_8_comments | comment_author_IP | varchar(100) | NO | '' | |
| wp_8_comments | comment_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_8_comments | comment_date_gmt | datetime | NO | MUL | '0000-00-00 00:00:00' |
| wp_8_comments | comment_content | text | NO | ||
| wp_8_comments | comment_karma | int(11) | NO | 0 | |
| wp_8_comments | comment_approved | varchar(20) | NO | MUL | '1' |
| wp_8_comments | comment_agent | varchar(255) | NO | '' | |
| wp_8_comments | comment_type | varchar(20) | NO | 'comment' | |
| wp_8_comments | comment_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_comments | user_id | bigint(20) unsigned | NO | 0 | |
| wp_8_links | link_id | bigint(20) unsigned | NO | PRI | |
| wp_8_links | link_url | varchar(255) | NO | '' | |
| wp_8_links | link_name | varchar(255) | NO | '' | |
| wp_8_links | link_image | varchar(255) | NO | '' | |
| wp_8_links | link_target | varchar(25) | NO | '' | |
| wp_8_links | link_description | varchar(255) | NO | '' | |
| wp_8_links | link_visible | varchar(20) | NO | MUL | 'Y' |
| wp_8_links | link_owner | bigint(20) unsigned | NO | 1 | |
| wp_8_links | link_rating | int(11) | NO | 0 | |
| wp_8_links | link_updated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_8_links | link_rel | varchar(255) | NO | '' | |
| wp_8_links | link_notes | mediumtext | NO | ||
| wp_8_links | link_rss | varchar(255) | NO | '' | |
| wp_8_options | option_id | bigint(20) unsigned | NO | PRI | |
| wp_8_options | option_name | varchar(191) | NO | UNI | '' |
| wp_8_options | option_value | longtext | NO | ||
| wp_8_options | autoload | varchar(20) | NO | MUL | 'yes' |
| wp_8_postmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_8_postmeta | post_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_postmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_8_postmeta | meta_value | longtext | YES | NULL | |
| wp_8_posts | ID | bigint(20) unsigned | NO | PRI | |
| wp_8_posts | post_author | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_posts | post_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_8_posts | post_date_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_8_posts | post_content | longtext | NO | ||
| wp_8_posts | post_title | text | NO | ||
| wp_8_posts | post_excerpt | text | NO | ||
| wp_8_posts | post_status | varchar(20) | NO | 'publish' | |
| wp_8_posts | comment_status | varchar(20) | NO | 'open' | |
| wp_8_posts | ping_status | varchar(20) | NO | 'open' | |
| wp_8_posts | post_password | varchar(255) | NO | '' | |
| wp_8_posts | post_name | varchar(200) | NO | MUL | '' |
| wp_8_posts | to_ping | text | NO | ||
| wp_8_posts | pinged | text | NO | ||
| wp_8_posts | post_modified | datetime | NO | '0000-00-00 00:00:00' | |
| wp_8_posts | post_modified_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_8_posts | post_content_filtered | longtext | NO | ||
| wp_8_posts | post_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_posts | guid | varchar(255) | NO | '' | |
| wp_8_posts | menu_order | int(11) | NO | 0 | |
| wp_8_posts | post_type | varchar(20) | NO | MUL | 'post' |
| wp_8_posts | post_mime_type | varchar(100) | NO | '' | |
| wp_8_posts | comment_count | bigint(20) | NO | 0 | |
| wp_8_termmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_8_termmeta | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_termmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_8_termmeta | meta_value | longtext | YES | NULL | |
| wp_8_terms | term_id | bigint(20) unsigned | NO | PRI | |
| wp_8_terms | name | varchar(200) | NO | MUL | '' |
| wp_8_terms | slug | varchar(200) | NO | MUL | '' |
| wp_8_terms | term_group | bigint(10) | NO | 0 | |
| wp_8_term_relationships | object_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_8_term_relationships | term_taxonomy_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_8_term_relationships | term_order | int(11) | NO | 0 | |
| wp_8_term_taxonomy | term_taxonomy_id | bigint(20) unsigned | NO | PRI | |
| wp_8_term_taxonomy | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_8_term_taxonomy | taxonomy | varchar(32) | NO | MUL | '' |
| wp_8_term_taxonomy | description | longtext | NO | ||
| wp_8_term_taxonomy | parent | bigint(20) unsigned | NO | 0 | |
| wp_8_term_taxonomy | count | bigint(20) | NO | 0 | |
| wp_8_wpmailsmtp_debug_events | id | int(10) unsigned | NO | PRI | |
| wp_8_wpmailsmtp_debug_events | content | text | YES | NULL | |
| wp_8_wpmailsmtp_debug_events | initiator | text | YES | NULL | |
| wp_8_wpmailsmtp_debug_events | event_type | tinyint(3) unsigned | NO | 0 | |
| wp_8_wpmailsmtp_debug_events | created_at | timestamp | NO | current_timestamp() | |
| wp_8_wpmailsmtp_emails_log | id | int(10) unsigned | NO | PRI | |
| wp_8_wpmailsmtp_emails_log | message_id | varchar(255) | YES | MUL | NULL |
| wp_8_wpmailsmtp_emails_log | subject | varchar(191) | NO | MUL | |
| wp_8_wpmailsmtp_emails_log | people | text | NO | ||
| wp_8_wpmailsmtp_emails_log | headers | text | NO | ||
| wp_8_wpmailsmtp_emails_log | error_text | text | YES | NULL | |
| wp_8_wpmailsmtp_emails_log | content_plain | longtext | NO | ||
| wp_8_wpmailsmtp_emails_log | content_html | longtext | NO | ||
| wp_8_wpmailsmtp_emails_log | status | tinyint(3) unsigned | NO | MUL | 0 |
| wp_8_wpmailsmtp_emails_log | date_sent | timestamp | NO | MUL | current_timestamp() |
| wp_8_wpmailsmtp_emails_log | mailer | varchar(255) | NO | ||
| wp_8_wpmailsmtp_emails_log | attachments | tinyint(3) unsigned | NO | 0 | |
| wp_8_wpmailsmtp_emails_log | initiator_name | varchar(255) | YES | NULL | |
| wp_8_wpmailsmtp_emails_log | initiator_file | text | YES | NULL | |
| wp_8_wpmailsmtp_emails_log | parent_id | int(10) unsigned | NO | 0 | |
| wp_8_wpmailsmtp_tasks_meta | id | bigint(20) | NO | PRI | |
| wp_8_wpmailsmtp_tasks_meta | action | varchar(255) | NO | ||
| wp_8_wpmailsmtp_tasks_meta | data | longtext | NO | ||
| wp_8_wpmailsmtp_tasks_meta | date | datetime | NO | ||
| wp_9_actionscheduler_actions | action_id | bigint(20) unsigned | NO | PRI | |
| wp_9_actionscheduler_actions | hook | varchar(191) | NO | MUL | |
| wp_9_actionscheduler_actions | status | varchar(20) | NO | MUL | |
| wp_9_actionscheduler_actions | scheduled_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_9_actionscheduler_actions | scheduled_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_9_actionscheduler_actions | priority | tinyint(3) unsigned | NO | 10 | |
| wp_9_actionscheduler_actions | args | varchar(191) | YES | MUL | NULL |
| wp_9_actionscheduler_actions | schedule | longtext | YES | NULL | |
| wp_9_actionscheduler_actions | group_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_actionscheduler_actions | attempts | int(11) | NO | 0 | |
| wp_9_actionscheduler_actions | last_attempt_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_9_actionscheduler_actions | last_attempt_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_9_actionscheduler_actions | claim_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_actionscheduler_actions | extended_args | varchar(8000) | YES | NULL | |
| wp_9_actionscheduler_claims | claim_id | bigint(20) unsigned | NO | PRI | |
| wp_9_actionscheduler_claims | date_created_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_9_actionscheduler_groups | group_id | bigint(20) unsigned | NO | PRI | |
| wp_9_actionscheduler_groups | slug | varchar(255) | NO | MUL | |
| wp_9_actionscheduler_logs | log_id | bigint(20) unsigned | NO | PRI | |
| wp_9_actionscheduler_logs | action_id | bigint(20) unsigned | NO | MUL | |
| wp_9_actionscheduler_logs | message | text | NO | ||
| wp_9_actionscheduler_logs | log_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_9_actionscheduler_logs | log_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_9_commentmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_9_commentmeta | comment_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_commentmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_9_commentmeta | meta_value | longtext | YES | NULL | |
| wp_9_comments | comment_ID | bigint(20) unsigned | NO | PRI | |
| wp_9_comments | comment_post_ID | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_comments | comment_author | tinytext | NO | ||
| wp_9_comments | comment_author_email | varchar(100) | NO | MUL | '' |
| wp_9_comments | comment_author_url | varchar(200) | NO | '' | |
| wp_9_comments | comment_author_IP | varchar(100) | NO | '' | |
| wp_9_comments | comment_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_9_comments | comment_date_gmt | datetime | NO | MUL | '0000-00-00 00:00:00' |
| wp_9_comments | comment_content | text | NO | ||
| wp_9_comments | comment_karma | int(11) | NO | 0 | |
| wp_9_comments | comment_approved | varchar(20) | NO | MUL | '1' |
| wp_9_comments | comment_agent | varchar(255) | NO | '' | |
| wp_9_comments | comment_type | varchar(20) | NO | 'comment' | |
| wp_9_comments | comment_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_comments | user_id | bigint(20) unsigned | NO | 0 | |
| wp_9_links | link_id | bigint(20) unsigned | NO | PRI | |
| wp_9_links | link_url | varchar(255) | NO | '' | |
| wp_9_links | link_name | varchar(255) | NO | '' | |
| wp_9_links | link_image | varchar(255) | NO | '' | |
| wp_9_links | link_target | varchar(25) | NO | '' | |
| wp_9_links | link_description | varchar(255) | NO | '' | |
| wp_9_links | link_visible | varchar(20) | NO | MUL | 'Y' |
| wp_9_links | link_owner | bigint(20) unsigned | NO | 1 | |
| wp_9_links | link_rating | int(11) | NO | 0 | |
| wp_9_links | link_updated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_9_links | link_rel | varchar(255) | NO | '' | |
| wp_9_links | link_notes | mediumtext | NO | ||
| wp_9_links | link_rss | varchar(255) | NO | '' | |
| wp_9_options | option_id | bigint(20) unsigned | NO | PRI | |
| wp_9_options | option_name | varchar(191) | NO | UNI | '' |
| wp_9_options | option_value | longtext | NO | ||
| wp_9_options | autoload | varchar(20) | NO | MUL | 'yes' |
| wp_9_postmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_9_postmeta | post_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_postmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_9_postmeta | meta_value | longtext | YES | NULL | |
| wp_9_posts | ID | bigint(20) unsigned | NO | PRI | |
| wp_9_posts | post_author | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_posts | post_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_9_posts | post_date_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_9_posts | post_content | longtext | NO | ||
| wp_9_posts | post_title | text | NO | ||
| wp_9_posts | post_excerpt | text | NO | ||
| wp_9_posts | post_status | varchar(20) | NO | 'publish' | |
| wp_9_posts | comment_status | varchar(20) | NO | 'open' | |
| wp_9_posts | ping_status | varchar(20) | NO | 'open' | |
| wp_9_posts | post_password | varchar(255) | NO | '' | |
| wp_9_posts | post_name | varchar(200) | NO | MUL | '' |
| wp_9_posts | to_ping | text | NO | ||
| wp_9_posts | pinged | text | NO | ||
| wp_9_posts | post_modified | datetime | NO | '0000-00-00 00:00:00' | |
| wp_9_posts | post_modified_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_9_posts | post_content_filtered | longtext | NO | ||
| wp_9_posts | post_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_posts | guid | varchar(255) | NO | '' | |
| wp_9_posts | menu_order | int(11) | NO | 0 | |
| wp_9_posts | post_type | varchar(20) | NO | MUL | 'post' |
| wp_9_posts | post_mime_type | varchar(100) | NO | '' | |
| wp_9_posts | comment_count | bigint(20) | NO | 0 | |
| wp_9_termmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_9_termmeta | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_termmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_9_termmeta | meta_value | longtext | YES | NULL | |
| wp_9_terms | term_id | bigint(20) unsigned | NO | PRI | |
| wp_9_terms | name | varchar(200) | NO | MUL | '' |
| wp_9_terms | slug | varchar(200) | NO | MUL | '' |
| wp_9_terms | term_group | bigint(10) | NO | 0 | |
| wp_9_term_relationships | object_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_9_term_relationships | term_taxonomy_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_9_term_relationships | term_order | int(11) | NO | 0 | |
| wp_9_term_taxonomy | term_taxonomy_id | bigint(20) unsigned | NO | PRI | |
| wp_9_term_taxonomy | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_9_term_taxonomy | taxonomy | varchar(32) | NO | MUL | '' |
| wp_9_term_taxonomy | description | longtext | NO | ||
| wp_9_term_taxonomy | parent | bigint(20) unsigned | NO | 0 | |
| wp_9_term_taxonomy | count | bigint(20) | NO | 0 | |
| wp_9_wpmailsmtp_debug_events | id | int(10) unsigned | NO | PRI | |
| wp_9_wpmailsmtp_debug_events | content | text | YES | NULL | |
| wp_9_wpmailsmtp_debug_events | initiator | text | YES | NULL | |
| wp_9_wpmailsmtp_debug_events | event_type | tinyint(3) unsigned | NO | 0 | |
| wp_9_wpmailsmtp_debug_events | created_at | timestamp | NO | current_timestamp() | |
| wp_9_wpmailsmtp_emails_log | id | int(10) unsigned | NO | PRI | |
| wp_9_wpmailsmtp_emails_log | message_id | varchar(255) | YES | MUL | NULL |
| wp_9_wpmailsmtp_emails_log | subject | varchar(191) | NO | MUL | |
| wp_9_wpmailsmtp_emails_log | people | text | NO | ||
| wp_9_wpmailsmtp_emails_log | headers | text | NO | ||
| wp_9_wpmailsmtp_emails_log | error_text | text | YES | NULL | |
| wp_9_wpmailsmtp_emails_log | content_plain | longtext | NO | ||
| wp_9_wpmailsmtp_emails_log | content_html | longtext | NO | ||
| wp_9_wpmailsmtp_emails_log | status | tinyint(3) unsigned | NO | MUL | 0 |
| wp_9_wpmailsmtp_emails_log | date_sent | timestamp | NO | MUL | current_timestamp() |
| wp_9_wpmailsmtp_emails_log | mailer | varchar(255) | NO | ||
| wp_9_wpmailsmtp_emails_log | attachments | tinyint(3) unsigned | NO | 0 | |
| wp_9_wpmailsmtp_emails_log | initiator_name | varchar(255) | YES | NULL | |
| wp_9_wpmailsmtp_emails_log | initiator_file | text | YES | NULL | |
| wp_9_wpmailsmtp_emails_log | parent_id | int(10) unsigned | NO | 0 | |
| wp_9_wpmailsmtp_tasks_meta | id | bigint(20) | NO | PRI | |
| wp_9_wpmailsmtp_tasks_meta | action | varchar(255) | NO | ||
| wp_9_wpmailsmtp_tasks_meta | data | longtext | NO | ||
| wp_9_wpmailsmtp_tasks_meta | date | datetime | NO | ||
| wp_actionscheduler_actions | action_id | bigint(20) unsigned | NO | PRI | |
| wp_actionscheduler_actions | hook | varchar(191) | NO | MUL | |
| wp_actionscheduler_actions | status | varchar(20) | NO | MUL | |
| wp_actionscheduler_actions | scheduled_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_actionscheduler_actions | scheduled_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_actionscheduler_actions | priority | tinyint(3) unsigned | NO | 10 | |
| wp_actionscheduler_actions | args | varchar(191) | YES | MUL | NULL |
| wp_actionscheduler_actions | schedule | longtext | YES | NULL | |
| wp_actionscheduler_actions | group_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_actionscheduler_actions | attempts | int(11) | NO | 0 | |
| wp_actionscheduler_actions | last_attempt_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_actionscheduler_actions | last_attempt_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_actionscheduler_actions | claim_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_actionscheduler_actions | extended_args | varchar(8000) | YES | NULL | |
| wp_actionscheduler_claims | claim_id | bigint(20) unsigned | NO | PRI | |
| wp_actionscheduler_claims | date_created_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_actionscheduler_groups | group_id | bigint(20) unsigned | NO | PRI | |
| wp_actionscheduler_groups | slug | varchar(255) | NO | MUL | |
| wp_actionscheduler_logs | log_id | bigint(20) unsigned | NO | PRI | |
| wp_actionscheduler_logs | action_id | bigint(20) unsigned | NO | MUL | |
| wp_actionscheduler_logs | message | text | NO | ||
| wp_actionscheduler_logs | log_date_gmt | datetime | YES | MUL | '0000-00-00 00:00:00' |
| wp_actionscheduler_logs | log_date_local | datetime | YES | '0000-00-00 00:00:00' | |
| wp_blogmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_blogmeta | blog_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_blogmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_blogmeta | meta_value | longtext | YES | NULL | |
| wp_blogs | blog_id | bigint(20) unsigned | NO | PRI | |
| wp_blogs | site_id | bigint(20) unsigned | NO | 0 | |
| wp_blogs | domain | varchar(200) | NO | MUL | '' |
| wp_blogs | path | varchar(100) | NO | '' | |
| wp_blogs | registered | datetime | NO | '0000-00-00 00:00:00' | |
| wp_blogs | last_updated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_blogs | public | tinyint(2) | NO | 1 | |
| wp_blogs | archived | tinyint(2) | NO | 0 | |
| wp_blogs | mature | tinyint(2) | NO | 0 | |
| wp_blogs | spam | tinyint(2) | NO | 0 | |
| wp_blogs | deleted | tinyint(2) | NO | 0 | |
| wp_blogs | lang_id | int(11) | NO | MUL | 0 |
| wp_commentmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_commentmeta | comment_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_commentmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_commentmeta | meta_value | longtext | YES | NULL | |
| wp_comments | comment_ID | bigint(20) unsigned | NO | PRI | |
| wp_comments | comment_post_ID | bigint(20) unsigned | NO | MUL | 0 |
| wp_comments | comment_author | tinytext | NO | ||
| wp_comments | comment_author_email | varchar(100) | NO | MUL | '' |
| wp_comments | comment_author_url | varchar(200) | NO | '' | |
| wp_comments | comment_author_IP | varchar(100) | NO | '' | |
| wp_comments | comment_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_comments | comment_date_gmt | datetime | NO | MUL | '0000-00-00 00:00:00' |
| wp_comments | comment_content | text | NO | ||
| wp_comments | comment_karma | int(11) | NO | 0 | |
| wp_comments | comment_approved | varchar(20) | NO | MUL | '1' |
| wp_comments | comment_agent | varchar(255) | NO | '' | |
| wp_comments | comment_type | varchar(20) | NO | 'comment' | |
| wp_comments | comment_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_comments | user_id | bigint(20) unsigned | NO | 0 | |
| wp_links | link_id | bigint(20) unsigned | NO | PRI | |
| wp_links | link_url | varchar(255) | NO | '' | |
| wp_links | link_name | varchar(255) | NO | '' | |
| wp_links | link_image | varchar(255) | NO | '' | |
| wp_links | link_target | varchar(25) | NO | '' | |
| wp_links | link_description | varchar(255) | NO | '' | |
| wp_links | link_visible | varchar(20) | NO | MUL | 'Y' |
| wp_links | link_owner | bigint(20) unsigned | NO | 1 | |
| wp_links | link_rating | int(11) | NO | 0 | |
| wp_links | link_updated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_links | link_rel | varchar(255) | NO | '' | |
| wp_links | link_notes | mediumtext | NO | ||
| wp_links | link_rss | varchar(255) | NO | '' | |
| wp_options | option_id | bigint(20) unsigned | NO | PRI | |
| wp_options | option_name | varchar(191) | NO | UNI | '' |
| wp_options | option_value | longtext | NO | ||
| wp_options | autoload | varchar(20) | NO | MUL | 'yes' |
| wp_postmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_postmeta | post_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_postmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_postmeta | meta_value | longtext | YES | NULL | |
| wp_posts | ID | bigint(20) unsigned | NO | PRI | |
| wp_posts | post_author | bigint(20) unsigned | NO | MUL | 0 |
| wp_posts | post_date | datetime | NO | '0000-00-00 00:00:00' | |
| wp_posts | post_date_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_posts | post_content | longtext | NO | ||
| wp_posts | post_title | text | NO | ||
| wp_posts | post_excerpt | text | NO | ||
| wp_posts | post_status | varchar(20) | NO | 'publish' | |
| wp_posts | comment_status | varchar(20) | NO | 'open' | |
| wp_posts | ping_status | varchar(20) | NO | 'open' | |
| wp_posts | post_password | varchar(255) | NO | '' | |
| wp_posts | post_name | varchar(200) | NO | MUL | '' |
| wp_posts | to_ping | text | NO | ||
| wp_posts | pinged | text | NO | ||
| wp_posts | post_modified | datetime | NO | '0000-00-00 00:00:00' | |
| wp_posts | post_modified_gmt | datetime | NO | '0000-00-00 00:00:00' | |
| wp_posts | post_content_filtered | longtext | NO | ||
| wp_posts | post_parent | bigint(20) unsigned | NO | MUL | 0 |
| wp_posts | guid | varchar(255) | NO | '' | |
| wp_posts | menu_order | int(11) | NO | 0 | |
| wp_posts | post_type | varchar(20) | NO | MUL | 'post' |
| wp_posts | post_mime_type | varchar(100) | NO | '' | |
| wp_posts | comment_count | bigint(20) | NO | 0 | |
| wp_registration_log | ID | bigint(20) unsigned | NO | PRI | |
| wp_registration_log | varchar(255) | NO | '' | ||
| wp_registration_log | IP | varchar(30) | NO | MUL | '' |
| wp_registration_log | blog_id | bigint(20) unsigned | NO | 0 | |
| wp_registration_log | date_registered | datetime | NO | '0000-00-00 00:00:00' | |
| wp_signups | signup_id | bigint(20) unsigned | NO | PRI | |
| wp_signups | domain | varchar(200) | NO | MUL | '' |
| wp_signups | path | varchar(100) | NO | '' | |
| wp_signups | title | longtext | NO | ||
| wp_signups | user_login | varchar(60) | NO | MUL | '' |
| wp_signups | user_email | varchar(100) | NO | MUL | '' |
| wp_signups | registered | datetime | NO | '0000-00-00 00:00:00' | |
| wp_signups | activated | datetime | NO | '0000-00-00 00:00:00' | |
| wp_signups | active | tinyint(1) | NO | 0 | |
| wp_signups | activation_key | varchar(50) | NO | MUL | '' |
| wp_signups | meta | longtext | YES | NULL | |
| wp_site | id | bigint(20) unsigned | NO | PRI | |
| wp_site | domain | varchar(200) | NO | MUL | '' |
| wp_site | path | varchar(100) | NO | '' | |
| wp_sitemeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_sitemeta | site_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_sitemeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_sitemeta | meta_value | longtext | YES | NULL | |
| wp_termmeta | meta_id | bigint(20) unsigned | NO | PRI | |
| wp_termmeta | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_termmeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_termmeta | meta_value | longtext | YES | NULL | |
| wp_terms | term_id | bigint(20) unsigned | NO | PRI | |
| wp_terms | name | varchar(200) | NO | MUL | '' |
| wp_terms | slug | varchar(200) | NO | MUL | '' |
| wp_terms | term_group | bigint(10) | NO | 0 | |
| wp_term_relationships | object_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_term_relationships | term_taxonomy_id | bigint(20) unsigned | NO | PRI | 0 |
| wp_term_relationships | term_order | int(11) | NO | 0 | |
| wp_term_taxonomy | term_taxonomy_id | bigint(20) unsigned | NO | PRI | |
| wp_term_taxonomy | term_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_term_taxonomy | taxonomy | varchar(32) | NO | MUL | '' |
| wp_term_taxonomy | description | longtext | NO | ||
| wp_term_taxonomy | parent | bigint(20) unsigned | NO | 0 | |
| wp_term_taxonomy | count | bigint(20) | NO | 0 | |
| wp_usermeta | umeta_id | bigint(20) unsigned | NO | PRI | |
| wp_usermeta | user_id | bigint(20) unsigned | NO | MUL | 0 |
| wp_usermeta | meta_key | varchar(255) | YES | MUL | NULL |
| wp_usermeta | meta_value | longtext | YES | NULL | |
| wp_users | ID | bigint(20) unsigned | NO | PRI | |
| wp_users | user_login | varchar(60) | NO | MUL | '' |
| wp_users | user_pass | varchar(255) | NO | '' | |
| wp_users | user_nicename | varchar(50) | NO | MUL | '' |
| wp_users | user_email | varchar(100) | NO | MUL | '' |
| wp_users | user_url | varchar(100) | NO | '' | |
| wp_users | user_registered | datetime | NO | '0000-00-00 00:00:00' | |
| wp_users | user_activation_key | varchar(255) | NO | '' | |
| wp_users | user_status | int(11) | NO | 0 | |
| wp_users | display_name | varchar(250) | NO | '' | |
| wp_users | spam | tinyint(2) | NO | 0 | |
| wp_users | deleted | tinyint(2) | NO | 0 | |
| wp_wpmailsmtp_debug_events | id | int(10) unsigned | NO | PRI | |
| wp_wpmailsmtp_debug_events | content | text | YES | NULL | |
| wp_wpmailsmtp_debug_events | initiator | text | YES | NULL | |
| wp_wpmailsmtp_debug_events | event_type | tinyint(3) unsigned | NO | 0 | |
| wp_wpmailsmtp_debug_events | created_at | timestamp | NO | current_timestamp() | |
| wp_wpmailsmtp_emails_log | id | int(10) unsigned | NO | PRI | |
| wp_wpmailsmtp_emails_log | subject | varchar(191) | NO | MUL | |
| wp_wpmailsmtp_emails_log | message_id | varchar(255) | YES | MUL | NULL |
| wp_wpmailsmtp_emails_log | people | text | NO | ||
| wp_wpmailsmtp_emails_log | headers | text | NO | ||
| wp_wpmailsmtp_emails_log | error_text | text | YES | NULL | |
| wp_wpmailsmtp_emails_log | content_plain | longtext | NO | ||
| wp_wpmailsmtp_emails_log | content_html | longtext | NO | ||
| wp_wpmailsmtp_emails_log | status | tinyint(3) unsigned | NO | MUL | 0 |
| wp_wpmailsmtp_emails_log | date_sent | timestamp | NO | MUL | current_timestamp() |
| wp_wpmailsmtp_emails_log | mailer | varchar(255) | NO | ||
| wp_wpmailsmtp_emails_log | attachments | tinyint(3) unsigned | NO | 0 | |
| wp_wpmailsmtp_emails_log | initiator_name | varchar(255) | YES | NULL | |
| wp_wpmailsmtp_emails_log | initiator_file | text | YES | NULL | |
| wp_wpmailsmtp_emails_log | parent_id | int(10) unsigned | NO | 0 | |
| wp_wpmailsmtp_tasks_meta | id | bigint(20) | NO | PRI | |
| wp_wpmailsmtp_tasks_meta | action | varchar(255) | NO | ||
| wp_wpmailsmtp_tasks_meta | data | longtext | NO | ||
| wp_wpmailsmtp_tasks_meta | date | datetime | NO | ||
| wsai_program_backlog | backlog_id | bigint(20) unsigned | NO | PRI | |
| wsai_program_backlog | initiative_key | varchar(191) | NO | UNI | |
| wsai_program_backlog | initiative_name | varchar(255) | NO | ||
| wsai_program_backlog | subsystem | varchar(191) | YES | NULL | |
| wsai_program_backlog | status | enum('active','planned','deferred','blocked','validated','locked','completed') | NO | 'planned' | |
| wsai_program_backlog | priority | enum('critical','high','medium','low','strategic') | NO | 'medium' | |
| wsai_program_backlog | owner | varchar(100) | YES | NULL | |
| wsai_program_backlog | authority_page_id | bigint(20) unsigned | YES | NULL | |
| wsai_program_backlog | notes | text | YES | NULL | |
| wsai_program_backlog | created_date | date | NO | ||
| wsai_program_backlog | updated_at | timestamp | YES | current_timestamp() |
Declared Foreign Keys
| Table | Column | References |
|---|
Common Link Candidates
| Table | Column | Type |
|---|---|---|
| wp_2_actionscheduler_actions | action_id | bigint(20) unsigned |
| wp_2_actionscheduler_logs | action_id | bigint(20) unsigned |
| wp_3_actionscheduler_actions | action_id | bigint(20) unsigned |
| wp_3_actionscheduler_logs | action_id | bigint(20) unsigned |
| wp_4_actionscheduler_actions | action_id | bigint(20) unsigned |
| wp_4_actionscheduler_logs | action_id | bigint(20) unsigned |
| wp_5_actionscheduler_actions | action_id | bigint(20) unsigned |
| wp_5_actionscheduler_logs | action_id | bigint(20) unsigned |
| wp_6_actionscheduler_actions | action_id | bigint(20) unsigned |
| wp_6_actionscheduler_logs | action_id | bigint(20) unsigned |
| wp_8_actionscheduler_actions | action_id | bigint(20) unsigned |
| wp_8_actionscheduler_logs | action_id | bigint(20) unsigned |
| wp_9_actionscheduler_actions | action_id | bigint(20) unsigned |
| wp_9_actionscheduler_logs | action_id | bigint(20) unsigned |
| wp_actionscheduler_actions | action_id | bigint(20) unsigned |
| wp_actionscheduler_logs | action_id | bigint(20) unsigned |
| wsai_program_backlog | authority_page_id | bigint(20) unsigned |
| wsai_program_backlog | backlog_id | bigint(20) unsigned |
| wp_blogmeta | blog_id | bigint(20) unsigned |
| wp_blogs | blog_id | bigint(20) unsigned |
| wp_registration_log | blog_id | bigint(20) unsigned |
| wp_2_actionscheduler_actions | claim_id | bigint(20) unsigned |
| wp_2_actionscheduler_claims | claim_id | bigint(20) unsigned |
| wp_3_actionscheduler_actions | claim_id | bigint(20) unsigned |
| wp_3_actionscheduler_claims | claim_id | bigint(20) unsigned |
| wp_4_actionscheduler_actions | claim_id | bigint(20) unsigned |
| wp_4_actionscheduler_claims | claim_id | bigint(20) unsigned |
| wp_5_actionscheduler_actions | claim_id | bigint(20) unsigned |
| wp_5_actionscheduler_claims | claim_id | bigint(20) unsigned |
| wp_6_actionscheduler_actions | claim_id | bigint(20) unsigned |
| wp_6_actionscheduler_claims | claim_id | bigint(20) unsigned |
| wp_8_actionscheduler_actions | claim_id | bigint(20) unsigned |
| wp_8_actionscheduler_claims | claim_id | bigint(20) unsigned |
| wp_9_actionscheduler_actions | claim_id | bigint(20) unsigned |
| wp_9_actionscheduler_claims | claim_id | bigint(20) unsigned |
| wp_actionscheduler_actions | claim_id | bigint(20) unsigned |
| wp_actionscheduler_claims | claim_id | bigint(20) unsigned |
| wp_2_commentmeta | comment_id | bigint(20) unsigned |
| wp_2_comments | comment_ID | bigint(20) unsigned |
| wp_3_commentmeta | comment_id | bigint(20) unsigned |
| wp_3_comments | comment_ID | bigint(20) unsigned |
| wp_4_commentmeta | comment_id | bigint(20) unsigned |
| wp_4_comments | comment_ID | bigint(20) unsigned |
| wp_5_commentmeta | comment_id | bigint(20) unsigned |
| wp_5_comments | comment_ID | bigint(20) unsigned |
| wp_6_commentmeta | comment_id | bigint(20) unsigned |
| wp_6_comments | comment_ID | bigint(20) unsigned |
| wp_8_commentmeta | comment_id | bigint(20) unsigned |
| wp_8_comments | comment_ID | bigint(20) unsigned |
| wp_9_commentmeta | comment_id | bigint(20) unsigned |
| wp_9_comments | comment_ID | bigint(20) unsigned |
| wp_commentmeta | comment_id | bigint(20) unsigned |
| wp_comments | comment_ID | bigint(20) unsigned |
| wp_2_comments | comment_post_ID | bigint(20) unsigned |
| wp_3_comments | comment_post_ID | bigint(20) unsigned |
| wp_4_comments | comment_post_ID | bigint(20) unsigned |
| wp_5_comments | comment_post_ID | bigint(20) unsigned |
| wp_6_comments | comment_post_ID | bigint(20) unsigned |
| wp_8_comments | comment_post_ID | bigint(20) unsigned |
| wp_9_comments | comment_post_ID | bigint(20) unsigned |
| wp_comments | comment_post_ID | bigint(20) unsigned |
| wp_blogs | domain | varchar(200) |
| wp_signups | domain | varchar(200) |
| wp_site | domain | varchar(200) |
| wp_2_actionscheduler_actions | group_id | bigint(20) unsigned |
| wp_2_actionscheduler_groups | group_id | bigint(20) unsigned |
| wp_3_actionscheduler_actions | group_id | bigint(20) unsigned |
| wp_3_actionscheduler_groups | group_id | bigint(20) unsigned |
| wp_4_actionscheduler_actions | group_id | bigint(20) unsigned |
| wp_4_actionscheduler_groups | group_id | bigint(20) unsigned |
| wp_5_actionscheduler_actions | group_id | bigint(20) unsigned |
| wp_5_actionscheduler_groups | group_id | bigint(20) unsigned |
| wp_6_actionscheduler_actions | group_id | bigint(20) unsigned |
| wp_6_actionscheduler_groups | group_id | bigint(20) unsigned |
| wp_8_actionscheduler_actions | group_id | bigint(20) unsigned |
| wp_8_actionscheduler_groups | group_id | bigint(20) unsigned |
| wp_9_actionscheduler_actions | group_id | bigint(20) unsigned |
| wp_9_actionscheduler_groups | group_id | bigint(20) unsigned |
| wp_actionscheduler_actions | group_id | bigint(20) unsigned |
| wp_actionscheduler_groups | group_id | bigint(20) unsigned |
| wp_blogs | lang_id | int(11) |
| wp_2_links | link_id | bigint(20) unsigned |
| wp_3_links | link_id | bigint(20) unsigned |
| wp_4_links | link_id | bigint(20) unsigned |
| wp_5_links | link_id | bigint(20) unsigned |
| wp_6_links | link_id | bigint(20) unsigned |
| wp_8_links | link_id | bigint(20) unsigned |
| wp_9_links | link_id | bigint(20) unsigned |
| wp_links | link_id | bigint(20) unsigned |
| wp_2_actionscheduler_logs | log_id | bigint(20) unsigned |
| wp_3_actionscheduler_logs | log_id | bigint(20) unsigned |
| wp_4_actionscheduler_logs | log_id | bigint(20) unsigned |
| wp_5_actionscheduler_logs | log_id | bigint(20) unsigned |
| wp_6_actionscheduler_logs | log_id | bigint(20) unsigned |
| wp_8_actionscheduler_logs | log_id | bigint(20) unsigned |
| wp_9_actionscheduler_logs | log_id | bigint(20) unsigned |
| wp_actionscheduler_logs | log_id | bigint(20) unsigned |
| wp_2_wpmailsmtp_emails_log | message_id | varchar(255) |
| wp_3_wpmailsmtp_emails_log | message_id | varchar(255) |
| wp_4_wpmailsmtp_emails_log | message_id | varchar(255) |
| wp_5_wpmailsmtp_emails_log | message_id | varchar(255) |
| wp_6_wpmailsmtp_emails_log | message_id | varchar(255) |
| wp_7_wpmailsmtp_emails_log | message_id | varchar(255) |
| wp_8_wpmailsmtp_emails_log | message_id | varchar(255) |
| wp_9_wpmailsmtp_emails_log | message_id | varchar(255) |
| wp_wpmailsmtp_emails_log | message_id | varchar(255) |
| wp_2_commentmeta | meta_id | bigint(20) unsigned |
| wp_2_postmeta | meta_id | bigint(20) unsigned |
| wp_2_termmeta | meta_id | bigint(20) unsigned |
| wp_3_commentmeta | meta_id | bigint(20) unsigned |
| wp_3_postmeta | meta_id | bigint(20) unsigned |
| wp_3_termmeta | meta_id | bigint(20) unsigned |
| wp_4_commentmeta | meta_id | bigint(20) unsigned |
| wp_4_postmeta | meta_id | bigint(20) unsigned |
| wp_4_termmeta | meta_id | bigint(20) unsigned |
| wp_5_commentmeta | meta_id | bigint(20) unsigned |
| wp_5_postmeta | meta_id | bigint(20) unsigned |
| wp_5_termmeta | meta_id | bigint(20) unsigned |
| wp_6_commentmeta | meta_id | bigint(20) unsigned |
| wp_6_postmeta | meta_id | bigint(20) unsigned |
| wp_6_termmeta | meta_id | bigint(20) unsigned |
| wp_8_commentmeta | meta_id | bigint(20) unsigned |
| wp_8_postmeta | meta_id | bigint(20) unsigned |
| wp_8_termmeta | meta_id | bigint(20) unsigned |
| wp_9_commentmeta | meta_id | bigint(20) unsigned |
| wp_9_postmeta | meta_id | bigint(20) unsigned |
| wp_9_termmeta | meta_id | bigint(20) unsigned |
| wp_blogmeta | meta_id | bigint(20) unsigned |
| wp_commentmeta | meta_id | bigint(20) unsigned |
| wp_postmeta | meta_id | bigint(20) unsigned |
| wp_sitemeta | meta_id | bigint(20) unsigned |
| wp_termmeta | meta_id | bigint(20) unsigned |
| wp_2_term_relationships | object_id | bigint(20) unsigned |
| wp_3_term_relationships | object_id | bigint(20) unsigned |
| wp_4_term_relationships | object_id | bigint(20) unsigned |
| wp_5_term_relationships | object_id | bigint(20) unsigned |
| wp_6_term_relationships | object_id | bigint(20) unsigned |
| wp_8_term_relationships | object_id | bigint(20) unsigned |
| wp_9_term_relationships | object_id | bigint(20) unsigned |
| wp_term_relationships | object_id | bigint(20) unsigned |
| wp_2_options | option_id | bigint(20) unsigned |
| wp_3_options | option_id | bigint(20) unsigned |
| wp_4_options | option_id | bigint(20) unsigned |
| wp_5_options | option_id | bigint(20) unsigned |
| wp_6_options | option_id | bigint(20) unsigned |
| wp_8_options | option_id | bigint(20) unsigned |
| wp_9_options | option_id | bigint(20) unsigned |
| wp_options | option_id | bigint(20) unsigned |
| wp_2_wpmailsmtp_emails_log | parent_id | int(10) unsigned |
| wp_3_wpmailsmtp_emails_log | parent_id | int(10) unsigned |
| wp_4_wpmailsmtp_emails_log | parent_id | int(10) unsigned |
| wp_5_wpmailsmtp_emails_log | parent_id | int(10) unsigned |
| wp_6_wpmailsmtp_emails_log | parent_id | int(10) unsigned |
| wp_7_wpmailsmtp_emails_log | parent_id | int(10) unsigned |
| wp_8_wpmailsmtp_emails_log | parent_id | int(10) unsigned |
| wp_9_wpmailsmtp_emails_log | parent_id | int(10) unsigned |
| wp_wpmailsmtp_emails_log | parent_id | int(10) unsigned |
| wp_2_postmeta | post_id | bigint(20) unsigned |
| wp_3_postmeta | post_id | bigint(20) unsigned |
| wp_4_postmeta | post_id | bigint(20) unsigned |
| wp_5_postmeta | post_id | bigint(20) unsigned |
| wp_6_postmeta | post_id | bigint(20) unsigned |
| wp_8_postmeta | post_id | bigint(20) unsigned |
| wp_9_postmeta | post_id | bigint(20) unsigned |
| wp_postmeta | post_id | bigint(20) unsigned |
| wp_signups | signup_id | bigint(20) unsigned |
| wp_blogs | site_id | bigint(20) unsigned |
| wp_sitemeta | site_id | bigint(20) unsigned |
| wp_2_termmeta | term_id | bigint(20) unsigned |
| wp_2_terms | term_id | bigint(20) unsigned |
| wp_2_term_taxonomy | term_id | bigint(20) unsigned |
| wp_3_termmeta | term_id | bigint(20) unsigned |
| wp_3_terms | term_id | bigint(20) unsigned |
| wp_3_term_taxonomy | term_id | bigint(20) unsigned |
| wp_4_termmeta | term_id | bigint(20) unsigned |
| wp_4_terms | term_id | bigint(20) unsigned |
| wp_4_term_taxonomy | term_id | bigint(20) unsigned |
| wp_5_termmeta | term_id | bigint(20) unsigned |
| wp_5_terms | term_id | bigint(20) unsigned |
| wp_5_term_taxonomy | term_id | bigint(20) unsigned |
| wp_6_termmeta | term_id | bigint(20) unsigned |
| wp_6_terms | term_id | bigint(20) unsigned |
| wp_6_term_taxonomy | term_id | bigint(20) unsigned |
| wp_8_termmeta | term_id | bigint(20) unsigned |
| wp_8_terms | term_id | bigint(20) unsigned |
| wp_8_term_taxonomy | term_id | bigint(20) unsigned |
| wp_9_termmeta | term_id | bigint(20) unsigned |
| wp_9_terms | term_id | bigint(20) unsigned |
| wp_9_term_taxonomy | term_id | bigint(20) unsigned |
| wp_termmeta | term_id | bigint(20) unsigned |
| wp_terms | term_id | bigint(20) unsigned |
| wp_term_taxonomy | term_id | bigint(20) unsigned |
| wp_2_term_relationships | term_taxonomy_id | bigint(20) unsigned |
| wp_2_term_taxonomy | term_taxonomy_id | bigint(20) unsigned |
| wp_3_term_relationships | term_taxonomy_id | bigint(20) unsigned |
| wp_3_term_taxonomy | term_taxonomy_id | bigint(20) unsigned |
| wp_4_term_relationships | term_taxonomy_id | bigint(20) unsigned |
| wp_4_term_taxonomy | term_taxonomy_id | bigint(20) unsigned |
| wp_5_term_relationships | term_taxonomy_id | bigint(20) unsigned |
| wp_5_term_taxonomy | term_taxonomy_id | bigint(20) unsigned |
| wp_6_term_relationships | term_taxonomy_id | bigint(20) unsigned |
| wp_6_term_taxonomy | term_taxonomy_id | bigint(20) unsigned |
| wp_8_term_relationships | term_taxonomy_id | bigint(20) unsigned |
| wp_8_term_taxonomy | term_taxonomy_id | bigint(20) unsigned |
| wp_9_term_relationships | term_taxonomy_id | bigint(20) unsigned |
| wp_9_term_taxonomy | term_taxonomy_id | bigint(20) unsigned |
| wp_term_relationships | term_taxonomy_id | bigint(20) unsigned |
| wp_term_taxonomy | term_taxonomy_id | bigint(20) unsigned |
| wp_usermeta | umeta_id | bigint(20) unsigned |
| wp_2_comments | user_id | bigint(20) unsigned |
| wp_3_comments | user_id | bigint(20) unsigned |
| wp_4_comments | user_id | bigint(20) unsigned |
| wp_5_comments | user_id | bigint(20) unsigned |
| wp_6_comments | user_id | bigint(20) unsigned |
| wp_8_comments | user_id | bigint(20) unsigned |
| wp_9_comments | user_id | bigint(20) unsigned |
| wp_comments | user_id | bigint(20) unsigned |
| wp_usermeta | user_id | bigint(20) unsigned |
Database: wsai_ops
Tables and Views
| Object | Type | Rows Estimate | Engine |
|---|---|---|---|
| artifacts | BASE TABLE | 6 | InnoDB |
| artifact_dependencies | BASE TABLE | 2 | InnoDB |
| artifact_extraction_flags | BASE TABLE | 2 | InnoDB |
| artifact_files | BASE TABLE | 6 | InnoDB |
| artifact_ingestion_runs | BASE TABLE | 0 | InnoDB |
| artifact_intake_queue | BASE TABLE | 0 | InnoDB |
| artifact_packages | BASE TABLE | 0 | InnoDB |
| artifact_package_items | BASE TABLE | 6 | InnoDB |
| artifact_statuses | BASE TABLE | 6 | InnoDB |
| artifact_storage_locations | BASE TABLE | 2 | InnoDB |
| artifact_types | BASE TABLE | 10 | InnoDB |
| artifact_versions | BASE TABLE | 6 | InnoDB |
| brands | BASE TABLE | 2 | InnoDB |
| brand_governance_rules | BASE TABLE | 6 | InnoDB |
| content_intake_items | BASE TABLE | 0 | InnoDB |
| content_intake_outputs | BASE TABLE | 0 | InnoDB |
| deployment_execution_events | BASE TABLE | 42 | InnoDB |
| deployment_execution_registry | BASE TABLE | 7 | InnoDB |
| deployment_package_queue | BASE TABLE | 7 | InnoDB |
| deployment_registry | BASE TABLE | 7 | InnoDB |
| deployment_runs | BASE TABLE | 17 | InnoDB |
| domains | BASE TABLE | 2 | InnoDB |
| email_aliases | BASE TABLE | 15 | InnoDB |
| email_alias_destinations | BASE TABLE | 13 | InnoDB |
| email_alias_mailbox_authorizations | BASE TABLE | 12 | InnoDB |
| email_dmarc_report_governance | BASE TABLE | 3 | InnoDB |
| email_domains | BASE TABLE | 3 | InnoDB |
| email_domain_routing_governance | BASE TABLE | 3 | InnoDB |
| email_mailboxes | BASE TABLE | 0 | InnoDB |
| mailbox_alias_authorizations | BASE TABLE | 15 | InnoDB |
| mailbox_identities | BASE TABLE | 3 | InnoDB |
| mailbox_identity_status_history | BASE TABLE | 8 | InnoDB |
| make_scenarios | BASE TABLE | 11 | InnoDB |
| operational_artifact_registry | BASE TABLE | 14 | InnoDB |
| operational_knowledge_base_pages | BASE TABLE | 20 | InnoDB |
| operational_repository_publications | BASE TABLE | 11 | InnoDB |
| operational_runtime_inventory | BASE TABLE | 8 | InnoDB |
| operational_schema_dependencies | BASE TABLE | 34 | InnoDB |
| operational_schema_drift_findings | BASE TABLE | 0 | InnoDB |
| operational_schema_fields | BASE TABLE | 701 | InnoDB |
| operational_schema_inventory_runs | BASE TABLE | 2 | InnoDB |
| operational_schema_tables | BASE TABLE | 71 | InnoDB |
| operational_schema_views | BASE TABLE | 26 | InnoDB |
| operational_script_definitions | BASE TABLE | 16 | InnoDB |
| operational_use_guides | BASE TABLE | 8 | InnoDB |
| product_backlog_events | BASE TABLE | 0 | InnoDB |
| product_backlog_items | BASE TABLE | 10 | InnoDB |
| product_registry | BASE TABLE | 15 | InnoDB |
| publishing_alert_events | BASE TABLE | 0 | InnoDB |
| publishing_content_assets | BASE TABLE | 2 | InnoDB |
| publishing_content_items | BASE TABLE | 2 | InnoDB |
| publishing_dead_letter_queue | BASE TABLE | 3 | InnoDB |
| publishing_execution_locks | BASE TABLE | 1 | InnoDB |
| publishing_failure_events | BASE TABLE | 17 | InnoDB |
| publishing_rag_ingestion | BASE TABLE | 0 | InnoDB |
| publishing_scheduler_activation | BASE TABLE | 1 | InnoDB |
| publishing_seo_governance | BASE TABLE | 0 | InnoDB |
| publishing_social_extractions | BASE TABLE | 0 | InnoDB |
| publishing_taxonomy_registry | BASE TABLE | 42 | InnoDB |
| publishing_workflow_events | BASE TABLE | 45 | InnoDB |
| publishing_workflow_runs | BASE TABLE | 2 | InnoDB |
| runtime_inventory_records | BASE TABLE | 12 | InnoDB |
| runtime_inventory_servers | BASE TABLE | 0 | InnoDB |
| schema_dictionary | BASE TABLE | 410 | InnoDB |
| schema_usage_registry | BASE TABLE | 80 | InnoDB |
| sites | BASE TABLE | 2 | InnoDB |
| table_registry | BASE TABLE | 43 | InnoDB |
| v_alias_authorization_matrix | VIEW | 0 | |
| v_deployment_orchestration_health | VIEW | 0 | |
| v_deployment_queue_next_claim | VIEW | 0 | |
| v_deployment_queue_ready | VIEW | 0 | |
| v_deployment_registry_dashboard | VIEW | 0 | |
| v_deployment_registry_ready_for_publication | VIEW | 0 | |
| v_deployment_rollback_required | VIEW | 0 | |
| v_email_alias_governance_ready | VIEW | 0 | |
| v_email_alias_mailbox_delivery | VIEW | 0 | |
| v_email_domain_routing_health | VIEW | 0 | |
| v_email_domain_routing_ready | VIEW | 0 | |
| v_email_domain_routing_status | VIEW | 0 | |
| v_email_mailbox_visibility | VIEW | 0 | |
| v_email_opendmarc_readiness | VIEW | 0 | |
| v_email_postfix_virtual_export | VIEW | 0 | |
| v_mailbox_alias_authorization_drift | VIEW | 0 | |
| v_mailbox_authorized_alias_routing | VIEW | 0 | |
| v_mailbox_governance_health | VIEW | 0 | |
| v_mailbox_governance_validation_gate | VIEW | 0 | |
| v_mailbox_identity_summary | VIEW | 0 | |
| v_operational_artifact_registry_summary | VIEW | 0 | |
| v_operational_data_dictionary_summary | VIEW | 0 | |
| v_operational_knowledge_base_health | VIEW | 0 | |
| v_operational_knowledge_base_summary | VIEW | 0 | |
| v_operational_runtime_inventory_summary | VIEW | 0 | |
| v_operational_schema_bootstrap_extract | VIEW | 0 | |
| v_operational_schema_dependency_dashboard | VIEW | 0 | |
| v_operational_schema_drift_candidates | VIEW | 0 | |
| v_operational_schema_drift_dashboard | VIEW | 0 | |
| v_operational_schema_missing_dependencies | VIEW | 0 | |
| v_operational_schema_promotion_gate | VIEW | 0 | |
| v_operational_schema_registry_health | VIEW | 0 | |
| v_operational_schema_registry_summary | VIEW | 0 | |
| v_postfix_virtual_alias_export | VIEW | 0 | |
| v_product_backlog_active | VIEW | 0 | |
| v_product_registry_dashboard | VIEW | 0 | |
| v_publishing_alert_candidates | VIEW | 0 | |
| v_publishing_dead_letter_queue_open | VIEW | 0 | |
| v_publishing_execution_lock_active | VIEW | 0 | |
| v_publishing_failure_events_open | VIEW | 0 | |
| v_publishing_items_ready_to_publish | VIEW | 0 | |
| v_publishing_operations_dashboard | VIEW | 0 | |
| v_publishing_production_dashboard | VIEW | 0 | |
| v_publishing_repeated_retry_failures | VIEW | 0 | |
| v_publishing_scheduler_activation_dashboard | VIEW | 0 | |
| v_publishing_scheduler_promotion_ready | VIEW | 0 | |
| v_runtime_inventory_reconciliation | VIEW | 0 | |
| v_scenario_field_dependencies | VIEW | 0 | |
| v_schema_dependency_summary | VIEW | 0 | |
| v_schema_field_usage | VIEW | 0 | |
| v_schema_unmapped_fields | VIEW | 0 |
Columns
| Table | Column | Type | Nullable | Key | Default |
|---|---|---|---|---|---|
| artifacts | id | int(11) | NO | PRI | |
| artifacts | artifact_key | varchar(128) | NO | UNI | |
| artifacts | artifact_name | varchar(255) | NO | ||
| artifacts | artifact_type_id | int(11) | NO | MUL | |
| artifacts | current_status_id | int(11) | NO | MUL | |
| artifacts | authority_level | enum('draft','working','canonical','deprecated','archived') | NO | 'draft' | |
| artifacts | owning_system | varchar(128) | YES | NULL | |
| artifacts | owning_brand_id | int(11) | YES | NULL | |
| artifacts | owning_site_id | int(11) | YES | NULL | |
| artifacts | module_name | varchar(128) | YES | NULL | |
| artifacts | description | text | YES | NULL | |
| artifacts | canonical_storage_uri | text | YES | NULL | |
| artifacts | latest_version_id | int(11) | YES | NULL | |
| artifacts | created_at | timestamp | NO | current_timestamp() | |
| artifacts | updated_at | timestamp | YES | NULL | |
| artifact_dependencies | id | int(11) | NO | PRI | |
| artifact_dependencies | artifact_id | int(11) | NO | MUL | |
| artifact_dependencies | depends_on_artifact_id | int(11) | NO | MUL | |
| artifact_dependencies | dependency_type | enum('bootstrap_dependency','operational_dependency','reference','supersedes','derived_from') | NO | 'reference' | |
| artifact_dependencies | notes | text | YES | NULL | |
| artifact_dependencies | created_at | timestamp | NO | current_timestamp() | |
| artifact_extraction_flags | id | int(11) | NO | PRI | |
| artifact_extraction_flags | artifact_version_id | int(11) | NO | MUL | |
| artifact_extraction_flags | flag_type | enum('content_idea','social_idea','ugc_angle','monetization','infrastructure','governance','bootstrap_update','pivot_recommended') | NO | ||
| artifact_extraction_flags | flag_text | text | NO | ||
| artifact_extraction_flags | priority | enum('low','medium','high','critical') | NO | 'medium' | |
| artifact_extraction_flags | status | enum('new','reviewed','accepted','rejected','implemented','deferred') | NO | 'new' | |
| artifact_extraction_flags | created_at | timestamp | NO | current_timestamp() | |
| artifact_files | id | int(11) | NO | PRI | |
| artifact_files | artifact_version_id | int(11) | NO | MUL | |
| artifact_files | storage_location_id | int(11) | YES | MUL | NULL |
| artifact_files | file_name | varchar(255) | NO | ||
| artifact_files | file_format | varchar(32) | YES | NULL | |
| artifact_files | storage_uri | text | NO | ||
| artifact_files | content_hash | char(64) | YES | NULL | |
| artifact_files | file_role | enum('source','generated','manifest','archive','bootstrap','sql','prompt','pdf','zip','blueprint','other') | NO | 'generated' | |
| artifact_files | is_primary | tinyint(1) | NO | 0 | |
| artifact_files | file_status | enum('registered','available','missing','superseded','archived') | NO | 'registered' | |
| artifact_files | notes | text | YES | NULL | |
| artifact_files | created_at | timestamp | NO | current_timestamp() | |
| artifact_ingestion_runs | id | int(11) | NO | PRI | |
| artifact_ingestion_runs | artifact_version_id | int(11) | NO | MUL | |
| artifact_ingestion_runs | make_scenario_id | int(11) | YES | NULL | |
| artifact_ingestion_runs | run_status | enum('queued','processing','success','failed','skipped') | NO | 'queued' | |
| artifact_ingestion_runs | ingestion_target | enum('mariadb','rag','wordpress','archive','make','other') | NO | 'mariadb' | |
| artifact_ingestion_runs | message | text | YES | NULL | |
| artifact_ingestion_runs | started_at | timestamp | YES | NULL | |
| artifact_ingestion_runs | completed_at | timestamp | YES | NULL | |
| artifact_ingestion_runs | created_at | timestamp | NO | current_timestamp() | |
| artifact_intake_queue | id | int(11) | NO | PRI | |
| artifact_intake_queue | intake_key | varchar(128) | NO | UNI | |
| artifact_intake_queue | intake_source | enum('chatgpt','make','manual_upload','wordpress','email','api','other') | NO | 'manual_upload' | |
| artifact_intake_queue | source_system_ref | text | YES | NULL | |
| artifact_intake_queue | proposed_artifact_key | varchar(128) | YES | NULL | |
| artifact_intake_queue | proposed_artifact_name | varchar(255) | NO | ||
| artifact_intake_queue | proposed_artifact_type_code | varchar(64) | NO | ||
| artifact_intake_queue | proposed_module_name | varchar(128) | YES | NULL | |
| artifact_intake_queue | proposed_file_name | varchar(255) | YES | NULL | |
| artifact_intake_queue | proposed_file_format | varchar(32) | YES | NULL | |
| artifact_intake_queue | proposed_storage_uri | text | YES | NULL | |
| artifact_intake_queue | proposed_content_hash | char(64) | YES | NULL | |
| artifact_intake_queue | proposed_summary | text | YES | NULL | |
| artifact_intake_queue | ingestion_target | enum('mariadb','rag','wordpress','archive','make','other') | NO | 'mariadb' | |
| artifact_intake_queue | intake_status | enum('new','validated','registered','rejected','failed','duplicate') | NO | 'new' | |
| artifact_intake_queue | validation_message | text | YES | NULL | |
| artifact_intake_queue | created_by | varchar(128) | YES | NULL | |
| artifact_intake_queue | created_at | timestamp | NO | current_timestamp() | |
| artifact_intake_queue | processed_at | timestamp | YES | NULL | |
| artifact_packages | id | int(11) | NO | PRI | |
| artifact_packages | package_key | varchar(128) | NO | UNI | |
| artifact_packages | package_name | varchar(255) | NO | ||
| artifact_packages | package_type | enum('bootstrap','pivot','milestone','release','import','export','archive') | NO | 'milestone' | |
| artifact_packages | module_name | varchar(128) | YES | NULL | |
| artifact_packages | source_conversation_ref | text | YES | NULL | |
| artifact_packages | authority_level | enum('draft','working','canonical','deprecated','archived') | NO | 'draft' | |
| artifact_packages | package_status | enum('created','registered','validated','ingested','failed','archived') | NO | 'created' | |
| artifact_packages | storage_uri | text | YES | NULL | |
| artifact_packages | manifest_artifact_id | int(11) | YES | MUL | NULL |
| artifact_packages | summary | text | YES | NULL | |
| artifact_packages | created_by | varchar(128) | YES | NULL | |
| artifact_packages | created_at | timestamp | NO | current_timestamp() | |
| artifact_packages | updated_at | timestamp | YES | NULL | |
| artifact_package_items | id | int(11) | NO | PRI | |
| artifact_package_items | package_id | int(11) | NO | MUL | |
| artifact_package_items | artifact_id | int(11) | NO | MUL | |
| artifact_package_items | artifact_version_id | int(11) | YES | MUL | NULL |
| artifact_package_items | package_role | enum('manifest','bootstrap_prompt','operational_summary','pivot_context','sql_schema','runbook','make_blueprint','source_file','archive_zip','other') | NO | 'other' | |
| artifact_package_items | required_for_bootstrap | tinyint(1) | NO | 0 | |
| artifact_package_items | sort_order | int(11) | NO | 100 | |
| artifact_package_items | notes | text | YES | NULL | |
| artifact_package_items | created_at | timestamp | NO | current_timestamp() | |
| artifact_statuses | id | int(11) | NO | PRI | |
| artifact_statuses | status_code | varchar(64) | NO | UNI | |
| artifact_statuses | status_name | varchar(128) | NO | ||
| artifact_statuses | description | text | YES | NULL | |
| artifact_statuses | is_terminal | tinyint(1) | NO | 0 | |
| artifact_statuses | created_at | timestamp | NO | current_timestamp() | |
| artifact_storage_locations | id | int(11) | NO | PRI | |
| artifact_storage_locations | storage_key | varchar(128) | NO | UNI | |
| artifact_storage_locations | storage_name | varchar(255) | NO | ||
| artifact_storage_locations | storage_type | enum('local_filesystem','s3','google_drive','dropbox','onedrive','url','other') | NO | 'local_filesystem' | |
| artifact_storage_locations | root_uri | text | NO | ||
| artifact_storage_locations | environment | enum('dev','staging','production','archive') | NO | 'production' | |
| artifact_storage_locations | is_primary | tinyint(1) | NO | 0 | |
| artifact_storage_locations | is_active | tinyint(1) | NO | 1 | |
| artifact_storage_locations | notes | text | YES | NULL | |
| artifact_storage_locations | created_at | timestamp | NO | current_timestamp() | |
| artifact_storage_locations | updated_at | timestamp | YES | NULL | |
| artifact_types | id | int(11) | NO | PRI | |
| artifact_types | type_code | varchar(64) | NO | UNI | |
| artifact_types | type_name | varchar(128) | NO | ||
| artifact_types | description | text | YES | NULL | |
| artifact_types | is_active | tinyint(1) | NO | 1 | |
| artifact_types | created_at | timestamp | NO | current_timestamp() | |
| artifact_versions | id | int(11) | NO | PRI | |
| artifact_versions | artifact_id | int(11) | NO | MUL | |
| artifact_versions | version_label | varchar(64) | NO | ||
| artifact_versions | revision_number | int(11) | NO | 1 | |
| artifact_versions | file_name | varchar(255) | YES | NULL | |
| artifact_versions | file_format | varchar(32) | YES | NULL | |
| artifact_versions | storage_uri | text | YES | NULL | |
| artifact_versions | content_hash | char(64) | YES | NULL | |
| artifact_versions | generated_by | varchar(128) | YES | NULL | |
| artifact_versions | source_conversation_ref | text | YES | NULL | |
| artifact_versions | summary | text | YES | NULL | |
| artifact_versions | ingestion_ready | tinyint(1) | NO | 0 | |
| artifact_versions | is_current | tinyint(1) | NO | 0 | |
| artifact_versions | created_at | timestamp | NO | current_timestamp() | |
| brands | id | bigint(20) unsigned | NO | PRI | |
| brands | brand_key | varchar(64) | NO | UNI | |
| brands | brand_name | varchar(150) | NO | ||
| brands | public_domain | varchar(150) | YES | NULL | |
| brands | owner_entity | varchar(150) | NO | ||
| brands | brand_lane | varchar(150) | NO | ||
| brands | tone_summary | text | YES | NULL | |
| brands | ai_positioning | text | YES | NULL | |
| brands | status | enum('planning','active','paused','retired') | YES | 'planning' | |
| brands | created_at | timestamp | YES | current_timestamp() | |
| brands | updated_at | timestamp | YES | current_timestamp() | |
| brand_governance_rules | id | bigint(20) unsigned | NO | PRI | |
| brand_governance_rules | brand_id | bigint(20) unsigned | NO | MUL | |
| brand_governance_rules | rule_type | varchar(100) | NO | ||
| brand_governance_rules | rule_text | text | NO | ||
| brand_governance_rules | severity | enum('info','warning','blocker') | YES | 'warning' | |
| brand_governance_rules | active | tinyint(1) | YES | 1 | |
| brand_governance_rules | created_at | timestamp | YES | current_timestamp() | |
| content_intake_items | id | bigint(20) unsigned | NO | PRI | |
| content_intake_items | intake_key | varchar(100) | NO | UNI | |
| content_intake_items | source_type | enum('conversation_pdf','bootstrap_package','pivot_context','operational_note','infrastructure_log','ugc_transcript','social_draft','wordpress_export','manual_upload','other') | NO | 'conversation_pdf' | |
| content_intake_items | source_title | varchar(255) | NO | ||
| content_intake_items | source_uri | text | YES | NULL | |
| content_intake_items | originating_conversation | varchar(255) | YES | NULL | |
| content_intake_items | brand_key | varchar(100) | YES | NULL | |
| content_intake_items | target_site_domain | varchar(255) | YES | NULL | |
| content_intake_items | lifecycle_status | enum('received','ready_for_analysis','analysis_in_progress','analyzed','draft_ready','published_to_wp_draft','archived','needs_review','failed') | NO | 'received' | |
| content_intake_items | content_category | varchar(100) | YES | NULL | |
| content_intake_items | content_angle | varchar(255) | YES | NULL | |
| content_intake_items | ai_summary | mediumtext | YES | NULL | |
| content_intake_items | monetization_angle | mediumtext | YES | NULL | |
| content_intake_items | extraction_flags | longtext | YES | NULL | |
| content_intake_items | wordpress_post_id | bigint(20) unsigned | YES | NULL | |
| content_intake_items | error_message | text | YES | NULL | |
| content_intake_items | created_at | timestamp | NO | current_timestamp() | |
| content_intake_items | updated_at | timestamp | YES | NULL | |
| content_intake_outputs | id | bigint(20) unsigned | NO | PRI | |
| content_intake_outputs | intake_item_id | bigint(20) unsigned | NO | MUL | |
| content_intake_outputs | output_type | enum('wordpress_draft','blog_outline','social_post','ugc_idea','operational_doc','monetizable_pdf','rag_artifact','archive_record') | NO | ||
| content_intake_outputs | output_status | enum('generated','queued','sent','published','archived','failed') | NO | 'generated' | |
| content_intake_outputs | output_title | varchar(255) | YES | NULL | |
| content_intake_outputs | output_body | mediumtext | YES | NULL | |
| content_intake_outputs | target_platform | varchar(100) | YES | NULL | |
| content_intake_outputs | external_id | varchar(255) | YES | NULL | |
| content_intake_outputs | created_at | timestamp | NO | current_timestamp() | |
| deployment_execution_events | event_id | bigint(20) unsigned | NO | PRI | |
| deployment_execution_events | execution_id | bigint(20) unsigned | NO | MUL | |
| deployment_execution_events | queue_id | bigint(20) unsigned | NO | MUL | |
| deployment_execution_events | event_type | varchar(120) | NO | MUL | |
| deployment_execution_events | event_status | enum('info','pass','warn','fail') | NO | 'info' | |
| deployment_execution_events | event_message | text | NO | ||
| deployment_execution_events | event_payload | longtext | YES | NULL | |
| deployment_execution_events | created_at | datetime | NO | current_timestamp() | |
| deployment_execution_registry | execution_id | bigint(20) unsigned | NO | PRI | |
| deployment_execution_registry | queue_id | bigint(20) unsigned | NO | MUL | |
| deployment_execution_registry | execution_uuid | char(36) | NO | UNI | |
| deployment_execution_registry | package_key | varchar(160) | NO | ||
| deployment_execution_registry | target_server | varchar(80) | NO | ||
| deployment_execution_registry | execution_status | enum('started','package_validated','package_transferred','package_extracted','script_executed','runtime_validated','evidence_generated','published','completed','failed','rolled_back') | NO | MUL | 'started' |
| deployment_execution_registry | server_script_path | varchar(500) | YES | NULL | |
| deployment_execution_registry | validation_summary | text | YES | NULL | |
| deployment_execution_registry | evidence_bundle_path | varchar(500) | YES | NULL | |
| deployment_execution_registry | deployment_log_path | varchar(500) | YES | NULL | |
| deployment_execution_registry | failure_snapshot_path | varchar(500) | YES | NULL | |
| deployment_execution_registry | rollback_log_path | varchar(500) | YES | NULL | |
| deployment_execution_registry | started_at | datetime | NO | current_timestamp() | |
| deployment_execution_registry | completed_at | datetime | YES | NULL | |
| deployment_execution_registry | created_at | datetime | NO | current_timestamp() | |
| deployment_package_queue | queue_id | bigint(20) unsigned | NO | PRI | |
| deployment_package_queue | package_key | varchar(160) | NO | MUL | |
| deployment_package_queue | package_name | varchar(255) | NO | ||
| deployment_package_queue | package_version | varchar(80) | YES | NULL | |
| deployment_package_queue | package_path | varchar(500) | NO | ||
| deployment_package_queue | target_server | varchar(80) | NO | MUL | 'web' |
| deployment_package_queue | target_runtime_user | varchar(80) | NO | 'admin' | |
| deployment_package_queue | target_working_dir | varchar(500) | NO | '/var/www' | |
| deployment_package_queue | requested_by | varchar(120) | NO | 'operator' | |
| deployment_package_queue | queue_status | enum('queued','claimed','validating','transferring','executing','validating_runtime','evidence_pending','completed','failed','cancelled') | NO | MUL | 'queued' |
| deployment_package_queue | priority | int(11) | NO | 100 | |
| deployment_package_queue | make_scenario_key | varchar(160) | YES | NULL | |
| deployment_package_queue | claimed_by | varchar(160) | YES | NULL | |
| deployment_package_queue | claimed_at | datetime | YES | NULL | |
| deployment_package_queue | started_at | datetime | YES | NULL | |
| deployment_package_queue | completed_at | datetime | YES | NULL | |
| deployment_package_queue | failure_reason | text | YES | NULL | |
| deployment_package_queue | rollback_required | tinyint(1) | NO | 0 | |
| deployment_package_queue | rollback_completed | tinyint(1) | NO | 0 | |
| deployment_package_queue | evidence_bundle_path | varchar(500) | YES | NULL | |
| deployment_package_queue | wordpress_publication_status | enum('not_required','pending','published','failed') | NO | 'pending' | |
| deployment_package_queue | wordpress_page_id | bigint(20) unsigned | YES | NULL | |
| deployment_package_queue | created_at | datetime | NO | current_timestamp() | |
| deployment_package_queue | updated_at | datetime | NO | current_timestamp() | |
| deployment_registry | deployment_id | bigint(20) unsigned | NO | PRI | |
| deployment_registry | execution_uuid | char(36) | NO | UNI | |
| deployment_registry | queue_id | bigint(20) unsigned | NO | ||
| deployment_registry | execution_id | bigint(20) unsigned | NO | ||
| deployment_registry | package_key | varchar(160) | NO | MUL | |
| deployment_registry | package_version | varchar(80) | YES | NULL | |
| deployment_registry | target_server | varchar(80) | NO | ||
| deployment_registry | deployment_result | enum('completed','failed','rollback_required','rolled_back') | NO | MUL | |
| deployment_registry | evidence_bundle_path | varchar(500) | YES | NULL | |
| deployment_registry | failure_snapshot_path | varchar(500) | YES | NULL | |
| deployment_registry | wordpress_publication_status | enum('pending','published','failed','not_required') | NO | 'pending' | |
| deployment_registry | wordpress_page_id | bigint(20) unsigned | YES | NULL | |
| deployment_registry | knowledge_capture_status | enum('pending','published','failed') | NO | 'pending' | |
| deployment_registry | started_at | datetime | YES | NULL | |
| deployment_registry | completed_at | datetime | YES | NULL | |
| deployment_registry | created_at | datetime | NO | current_timestamp() | |
| deployment_runs | id | bigint(20) unsigned | NO | PRI | |
| deployment_runs | site_id | bigint(20) unsigned | NO | MUL | |
| deployment_runs | make_scenario_id | bigint(20) unsigned | YES | MUL | NULL |
| deployment_runs | run_status | enum('started','success','warning','failed') | YES | 'started' | |
| deployment_runs | step_name | varchar(150) | YES | NULL | |
| deployment_runs | message | text | YES | NULL | |
| deployment_runs | make_execution_id | varchar(150) | YES | NULL | |
| deployment_runs | started_at | datetime | YES | current_timestamp() | |
| deployment_runs | finished_at | datetime | YES | NULL | |
| deployment_runs | deployment_type | varchar(50) | YES | NULL | |
| deployment_runs | deployment_target | varchar(255) | YES | NULL | |
| deployment_runs | deployment_hash | varchar(128) | YES | NULL | |
| deployment_runs | completed_at | datetime | YES | NULL | |
| deployment_runs | validation_result | varchar(50) | YES | NULL | |
| deployment_runs | rollback_available | tinyint(1) | YES | NULL | |
| deployment_runs | triggered_by | varchar(255) | YES | NULL | |
| deployment_runs | execution_node | varchar(255) | YES | NULL | |
| deployment_runs | backup_path | varchar(500) | YES | NULL | |
| deployment_runs | deployment_notes | text | YES | NULL | |
| domains | id | bigint(20) unsigned | NO | PRI | |
| domains | brand_id | bigint(20) unsigned | NO | MUL | |
| domains | domain | varchar(150) | NO | UNI | |
| domains | registrar | varchar(100) | YES | NULL | |
| domains | dns_provider | varchar(100) | YES | 'Cloudflare' | |
| domains | points_to | varchar(255) | YES | NULL | |
| domains | ssl_status | enum('unknown','pending','active','error') | YES | 'unknown' | |
| domains | mx_status | enum('unknown','pending','active','error') | YES | 'unknown' | |
| domains | created_at | timestamp | YES | current_timestamp() | |
| domains | updated_at | timestamp | YES | current_timestamp() | |
| email_aliases | id | bigint(20) unsigned | NO | PRI | |
| email_aliases | email_domain_id | bigint(20) unsigned | NO | MUL | |
| email_aliases | alias_address | varchar(150) | NO | UNI | |
| email_aliases | destination_address | varchar(150) | NO | ||
| email_aliases | purpose | varchar(150) | YES | NULL | |
| email_aliases | status | enum('active','paused','retired') | YES | 'active' | |
| email_aliases | created_at | timestamp | YES | current_timestamp() | |
| email_aliases | updated_at | timestamp | YES | current_timestamp() | |
| email_alias_destinations | id | bigint(20) unsigned | NO | PRI | |
| email_alias_destinations | email_alias_id | bigint(20) unsigned | NO | MUL | |
| email_alias_destinations | mailbox_id | bigint(20) unsigned | NO | MUL | |
| email_alias_destinations | delivery_role | varchar(100) | YES | 'recipient' | |
| email_alias_destinations | status | enum('active','paused','retired') | YES | 'active' | |
| email_alias_destinations | created_at | timestamp | YES | current_timestamp() | |
| email_alias_destinations | updated_at | timestamp | YES | current_timestamp() | |
| email_alias_mailbox_authorizations | id | bigint(20) unsigned | NO | PRI | |
| email_alias_mailbox_authorizations | alias_id | bigint(20) unsigned | NO | MUL | |
| email_alias_mailbox_authorizations | mailbox_id | bigint(20) unsigned | NO | MUL | |
| email_alias_mailbox_authorizations | authorization_status | enum('draft','approved','active','suspended','retired') | NO | MUL | 'draft' |
| email_alias_mailbox_authorizations | delivery_role | enum('primary','shared','archive','monitoring') | NO | 'primary' | |
| email_alias_mailbox_authorizations | notes | text | YES | NULL | |
| email_alias_mailbox_authorizations | created_at | timestamp | YES | current_timestamp() | |
| email_alias_mailbox_authorizations | updated_at | timestamp | YES | current_timestamp() | |
| email_dmarc_report_governance | id | bigint(20) unsigned | NO | PRI | |
| email_dmarc_report_governance | domain_name | varchar(255) | NO | UNI | |
| email_dmarc_report_governance | dmarc_policy | enum('none','quarantine','reject','unknown') | NO | 'unknown' | |
| email_dmarc_report_governance | rua_address | varchar(255) | YES | NULL | |
| email_dmarc_report_governance | ruf_address | varchar(255) | YES | NULL | |
| email_dmarc_report_governance | opendmarc_status | enum('not_installed','planned','installed','configured','validated','disabled') | NO | 'planned' | |
| email_dmarc_report_governance | report_processing_status | enum('not_started','pending','active','failed','disabled') | NO | 'not_started' | |
| email_dmarc_report_governance | notes | text | YES | NULL | |
| email_dmarc_report_governance | created_at | timestamp | YES | current_timestamp() | |
| email_dmarc_report_governance | updated_at | timestamp | YES | current_timestamp() | |
| email_domains | id | bigint(20) unsigned | NO | PRI | |
| email_domains | brand_id | bigint(20) unsigned | NO | MUL | |
| email_domains | domain | varchar(150) | NO | UNI | |
| email_domains | mail_server | varchar(150) | YES | NULL | |
| email_domains | mx_provider | varchar(100) | YES | NULL | |
| email_domains | mx_target | varchar(255) | YES | NULL | |
| email_domains | mx_priority | int(11) | YES | NULL | |
| email_domains | dns_validation_status | enum('unknown','valid','invalid','pending') | YES | 'unknown' | |
| email_domains | mail_routing_status | enum('unknown','active','not_routed','external_provider','pending') | YES | 'unknown' | |
| email_domains | last_dns_verified_at | datetime | YES | NULL | |
| email_domains | status | enum('planning','active','paused','error') | YES | 'planning' | |
| email_domains | created_at | timestamp | YES | current_timestamp() | |
| email_domains | updated_at | timestamp | YES | current_timestamp() | |
| email_domain_routing_governance | id | bigint(20) unsigned | NO | PRI | |
| email_domain_routing_governance | domain_name | varchar(255) | NO | UNI | |
| email_domain_routing_governance | mx_provider | enum('aws_ses','self_hosted_postfix','external','unknown') | NO | 'unknown' | |
| email_domain_routing_governance | mx_target | varchar(255) | YES | NULL | |
| email_domain_routing_governance | mx_priority | int(11) | YES | NULL | |
| email_domain_routing_governance | dns_validation_status | enum('unknown','pending','validated','failed','not_configured') | NO | 'unknown' | |
| email_domain_routing_governance | mail_routing_status | enum('unknown','pending','active','failed','disabled') | NO | 'unknown' | |
| email_domain_routing_governance | spf_status | enum('unknown','validated','failed','not_configured') | NO | 'unknown' | |
| email_domain_routing_governance | dkim_status | enum('unknown','validated','failed','not_configured') | NO | 'unknown' | |
| email_domain_routing_governance | dmarc_status | enum('unknown','validated','failed','not_configured') | NO | 'unknown' | |
| email_domain_routing_governance | last_dns_verified_at | datetime | YES | NULL | |
| email_domain_routing_governance | notes | text | YES | NULL | |
| email_domain_routing_governance | created_at | timestamp | YES | current_timestamp() | |
| email_domain_routing_governance | updated_at | timestamp | YES | current_timestamp() | |
| email_mailboxes | id | bigint(20) unsigned | NO | PRI | |
| email_mailboxes | mailbox_key | varchar(100) | NO | UNI | |
| email_mailboxes | mailbox_login | varchar(150) | NO | UNI | |
| email_mailboxes | display_name | varchar(150) | NO | ||
| email_mailboxes | mailbox_server | varchar(150) | NO | 'mail.wickedspooky.org' | |
| email_mailboxes | status | enum('active','paused','retired') | YES | 'active' | |
| email_mailboxes | runtime_status | enum('pending','created','validated','disabled','retired') | NO | 'pending' | |
| email_mailboxes | governance_status | enum('draft','approved','active','suspended','retired') | NO | 'draft' | |
| email_mailboxes | notes | text | YES | NULL | |
| email_mailboxes | created_at | timestamp | YES | current_timestamp() | |
| email_mailboxes | updated_at | timestamp | YES | current_timestamp() | |
| mailbox_alias_authorizations | id | int(11) | NO | PRI | |
| mailbox_alias_authorizations | mailbox_identity_id | int(11) | NO | MUL | |
| mailbox_alias_authorizations | email_alias_id | bigint(20) unsigned | NO | MUL | |
| mailbox_alias_authorizations | authorization_status | enum('authorized','revoked') | YES | 'authorized' | |
| mailbox_alias_authorizations | notes | text | YES | NULL | |
| mailbox_alias_authorizations | created_at | timestamp | YES | current_timestamp() | |
| mailbox_alias_authorizations | updated_at | timestamp | YES | current_timestamp() | |
| mailbox_identities | id | int(11) | NO | PRI | |
| mailbox_identities | mailbox_identity | varchar(100) | NO | UNI | |
| mailbox_identities | display_name | varchar(255) | YES | NULL | |
| mailbox_identities | mailbox_status | enum('planned','provisioning','active','disabled','retired') | YES | 'planned' | |
| mailbox_identities | runtime_mailbox_exists | tinyint(1) | YES | 0 | |
| mailbox_identities | roundcube_enabled | tinyint(1) | YES | 0 | |
| mailbox_identities | notes | text | YES | NULL | |
| mailbox_identities | created_at | timestamp | YES | current_timestamp() | |
| mailbox_identities | updated_at | timestamp | YES | current_timestamp() | |
| mailbox_identity_status_history | id | int(11) | NO | PRI | |
| mailbox_identity_status_history | mailbox_identity_id | int(11) | NO | MUL | |
| mailbox_identity_status_history | previous_status | varchar(50) | YES | NULL | |
| mailbox_identity_status_history | new_status | varchar(50) | NO | ||
| mailbox_identity_status_history | change_reason | text | YES | NULL | |
| mailbox_identity_status_history | changed_at | timestamp | YES | current_timestamp() | |
| make_scenarios | id | bigint(20) unsigned | NO | PRI | |
| make_scenarios | scenario_key | varchar(100) | NO | UNI | |
| make_scenarios | scenario_name | varchar(150) | NO | ||
| make_scenarios | purpose | text | YES | NULL | |
| make_scenarios | status | enum('draft','active','paused','retired') | YES | 'draft' | |
| make_scenarios | created_at | timestamp | YES | current_timestamp() | |
| make_scenarios | updated_at | timestamp | YES | current_timestamp() | |
| make_scenarios | lifecycle_status | enum('draft','manual','active','paused','retired') | YES | 'manual' | |
| make_scenarios | automation_status | enum('manual_off','scheduled_on','paused','disabled') | YES | 'manual_off' | |
| make_scenarios | max_concurrent_runs | int(11) | YES | 1 | |
| make_scenarios | production_ready | tinyint(1) | YES | 0 | |
| make_scenarios | last_validated_at | datetime | YES | NULL | |
| make_scenarios | notes | text | YES | NULL | |
| operational_artifact_registry | id | int(11) | NO | PRI | |
| operational_artifact_registry | subsystem_key | varchar(150) | NO | MUL | |
| operational_artifact_registry | artifact_key | varchar(200) | NO | UNI | |
| operational_artifact_registry | artifact_title | varchar(255) | NO | ||
| operational_artifact_registry | artifact_type | enum('bootstrap_package','seed_prompt','operational_use_guide','runtime_snapshot','validation_report','repository_page','checksum','zip_archive') | NO | MUL | |
| operational_artifact_registry | version_label | varchar(50) | NO | ||
| operational_artifact_registry | wp_page_id | bigint(20) unsigned | YES | NULL | |
| operational_artifact_registry | wp_media_id | bigint(20) unsigned | YES | NULL | |
| operational_artifact_registry | artifact_location | text | YES | NULL | |
| operational_artifact_registry | checksum_sha256 | varchar(128) | YES | NULL | |
| operational_artifact_registry | publication_status | enum('draft','published','archived') | YES | MUL | 'published' |
| operational_artifact_registry | published_at | timestamp | YES | NULL | |
| operational_artifact_registry | created_at | timestamp | YES | current_timestamp() | |
| operational_artifact_registry | updated_at | timestamp | YES | current_timestamp() | |
| operational_knowledge_base_pages | id | int(11) | NO | PRI | |
| operational_knowledge_base_pages | subsystem_key | varchar(150) | NO | MUL | |
| operational_knowledge_base_pages | page_title | varchar(255) | NO | ||
| operational_knowledge_base_pages | wp_page_id | bigint(20) unsigned | NO | UNI | |
| operational_knowledge_base_pages | wp_parent_id | bigint(20) unsigned | YES | NULL | |
| operational_knowledge_base_pages | wp_slug | varchar(255) | NO | ||
| operational_knowledge_base_pages | wp_status | varchar(50) | NO | 'private' | |
| operational_knowledge_base_pages | page_role | varchar(100) | NO | MUL | |
| operational_knowledge_base_pages | version_label | varchar(50) | NO | 'v1' | |
| operational_knowledge_base_pages | lifecycle_status | enum('draft','active','archived') | YES | MUL | 'active' |
| operational_knowledge_base_pages | published_at | timestamp | YES | NULL | |
| operational_knowledge_base_pages | created_at | timestamp | YES | current_timestamp() | |
| operational_knowledge_base_pages | updated_at | timestamp | YES | current_timestamp() | |
| operational_repository_publications | id | int(11) | NO | PRI | |
| operational_repository_publications | publication_key | varchar(150) | NO | UNI | |
| operational_repository_publications | subsystem_key | varchar(150) | NO | MUL | |
| operational_repository_publications | publication_action | varchar(100) | NO | ||
| operational_repository_publications | publication_status | enum('started','completed','failed','rolled_back') | YES | MUL | 'completed' |
| operational_repository_publications | wp_parent_page_id | bigint(20) unsigned | YES | NULL | |
| operational_repository_publications | pages_published | int(11) | YES | 0 | |
| operational_repository_publications | artifacts_published | int(11) | YES | 0 | |
| operational_repository_publications | checksum_status | enum('not_applicable','pending','verified','failed') | YES | 'not_applicable' | |
| operational_repository_publications | publication_notes | text | YES | NULL | |
| operational_repository_publications | published_at | timestamp | YES | MUL | current_timestamp() |
| operational_repository_publications | created_at | timestamp | YES | current_timestamp() | |
| operational_runtime_inventory | id | int(11) | NO | PRI | |
| operational_runtime_inventory | subsystem_key | varchar(150) | NO | MUL | |
| operational_runtime_inventory | inventory_key | varchar(200) | NO | UNI | |
| operational_runtime_inventory | environment_label | varchar(50) | NO | 'production' | |
| operational_runtime_inventory | server_name | varchar(100) | YES | MUL | NULL |
| operational_runtime_inventory | hostname | varchar(255) | YES | NULL | |
| operational_runtime_inventory | ip_address | varchar(100) | YES | NULL | |
| operational_runtime_inventory | dns_name | varchar(255) | YES | NULL | |
| operational_runtime_inventory | service_name | varchar(150) | YES | MUL | NULL |
| operational_runtime_inventory | service_port | varchar(50) | YES | NULL | |
| operational_runtime_inventory | filesystem_path | text | YES | NULL | |
| operational_runtime_inventory | config_path | text | YES | NULL | |
| operational_runtime_inventory | database_name | varchar(100) | YES | NULL | |
| operational_runtime_inventory | table_or_view_name | varchar(150) | YES | NULL | |
| operational_runtime_inventory | script_path | text | YES | NULL | |
| operational_runtime_inventory | validation_command | text | YES | NULL | |
| operational_runtime_inventory | rollback_command | text | YES | NULL | |
| operational_runtime_inventory | known_good_state | text | YES | NULL | |
| operational_runtime_inventory | secrets_policy | text | YES | NULL | |
| operational_runtime_inventory | lifecycle_status | enum('draft','active','archived') | YES | MUL | 'active' |
| operational_runtime_inventory | last_validated_at | timestamp | YES | NULL | |
| operational_runtime_inventory | created_at | timestamp | YES | current_timestamp() | |
| operational_runtime_inventory | updated_at | timestamp | YES | current_timestamp() | |
| operational_schema_dependencies | id | int(11) | NO | PRI | |
| operational_schema_dependencies | dependency_key | varchar(200) | NO | UNI | |
| operational_schema_dependencies | source_object_type | enum('script','view','make_scenario','artifact','dashboard') | NO | ||
| operational_schema_dependencies | source_object_key | varchar(200) | NO | ||
| operational_schema_dependencies | target_schema_name | varchar(100) | NO | 'wsai_ops' | |
| operational_schema_dependencies | target_object_name | varchar(150) | NO | ||
| operational_schema_dependencies | target_field_name | varchar(150) | YES | NULL | |
| operational_schema_dependencies | dependency_type | enum('reads','writes','updates','deletes','creates','references','unknown') | YES | 'unknown' | |
| operational_schema_dependencies | governance_notes | text | YES | NULL | |
| operational_schema_dependencies | lifecycle_status | enum('active','deprecated','archived') | YES | 'active' | |
| operational_schema_dependencies | created_at | timestamp | YES | current_timestamp() | |
| operational_schema_dependencies | updated_at | timestamp | YES | current_timestamp() | |
| operational_schema_drift_findings | id | int(11) | NO | PRI | |
| operational_schema_drift_findings | drift_key | varchar(200) | NO | UNI | |
| operational_schema_drift_findings | run_uuid | char(36) | NO | ||
| operational_schema_drift_findings | drift_source | enum('artifact','script','make_scenario','dashboard','manual_review') | NO | ||
| operational_schema_drift_findings | object_name | varchar(150) | NO | ||
| operational_schema_drift_findings | field_name | varchar(150) | YES | NULL | |
| operational_schema_drift_findings | expected_definition | text | YES | NULL | |
| operational_schema_drift_findings | live_definition | text | YES | NULL | |
| operational_schema_drift_findings | drift_status | enum('open','resolved','accepted','false_positive') | YES | 'open' | |
| operational_schema_drift_findings | resolution_notes | text | YES | NULL | |
| operational_schema_drift_findings | created_at | timestamp | YES | current_timestamp() | |
| operational_schema_drift_findings | resolved_at | timestamp | YES | NULL | |
| operational_schema_fields | id | int(11) | NO | PRI | |
| operational_schema_fields | table_schema_name | varchar(100) | NO | MUL | |
| operational_schema_fields | table_name | varchar(150) | NO | ||
| operational_schema_fields | column_name | varchar(150) | NO | ||
| operational_schema_fields | ordinal_position | int(11) | NO | ||
| operational_schema_fields | column_type | text | NO | ||
| operational_schema_fields | data_type | varchar(100) | NO | ||
| operational_schema_fields | is_nullable | varchar(10) | NO | ||
| operational_schema_fields | column_default | text | YES | NULL | |
| operational_schema_fields | column_key | varchar(20) | YES | NULL | |
| operational_schema_fields | extra | varchar(100) | YES | NULL | |
| operational_schema_fields | column_comment | text | YES | NULL | |
| operational_schema_fields | last_inventory_run_uuid | char(36) | YES | NULL | |
| operational_schema_fields | lifecycle_status | enum('active','deprecated','archived') | YES | 'active' | |
| operational_schema_fields | created_at | timestamp | YES | current_timestamp() | |
| operational_schema_fields | updated_at | timestamp | YES | current_timestamp() | |
| operational_schema_inventory_runs | id | int(11) | NO | PRI | |
| operational_schema_inventory_runs | run_uuid | char(36) | NO | UNI | |
| operational_schema_inventory_runs | database_name | varchar(100) | NO | ||
| operational_schema_inventory_runs | run_status | enum('started','completed','failed') | NO | 'started' | |
| operational_schema_inventory_runs | extraction_source | varchar(100) | NO | 'information_schema' | |
| operational_schema_inventory_runs | started_at | timestamp | YES | current_timestamp() | |
| operational_schema_inventory_runs | completed_at | timestamp | YES | NULL | |
| operational_schema_inventory_runs | notes | text | YES | NULL | |
| operational_schema_tables | id | int(11) | NO | PRI | |
| operational_schema_tables | table_schema_name | varchar(100) | NO | MUL | |
| operational_schema_tables | table_name | varchar(150) | NO | ||
| operational_schema_tables | table_type | varchar(50) | NO | ||
| operational_schema_tables | engine | varchar(50) | YES | NULL | |
| operational_schema_tables | table_collation | varchar(100) | YES | NULL | |
| operational_schema_tables | table_comment | text | YES | NULL | |
| operational_schema_tables | last_inventory_run_uuid | char(36) | YES | NULL | |
| operational_schema_tables | lifecycle_status | enum('active','deprecated','archived') | YES | 'active' | |
| operational_schema_tables | created_at | timestamp | YES | current_timestamp() | |
| operational_schema_tables | updated_at | timestamp | YES | current_timestamp() | |
| operational_schema_views | id | int(11) | NO | PRI | |
| operational_schema_views | table_schema_name | varchar(100) | NO | MUL | |
| operational_schema_views | view_name | varchar(150) | NO | ||
| operational_schema_views | view_definition | longtext | NO | ||
| operational_schema_views | check_option | varchar(20) | YES | NULL | |
| operational_schema_views | is_updatable | varchar(10) | YES | NULL | |
| operational_schema_views | definer | varchar(255) | YES | NULL | |
| operational_schema_views | security_type | varchar(20) | YES | NULL | |
| operational_schema_views | last_inventory_run_uuid | char(36) | YES | NULL | |
| operational_schema_views | lifecycle_status | enum('active','deprecated','archived') | YES | 'active' | |
| operational_schema_views | created_at | timestamp | YES | current_timestamp() | |
| operational_schema_views | updated_at | timestamp | YES | current_timestamp() | |
| operational_script_definitions | id | int(11) | NO | PRI | |
| operational_script_definitions | script_key | varchar(120) | NO | UNI | |
| operational_script_definitions | subsystem | varchar(120) | NO | ||
| operational_script_definitions | script_path | varchar(500) | NO | ||
| operational_script_definitions | scenario_key | varchar(160) | YES | NULL | |
| operational_script_definitions | script_role | varchar(120) | NO | ||
| operational_script_definitions | execution_layer | enum('ssh','local_shell','wp_cli','mysql','hybrid') | NO | 'hybrid' | |
| operational_script_definitions | input_contract | text | YES | NULL | |
| operational_script_definitions | output_contract | text | YES | NULL | |
| operational_script_definitions | governance_notes | text | YES | NULL | |
| operational_script_definitions | lifecycle_status | enum('draft','active','deprecated','archived') | NO | 'active' | |
| operational_script_definitions | created_at | timestamp | YES | current_timestamp() | |
| operational_script_definitions | updated_at | timestamp | YES | current_timestamp() | |
| operational_use_guides | id | int(11) | NO | PRI | |
| operational_use_guides | guide_key | varchar(150) | NO | UNI | |
| operational_use_guides | subsystem | varchar(100) | NO | ||
| operational_use_guides | title | varchar(255) | NO | ||
| operational_use_guides | guide_content | longtext | NO | ||
| operational_use_guides | version_label | varchar(50) | NO | ||
| operational_use_guides | lifecycle_status | enum('draft','active','archived') | YES | 'active' | |
| operational_use_guides | created_at | timestamp | YES | current_timestamp() | |
| operational_use_guides | updated_at | timestamp | YES | current_timestamp() | |
| product_backlog_events | event_id | int(11) | NO | PRI | |
| product_backlog_events | backlog_item_id | int(11) | NO | MUL | |
| product_backlog_events | event_type | enum('created','status_changed','priority_changed','note','validation','deferred','promoted','published') | NO | 'note' | |
| product_backlog_events | event_message | text | NO | ||
| product_backlog_events | event_source | enum('conversation','script','make','wordpress','mariadb','airtable','ai_agent','operator') | NO | 'operator' | |
| product_backlog_events | created_at | datetime | NO | current_timestamp() | |
| product_backlog_items | backlog_item_id | int(11) | NO | PRI | |
| product_backlog_items | product_id | int(11) | NO | MUL | |
| product_backlog_items | backlog_key | varchar(180) | NO | UNI | |
| product_backlog_items | title | varchar(255) | NO | ||
| product_backlog_items | backlog_status | enum('proposed','planned','active','blocked','validated','done','deferred','retired') | NO | 'proposed' | |
| product_backlog_items | backlog_type | enum('feature','enhancement','defect','research','integration','documentation','governance','automation') | NO | 'feature' | |
| product_backlog_items | priority | enum('low','medium','high','strategic') | NO | 'medium' | |
| product_backlog_items | source_type | enum('conversation','imported_file','wordpress','mariadb','make','airtable','operational_discovery','ai_recommendation','customer_request') | NO | 'conversation' | |
| product_backlog_items | source_reference | varchar(255) | YES | NULL | |
| product_backlog_items | description | text | YES | NULL | |
| product_backlog_items | acceptance_criteria | text | YES | NULL | |
| product_backlog_items | created_at | datetime | NO | current_timestamp() | |
| product_backlog_items | updated_at | datetime | NO | current_timestamp() | |
| product_registry | product_id | int(11) | NO | PRI | |
| product_registry | product_key | varchar(150) | NO | UNI | |
| product_registry | product_name | varchar(255) | NO | ||
| product_registry | product_domain | enum('Infrastructure','Content Platform','Platform','AI Agents','Hospitality','Research') | NO | ||
| product_registry | lifecycle_status | enum('proposed','planned','active','validated','production','deferred','retired') | NO | 'proposed' | |
| product_registry | priority | enum('low','medium','high','strategic') | NO | 'medium' | |
| product_registry | authority_page_id | bigint(20) | YES | NULL | |
| product_registry | description | text | YES | NULL | |
| product_registry | owner_role | varchar(150) | YES | NULL | |
| product_registry | created_at | datetime | NO | current_timestamp() | |
| product_registry | updated_at | datetime | NO | current_timestamp() | |
| publishing_alert_events | id | int(11) | NO | PRI | |
| publishing_alert_events | alert_key | varchar(150) | NO | ||
| publishing_alert_events | workflow_run_uuid | varchar(100) | YES | NULL | |
| publishing_alert_events | scenario_key | varchar(150) | YES | NULL | |
| publishing_alert_events | content_item_id | int(11) | YES | NULL | |
| publishing_alert_events | alert_severity | enum('info','warning','critical') | NO | 'warning' | |
| publishing_alert_events | alert_status | enum('open','acknowledged','resolved','muted') | NO | 'open' | |
| publishing_alert_events | alert_title | varchar(255) | NO | ||
| publishing_alert_events | alert_message | text | NO | ||
| publishing_alert_events | source_table | varchar(150) | YES | NULL | |
| publishing_alert_events | source_id | int(11) | YES | NULL | |
| publishing_alert_events | created_at | timestamp | NO | current_timestamp() | |
| publishing_alert_events | acknowledged_at | timestamp | YES | NULL | |
| publishing_alert_events | resolved_at | timestamp | YES | NULL | |
| publishing_content_assets | id | int(11) | NO | PRI | |
| publishing_content_assets | content_item_id | int(11) | NO | MUL | |
| publishing_content_assets | asset_type | enum('featured_image','inline_image','social_image','pdf','video','thumbnail') | NO | ||
| publishing_content_assets | asset_status | enum('missing','queued','generated','approved','attached','published','archived') | NO | MUL | 'missing' |
| publishing_content_assets | asset_provider | enum('pending_generator','openai_image','replicate','onedrive_upload','dropbox_upload','manual_url') | YES | 'pending_generator' | |
| publishing_content_assets | asset_prompt | text | YES | NULL | |
| publishing_content_assets | source_url | varchar(1000) | YES | NULL | |
| publishing_content_assets | asset_url | varchar(1000) | YES | NULL | |
| publishing_content_assets | wordpress_media_id | bigint(20) | YES | NULL | |
| publishing_content_assets | alt_text | varchar(255) | YES | NULL | |
| publishing_content_assets | reviewed_by | varchar(120) | YES | NULL | |
| publishing_content_assets | approved_at | datetime | YES | NULL | |
| publishing_content_assets | attached_at | datetime | YES | NULL | |
| publishing_content_assets | published_at | datetime | YES | NULL | |
| publishing_content_assets | created_at | timestamp | YES | current_timestamp() | |
| publishing_content_assets | updated_at | timestamp | YES | current_timestamp() | |
| publishing_content_items | id | int(11) | NO | PRI | |
| publishing_content_items | site_id | int(11) | NO | MUL | |
| publishing_content_items | brand_id | int(11) | NO | MUL | |
| publishing_content_items | content_uuid | char(36) | NO | MUL | |
| publishing_content_items | title | varchar(255) | NO | ||
| publishing_content_items | slug | varchar(255) | YES | NULL | |
| publishing_content_items | primary_category | varchar(120) | YES | NULL | |
| publishing_content_items | tags_json | longtext | YES | NULL | |
| publishing_content_items | lifecycle_status | enum('idea','queued','ai_draft','human_review','approved','wordpress_draft_created','media_ready','taxonomy_mapped','scheduled','published','archived','repurposed') | NO | MUL | 'idea' |
| publishing_content_items | content_type | enum('blog','tutorial','case_study','resource','announcement','social_seed') | NO | 'blog' | |
| publishing_content_items | ai_model | varchar(120) | YES | NULL | |
| publishing_content_items | ai_prompt_version | varchar(120) | YES | NULL | |
| publishing_content_items | wordpress_post_id | bigint(20) | YES | NULL | |
| publishing_content_items | wordpress_post_url | varchar(500) | YES | NULL | |
| publishing_content_items | featured_image_status | enum('missing','queued','generated','approved','published') | YES | 'missing' | |
| publishing_content_items | featured_image_url | varchar(1000) | YES | NULL | |
| publishing_content_items | seo_title | varchar(255) | YES | NULL | |
| publishing_content_items | seo_description | text | YES | NULL | |
| publishing_content_items | seo_keywords | text | YES | NULL | |
| publishing_content_items | draft_body | longtext | YES | NULL | |
| publishing_content_items | draft_excerpt | text | YES | NULL | |
| publishing_content_items | review_required | tinyint(1) | YES | 1 | |
| publishing_content_items | approved_by | varchar(120) | YES | NULL | |
| publishing_content_items | taxonomy_mapped_at | datetime | YES | NULL | |
| publishing_content_items | taxonomy_mapping_status | enum('pending','mapped','failed') | YES | 'pending' | |
| publishing_content_items | scheduled_publish_at | datetime | YES | NULL | |
| publishing_content_items | published_at | datetime | YES | NULL | |
| publishing_content_items | social_extraction_status | enum('pending','queued','completed') | YES | 'pending' | |
| publishing_content_items | rag_ingestion_status | enum('pending','queued','indexed') | YES | 'pending' | |
| publishing_content_items | created_at | timestamp | YES | current_timestamp() | |
| publishing_content_items | updated_at | timestamp | YES | current_timestamp() | |
| publishing_content_items | last_error | text | YES | NULL | |
| publishing_content_items | processing_lock_uuid | char(36) | YES | NULL | |
| publishing_content_items | lock_acquired_at | datetime | YES | NULL | |
| publishing_content_items | lock_expires_at | datetime | YES | NULL | |
| publishing_content_items | workflow_owner | varchar(120) | YES | NULL | |
| publishing_dead_letter_queue | id | int(11) | NO | PRI | |
| publishing_dead_letter_queue | source_failure_event_id | int(11) | NO | ||
| publishing_dead_letter_queue | workflow_run_uuid | varchar(100) | NO | ||
| publishing_dead_letter_queue | scenario_key | varchar(150) | NO | ||
| publishing_dead_letter_queue | publishing_item_id | int(11) | YES | MUL | NULL |
| publishing_dead_letter_queue | failure_stage | varchar(100) | NO | ||
| publishing_dead_letter_queue | failure_message | text | NO | ||
| publishing_dead_letter_queue | retry_count | int(11) | YES | 0 | |
| publishing_dead_letter_queue | max_retry_count | int(11) | YES | 3 | |
| publishing_dead_letter_queue | next_retry_after | datetime | YES | MUL | NULL |
| publishing_dead_letter_queue | queue_status | enum('open','retry_ready','retrying','resolved','abandoned') | YES | MUL | 'open' |
| publishing_dead_letter_queue | created_at | timestamp | YES | current_timestamp() | |
| publishing_dead_letter_queue | updated_at | timestamp | YES | current_timestamp() | |
| publishing_execution_locks | lock_name | varchar(150) | NO | PRI | |
| publishing_execution_locks | workflow_run_uuid | varchar(100) | NO | ||
| publishing_execution_locks | scenario_key | varchar(150) | NO | ||
| publishing_execution_locks | lock_status | enum('active','released','expired','failed') | NO | 'active' | |
| publishing_execution_locks | acquired_at | timestamp | NO | current_timestamp() | |
| publishing_execution_locks | expires_at | timestamp | YES | NULL | |
| publishing_execution_locks | released_at | timestamp | YES | NULL | |
| publishing_execution_locks | lock_metadata | longtext | YES | NULL | |
| publishing_failure_events | id | int(11) | NO | PRI | |
| publishing_failure_events | workflow_run_uuid | varchar(100) | NO | MUL | |
| publishing_failure_events | scenario_key | varchar(150) | NO | MUL | |
| publishing_failure_events | script_key | varchar(150) | YES | NULL | |
| publishing_failure_events | publishing_item_id | int(11) | YES | MUL | NULL |
| publishing_failure_events | wordpress_post_id | bigint(20) | YES | NULL | |
| publishing_failure_events | failure_stage | varchar(100) | NO | ||
| publishing_failure_events | failure_code | varchar(100) | YES | NULL | |
| publishing_failure_events | failure_message | text | NO | ||
| publishing_failure_events | raw_error | longtext | YES | NULL | |
| publishing_failure_events | retryable | tinyint(1) | YES | 1 | |
| publishing_failure_events | resolved | tinyint(1) | YES | MUL | 0 |
| publishing_failure_events | resolved_at | datetime | YES | NULL | |
| publishing_failure_events | resolution_notes | text | YES | NULL | |
| publishing_failure_events | created_at | timestamp | YES | current_timestamp() | |
| publishing_rag_ingestion | id | int(11) | NO | PRI | |
| publishing_rag_ingestion | content_item_id | int(11) | NO | MUL | |
| publishing_rag_ingestion | ingestion_status | enum('pending','queued','indexed','failed','excluded') | NO | MUL | 'pending' |
| publishing_rag_ingestion | source_type | enum('wordpress_post','pdf','social_asset','operational_artifact','manual_note') | NO | 'wordpress_post' | |
| publishing_rag_ingestion | source_url | varchar(1000) | YES | NULL | |
| publishing_rag_ingestion | vector_namespace | varchar(160) | YES | MUL | NULL |
| publishing_rag_ingestion | embedding_model | varchar(160) | YES | NULL | |
| publishing_rag_ingestion | chunk_count | int(11) | YES | NULL | |
| publishing_rag_ingestion | last_indexed_at | datetime | YES | NULL | |
| publishing_rag_ingestion | failure_message | text | YES | NULL | |
| publishing_rag_ingestion | created_at | timestamp | YES | current_timestamp() | |
| publishing_rag_ingestion | updated_at | timestamp | YES | current_timestamp() | |
| publishing_scheduler_activation | id | int(11) | NO | PRI | |
| publishing_scheduler_activation | scenario_key | varchar(150) | NO | UNI | |
| publishing_scheduler_activation | activation_status | enum('manual_off','scheduled_shadow','scheduled_limited','scheduled_active','paused') | NO | 'manual_off' | |
| publishing_scheduler_activation | schedule_description | varchar(255) | YES | NULL | |
| publishing_scheduler_activation | max_concurrent_runs | int(11) | NO | 1 | |
| publishing_scheduler_activation | last_workflow_run_uuid | varchar(100) | YES | NULL | |
| publishing_scheduler_activation | last_run_at | datetime | YES | NULL | |
| publishing_scheduler_activation | promoted_at | datetime | YES | NULL | |
| publishing_scheduler_activation | promoted_by | varchar(120) | YES | NULL | |
| publishing_scheduler_activation | governance_notes | text | YES | NULL | |
| publishing_scheduler_activation | created_at | timestamp | YES | current_timestamp() | |
| publishing_scheduler_activation | updated_at | timestamp | YES | current_timestamp() | |
| publishing_seo_governance | id | int(11) | NO | PRI | |
| publishing_seo_governance | content_item_id | int(11) | NO | MUL | |
| publishing_seo_governance | seo_status | enum('missing','drafted','review_required','approved','published','needs_revision') | NO | MUL | 'missing' |
| publishing_seo_governance | seo_title | varchar(255) | YES | NULL | |
| publishing_seo_governance | seo_description | text | YES | NULL | |
| publishing_seo_governance | focus_keyword | varchar(160) | YES | NULL | |
| publishing_seo_governance | secondary_keywords | text | YES | NULL | |
| publishing_seo_governance | canonical_url | varchar(500) | YES | NULL | |
| publishing_seo_governance | og_title | varchar(255) | YES | NULL | |
| publishing_seo_governance | og_description | text | YES | NULL | |
| publishing_seo_governance | og_image_url | varchar(1000) | YES | NULL | |
| publishing_seo_governance | reviewed_by | varchar(120) | YES | NULL | |
| publishing_seo_governance | approved_at | datetime | YES | NULL | |
| publishing_seo_governance | created_at | timestamp | YES | current_timestamp() | |
| publishing_seo_governance | updated_at | timestamp | YES | current_timestamp() | |
| publishing_social_extractions | id | int(11) | NO | PRI | |
| publishing_social_extractions | content_item_id | int(11) | NO | MUL | |
| publishing_social_extractions | platform | enum('instagram','tiktok','facebook','youtube','linkedin','x','general') | NO | MUL | 'general' |
| publishing_social_extractions | extraction_type | enum('hook','caption','carousel','short_video_script','ugc_angle','thread','quote_card','email_snippet') | NO | ||
| publishing_social_extractions | extraction_status | enum('queued','drafted','review_required','approved','published','archived') | NO | MUL | 'queued' |
| publishing_social_extractions | extracted_text | text | YES | NULL | |
| publishing_social_extractions | asset_id | int(11) | YES | MUL | NULL |
| publishing_social_extractions | source_section | varchar(255) | YES | NULL | |
| publishing_social_extractions | reviewed_by | varchar(120) | YES | NULL | |
| publishing_social_extractions | approved_at | datetime | YES | NULL | |
| publishing_social_extractions | created_at | timestamp | YES | current_timestamp() | |
| publishing_social_extractions | updated_at | timestamp | YES | current_timestamp() | |
| publishing_taxonomy_registry | id | int(11) | NO | PRI | |
| publishing_taxonomy_registry | site_id | int(11) | NO | MUL | |
| publishing_taxonomy_registry | brand_id | int(11) | NO | MUL | |
| publishing_taxonomy_registry | taxonomy_type | enum('category','tag') | NO | MUL | |
| publishing_taxonomy_registry | term_name | varchar(120) | NO | ||
| publishing_taxonomy_registry | term_slug | varchar(120) | NO | ||
| publishing_taxonomy_registry | governance_scope | enum('global','brand_specific','campaign','temporary','deprecated') | NO | MUL | 'brand_specific' |
| publishing_taxonomy_registry | is_allowed | tinyint(1) | NO | 1 | |
| publishing_taxonomy_registry | max_primary_use | tinyint(1) | YES | NULL | |
| publishing_taxonomy_registry | created_at | timestamp | YES | current_timestamp() | |
| publishing_taxonomy_registry | updated_at | timestamp | YES | current_timestamp() | |
| publishing_workflow_events | id | int(11) | NO | PRI | |
| publishing_workflow_events | content_item_id | int(11) | YES | MUL | NULL |
| publishing_workflow_events | workflow_run_uuid | char(36) | YES | NULL | |
| publishing_workflow_events | event_type | enum('created','queued','ai_draft_generated','ai_draft','human_review_requested','human_review','approved','wordpress_draft_created','media_ready','taxonomy_mapped','asset_generated','asset_approved','asset_attached','scheduled','published','repurposed','archived','failed','note') | NO | MUL | |
| publishing_workflow_events | event_source | enum('human','make','wordpress','openai','system') | NO | MUL | 'system' |
| publishing_workflow_events | event_message | text | YES | NULL | |
| publishing_workflow_events | event_payload | longtext | YES | NULL | |
| publishing_workflow_events | created_by | varchar(120) | YES | NULL | |
| publishing_workflow_events | created_at | timestamp | YES | current_timestamp() | |
| publishing_workflow_runs | id | int(11) | NO | PRI | |
| publishing_workflow_runs | workflow_run_uuid | varchar(100) | NO | UNI | |
| publishing_workflow_runs | scenario_key | varchar(150) | NO | ||
| publishing_workflow_runs | run_status | enum('started','completed','failed','abandoned') | NO | 'started' | |
| publishing_workflow_runs | started_at | datetime | NO | ||
| publishing_workflow_runs | completed_at | datetime | YES | NULL | |
| publishing_workflow_runs | execution_duration_seconds | int(11) | YES | NULL | |
| publishing_workflow_runs | execution_notes | text | YES | NULL | |
| publishing_workflow_runs | created_at | timestamp | YES | current_timestamp() | |
| runtime_inventory_records | id | int(11) | NO | PRI | |
| runtime_inventory_records | subsystem_key | varchar(150) | NO | ||
| runtime_inventory_records | inventory_category | varchar(100) | NO | ||
| runtime_inventory_records | runtime_name | varchar(255) | NO | ||
| runtime_inventory_records | runtime_type | varchar(100) | NO | ||
| runtime_inventory_records | runtime_location | varchar(255) | YES | NULL | |
| runtime_inventory_records | runtime_details | longtext | YES | NULL | |
| runtime_inventory_records | lifecycle_status | enum('active','planned','retired') | YES | 'active' | |
| runtime_inventory_records | validated_at | timestamp | YES | NULL | |
| runtime_inventory_records | created_at | timestamp | YES | current_timestamp() | |
| runtime_inventory_records | updated_at | timestamp | YES | current_timestamp() | |
| runtime_inventory_servers | id | int(11) | NO | PRI | |
| runtime_inventory_servers | server_name | varchar(100) | NO | ||
| runtime_inventory_servers | server_role | varchar(100) | NO | ||
| runtime_inventory_servers | operating_system | varchar(255) | YES | NULL | |
| runtime_inventory_servers | primary_purpose | text | YES | NULL | |
| runtime_inventory_servers | lifecycle_status | enum('active','planned','retired') | YES | 'active' | |
| runtime_inventory_servers | created_at | timestamp | YES | current_timestamp() | |
| schema_dictionary | id | bigint(20) unsigned | NO | PRI | |
| schema_dictionary | table_name | varchar(150) | NO | MUL | |
| schema_dictionary | field_name | varchar(150) | NO | ||
| schema_dictionary | data_type | varchar(255) | NO | ||
| schema_dictionary | field_role | varchar(100) | NO | ||
| schema_dictionary | purpose | text | NO | ||
| schema_dictionary | primary_writer | text | YES | NULL | |
| schema_dictionary | primary_reader | text | YES | NULL | |
| schema_dictionary | example_value | text | YES | NULL | |
| schema_dictionary | lifecycle_dependency | text | YES | NULL | |
| schema_dictionary | governance_notes | text | YES | NULL | |
| schema_dictionary | required_flag | tinyint(1) | YES | 0 | |
| schema_dictionary | active_flag | tinyint(1) | YES | 1 | |
| schema_dictionary | created_at | timestamp | YES | current_timestamp() | |
| schema_dictionary | updated_at | timestamp | YES | current_timestamp() | |
| schema_usage_registry | id | bigint(20) unsigned | NO | PRI | |
| schema_usage_registry | table_name | varchar(150) | NO | MUL | |
| schema_usage_registry | field_name | varchar(150) | NO | ||
| schema_usage_registry | usage_type | enum('read','write','read_write','trigger','validation','publishing_output','rag_input','audit','governance') | NO | ||
| schema_usage_registry | using_system | enum('make','wordpress','mariadb','openai','rag','human','system','other') | NO | MUL | |
| schema_usage_registry | scenario_key | varchar(150) | YES | MUL | NULL |
| schema_usage_registry | process_name | varchar(255) | NO | ||
| schema_usage_registry | lifecycle_stage | varchar(150) | YES | NULL | |
| schema_usage_registry | usage_purpose | text | NO | ||
| schema_usage_registry | dependency_notes | text | YES | NULL | |
| schema_usage_registry | governance_notes | text | YES | NULL | |
| schema_usage_registry | active_flag | tinyint(1) | YES | 1 | |
| schema_usage_registry | created_at | timestamp | YES | current_timestamp() | |
| schema_usage_registry | updated_at | timestamp | YES | current_timestamp() | |
| sites | id | bigint(20) unsigned | NO | PRI | |
| sites | brand_id | bigint(20) unsigned | NO | MUL | |
| sites | wp_network_root | varchar(150) | NO | ||
| sites | wp_blog_id | bigint(20) unsigned | YES | NULL | |
| sites | domain | varchar(150) | NO | UNI | |
| sites | site_slug | varchar(100) | NO | ||
| sites | site_title | varchar(150) | NO | ||
| sites | site_type | varchar(100) | YES | NULL | |
| sites | deployment_status | enum('draft','ready_to_deploy','provisioning','dns_pending','ssl_pending','theme_applied','starter_pages_created','qa_required','live','paused','error') | YES | 'draft' | |
| sites | admin_email | varchar(150) | YES | NULL | |
| sites | last_deployed_at | datetime | YES | NULL | |
| sites | created_at | timestamp | YES | current_timestamp() | |
| sites | updated_at | timestamp | YES | current_timestamp() | |
| table_registry | id | bigint(20) unsigned | NO | PRI | |
| table_registry | table_name | varchar(150) | NO | UNI | |
| table_registry | subsystem | varchar(100) | NO | ||
| table_registry | lifecycle_role | varchar(100) | NO | ||
| table_registry | authority_type | enum('system_of_record','operational_memory','execution_log','governance','reference','staging') | NO | ||
| table_registry | ownership_team | varchar(150) | NO | ||
| table_registry | purpose | text | NO | ||
| table_registry | primary_writer | text | YES | NULL | |
| table_registry | primary_reader | text | YES | NULL | |
| table_registry | governance_notes | text | YES | NULL | |
| table_registry | active_flag | tinyint(1) | YES | 1 | |
| table_registry | created_at | timestamp | YES | current_timestamp() | |
| table_registry | updated_at | timestamp | YES | current_timestamp() | |
| v_alias_authorization_matrix | authorization_id | int(11) | NO | 0 | |
| v_alias_authorization_matrix | mailbox_identity | varchar(100) | NO | ||
| v_alias_authorization_matrix | display_name | varchar(255) | YES | NULL | |
| v_alias_authorization_matrix | mailbox_status | enum('planned','provisioning','active','disabled','retired') | YES | 'planned' | |
| v_alias_authorization_matrix | alias_address | varchar(150) | NO | ||
| v_alias_authorization_matrix | legacy_destination_address | varchar(150) | NO | ||
| v_alias_authorization_matrix | alias_status | enum('active','paused','retired') | YES | 'active' | |
| v_alias_authorization_matrix | authorization_status | enum('authorized','revoked') | YES | 'authorized' | |
| v_alias_authorization_matrix | notes | text | YES | NULL | |
| v_alias_authorization_matrix | created_at | timestamp | YES | current_timestamp() | |
| v_alias_authorization_matrix | updated_at | timestamp | YES | current_timestamp() | |
| v_deployment_orchestration_health | queued_packages | decimal(23,0) | NO | 0 | |
| v_deployment_orchestration_health | claimed_packages | decimal(23,0) | NO | 0 | |
| v_deployment_orchestration_health | active_packages | decimal(23,0) | NO | 0 | |
| v_deployment_orchestration_health | completed_packages | decimal(23,0) | NO | 0 | |
| v_deployment_orchestration_health | historical_failed_packages | decimal(23,0) | NO | 0 | |
| v_deployment_orchestration_health | open_failed_packages | decimal(23,0) | NO | 0 | |
| v_deployment_orchestration_health | open_rollbacks | decimal(23,0) | NO | 0 | |
| v_deployment_orchestration_health | validation_status | varchar(6) | NO | '' | |
| v_deployment_queue_next_claim | queue_id | bigint(20) unsigned | NO | 0 | |
| v_deployment_queue_next_claim | package_key | varchar(160) | NO | ||
| v_deployment_queue_next_claim | package_name | varchar(255) | NO | ||
| v_deployment_queue_next_claim | package_version | varchar(80) | YES | NULL | |
| v_deployment_queue_next_claim | package_path | varchar(500) | NO | ||
| v_deployment_queue_next_claim | target_server | varchar(80) | NO | 'web' | |
| v_deployment_queue_next_claim | target_runtime_user | varchar(80) | NO | 'admin' | |
| v_deployment_queue_next_claim | target_working_dir | varchar(500) | NO | '/var/www' | |
| v_deployment_queue_next_claim | priority | int(11) | NO | 100 | |
| v_deployment_queue_next_claim | created_at | datetime | NO | current_timestamp() | |
| v_deployment_queue_ready | queue_id | bigint(20) unsigned | NO | 0 | |
| v_deployment_queue_ready | package_key | varchar(160) | NO | ||
| v_deployment_queue_ready | package_name | varchar(255) | NO | ||
| v_deployment_queue_ready | package_version | varchar(80) | YES | NULL | |
| v_deployment_queue_ready | package_path | varchar(500) | NO | ||
| v_deployment_queue_ready | target_server | varchar(80) | NO | 'web' | |
| v_deployment_queue_ready | target_runtime_user | varchar(80) | NO | 'admin' | |
| v_deployment_queue_ready | target_working_dir | varchar(500) | NO | '/var/www' | |
| v_deployment_queue_ready | priority | int(11) | NO | 100 | |
| v_deployment_queue_ready | created_at | datetime | NO | current_timestamp() | |
| v_deployment_registry_dashboard | deployment_id | bigint(20) unsigned | NO | 0 | |
| v_deployment_registry_dashboard | package_key | varchar(160) | NO | ||
| v_deployment_registry_dashboard | package_version | varchar(80) | YES | NULL | |
| v_deployment_registry_dashboard | target_server | varchar(80) | NO | ||
| v_deployment_registry_dashboard | deployment_result | enum('completed','failed','rollback_required','rolled_back') | NO | ||
| v_deployment_registry_dashboard | wordpress_publication_status | enum('pending','published','failed','not_required') | NO | 'pending' | |
| v_deployment_registry_dashboard | knowledge_capture_status | enum('pending','published','failed') | NO | 'pending' | |
| v_deployment_registry_dashboard | started_at | datetime | YES | NULL | |
| v_deployment_registry_dashboard | completed_at | datetime | YES | NULL | |
| v_deployment_registry_ready_for_publication | deployment_id | bigint(20) unsigned | NO | 0 | |
| v_deployment_registry_ready_for_publication | execution_uuid | char(36) | NO | ||
| v_deployment_registry_ready_for_publication | queue_id | bigint(20) unsigned | NO | ||
| v_deployment_registry_ready_for_publication | execution_id | bigint(20) unsigned | NO | ||
| v_deployment_registry_ready_for_publication | package_key | varchar(160) | NO | ||
| v_deployment_registry_ready_for_publication | package_version | varchar(80) | YES | NULL | |
| v_deployment_registry_ready_for_publication | target_server | varchar(80) | NO | ||
| v_deployment_registry_ready_for_publication | deployment_result | enum('completed','failed','rollback_required','rolled_back') | NO | ||
| v_deployment_registry_ready_for_publication | evidence_bundle_path | varchar(500) | YES | NULL | |
| v_deployment_registry_ready_for_publication | failure_snapshot_path | varchar(500) | YES | NULL | |
| v_deployment_registry_ready_for_publication | started_at | datetime | YES | NULL | |
| v_deployment_registry_ready_for_publication | completed_at | datetime | YES | NULL | |
| v_deployment_rollback_required | queue_id | bigint(20) unsigned | NO | 0 | |
| v_deployment_rollback_required | execution_id | bigint(20) unsigned | NO | 0 | |
| v_deployment_rollback_required | package_key | varchar(160) | NO | ||
| v_deployment_rollback_required | package_version | varchar(80) | YES | NULL | |
| v_deployment_rollback_required | queue_status | enum('queued','claimed','validating','transferring','executing','validating_runtime','evidence_pending','completed','failed','cancelled') | NO | 'queued' | |
| v_deployment_rollback_required | failure_reason | text | YES | NULL | |
| v_deployment_rollback_required | rollback_required | tinyint(1) | NO | 0 | |
| v_deployment_rollback_required | rollback_completed | tinyint(1) | NO | 0 | |
| v_deployment_rollback_required | execution_status | enum('started','package_validated','package_transferred','package_extracted','script_executed','runtime_validated','evidence_generated','published','completed','failed','rolled_back') | NO | 'started' | |
| v_deployment_rollback_required | failure_snapshot_path | varchar(500) | YES | NULL | |
| v_deployment_rollback_required | updated_at | datetime | NO | current_timestamp() | |
| v_email_alias_governance_ready | alias_id | bigint(20) unsigned | NO | 0 | |
| v_email_alias_governance_ready | alias_address | varchar(150) | NO | ||
| v_email_alias_governance_ready | domain_name | varchar(150) | YES | NULL | |
| v_email_alias_governance_ready | alias_status | enum('active','paused','retired') | YES | 'active' | |
| v_email_alias_governance_ready | routing_readiness | varchar(9) | YES | NULL | |
| v_email_alias_governance_ready | alias_deployment_readiness | varchar(10) | YES | NULL | |
| v_email_alias_mailbox_delivery | alias_id | bigint(20) unsigned | NO | 0 | |
| v_email_alias_mailbox_delivery | alias_address | varchar(150) | NO | ||
| v_email_alias_mailbox_delivery | alias_status | enum('active','paused','retired') | YES | 'active' | |
| v_email_alias_mailbox_delivery | mailbox_id | bigint(20) unsigned | NO | 0 | |
| v_email_alias_mailbox_delivery | mailbox_key | varchar(100) | NO | ||
| v_email_alias_mailbox_delivery | mailbox_login | varchar(150) | NO | ||
| v_email_alias_mailbox_delivery | mailbox_server | varchar(150) | NO | 'mail.wickedspooky.org' | |
| v_email_alias_mailbox_delivery | runtime_status | enum('pending','created','validated','disabled','retired') | NO | 'pending' | |
| v_email_alias_mailbox_delivery | governance_status | enum('draft','approved','active','suspended','retired') | NO | 'draft' | |
| v_email_alias_mailbox_delivery | delivery_role | enum('primary','shared','archive','monitoring') | NO | 'primary' | |
| v_email_alias_mailbox_delivery | authorization_status | enum('draft','approved','active','suspended','retired') | NO | 'draft' | |
| v_email_domain_routing_health | registered_domains | bigint(21) | NO | 0 | |
| v_email_domain_routing_health | active_domains | decimal(23,0) | YES | NULL | |
| v_email_domain_routing_health | unrouted_domains | decimal(23,0) | YES | NULL | |
| v_email_domain_routing_health | external_provider_domains | decimal(23,0) | YES | NULL | |
| v_email_domain_routing_health | pending_domains | decimal(23,0) | YES | NULL | |
| v_email_domain_routing_health | invalid_dns_domains | decimal(23,0) | YES | NULL | |
| v_email_domain_routing_ready | domain_name | varchar(255) | NO | ||
| v_email_domain_routing_ready | mx_provider | enum('aws_ses','self_hosted_postfix','external','unknown') | NO | 'unknown' | |
| v_email_domain_routing_ready | dns_validation_status | enum('unknown','pending','validated','failed','not_configured') | NO | 'unknown' | |
| v_email_domain_routing_ready | mail_routing_status | enum('unknown','pending','active','failed','disabled') | NO | 'unknown' | |
| v_email_domain_routing_ready | spf_status | enum('unknown','validated','failed','not_configured') | NO | 'unknown' | |
| v_email_domain_routing_ready | dkim_status | enum('unknown','validated','failed','not_configured') | NO | 'unknown' | |
| v_email_domain_routing_ready | dmarc_status | enum('unknown','validated','failed','not_configured') | NO | 'unknown' | |
| v_email_domain_routing_ready | routing_readiness | varchar(9) | NO | '' | |
| v_email_domain_routing_status | id | bigint(20) unsigned | NO | 0 | |
| v_email_domain_routing_status | domain | varchar(150) | NO | ||
| v_email_domain_routing_status | mail_server | varchar(150) | YES | NULL | |
| v_email_domain_routing_status | mx_provider | varchar(100) | YES | NULL | |
| v_email_domain_routing_status | mx_target | varchar(255) | YES | NULL | |
| v_email_domain_routing_status | mx_priority | int(11) | YES | NULL | |
| v_email_domain_routing_status | dns_validation_status | enum('unknown','valid','invalid','pending') | YES | 'unknown' | |
| v_email_domain_routing_status | mail_routing_status | enum('unknown','active','not_routed','external_provider','pending') | YES | 'unknown' | |
| v_email_domain_routing_status | last_dns_verified_at | datetime | YES | NULL | |
| v_email_domain_routing_status | status | enum('planning','active','paused','error') | YES | 'planning' | |
| v_email_mailbox_visibility | mailbox_key | varchar(100) | NO | ||
| v_email_mailbox_visibility | display_name | varchar(150) | NO | ||
| v_email_mailbox_visibility | mailbox_login | varchar(150) | NO | ||
| v_email_mailbox_visibility | mailbox_server | varchar(150) | NO | 'mail.wickedspooky.org' | |
| v_email_mailbox_visibility | domain | varchar(150) | NO | ||
| v_email_mailbox_visibility | alias_address | varchar(150) | NO | ||
| v_email_mailbox_visibility | purpose | varchar(150) | YES | NULL | |
| v_email_mailbox_visibility | alias_status | enum('active','paused','retired') | YES | 'active' | |
| v_email_mailbox_visibility | destination_status | enum('active','paused','retired') | YES | 'active' | |
| v_email_opendmarc_readiness | domain_name | varchar(255) | NO | ||
| v_email_opendmarc_readiness | dmarc_policy | enum('none','quarantine','reject','unknown') | NO | 'unknown' | |
| v_email_opendmarc_readiness | opendmarc_status | enum('not_installed','planned','installed','configured','validated','disabled') | NO | 'planned' | |
| v_email_opendmarc_readiness | report_processing_status | enum('not_started','pending','active','failed','disabled') | NO | 'not_started' | |
| v_email_opendmarc_readiness | routing_readiness | varchar(9) | NO | '' | |
| v_email_opendmarc_readiness | opendmarc_deployment_readiness | varchar(8) | NO | '' | |
| v_email_postfix_virtual_export | alias_address | varchar(150) | NO | ||
| v_email_postfix_virtual_export | destination_mailboxes | mediumtext | YES | NULL | |
| v_mailbox_alias_authorization_drift | email_alias_id | bigint(20) unsigned | NO | 0 | |
| v_mailbox_alias_authorization_drift | alias_address | varchar(150) | NO | ||
| v_mailbox_alias_authorization_drift | legacy_destination_address | varchar(150) | NO | ||
| v_mailbox_alias_authorization_drift | alias_status | enum('active','paused','retired') | YES | 'active' | |
| v_mailbox_alias_authorization_drift | active_authorized_mailbox_count | bigint(21) | NO | 0 | |
| v_mailbox_authorized_alias_routing | alias_address | varchar(150) | NO | ||
| v_mailbox_authorized_alias_routing | authorized_mailbox_identities | mediumtext | YES | NULL | |
| v_mailbox_authorized_alias_routing | authorized_mailbox_count | bigint(21) | NO | 0 | |
| v_mailbox_governance_health | mailbox_identities | bigint(21) | NO | 0 | |
| v_mailbox_governance_health | active_mailboxes | decimal(22,0) | YES | NULL | |
| v_mailbox_governance_health | planned_mailboxes | decimal(22,0) | YES | NULL | |
| v_mailbox_governance_health | active_runtime_drift | decimal(22,0) | YES | NULL | |
| v_mailbox_governance_health | roundcube_runtime_drift | decimal(22,0) | YES | NULL | |
| v_mailbox_governance_validation_gate | mailbox_identities | bigint(21) | NO | 0 | |
| v_mailbox_governance_validation_gate | active_mailboxes | decimal(22,0) | YES | NULL | |
| v_mailbox_governance_validation_gate | planned_mailboxes | decimal(22,0) | YES | NULL | |
| v_mailbox_governance_validation_gate | active_runtime_drift | decimal(22,0) | YES | NULL | |
| v_mailbox_governance_validation_gate | roundcube_runtime_drift | decimal(22,0) | YES | NULL | |
| v_mailbox_governance_validation_gate | active_alias_authorization_drift | bigint(21) | NO | 0 | |
| v_mailbox_governance_validation_gate | validation_status | varchar(4) | YES | NULL | |
| v_mailbox_identity_summary | id | int(11) | NO | 0 | |
| v_mailbox_identity_summary | mailbox_identity | varchar(100) | NO | ||
| v_mailbox_identity_summary | display_name | varchar(255) | YES | NULL | |
| v_mailbox_identity_summary | mailbox_status | enum('planned','provisioning','active','disabled','retired') | YES | 'planned' | |
| v_mailbox_identity_summary | runtime_mailbox_exists | tinyint(1) | YES | 0 | |
| v_mailbox_identity_summary | roundcube_enabled | tinyint(1) | YES | 0 | |
| v_mailbox_identity_summary | authorized_aliases | bigint(21) | NO | 0 | |
| v_operational_artifact_registry_summary | subsystem_key | varchar(150) | NO | ||
| v_operational_artifact_registry_summary | registered_artifacts | bigint(21) | NO | 0 | |
| v_operational_artifact_registry_summary | published_artifacts | decimal(22,0) | YES | NULL | |
| v_operational_artifact_registry_summary | last_updated | timestamp | YES | current_timestamp() | |
| v_operational_data_dictionary_summary | subsystem | varchar(100) | NO | ||
| v_operational_data_dictionary_summary | registered_objects | bigint(21) | NO | 0 | |
| v_operational_data_dictionary_summary | documented_objects | bigint(21) | NO | 0 | |
| v_operational_data_dictionary_summary | documented_fields | bigint(21) | NO | 0 | |
| v_operational_knowledge_base_health | total_subsystems | bigint(21) | NO | 0 | |
| v_operational_knowledge_base_health | total_pages | bigint(21) | NO | 0 | |
| v_operational_knowledge_base_health | active_pages | decimal(22,0) | YES | NULL | |
| v_operational_knowledge_base_health | private_pages | decimal(22,0) | YES | NULL | |
| v_operational_knowledge_base_health | total_artifacts | bigint(21) | NO | 0 | |
| v_operational_knowledge_base_health | published_artifacts | decimal(22,0) | YES | NULL | |
| v_operational_knowledge_base_health | completed_publications | bigint(21) | NO | 0 | |
| v_operational_knowledge_base_health | runtime_subsystems | bigint(21) | NO | 0 | |
| v_operational_knowledge_base_health | runtime_records | bigint(21) | NO | 0 | |
| v_operational_knowledge_base_health | active_runtime_records | decimal(22,0) | YES | NULL | |
| v_operational_knowledge_base_health | validation_status | varchar(6) | YES | NULL | |
| v_operational_knowledge_base_summary | subsystem_key | varchar(150) | NO | ||
| v_operational_knowledge_base_summary | registered_pages | bigint(21) | NO | 0 | |
| v_operational_knowledge_base_summary | active_pages | decimal(22,0) | YES | NULL | |
| v_operational_knowledge_base_summary | private_pages | decimal(22,0) | YES | NULL | |
| v_operational_knowledge_base_summary | first_published_at | timestamp | YES | NULL | |
| v_operational_knowledge_base_summary | last_updated_at | timestamp | YES | current_timestamp() | |
| v_operational_runtime_inventory_summary | subsystem_key | varchar(150) | NO | ||
| v_operational_runtime_inventory_summary | inventory_records | bigint(21) | NO | 0 | |
| v_operational_runtime_inventory_summary | active_records | decimal(22,0) | YES | NULL | |
| v_operational_runtime_inventory_summary | last_validated_at | timestamp | YES | NULL | |
| v_operational_runtime_inventory_summary | last_updated_at | timestamp | YES | current_timestamp() | |
| v_operational_schema_bootstrap_extract | object_name | varchar(150) | NO | ||
| v_operational_schema_bootstrap_extract | object_type | varchar(50) | NO | ||
| v_operational_schema_bootstrap_extract | column_name | varchar(150) | YES | ||
| v_operational_schema_bootstrap_extract | ordinal_position | int(11) | YES | ||
| v_operational_schema_bootstrap_extract | column_type | text | YES | ||
| v_operational_schema_bootstrap_extract | is_nullable | varchar(10) | YES | ||
| v_operational_schema_bootstrap_extract | column_key | varchar(20) | YES | NULL | |
| v_operational_schema_bootstrap_extract | extra | varchar(100) | YES | NULL | |
| v_operational_schema_bootstrap_extract | column_default | text | YES | NULL | |
| v_operational_schema_bootstrap_extract | object_lifecycle_status | enum('active','deprecated','archived') | YES | 'active' | |
| v_operational_schema_bootstrap_extract | field_lifecycle_status | enum('active','deprecated','archived') | YES | 'active' | |
| v_operational_schema_dependency_dashboard | source_object_type | enum('script','view','make_scenario','artifact','dashboard') | NO | ||
| v_operational_schema_dependency_dashboard | source_object_key | varchar(200) | NO | ||
| v_operational_schema_dependency_dashboard | target_object_name | varchar(150) | NO | ||
| v_operational_schema_dependency_dashboard | dependency_count | bigint(21) | NO | 0 | |
| v_operational_schema_dependency_dashboard | object_level_dependencies | decimal(22,0) | YES | NULL | |
| v_operational_schema_dependency_dashboard | field_level_dependencies | decimal(22,0) | YES | NULL | |
| v_operational_schema_drift_candidates | drift_key | varchar(213) | YES | NULL | |
| v_operational_schema_drift_candidates | run_uuid | uuid | YES | NULL | |
| v_operational_schema_drift_candidates | drift_source | varchar(13) | NO | '' | |
| v_operational_schema_drift_candidates | object_name | varchar(150) | NO | '' | |
| v_operational_schema_drift_candidates | field_name | varchar(150) | YES | NULL | |
| v_operational_schema_drift_candidates | expected_definition | varchar(334) | YES | NULL | |
| v_operational_schema_drift_candidates | live_definition | varchar(45) | NO | '' | |
| v_operational_schema_drift_dashboard | drift_status | enum('open','resolved','accepted','false_positive') | YES | 'open' | |
| v_operational_schema_drift_dashboard | drift_source | enum('artifact','script','make_scenario','dashboard','manual_review') | NO | ||
| v_operational_schema_drift_dashboard | object_name | varchar(150) | NO | ||
| v_operational_schema_drift_dashboard | field_name | varchar(150) | YES | NULL | |
| v_operational_schema_drift_dashboard | finding_count | bigint(21) | NO | 0 | |
| v_operational_schema_drift_dashboard | first_seen_at | timestamp | YES | current_timestamp() | |
| v_operational_schema_drift_dashboard | last_seen_at | timestamp | YES | current_timestamp() | |
| v_operational_schema_missing_dependencies | dependency_key | varchar(200) | NO | '' | |
| v_operational_schema_missing_dependencies | source_object_type | varchar(13) | NO | '' | |
| v_operational_schema_missing_dependencies | source_object_key | varchar(200) | NO | '' | |
| v_operational_schema_missing_dependencies | target_object_name | varchar(150) | NO | '' | |
| v_operational_schema_missing_dependencies | target_field_name | varchar(150) | YES | NULL | |
| v_operational_schema_missing_dependencies | dependency_type | varchar(10) | YES | NULL | |
| v_operational_schema_promotion_gate | scenario_key | varchar(200) | NO | ||
| v_operational_schema_promotion_gate | registered_dependencies | bigint(21) | NO | 0 | |
| v_operational_schema_promotion_gate | missing_dependencies | decimal(22,0) | YES | NULL | |
| v_operational_schema_promotion_gate | schema_gate_status | varchar(20) | YES | NULL | |
| v_operational_schema_registry_health | registered_tables | bigint(21) | YES | NULL | |
| v_operational_schema_registry_health | registered_fields | bigint(21) | YES | NULL | |
| v_operational_schema_registry_health | registered_views | bigint(21) | YES | NULL | |
| v_operational_schema_registry_health | active_dependencies | bigint(21) | YES | NULL | |
| v_operational_schema_registry_health | open_drift_findings | bigint(21) | YES | NULL | |
| v_operational_schema_registry_health | promotion_ready_scenarios | bigint(21) | YES | NULL | |
| v_operational_schema_registry_summary | registry_area | varchar(19) | NO | '' | |
| v_operational_schema_registry_summary | registered_objects | bigint(21) | NO | 0 | |
| v_postfix_virtual_alias_export | alias_address | varchar(150) | NO | ||
| v_postfix_virtual_alias_export | destination_mailboxes | mediumtext | YES | NULL | |
| v_product_backlog_active | product_key | varchar(150) | NO | ||
| v_product_backlog_active | product_name | varchar(255) | NO | ||
| v_product_backlog_active | product_domain | enum('Infrastructure','Content Platform','Platform','AI Agents','Hospitality','Research') | NO | ||
| v_product_backlog_active | product_status | enum('proposed','planned','active','validated','production','deferred','retired') | NO | 'proposed' | |
| v_product_backlog_active | backlog_key | varchar(180) | NO | ||
| v_product_backlog_active | title | varchar(255) | NO | ||
| v_product_backlog_active | backlog_status | enum('proposed','planned','active','blocked','validated','done','deferred','retired') | NO | 'proposed' | |
| v_product_backlog_active | backlog_type | enum('feature','enhancement','defect','research','integration','documentation','governance','automation') | NO | 'feature' | |
| v_product_backlog_active | priority | enum('low','medium','high','strategic') | NO | 'medium' | |
| v_product_backlog_active | source_type | enum('conversation','imported_file','wordpress','mariadb','make','airtable','operational_discovery','ai_recommendation','customer_request') | NO | 'conversation' | |
| v_product_backlog_active | source_reference | varchar(255) | YES | NULL | |
| v_product_backlog_active | updated_at | datetime | NO | current_timestamp() | |
| v_product_registry_dashboard | product_domain | enum('Infrastructure','Content Platform','Platform','AI Agents','Hospitality','Research') | NO | ||
| v_product_registry_dashboard | lifecycle_status | enum('proposed','planned','active','validated','production','deferred','retired') | NO | 'proposed' | |
| v_product_registry_dashboard | priority | enum('low','medium','high','strategic') | NO | 'medium' | |
| v_product_registry_dashboard | product_count | bigint(21) | NO | 0 | |
| v_publishing_alert_candidates | alert_type | varchar(23) | NO | '' | |
| v_publishing_alert_candidates | alert_count | bigint(21) | NO | 0 | |
| v_publishing_dead_letter_queue_open | id | int(11) | NO | 0 | |
| v_publishing_dead_letter_queue_open | source_failure_event_id | int(11) | NO | ||
| v_publishing_dead_letter_queue_open | workflow_run_uuid | varchar(100) | NO | ||
| v_publishing_dead_letter_queue_open | scenario_key | varchar(150) | NO | ||
| v_publishing_dead_letter_queue_open | publishing_item_id | int(11) | YES | NULL | |
| v_publishing_dead_letter_queue_open | failure_stage | varchar(100) | NO | ||
| v_publishing_dead_letter_queue_open | retry_count | int(11) | YES | 0 | |
| v_publishing_dead_letter_queue_open | max_retry_count | int(11) | YES | 3 | |
| v_publishing_dead_letter_queue_open | next_retry_after | datetime | YES | NULL | |
| v_publishing_dead_letter_queue_open | queue_status | enum('open','retry_ready','retrying','resolved','abandoned') | YES | 'open' | |
| v_publishing_dead_letter_queue_open | failure_message | text | NO | ||
| v_publishing_dead_letter_queue_open | created_at | timestamp | YES | current_timestamp() | |
| v_publishing_dead_letter_queue_open | updated_at | timestamp | YES | current_timestamp() | |
| v_publishing_execution_lock_active | lock_name | varchar(150) | NO | ||
| v_publishing_execution_lock_active | workflow_run_uuid | varchar(100) | NO | ||
| v_publishing_execution_lock_active | scenario_key | varchar(150) | NO | ||
| v_publishing_execution_lock_active | lock_status | enum('active','released','expired','failed') | NO | 'active' | |
| v_publishing_execution_lock_active | acquired_at | timestamp | NO | current_timestamp() | |
| v_publishing_execution_lock_active | expires_at | timestamp | YES | NULL | |
| v_publishing_execution_lock_active | lock_age_minutes | bigint(21) | YES | NULL | |
| v_publishing_failure_events_open | id | int(11) | NO | 0 | |
| v_publishing_failure_events_open | workflow_run_uuid | varchar(100) | NO | ||
| v_publishing_failure_events_open | scenario_key | varchar(150) | NO | ||
| v_publishing_failure_events_open | script_key | varchar(150) | YES | NULL | |
| v_publishing_failure_events_open | publishing_item_id | int(11) | YES | NULL | |
| v_publishing_failure_events_open | wordpress_post_id | bigint(20) | YES | NULL | |
| v_publishing_failure_events_open | failure_stage | varchar(100) | NO | ||
| v_publishing_failure_events_open | failure_code | varchar(100) | YES | NULL | |
| v_publishing_failure_events_open | failure_message | text | NO | ||
| v_publishing_failure_events_open | retryable | tinyint(1) | YES | 1 | |
| v_publishing_failure_events_open | resolved | tinyint(1) | YES | 0 | |
| v_publishing_failure_events_open | created_at | timestamp | YES | current_timestamp() | |
| v_publishing_items_ready_to_publish | id | int(11) | NO | 0 | |
| v_publishing_items_ready_to_publish | title | varchar(255) | NO | ||
| v_publishing_items_ready_to_publish | site_id | int(11) | NO | ||
| v_publishing_items_ready_to_publish | brand_id | int(11) | NO | ||
| v_publishing_items_ready_to_publish | wordpress_post_id | bigint(20) | YES | NULL | |
| v_publishing_items_ready_to_publish | lifecycle_status | enum('idea','queued','ai_draft','human_review','approved','wordpress_draft_created','media_ready','taxonomy_mapped','scheduled','published','archived','repurposed') | NO | 'idea' | |
| v_publishing_items_ready_to_publish | featured_image_status | enum('missing','queued','generated','approved','published') | YES | 'missing' | |
| v_publishing_items_ready_to_publish | taxonomy_mapping_status | enum('pending','mapped','failed') | YES | 'pending' | |
| v_publishing_items_ready_to_publish | primary_category | varchar(120) | YES | NULL | |
| v_publishing_operations_dashboard | metric_key | varchar(22) | NO | '' | |
| v_publishing_operations_dashboard | metric_value | bigint(21) | NO | 0 | |
| v_publishing_production_dashboard | lifecycle_status | enum('idea','queued','ai_draft','human_review','approved','wordpress_draft_created','media_ready','taxonomy_mapped','scheduled','published','archived','repurposed') | NO | 'idea' | |
| v_publishing_production_dashboard | featured_image_status | enum('missing','queued','generated','approved','published') | YES | 'missing' | |
| v_publishing_production_dashboard | taxonomy_mapping_status | enum('pending','mapped','failed') | YES | 'pending' | |
| v_publishing_production_dashboard | item_count | bigint(21) | NO | 0 | |
| v_publishing_repeated_retry_failures | scenario_key | varchar(150) | NO | ||
| v_publishing_repeated_retry_failures | publishing_item_id | int(11) | YES | NULL | |
| v_publishing_repeated_retry_failures | open_failure_count | bigint(21) | NO | 0 | |
| v_publishing_repeated_retry_failures | last_failure_at | timestamp | YES | current_timestamp() | |
| v_publishing_scheduler_activation_dashboard | scenario_key | varchar(150) | NO | ||
| v_publishing_scheduler_activation_dashboard | activation_status | enum('manual_off','scheduled_shadow','scheduled_limited','scheduled_active','paused') | NO | 'manual_off' | |
| v_publishing_scheduler_activation_dashboard | schedule_description | varchar(255) | YES | NULL | |
| v_publishing_scheduler_activation_dashboard | max_concurrent_runs | int(11) | NO | 1 | |
| v_publishing_scheduler_activation_dashboard | last_workflow_run_uuid | varchar(100) | YES | NULL | |
| v_publishing_scheduler_activation_dashboard | last_run_at | datetime | YES | NULL | |
| v_publishing_scheduler_activation_dashboard | promoted_at | datetime | YES | NULL | |
| v_publishing_scheduler_activation_dashboard | promoted_by | varchar(120) | YES | NULL | |
| v_publishing_scheduler_activation_dashboard | registered_schema_dependencies | bigint(21) | NO | 0 | |
| v_publishing_scheduler_activation_dashboard | missing_schema_dependencies | decimal(22,0) | NO | 0 | |
| v_publishing_scheduler_activation_dashboard | schema_gate_status | varchar(21) | NO | '' | |
| v_publishing_scheduler_activation_dashboard | governance_notes | text | YES | NULL | |
| v_publishing_scheduler_activation_dashboard | updated_at | timestamp | YES | current_timestamp() | |
| v_publishing_scheduler_promotion_ready | scenario_key | varchar(150) | NO | ||
| v_publishing_scheduler_promotion_ready | activation_status | enum('manual_off','scheduled_shadow','scheduled_limited','scheduled_active','paused') | NO | 'manual_off' | |
| v_publishing_scheduler_promotion_ready | registered_schema_dependencies | bigint(21) | NO | 0 | |
| v_publishing_scheduler_promotion_ready | missing_schema_dependencies | decimal(22,0) | NO | 0 | |
| v_publishing_scheduler_promotion_ready | schema_gate_status | varchar(21) | NO | '' | |
| v_publishing_scheduler_promotion_ready | promotion_readiness | varchar(30) | NO | '' | |
| v_runtime_inventory_reconciliation | source_table | varchar(29) | NO | '' | |
| v_runtime_inventory_reconciliation | record_count | bigint(21) | NO | 0 | |
| v_scenario_field_dependencies | scenario_key | varchar(150) | YES | NULL | |
| v_scenario_field_dependencies | process_name | varchar(255) | NO | ||
| v_scenario_field_dependencies | lifecycle_stage | varchar(150) | YES | NULL | |
| v_scenario_field_dependencies | usage_type | enum('read','write','read_write','trigger','validation','publishing_output','rag_input','audit','governance') | NO | ||
| v_scenario_field_dependencies | using_system | enum('make','wordpress','mariadb','openai','rag','human','system','other') | NO | ||
| v_scenario_field_dependencies | table_name | varchar(150) | NO | ||
| v_scenario_field_dependencies | field_name | varchar(150) | NO | ||
| v_scenario_field_dependencies | field_role | varchar(100) | YES | ||
| v_scenario_field_dependencies | field_purpose | text | YES | ||
| v_scenario_field_dependencies | usage_purpose | text | NO | ||
| v_scenario_field_dependencies | dependency_notes | text | YES | NULL | |
| v_scenario_field_dependencies | governance_notes | text | YES | NULL | |
| v_schema_dependency_summary | source_object_type | enum('script','view','make_scenario','artifact','dashboard') | NO | ||
| v_schema_dependency_summary | dependency_count | bigint(21) | NO | 0 | |
| v_schema_field_usage | table_name | varchar(150) | NO | ||
| v_schema_field_usage | field_name | varchar(150) | NO | ||
| v_schema_field_usage | field_role | varchar(100) | NO | ||
| v_schema_field_usage | field_purpose | text | NO | ||
| v_schema_field_usage | usage_type | enum('read','write','read_write','trigger','validation','publishing_output','rag_input','audit','governance') | YES | ||
| v_schema_field_usage | using_system | enum('make','wordpress','mariadb','openai','rag','human','system','other') | YES | ||
| v_schema_field_usage | scenario_key | varchar(150) | YES | NULL | |
| v_schema_field_usage | process_name | varchar(255) | YES | ||
| v_schema_field_usage | lifecycle_stage | varchar(150) | YES | NULL | |
| v_schema_field_usage | usage_purpose | text | YES | ||
| v_schema_unmapped_fields | table_name | varchar(150) | NO | ||
| v_schema_unmapped_fields | field_name | varchar(150) | NO | ||
| v_schema_unmapped_fields | field_role | varchar(100) | NO | ||
| v_schema_unmapped_fields | purpose | text | NO | ||
| v_schema_unmapped_fields | primary_writer | text | YES | NULL | |
| v_schema_unmapped_fields | primary_reader | text | YES | NULL |
Declared Foreign Keys
| Table | Column | References |
|---|---|---|
| artifacts | artifact_type_id | wsai_ops.artifact_types.id |
| artifacts | current_status_id | wsai_ops.artifact_statuses.id |
| artifact_dependencies | artifact_id | wsai_ops.artifacts.id |
| artifact_dependencies | depends_on_artifact_id | wsai_ops.artifacts.id |
| artifact_extraction_flags | artifact_version_id | wsai_ops.artifact_versions.id |
| artifact_files | artifact_version_id | wsai_ops.artifact_versions.id |
| artifact_files | storage_location_id | wsai_ops.artifact_storage_locations.id |
| artifact_ingestion_runs | artifact_version_id | wsai_ops.artifact_versions.id |
| artifact_packages | manifest_artifact_id | wsai_ops.artifacts.id |
| artifact_package_items | artifact_id | wsai_ops.artifacts.id |
| artifact_package_items | artifact_version_id | wsai_ops.artifact_versions.id |
| artifact_package_items | package_id | wsai_ops.artifact_packages.id |
| artifact_versions | artifact_id | wsai_ops.artifacts.id |
| brand_governance_rules | brand_id | wsai_ops.brands.id |
| content_intake_outputs | intake_item_id | wsai_ops.content_intake_items.id |
| deployment_execution_events | execution_id | wsai_ops.deployment_execution_registry.execution_id |
| deployment_execution_registry | queue_id | wsai_ops.deployment_package_queue.queue_id |
| deployment_runs | make_scenario_id | wsai_ops.make_scenarios.id |
| deployment_runs | site_id | wsai_ops.sites.id |
| domains | brand_id | wsai_ops.brands.id |
| email_aliases | email_domain_id | wsai_ops.email_domains.id |
| email_alias_destinations | email_alias_id | wsai_ops.email_aliases.id |
| email_alias_destinations | mailbox_id | wsai_ops.email_mailboxes.id |
| email_domains | brand_id | wsai_ops.brands.id |
| mailbox_alias_authorizations | email_alias_id | wsai_ops.email_aliases.id |
| mailbox_alias_authorizations | mailbox_identity_id | wsai_ops.mailbox_identities.id |
| mailbox_identity_status_history | mailbox_identity_id | wsai_ops.mailbox_identities.id |
| product_backlog_events | backlog_item_id | wsai_ops.product_backlog_items.backlog_item_id |
| product_backlog_items | product_id | wsai_ops.product_registry.product_id |
| publishing_content_assets | content_item_id | wsai_ops.publishing_content_items.id |
| publishing_rag_ingestion | content_item_id | wsai_ops.publishing_content_items.id |
| publishing_seo_governance | content_item_id | wsai_ops.publishing_content_items.id |
| publishing_social_extractions | asset_id | wsai_ops.publishing_content_assets.id |
| publishing_social_extractions | content_item_id | wsai_ops.publishing_content_items.id |
| publishing_workflow_events | content_item_id | wsai_ops.publishing_content_items.id |
| sites | brand_id | wsai_ops.brands.id |
Common Link Candidates
| Table | Column | Type |
|---|---|---|
| email_alias_mailbox_authorizations | alias_id | bigint(20) unsigned |
| v_email_alias_governance_ready | alias_id | bigint(20) unsigned |
| v_email_alias_mailbox_delivery | alias_id | bigint(20) unsigned |
| artifact_dependencies | artifact_id | int(11) |
| artifact_package_items | artifact_id | int(11) |
| artifact_versions | artifact_id | int(11) |
| artifacts | artifact_type_id | int(11) |
| artifact_extraction_flags | artifact_version_id | int(11) |
| artifact_files | artifact_version_id | int(11) |
| artifact_ingestion_runs | artifact_version_id | int(11) |
| artifact_package_items | artifact_version_id | int(11) |
| publishing_social_extractions | asset_id | int(11) |
| product_registry | authority_page_id | bigint(20) |
| v_alias_authorization_matrix | authorization_id | int(11) |
| product_backlog_events | backlog_item_id | int(11) |
| product_backlog_items | backlog_item_id | int(11) |
| brand_governance_rules | brand_id | bigint(20) unsigned |
| domains | brand_id | bigint(20) unsigned |
| email_domains | brand_id | bigint(20) unsigned |
| publishing_content_items | brand_id | int(11) |
| publishing_taxonomy_registry | brand_id | int(11) |
| sites | brand_id | bigint(20) unsigned |
| v_publishing_items_ready_to_publish | brand_id | int(11) |
| brands | brand_key | varchar(64) |
| content_intake_items | brand_key | varchar(100) |
| publishing_alert_events | content_item_id | int(11) |
| publishing_content_assets | content_item_id | int(11) |
| publishing_rag_ingestion | content_item_id | int(11) |
| publishing_seo_governance | content_item_id | int(11) |
| publishing_social_extractions | content_item_id | int(11) |
| publishing_workflow_events | content_item_id | int(11) |
| artifacts | current_status_id | int(11) |
| artifact_dependencies | depends_on_artifact_id | int(11) |
| deployment_registry | deployment_id | bigint(20) unsigned |
| v_deployment_registry_dashboard | deployment_id | bigint(20) unsigned |
| v_deployment_registry_ready_for_publication | deployment_id | bigint(20) unsigned |
| domains | domain | varchar(150) |
| email_domains | domain | varchar(150) |
| sites | domain | varchar(150) |
| v_email_domain_routing_status | domain | varchar(150) |
| v_email_mailbox_visibility | domain | varchar(150) |
| email_dmarc_report_governance | domain_name | varchar(255) |
| email_domain_routing_governance | domain_name | varchar(255) |
| v_email_alias_governance_ready | domain_name | varchar(150) |
| v_email_domain_routing_ready | domain_name | varchar(255) |
| v_email_opendmarc_readiness | domain_name | varchar(255) |
| email_alias_destinations | email_alias_id | bigint(20) unsigned |
| mailbox_alias_authorizations | email_alias_id | bigint(20) unsigned |
| v_mailbox_alias_authorization_drift | email_alias_id | bigint(20) unsigned |
| email_aliases | email_domain_id | bigint(20) unsigned |
| deployment_execution_events | event_id | bigint(20) unsigned |
| product_backlog_events | event_id | int(11) |
| deployment_execution_events | execution_id | bigint(20) unsigned |
| deployment_execution_registry | execution_id | bigint(20) unsigned |
| deployment_registry | execution_id | bigint(20) unsigned |
| v_deployment_registry_ready_for_publication | execution_id | bigint(20) unsigned |
| v_deployment_rollback_required | execution_id | bigint(20) unsigned |
| content_intake_outputs | external_id | varchar(255) |
| content_intake_outputs | intake_item_id | bigint(20) unsigned |
| artifacts | latest_version_id | int(11) |
| email_alias_destinations | mailbox_id | bigint(20) unsigned |
| email_alias_mailbox_authorizations | mailbox_id | bigint(20) unsigned |
| v_email_alias_mailbox_delivery | mailbox_id | bigint(20) unsigned |
| mailbox_alias_authorizations | mailbox_identity_id | int(11) |
| mailbox_identity_status_history | mailbox_identity_id | int(11) |
| deployment_runs | make_execution_id | varchar(150) |
| artifact_ingestion_runs | make_scenario_id | int(11) |
| deployment_runs | make_scenario_id | bigint(20) unsigned |
| artifact_packages | manifest_artifact_id | int(11) |
| artifacts | owning_brand_id | int(11) |
| artifacts | owning_site_id | int(11) |
| artifact_package_items | package_id | int(11) |
| product_backlog_items | product_id | int(11) |
| product_registry | product_id | int(11) |
| publishing_dead_letter_queue | publishing_item_id | int(11) |
| publishing_failure_events | publishing_item_id | int(11) |
| v_publishing_dead_letter_queue_open | publishing_item_id | int(11) |
| v_publishing_failure_events_open | publishing_item_id | int(11) |
| v_publishing_repeated_retry_failures | publishing_item_id | int(11) |
| deployment_execution_events | queue_id | bigint(20) unsigned |
| deployment_execution_registry | queue_id | bigint(20) unsigned |
| deployment_package_queue | queue_id | bigint(20) unsigned |
| deployment_registry | queue_id | bigint(20) unsigned |
| v_deployment_queue_next_claim | queue_id | bigint(20) unsigned |
| v_deployment_queue_ready | queue_id | bigint(20) unsigned |
| v_deployment_registry_ready_for_publication | queue_id | bigint(20) unsigned |
| v_deployment_rollback_required | queue_id | bigint(20) unsigned |
| deployment_runs | site_id | bigint(20) unsigned |
| publishing_content_items | site_id | int(11) |
| publishing_taxonomy_registry | site_id | int(11) |
| v_publishing_items_ready_to_publish | site_id | int(11) |
| publishing_dead_letter_queue | source_failure_event_id | int(11) |
| v_publishing_dead_letter_queue_open | source_failure_event_id | int(11) |
| publishing_alert_events | source_id | int(11) |
| artifact_files | storage_location_id | int(11) |
| publishing_content_assets | wordpress_media_id | bigint(20) |
| deployment_package_queue | wordpress_page_id | bigint(20) unsigned |
| deployment_registry | wordpress_page_id | bigint(20) unsigned |
| content_intake_items | wordpress_post_id | bigint(20) unsigned |
| publishing_content_items | wordpress_post_id | bigint(20) |
| publishing_failure_events | wordpress_post_id | bigint(20) |
| v_publishing_failure_events_open | wordpress_post_id | bigint(20) |
| v_publishing_items_ready_to_publish | wordpress_post_id | bigint(20) |
| sites | wp_blog_id | bigint(20) unsigned |
| operational_artifact_registry | wp_media_id | bigint(20) unsigned |
| operational_artifact_registry | wp_page_id | bigint(20) unsigned |
| operational_knowledge_base_pages | wp_page_id | bigint(20) unsigned |
| operational_knowledge_base_pages | wp_parent_id | bigint(20) unsigned |
| operational_repository_publications | wp_parent_page_id | bigint(20) unsigned |
Governance Notes
- This catalog is generated from live MariaDB information_schema metadata using local root/socket discovery.
- It does not create or alter databases, tables, or schemas.
- Declared foreign keys are database-enforced constraints only.
- Common link candidates are inferred from naming patterns and require review before being treated as authoritative relationships.