MLOCALSERVICO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MPLANEXECUTIVA.CODCOLIGADA FKMPLANEXECUTIVA_MLOCALSERVICOR
MTAREFA.CODCOLIGADA FKMTAREFA_MLOCALSERVICOR
MUNIDADESERVICO.CODCOLIGADA FKMLOCALSERVICO_MUNDSERVR
GCOLIGADA.CODCOLIGADA FKMLOCALSERVICO_GCOLIGR
MPRJ.CODCOLIGADA FKMLOCALSERVICO_MPRJR
IDPRJ int 4 null
MPLANEXECUTIVA.IDPRJ FKMPLANEXECUTIVA_MLOCALSERVICOR
MTAREFA.IDPRJ FKMTAREFA_MLOCALSERVICOR
MUNIDADESERVICO.IDPRJ FKMLOCALSERVICO_MUNDSERVR
MPRJ.IDPRJ FKMLOCALSERVICO_MPRJR
IDLOCALSERVICO int 4 null
MPLANEXECUTIVA.IDLOCALSERVICO FKMPLANEXECUTIVA_MLOCALSERVICOR
MTAREFA.IDLOCALSERVICO FKMTAREFA_MLOCALSERVICOR
IDUNIDADESERVICO int 4 null
MUNIDADESERVICO.IDUNIDADESERVICO FKMLOCALSERVICO_MUNDSERVR
CODIGO varchar 20 null
DESCRICAO varchar 100 null
ATIVO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null

Indexes

Constraint Name Type Sort Column(s)
PKMLOCALSERVICO Primary key Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDLOCALSERVICO
MXLOCSERVCODIGO Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDUNIDADESERVICO + CODIGO

Relationships

Close relationships within degrees of separation