MTRFMEDPRD

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MTRFMED.CODCOLIGADA FKMTRFMEDPRD_MTRFMEDR
IDPRJ int 4 null
MTRFMED.IDPRJ FKMTRFMEDPRD_MTRFMEDR
PERIODOMED varchar 10 null
MTRFMED.PERIODOMED FKMTRFMEDPRD_MTRFMEDR
PERIODOCLASSIFICACAO smallint 2 null
MTRFMED.PERIODOCLASSIFICACAO FKMTRFMEDPRD_MTRFMEDR
IDITMCNT int 4 null
MTRFMED.IDITMCNT FKMTRFMEDPRD_MTRFMEDR
IDPRD int 4 null
TPRODUTO.IDPRD FKMTRFMEDPRD_TPRDR
VALOR decimal 23,4 √ null
QUANTIDADE RMDVALOR4 17,4 √ 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)
PKMTRFMEDPRD Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPRJ + PERIODOMED + PERIODOCLASSIFICACAO + IDITMCNT + IDPRD

Relationships

Close relationships within degrees of separation