MISMASSOC

287 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MISM.CODCOLIGADA FKMISMASSOC_MISMR
IDPRJ int 4 null
MISM.IDPRJ FKMISMASSOC_MISMR
IDISM int 4 null
MISM.IDISM FKMISMASSOC_MISMR
IDISMASSOC int 4 null
MISM.IDISM FKMISMASSOC_MISMIDISMR
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)
PKMISMASSOC Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDISM + IDISMASSOC
MXISMASSOC Performance Asc IDISM
MXMISMASSOC Must be unique Asc/Asc IDISM + IDISMASSOC

Relationships

Close relationships within degrees of separation