EDEPTO

36 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCOLIGADA.CODCOLIGADA FKEDEPTO_GCOLIGADAR
GFILIAL.CODCOLIGADA FKEDEPTO_GFILIALR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKEDEPTO_GFILIALR
CODDEPARTAMENTO varchar 25 null
NOME varchar 40 √ null
CONTATO varchar 40 √ null
LOCALIZACAO varchar 80 √ null
TELEFONE varchar 15 √ null
FAX varchar 15 √ null
RAMAL varchar 5 √ null
CHEFE varchar 80 √ null
VICECHEFE varchar 80 √ null
DTINIMANDATO datetime 16,3 √ null
DTFIMMANDATO datetime 16,3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKEDEPTO Primary key Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODDEPARTAMENTO

Relationships

Close relationships within degrees of separation