MDISCIPLINA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MDISCIPLINAUSR.CODCOLIGADA FKMDISCIPLINAUSR_MDISCIPLINAR
MPLANEXECUTIVA.CODCOLIGADA FKMPLANEXECUTIVA_MDISCIPLINAR
MTAREFA.CODCOLIGADA FKMTAREFA_MDISCIPLINAR
GCOLIGADA.CODCOLIGADA FKMDISCIPLINA_GCOLIGADAR
MPRJ.CODCOLIGADA FKMDISCIPLINA_MPRJR
IDPRJ int 4 null
MDISCIPLINAUSR.IDPRJ FKMDISCIPLINAUSR_MDISCIPLINAR
MPLANEXECUTIVA.IDPRJ FKMPLANEXECUTIVA_MDISCIPLINAR
MTAREFA.IDPRJ FKMTAREFA_MDISCIPLINAR
MPRJ.IDPRJ FKMDISCIPLINA_MPRJR
IDDISCIPLINA int 4 null
MDISCIPLINAUSR.IDDISCIPLINA FKMDISCIPLINAUSR_MDISCIPLINAR
MPLANEXECUTIVA.IDDISCIPLINA FKMPLANEXECUTIVA_MDISCIPLINAR
MTAREFA.IDDISCIPLINA FKMTAREFA_MDISCIPLINAR
CODIGO varchar 15 null
DESCRICAO varchar 60 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)
PKMDISCIPLINA Primary key Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDDISCIPLINA
MXMDISCIPLINA Must be unique Asc/Asc/Asc CODCOLIGADA + IDPRJ + CODIGO

Relationships

Close relationships within degrees of separation