DPERPRJ

73 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DPERIODO.CODCOLIGADA FKDPERPRJ_DPERIODOR
MPRJ.CODCOLIGADA FKDPERPRJ_MPRJR
IDPER int 4 null
DPERIODO.IDPER FKDPERPRJ_DPERIODOR
IDPRJ int 4 √ null
MPRJ.IDPRJ FKDPERPRJ_MPRJR
SALDOTRBATUAL RMDVALOR4 17,4 √ null
SALDOTRBANT RMDVALOR4 17,4 √ null
VLRTOTALDEDUCOES RMDVALOR4 17,4 √ null
VLRDEDUCAOMATERIAL RMDVALOR4 17,4 √ null
VLRDEDUCAOSUBEMP RMDVALOR4 17,4 √ null
VLRDEDUCAOSOBRAMAT RMDVALOR4 17,4 √ null
VLRTOTALSAIDAS RMDVALOR4 17,4 √ null
CODSERVICO varchar 15 √ null
IDPERPRJ int 4 null
SALDOANTMATERIAIS RMDVALOR4 17,4 √ null
SALDOANTSUBEMPREITADA RMDVALOR4 17,4 √ null
SALDOMATERIAIS RMDVALOR4 17,4 √ null
SALDOSUBEMPREITADA 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)
PKDPERPRJ Primary key Asc/Asc CODCOLIGADA + IDPERPRJ
DXPRJSERV Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + IDPER + IDPRJ + CODSERVICO

Relationships

Close relationships within degrees of separation