Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CODCOLIGADA | DCODCOLIGADA | 2 | null |
|
|
|||||
| IDAPAC | int | 4 | null |
|
|
|||||
| SEQAPAC | int | 4 | null |
|
|
|||||
| DTAVALIACAO | DDATETIME | 16,3 | √ | null |
|
|
||||
| PESO | int | 4 | √ | null |
|
|
||||
| IMCPRIVEZ | int | 4 | √ | null |
|
|
||||
| DTPRIVEZ | DDATETIME | 16,3 | √ | null |
|
|
||||
| NUTRICIONISTA | char | 1 | √ | null |
|
|
||||
| PSIQUIATRA | char | 1 | √ | null |
|
|
||||
| CIRGERAL | char | 1 | √ | null |
|
|
||||
| PSICOLOGO | char | 1 | √ | null |
|
|
||||
| ENDOCRINO | char | 1 | √ | null |
|
|
||||
| CLINICO | char | 1 | √ | null |
|
|
||||
| CIRAPDIGESTIVO | char | 1 | √ | null |
|
|
||||
| REUNIOES | char | 1 | √ | null |
|
|
||||
| AVRISCOCIRURGICO | char | 1 | √ | null |
|
|
||||
| EXAMLAB | char | 1 | √ | null |
|
|
||||
| PERDA | char | 1 | √ | null |
|
|
||||
| ESOFAG | char | 1 | √ | null |
|
|
||||
| ULTRASOMABDOMEN | char | 1 | √ | null |
|
|
||||
| ECOTRASTORACICA | char | 1 | √ | null |
|
|
||||
| ULTRADOPLLERCOLOR | char | 1 | √ | null |
|
|
||||
| ESPIROMETRIA | char | 1 | √ | null |
|
|
||||
| APTO | char | 1 | √ | 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) |
|---|---|---|---|
| PKSZAPACPREBARI | Primary key | Asc/Asc/Asc | CODCOLIGADA + IDAPAC + SEQAPAC |
Relationships
Close relationships within degrees of separation
