Detalhes da Tabela

PARTITIONS | Database: information_schema | Conexão: Teste migração

Estrutura da Tabela

Field Type Null Key Default Extra
TABLE_CATALOG varchar(512) NO
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
PARTITION_NAME varchar(64) YES
SUBPARTITION_NAME varchar(64) YES
PARTITION_ORDINAL_POSITION bigint(21) unsigned YES
SUBPARTITION_ORDINAL_POSITION bigint(21) unsigned YES
PARTITION_METHOD varchar(18) YES
SUBPARTITION_METHOD varchar(12) YES
PARTITION_EXPRESSION longtext YES
SUBPARTITION_EXPRESSION longtext YES
PARTITION_DESCRIPTION longtext YES
TABLE_ROWS bigint(21) unsigned NO 0
AVG_ROW_LENGTH bigint(21) unsigned NO 0
DATA_LENGTH bigint(21) unsigned NO 0
MAX_DATA_LENGTH bigint(21) unsigned YES
INDEX_LENGTH bigint(21) unsigned NO 0
DATA_FREE bigint(21) unsigned NO 0
CREATE_TIME datetime YES
UPDATE_TIME datetime YES
CHECK_TIME datetime YES
CHECKSUM bigint(21) unsigned YES
PARTITION_COMMENT varchar(80) NO
NODEGROUP varchar(12) NO
TABLESPACE_NAME varchar(64) YES

