VSPAT

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VREUNIAOSPAT.CODCOLIGADA FKVREUNIAOSPAT_VSPATR
VCOMISSAO.CODCOLIGADA FKVSPAT_VCOMISSAOR
CODCOMISSAO varchar 10 null
VREUNIAOSPAT.CODCOMISSAO FKVREUNIAOSPAT_VSPATR
VCOMISSAO.CODCOMISSAO FKVSPAT_VCOMISSAOR
CODSPAT varchar 10 null
VREUNIAOSPAT.CODSPAT FKVREUNIAOSPAT_VSPATR
NOMESPAT varchar 40 √ null
DATAINICIO datetime 16,3 √ null
PFHSTGRADEREMUN.DATAINICIO Implied ConstraintR
DATATERMINO datetime 16,3 √ null
DESCRICAO MEMO 2147483647 √ 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)
PKVSPAT Primary key Asc/Asc/Asc CODCOLIGADA + CODCOMISSAO + CODSPAT

Relationships

Close relationships within degrees of separation