nfephp |
| emitente | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
Id_emit |
int(10) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
Id sequencial do emitente |
Razao_Social |
text |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Razao Social do emintente |
Fantasia |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
Fantasia do Emitente |
Cnpj |
int(14) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Cnpj Do eminten 14 posicoes |
IE |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
Ie do emitente |
Cnae_Fiscal |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
Descobrir oq é |
IM |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
Inscrica Municial emitente |
Ie_St |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
Inscricao Estatdual Subt tributario |
Logaduro |
text |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Endereco do emitente |
Numero_logaduro |
text |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
NUmero do endereco |
Complemnte |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
complemento do endereco |
Bairro |
text |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Bairro |
Cep |
int(8) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Cep |
Cod_Pais |
int(5) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Codigo Do Pais do Emitente referencia tabela Pais |
UF |
int(5) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Codigo Da UF Refenreica tabela UF |
Municipio |
int(5) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Codigo Do Municipio referencia tabela municipio |
Telefone |
text |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Telefone do emintente |
logo |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
Caminho ate o logo do eminte |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
emitente |
0 |
PRIMARY |
1 |
Id_emit |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| estado | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id_uf |
int(5) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
Codigo Sequencial da uf |
desc_uf |
text |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Nome do estado |
sigla_uf |
varchar(2) |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Sigla do estado |
id_pais |
int(5) |
(NULL) |
NO |
MUL |
(NULL) |
|
select,insert,update,references |
Referencia tabela Pais |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
estado |
0 |
PRIMARY |
1 |
id_uf |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
estado |
1 |
id_pais |
1 |
id_pais |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| Foreign Key Relationships |
| FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_estado |
pais |
`id_pais` |
`id_pais` |
|
Back
| municipio | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id_municipio |
int(5) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
Sequencial ID dos municipio |
id_uf |
int(5) |
(NULL) |
NO |
MUL |
(NULL) |
|
select,insert,update,references |
Codigo da Uf qual pertence a cidade |
desc_municipo |
text |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Nome do Municipio |
codigo_ibge |
int(7) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Codigo Ibge do muncipio |
id_pais |
int(5) |
(NULL) |
NO |
MUL |
(NULL) |
|
select,insert,update,references |
refencia tabela pais |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
municipio |
0 |
PRIMARY |
1 |
id_municipio |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
municipio |
1 |
id_uf |
1 |
id_uf |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
municipio |
1 |
id_pais |
1 |
id_pais |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| Foreign Key Relationships |
| FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_municipio |
estado |
`id_uf` |
`id_uf` |
|
Back
| nfes | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
|
select,insert,update,references |
Id da Tabela |
nfe_id |
varchar(44) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Identificação da NFe |
nfe_numnf |
int(11) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Numero da NF |
nfe_ent_format |
varchar(3) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Formato na entrada TXT ou XML |
nfe_ent_time |
datetime |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Data e Hora da Leitura |
nfe_sign_time |
datetime |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Data e Hora da Assinatura Digital |
nfe_intval_status |
tinyint(4) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Statusda Validação Interna 0-Falha 1-OK |
nfe_lote |
int(11) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Numero do lote de envio |
nfe_lote_time |
datetime |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Data e hora da ciração do lote de envio |
nfe_SEFAZ_envtime |
datetime |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
DAta e hora do envio ao SEFAZ |
nfe_sefaz_retstatus |
tinyint(4) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Status da NFe no SEFAZ |
nfe_sefaz_rettime |
datetime |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Data e hora do retorno do SEFAZ |
nfe_sefaz_protocol |
varchar(44) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Numero do protocolo de aceitação do SEFAZ |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
nfes |
0 |
PRIMARY |
1 |
id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| pais | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id_pais |
int(5) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
Id sequencial codigo do pais |
desc_pais |
text |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Nome do pais |
codigo_pais |
int(10) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Codigo Pais Ibge |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
pais |
0 |
PRIMARY |
1 |
id_pais |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back
| paramentro | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id_paramentro |
int(5) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
Sequencial |
id_usuario |
int(5) |
(NULL) |
NO |
MUL |
(NULL) |
|
select,insert,update,references |
Codigo Usuario |
autorizacao |
tinyint(1) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
Permite Emissao de nota |
cancela |
tinyint(1) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
Permite Cancelar nota |
certificado |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
Path Pro certificado |
ativa_cups |
tinyint(1) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
Se vai usar ou nao cups |
impressora_cups |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
Qual Impressora vai usar |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
paramentro |
0 |
PRIMARY |
1 |
id_paramentro |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
paramentro |
1 |
id_usuario |
1 |
id_usuario |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
| Foreign Key Relationships |
| FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_paramentro |
usuario |
`id_usuario` |
`id_usuario` |
|
Back
| usuario | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id_usuario |
int(5) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
Codigo Squencial Usuario |
Nome |
text |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Nome do Usuario |
login |
varchar(10) |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Login de Acesso |
senha |
varchar(10) |
latin1_swedish_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
Senha de Acesso |
situacao |
int(1) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
Situacao Logado Desconectado Bloqueado |
emitente |
text |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
Emitentes a qual o usuario esta autorizado a emitir nfe |
data_cad |
datetime |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
Data Cadastro Usuario |
ultimo_acesso |
datetime |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
Data do ultimo acesso |
ultimo_ip |
varchar(16) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
Ip do ultimo acesso |
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
usuario |
0 |
PRIMARY |
1 |
id_usuario |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
Back