ECNTMTESC

87 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ECURPERLET.CODCOLIGADA FKECNTMTESC_ECURPERLETR
CODFILIAL smallint 2 null
ECURPERLET.CODFILIAL FKECNTMTESC_ECURPERLETR
CODPERLET varchar 6 null
ECURPERLET.CODPERLET FKECNTMTESC_ECURPERLETR
CODCUR int 4 null
ECURPERLET.CODCUR FKECNTMTESC_ECURPERLETR
CODPER int 4 null
ECURPERLET.CODPER FKECNTMTESC_ECURPERLETR
CODTUN int 4 null
ECURPERLET.CODTUN FKECNTMTESC_ECURPERLETR
CODKIT varchar 6 null
EKITMATES.CODKIT FKECNTMTESC_EKITMATESR
PLANO varchar 1 √ null
CONTRATOASS varchar 1 √ null
STATUSSEC varchar 1 √ null
LANCDEB varchar 1 √ null
UNICOPERLET varchar 1 √ null
ORDEM smallint 2 √ null
TOLERANCIAMES varchar 1 √ null
DIASTOLERANCIA int 4 √ 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)
PKECNTMTESC Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODPERLET + CODCUR + CODPER + CODTUN + CODKIT
INDKIT Performance Asc CODKIT

Relationships

Close relationships within degrees of separation