Dados da Tabela (máx. 100 linhas)

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME PARTITION_ORDINAL_POSITION SUBPARTITION_ORDINAL_POSITION PARTITION_METHOD SUBPARTITION_METHOD PARTITION_EXPRESSION SUBPARTITION_EXPRESSION PARTITION_DESCRIPTION TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE CREATE_TIME UPDATE_TIME CHECK_TIME CHECKSUM PARTITION_COMMENT NODEGROUP TABLESPACE_NAME
def information_schema CHARACTER_SETS 0 384 0 16434816 0 0 2026-10-02 21:27:02
def information_schema COLLATIONS 0 231 0 16704765 0 0 2026-10-02 21:27:02
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY 0 195 0 16357770 0 0 2026-10-02 21:27:02
def information_schema COLUMNS 0 0 16384 0 0
def information_schema COLUMN_PRIVILEGES 0 2565 0 16757145 0 0 2026-10-02 21:27:02
def information_schema ENGINES 0 490 0 16574250 0 0 2026-10-02 21:27:02
def information_schema EVENTS 0 0 16384 0 0
def information_schema FILES 0 14468 0 16768412 0 0 2026-10-02 21:27:02
def information_schema GLOBAL_STATUS 0 3268 0 16755036 0 0 2026-10-02 21:27:02
def information_schema GLOBAL_VARIABLES 0 3268 0 16755036 0 0 2026-10-02 21:27:02
def information_schema KEY_COLUMN_USAGE 0 4637 0 16762755 0 0 2026-10-02 21:27:02
def information_schema OPTIMIZER_TRACE 0 0 16384 0 0
def information_schema PARAMETERS 0 0 16384 0 0
def information_schema PARTITIONS 0 0 16384 0 0
def information_schema PLUGINS 0 0 16384 0 0
def information_schema PROCESSLIST 0 0 16384 0 0
def information_schema PROFILING 0 308 0 16562084 0 0 2026-10-02 21:27:02
def information_schema REFERENTIAL_CONSTRAINTS 0 4814 0 16767162 0 0 2026-10-02 21:27:02
def information_schema ROUTINES 0 0 16384 0 0
def information_schema SCHEMATA 0 3464 0 16738048 0 0 2026-10-02 21:27:02
def information_schema SCHEMA_PRIVILEGES 0 2179 0 16736899 0 0 2026-10-02 21:27:02
def information_schema SESSION_STATUS 0 3268 0 16755036 0 0 2026-10-02 21:27:02
def information_schema SESSION_VARIABLES 0 3268 0 16755036 0 0 2026-10-02 21:27:02
def information_schema STATISTICS 0 5753 0 16752736 0 0 2026-10-02 21:27:02
def information_schema TABLES 0 9441 0 16757775 0 0 2026-10-02 21:27:02
def information_schema TABLESPACES 0 6951 0 16772763 0 0 2026-10-02 21:27:02
def information_schema TABLE_CONSTRAINTS 0 2504 0 16721712 0 0 2026-10-02 21:27:02
def information_schema TABLE_PRIVILEGES 0 2372 0 16748692 0 0 2026-10-02 21:27:02
def information_schema TRIGGERS 0 0 16384 0 0
def information_schema USER_PRIVILEGES 0 1986 0 16726092 0 0 2026-10-02 21:27:02
def information_schema VIEWS 0 0 16384 0 0
def information_schema INNODB_LOCKS 0 31244 0 16746784 0 0 2026-10-02 21:27:02
def information_schema INNODB_TRX 0 4536 0 16746912 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_DATAFILES 0 12007 0 16773779 0 0 2026-10-02 21:27:02
def information_schema INNODB_FT_CONFIG 0 1163 0 16705332 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_VIRTUAL 0 17 0 11883850 0 0 2026-10-02 21:27:02
def information_schema INNODB_CMP 0 25 0 13107200 0 0 2026-10-02 21:27:02
def information_schema INNODB_FT_BEING_DELETED 0 9 0 9437184 0 0 2026-10-02 21:27:02
def information_schema INNODB_CMP_RESET 0 25 0 13107200 0 0 2026-10-02 21:27:02
def information_schema INNODB_CMP_PER_INDEX 0 1755 0 16728660 0 0 2026-10-02 21:27:02
def information_schema INNODB_CMPMEM_RESET 0 29 0 15204352 0 0 2026-10-02 21:27:02
def information_schema INNODB_FT_DELETED 0 9 0 9437184 0 0 2026-10-02 21:27:02
def information_schema INNODB_BUFFER_PAGE_LRU 0 6669 0 16765866 0 0 2026-10-02 21:27:02
def information_schema INNODB_LOCK_WAITS 0 599 0 16749238 0 0 2026-10-02 21:27:02
def information_schema INNODB_TEMP_TABLE_INFO 0 1011 0 16694643 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_INDEXES 0 618 0 16615548 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_TABLES 0 2091 0 16736364 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_FIELDS 0 594 0 16609428 0 0 2026-10-02 21:27:02
def information_schema INNODB_CMP_PER_INDEX_RESET 0 1755 0 16728660 0 0 2026-10-02 21:27:02
def information_schema INNODB_BUFFER_PAGE 0 6852 0 16766844 0 0 2026-10-02 21:27:02
def information_schema INNODB_FT_DEFAULT_STOPWORD 0 56 0 14680064 0 0 2026-10-02 21:27:02
def information_schema INNODB_FT_INDEX_TABLE 0 1054 0 16744898 0 0 2026-10-02 21:27:02
def information_schema INNODB_FT_INDEX_CACHE 0 1054 0 16744898 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_TABLESPACES 0 2133 0 16752582 0 0 2026-10-02 21:27:02
def information_schema INNODB_METRICS 0 2994 0 16742448 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_FOREIGN_COLS 0 1748 0 16738848 0 0 2026-10-02 21:27:02
def information_schema INNODB_CMPMEM 0 29 0 15204352 0 0 2026-10-02 21:27:02
def information_schema INNODB_BUFFER_POOL_STATS 0 257 0 16332350 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_COLUMNS 0 610 0 16613350 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_FOREIGN 0 1752 0 16700064 0 0 2026-10-02 21:27:02
def information_schema INNODB_SYS_TABLESTATS 0 1215 0 16763355 0 0 2026-10-02 21:27:02
def devprojetos_emissor admin_backup 0 0 16384 0 0 2026-08-15 09:36:28
def devprojetos_emissor agenda 687 190 131072 49152 0 2026-08-15 09:36:28
def devprojetos_emissor agenda_clientes 0 0 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor agenda_nome 9 1820 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor ajuda 0 0 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor ajuda_artigos 7 2340 16384 32768 0 2026-08-15 09:36:28
def devprojetos_emissor anexos 0 0 16384 16384 0 2026-08-15 09:37:03
def devprojetos_emissor armazem_estoque 0 0 16384 32768 0 2026-08-15 09:36:29
def devprojetos_emissor armazem_movimentacoes 0 0 16384 16384 0 2026-08-15 09:36:29
def devprojetos_emissor armazens 2 8192 16384 16384 0 2026-08-15 09:36:29
def devprojetos_emissor asaas_cobrancas 0 0 16384 81920 0 2026-08-15 09:36:29
def devprojetos_emissor assinaturas 0 0 16384 49152 0 2026-08-15 09:36:30
def devprojetos_emissor ativos 2 8192 16384 98304 0 2026-08-15 09:36:30
def devprojetos_emissor ativos_auditoria 0 0 16384 49152 0 2026-08-15 09:36:30
def devprojetos_emissor ativos_backup 0 0 16384 16384 0 2026-08-15 09:36:30
def devprojetos_emissor atualizacao 0 0 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor atualizacao_pendente 0 0 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor atualizacao_pendente_item 0 0 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor backup_historico 0 0 16384 32768 0 2026-08-15 09:36:30
def devprojetos_emissor bancos 106 154 16384 32768 0 2026-08-15 09:36:30
def devprojetos_emissor boletos 0 0 16384 65536 0 2026-08-15 09:36:31
def devprojetos_emissor cache_cnpj 0 0 16384 49152 0 2026-08-15 09:36:31
def devprojetos_emissor caixa_conta 9 1820 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor caixa_fluxo 39 420 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor caixa_fluxo_categoria 0 0 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor caixa_fluxo_movimento 36 455 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor caixa_fluxo_tipo 6 2730 16384 0 0 2026-08-15 09:51:33
def devprojetos_emissor carnes 0 0 0 281474976710655 1024 0 2026-08-15 09:51:33 2026-08-15 09:51:33
def devprojetos_emissor carnes_config 0 0 0 281474976710655 1024 0 2026-08-15 09:51:33 2026-08-15 09:51:33
def devprojetos_emissor carnes_financeiro 0 0 0 281474976710655 1024 0 2026-08-15 09:51:33 2026-08-15 09:51:33
def devprojetos_emissor cartao_etiquetas 0 0 16384 16384 0 2026-08-15 09:37:03
def devprojetos_emissor cartas_correcao 0 0 16384 32768 0 2026-08-15 09:36:31
def devprojetos_emissor cartoes 0 0 16384 16384 0 2026-08-15 09:37:04
def devprojetos_emissor categorias 5 3276 16384 16384 0 2026-08-15 09:36:31
def devprojetos_emissor centro_custos 24 682 16384 32768 0 2026-08-15 09:36:32
def devprojetos_emissor certificados_digitais 0 0 16384 49152 0 2026-08-15 09:36:32
def devprojetos_emissor certificados_historico 14 1170 16384 16384 0 2026-08-15 09:36:32
def devprojetos_emissor cest_ncm 798 184 147456 65536 0 2026-08-15 09:36:32
def devprojetos_emissor chamados 0 0 16384 49152 0 2026-08-15 09:36:32
Voltar para Tabelas Voltar para Bases