PCODEMPRT

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFEMPRT.CODCOLIGADA FKPFEMPRT_PCODEMPRTR
PGRPLANC.CODCOLIGADA FKPGRPLANC_PCODEMPRTR
PPARAM.CODCOLIGADA FKPPARAM_PCODEMPRTR
GCOLIGADA.CODCOLIGADA FKPCODEMPRT_GCOLIGADAR
CODCLIENTE varchar 10 null
PFEMPRT.TIPOEMPRESTIMO FKPFEMPRT_PCODEMPRTR
PGRPLANC.TIPOEMPRESTIMO FKPGRPLANC_PCODEMPRTR
PPARAM.TIPOEMPRESTIMOFERIAS FKPPARAM_PCODEMPRTR
CODINTERNO varchar 10 null
XMOTIVO.CODINTERNO Implied ConstraintR
DESCRICAO varchar 50 √ null
PODEALTERAR smallint 2 √ null
CONSIGNADO smallint 2 (0)
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)
PKPCODEMPRT Primary key Asc/Asc CODCOLIGADA + CODCLIENTE

Relationships

Close relationships within degrees of separation