controle_estoque |
| categorias | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
categoria |
varchar(250) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
categorias |
0 |
PRIMARY |
1 |
id |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
| estoque | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
codigo |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
Id_produto |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
qtd_estoque |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
und |
varchar(5) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
preco |
decimal(10,0) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
id_fornecedor |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
id_categoria |
varchar(250) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
pedido_pendende |
char(1) |
utf8_general_ci |
NO |
|
S |
|
select,insert,update,references |
|
lastupdate |
timestamp |
(NULL) |
NO |
|
CURRENT_TIMESTAMP |
on update CURRENT_TIMESTAMP |
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
estoque |
0 |
PRIMARY |
1 |
id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
| fornecedores | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
nome |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
razao_social |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
cnpj |
varchar(20) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
telefone |
varchar(50) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
ativo |
char(1) |
utf8_general_ci |
NO |
|
1 |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
fornecedores |
0 |
PRIMARY |
1 |
id |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
| ordem_compras | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
pedido |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
fornecedor |
varchar(250) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
produto |
varchar(250) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
qtd_pedido |
varchar(250) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
und |
varchar(5) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
preco |
decimal(10,0) |
(NULL) |
NO |
|
(NULL) |
|
select,insert,update,references |
|
data |
datetime |
(NULL) |
NO |
|
CURRENT_TIMESTAMP |
on update CURRENT_TIMESTAMP |
select,insert,update,references |
|
ativa |
char(1) |
utf8_general_ci |
YES |
|
S |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
ordem_compras |
0 |
PRIMARY |
1 |
pedido |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
| precos | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
preco |
decimal(10,0) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
produto |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
fornecedor |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
ativo |
char(1) |
utf8_general_ci |
NO |
|
1 |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
precos |
0 |
PRIMARY |
1 |
id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
| produtos | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
nome |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
codigo |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
und |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
categoria |
varchar(250) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
fornecedor |
varchar(250) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
produtos |
0 |
PRIMARY |
1 |
id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
| saidas | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
codigo |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
Id_produto |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
qtd_estoque |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
und |
varchar(5) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
preco |
decimal(10,0) |
(NULL) |
NO |
|
0 |
|
select,insert,update,references |
|
categoria |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
tipo_saida |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
lastupdate |
timestamp |
(NULL) |
NO |
|
CURRENT_TIMESTAMP |
on update CURRENT_TIMESTAMP |
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
saidas |
0 |
PRIMARY |
1 |
id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
| Foreign Key Relationships |
| FK Id | Reference Table | Source Column | Target Column | Extra Info |
FK_saidas_tipos_saida |
tipos_saida |
`id` |
`id` |
|
Back
| setores | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) unsigned |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
nome |
varchar(50) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
setores |
0 |
PRIMARY |
1 |
id |
A |
3 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
| tipos_saida | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
nome |
varchar(250) |
utf8_general_ci |
NO |
|
0 |
|
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
tipos_saida |
0 |
PRIMARY |
1 |
id |
A |
0 |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back
| usuarios | |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
id |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
nome |
varchar(50) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
usuario |
varchar(25) |
utf8_general_ci |
NO |
UNI |
(NULL) |
|
select,insert,update,references |
|
senha |
varchar(40) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
varchar(100) |
utf8_general_ci |
NO |
|
(NULL) |
|
select,insert,update,references |
|
|
nivel |
char(1) |
utf8_general_ci |
NO |
MUL |
1 |
|
select,insert,update,references |
|
ativo |
char(1) |
utf8_general_ci |
NO |
|
1 |
|
select,insert,update,references |
|
cadastro |
timestamp |
(NULL) |
NO |
|
CURRENT_TIMESTAMP |
on update CURRENT_TIMESTAMP |
select,insert,update,references |
|
| Indexes |
| Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment | Index comment |
usuarios |
0 |
PRIMARY |
1 |
id |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
usuarios |
0 |
usuario |
1 |
usuario |
A |
2 |
(NULL) |
(NULL) |
|
BTREE |
|
|
usuarios |
1 |
nivel |
1 |
nivel |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
Back