KITEMPROGRAMACAOPOSTO

407 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
KITEMPLANOMESTRE.CODCOLIGADA FKKITEMPROGPOST_KITEMPLANOMESTR
KPOSTO.CODCOLIGADA FKKITEMPROGRAMACAOPOSTO_KPOSTOR
IDPROGRAMA DINTEGER 4 null
KITEMPLANOMESTRE.IDPROGRAMA FKKITEMPROGPOST_KITEMPLANOMESTR
IDCALCULO DINTEGER 4 null
KITEMPLANOMESTRE.IDCALCULO FKKITEMPROGPOST_KITEMPLANOMESTR
PERIODO DINTEGER 4 null
KITEMPLANOMESTRE.PERIODO FKKITEMPROGPOST_KITEMPLANOMESTR
CODESTRUTURA varchar 30 null
KITEMPLANOMESTRE.CODESTRUTURA FKKITEMPROGPOST_KITEMPLANOMESTR
CODMODELO DKCODMODELO 15 null
KITEMPLANOMESTRE.CODMODELO FKKITEMPROGPOST_KITEMPLANOMESTR
CODPOSTO varchar 25 null
KPOSTO.CODPOSTO FKKITEMPROGRAMACAOPOSTO_KPOSTOR
QTDEHORAS RMDVALOR4 17,4 null
CODFILIAL smallint 2 null
KPOSTO.CODFILIAL FKKITEMPROGRAMACAOPOSTO_KPOSTOR
KITEMPLANOMESTRE.CODFILIAL FKKITEMPROGPOST_KITEMPLANOMESTR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDITEMPMP int 4 null
KITEMPLANOMESTRE.IDITEMPMP FKKITEMPROGPOST_KITEMPLANOMESTR

Indexes

Constraint Name Type Sort Column(s)
PKKITEMPROGRAMACAOPOSTO Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + IDPROGRAMA + IDCALCULO + PERIODO + CODESTRUTURA + CODMODELO + CODPOSTO + IDITEMPMP

Relationships

Close relationships within degrees of separation