PMOTMUDSECAO

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTSEC.CODCOLIGADA FKPFHSTSEC_PMOTMUDSECAOR
PORCAMENTOALTERACAOSECAO.CODCOLIGADA FKPORCAMENTOALTSEC_PMOTMUDSECAR
VREQTRANSFERENCIA.CODCOLREQUISICAO FKVREQTRANSFERENC_PMOTMUDSECAOR
VREQTRANSFERENCIAPARECER.CODCOLREQUISICAO FKVREQTRANSFPAREC_PMOTMUDSECAOR
VREQTRANSFLOTE.CODCOLREQUISICAO FKVREQTRANSFLOTE_PMOTMUDSECAOR
VREQTRANSFLOTEPARECER.CODCOLREQUISICAO FKVREQTRANSFLOTEPARECER_PMOTMUR
VREQTRANSFPROMOCAO.CODCOLREQUISICAO FKVREQTRANSFPROM_PMOTMUDSECAOR
VREQTRANSFPROMOCAOPARECER.CODCOLREQUISICAO FKVREQTRANSFPRPAR_PMOTMUDSECAOR
GCOLIGADA.CODCOLIGADA FKPMOTMUDSECAO_GCOLIGADAR
CODCLIENTE varchar 2 null
PFHSTSEC.MOTIVO FKPFHSTSEC_PMOTMUDSECAOR
PORCAMENTOALTERACAOSECAO.CODMOTIVO FKPORCAMENTOALTSEC_PMOTMUDSECAR
VREQTRANSFERENCIA.CODMOTMUDSECAO FKVREQTRANSFERENC_PMOTMUDSECAOR
VREQTRANSFERENCIAPARECER.CODMOTMUDSECAO FKVREQTRANSFPAREC_PMOTMUDSECAOR
VREQTRANSFLOTE.CODMOTMUDSECAO FKVREQTRANSFLOTE_PMOTMUDSECAOR
VREQTRANSFLOTEPARECER.CODMOTMUDSECAO FKVREQTRANSFLOTEPARECER_PMOTMUR
VREQTRANSFPROMOCAO.CODMOTMUDSECAO FKVREQTRANSFPROM_PMOTMUDSECAOR
VREQTRANSFPROMOCAOPARECER.CODMOTMUDSECAO FKVREQTRANSFPRPAR_PMOTMUDSECAOR
CODINTERNO varchar 2 null
PTPFINAGRI.CODINTERNO Implied ConstraintR
DESCRICAO varchar 50 √ null
PODEALTERAR smallint 2 √ 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)
PKPMOTMUDSECAO Primary key Asc/Asc CODCOLIGADA + CODCLIENTE

Relationships

Close relationships within degrees of separation