MREVFORMULAPT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MCNTPT.CODCOLIGADA FKMCNTPT_MREVFORMULAPTR
MREVADIANTAMENTOPT.CODCOLIGADA FKMREVADIANTAMENPT_MREVFORMULAR
MREVFORMULAPT.CODCOLIGADA FKMREVFORMUPT_MREVFORMULAPTPAIR
MREVITEMFORMULAPT.CODCOLIGADA FKMREVITEMFORMPT_MREVFORMULAPTR
MREVMEDICAOPT.CODCOLIGADA FKMREVMEDICAOPT_MREVFORMULAPTR
MREVFORMULAPT.CODCOLIGADA FKMREVFORMUPT_MREVFORMULAPTPAIR
MPRJ.CODCOLIGADA FKMREVFORMULAPT_MPRJR
IDPRJ int 4 null
MCNTPT.IDPRJFORMULAREVISAO FKMCNTPT_MREVFORMULAPTR
MREVADIANTAMENTOPT.IDPRJFORMULA FKMREVADIANTAMENPT_MREVFORMULAR
MREVFORMULAPT.IDPRJFORMULAPAI FKMREVFORMUPT_MREVFORMULAPTPAIR
MREVITEMFORMULAPT.IDPRJ FKMREVITEMFORMPT_MREVFORMULAPTR
MREVMEDICAOPT.IDPRJFORMULA FKMREVMEDICAOPT_MREVFORMULAPTR
MPRJ.IDPRJ FKMREVFORMULAPT_MPRJR
CODFORMULA varchar 10 null
MCNTPT.CODFORMULAREVISAO FKMCNTPT_MREVFORMULAPTR
MREVADIANTAMENTOPT.CODFORMULA FKMREVADIANTAMENPT_MREVFORMULAR
MREVFORMULAPT.CODFORMULAPAI FKMREVFORMUPT_MREVFORMULAPTPAIR
MREVITEMFORMULAPT.CODFORMULA FKMREVITEMFORMPT_MREVFORMULAPTR
MREVMEDICAOPT.CODFORMULA FKMREVMEDICAOPT_MREVFORMULAPTR
NOMEFORMULA varchar 60 √ null
DESCRICAO varchar 255 √ null
IDPRJFORMULAPAI int 4 √ null
MREVFORMULAPT.IDPRJ FKMREVFORMUPT_MREVFORMULAPTPAIR
CODFORMULAPAI varchar 10 √ null
MREVFORMULAPT.CODFORMULA FKMREVFORMUPT_MREVFORMULAPTPAIR
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)
PKMREVFORMULAPT Primary key Asc/Asc/Asc CODCOLIGADA + IDPRJ + CODFORMULA

Relationships

Close relationships within degrees of separation