TPRDSUGESTAO

969 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
TMOVSUGESTAO.CODCOLIGADA FKTMOVSUGESTAO_TPRDSUGESTAOR
TPRDLOCINFO.CODCOLIGADA FKTPRDSUGESTAO_TPRDLOCINFOR
IDSUGESTAO DINTEGER 4 null
TMOVSUGESTAO.IDSUGESTAO FKTMOVSUGESTAO_TPRDSUGESTAOR
IDPRD int 4 null
TPRDLOCINFO.IDPRD FKTPRDSUGESTAO_TPRDLOCINFOR
IDPRDLOCINFO DINTEGER 4 null
TPRDLOCINFO.IDPRDLOCINFO FKTPRDSUGESTAO_TPRDLOCINFOR
DATASUGESTAO datetime 16,3 null
QTDSUGESTAOTEORICA RMDVALOR4 17,4 null
QTDSUGESTAOPRATICA RMDVALOR4 17,4 null
STSUGESTAO DTSTATUS 1 null
QTDSOLICITADA RMDVALOR4 17,4 √ null
DATAENTREGA datetime 16,3 √ null
DATAENTREGASOLICITADA datetime 16,3 √ null
MOTIVOREJEICAO varchar 80 √ 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)
PKTPRDSUGESTAO Primary key Asc/Asc CODCOLIGADA + IDSUGESTAO
TXPRDSUGESTAO Performance Asc/Asc/Asc/Asc IDPRD + CODCOLIGADA + IDPRDLOCINFO + STSUGESTAO

Relationships

Close relationships within degrees of separation