MAVA

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MAVAINDICES.CODCOLIGADA FKMAVAINDICES_MAVAR
MAVAINDICESCCUSTO.CODCOLIGADA FKMAVAINDICESCCUSTO_MAVAR
MAVAINDICESRECURSO.CODCOLIGADA FKMAVAINDICESRECURSO_MAVAR
MAVAINDICESTAREFA.CODCOLIGADA FKMAVAINDICESTAREFA_MAVAR
IDPRJ int 4 null
MAVAINDICES.IDPRJ FKMAVAINDICES_MAVAR
MAVAINDICESCCUSTO.IDPRJ FKMAVAINDICESCCUSTO_MAVAR
MAVAINDICESRECURSO.IDPRJ FKMAVAINDICESRECURSO_MAVAR
MAVAINDICESTAREFA.IDPRJ FKMAVAINDICESTAREFA_MAVAR
IDAVA int 4 null
MAVAINDICES.IDAVA FKMAVAINDICES_MAVAR
MAVAINDICESCCUSTO.IDAVA FKMAVAINDICESCCUSTO_MAVAR
MAVAINDICESRECURSO.IDAVA FKMAVAINDICESRECURSO_MAVAR
MAVAINDICESTAREFA.IDAVA FKMAVAINDICESTAREFA_MAVAR
DESCRICAO varchar 120 √ null
ATIVO int 4 ((1))
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDPDOCALCTRF int 4 √ null
IDPDOCALCCCUSTO int 4 √ null
IDPDOCALCREC int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKMAVA Primary key Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDAVA

Relationships

Close relationships within degrees of separation