SZSOROCOMPONENTE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SZITEMPRESCRICAO.CODCOLIGADA FKSZSOROCOMPONENTE_SZITEMPRESR
SZPRD.CODCOLIGADA FKSZSOROCOMPONENTE_SZPRDR
SZUNDAPRESENTACAO.CODCOLIGADA FKSZSOROCOMPONENTE_SZUNDAPRESR
CODPRESCRICAO int 4 null
SZITEMPRESCRICAO.CODPRESCRICAO FKSZSOROCOMPONENTE_SZITEMPRESR
SEQUENCIAL int 4 null
SZITEMPRESCRICAO.SEQUENCIAL FKSZSOROCOMPONENTE_SZITEMPRESR
CODSOROCOMPONENTE int 4 null
IDPRD int 4 null
SZPRD.IDPRD FKSZSOROCOMPONENTE_SZPRDR
CODAPRESENTACAO int 4 null
SZUNDAPRESENTACAO.IDUNDAPR FKSZSOROCOMPONENTE_SZUNDAPRESR
QUANTIDADE RMDVALOR4 17,4 null
CODUND varchar 5 null
TUND.CODUND FKSZSOROCOMPONENTE_TUNDR
TIPO int 4 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
STATUS char 1 √ null
DESCRICAO varchar 300 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSZSOROCOMPONENTE Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODPRESCRICAO + SEQUENCIAL + CODSOROCOMPONENTE

Relationships

Close relationships within degrees of separation