VPLANOVAGAS

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VPLANOVAGASFUNCAO.CODCOLIGADA FKVPLANVAGASFUNCAO_VPLANOVAGASR
VPLANOVAGASLOTACAO.CODCOLIGADA FKVPLAVAGASLOTACAO_VPLANOVAGASR
VPLANOVAGASSECAO.CODCOLIGADA FKVPLANOVAGASSECAO_VPLANOVAGASR
CODPLANO varchar 16 null
VPLANOVAGASFUNCAO.CODPLANO FKVPLANVAGASFUNCAO_VPLANOVAGASR
VPLANOVAGASLOTACAO.CODPLANO FKVPLAVAGASLOTACAO_VPLANOVAGASR
VPLANOVAGASSECAO.CODPLANO FKVPLANOVAGASSECAO_VPLANOVAGASR
DESCPLANO varchar 40 √ null
DTINIVALIDADE datetime 16,3 √ null
DTFIMVALIDADE datetime 16,3 √ null
DTCRIACAO datetime 16,3 √ null
CODMEMOOBS int 4 √ null
VMEMO.ID FKVPLANOVAGAS_VMEMOR
PLANOORCAMENTARIO 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)
PKVPLANOVAGAS Primary key Asc/Asc CODCOLIGADA + CODPLANO

Relationships

Close relationships within degrees of separation