SZSUSBPAPROD

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SEQBPAPROD int 4 null
CODCOLIGADA DCODCOLIGADA 2 null
SZSUSBPAESPECIALIDADES.CODCOLIGADA FKSZSUSBPAPROD_SZSUSBPAESPECIAR
varchar 9 null
PADV varchar 1 √ null
CODESPECIALIDADE smallint 2 √ null
SZSUSBPAESPECIALIDADES.CODESPECIALIDADE FKSZSUSBPAPROD_SZSUSBPAESPECIAR
CODTIPOATEND smallint 2 √ null
CODGRUPOATEND smallint 2 √ null
CODFAIXA smallint 2 √ null
QTDEPROD smallint 2 null
VALORPROD RMDVALOR2 17,2 √ null
COMPETENCIA datetime 16,3 √ null
FOLHA smallint 2 √ null
DATAGRAVACAO datetime 16,3 √ null
NOMERESPGRAVACAO varchar 30 √ null
SEQFOLHA smallint 2 √ null
CBO varchar 6 √ null
CID varchar 4 √ null
CARACTERATEND varchar 2 √ null
NUMAUTORIZACAO varchar 13 √ 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)
PKSZSUSBPAPROD Primary key Asc/Asc SEQBPAPROD + CODCOLIGADA
SZXSUSBPAPROD Performance Asc/Asc/Asc CODCOLIGADA + PADV + PAID

Relationships

Close relationships within degrees of separation