| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| IDCAD (Primary) | int(11) | No | ||
| DTCADASTRO | char(10) | No | ||
| NOME | varchar(30) | No | ||
| FUNCAO | varchar(20) | No | ||
| IDCHAVE | char(36) | No | ||
| CHAVE | char(55) | No | ||
| MODELO | varchar(20) | Yes | NULL | |
| SERVTAG | varchar(10) | Yes | NULL | |
| AREA | enum('INTERNA', 'EXTERNA') | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | IDCAD | 17 | A | No | |
| IDCHAVE | BTREE | Yes | No | IDCHAVE | 17 | A | No | |
| CHAVE | BTREE | Yes | No | CHAVE | 17 | A | No |