MRSC

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MRSCREUNIAORSC.CODCOLIGADA FKMRSCREUNIAORSC_MRSCR
MRSCTAREFA.CODCOLIGADA FKMRSCTAREFA_MRSCR
MPRJ.CODCOLIGADA FKMRSC_MPRJR
MRSCMATRIZIMPPROB.CODCOLIGADA FKMRSC_MRSCMATRIZIMPPROBR
IDPRJ int 4 null
MRSCREUNIAORSC.IDPRJ FKMRSCREUNIAORSC_MRSCR
MRSCTAREFA.IDPRJ FKMRSCTAREFA_MRSCR
MRSCMATRIZIMPPROB.IDPRJ FKMRSC_MRSCMATRIZIMPPROBR
MPRJ.IDPRJ FKMRSC_MPRJR
IDRSC int 4 null
MRSCREUNIAORSC.IDRSC FKMRSCREUNIAORSC_MRSCR
MRSCTAREFA.IDRSC FKMRSCTAREFA_MRSCR
CODRSC varchar 20 null
DESCRICAO varchar 90 √ null
TIPO int 4 null
STATUS int 4 null
DATAIDENTIFICACAO DDATETIME 16,3 √ null
IDRESPIDENTIFICACAO int 4 √ null
IDRESPACOMPANHAMENTO int 4 √ null
INDICEIMPORTANCIA numeric 23,8 √ null
CONTEXTO MEMO 2147483647 √ null
IDCATEAR int 4 √ null
MRSCEAR.IDCATEAR FKMRSC_MRSCEARR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDMATRIZ int 4 √ null
MRSCMATRIZIMPPROB.IDMATRIZ FKMRSC_MRSCMATRIZIMPPROBR
IDEQUIPEACOMP int 4 √ null
IDEQUIPEIDENT int 4 √ null
VME numeric 23,4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKMRSC Primary key Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDRSC
UQMRSCCODRSC Must be unique Asc/Asc/Asc CODCOLIGADA + IDPRJ + CODRSC

Relationships

Close relationships within degrees of separation