Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CODCOLIGADA | DCODCOLIGADA | 2 | null |
|
|
|||
SEQ | int | 4 | null |
|
|
|||
CODESPECIALIDADE | char | 2 | null |
|
|
|||
CODGRUPOITENS | char | 2 | null |
|
|
|||
CODITEM | char | 4 | null |
|
|
|||
CODTABELA | char | 2 | null |
|
|
|||
DESCITEM | varchar | 255 | √ | null |
|
|
||
FATORITEM | varchar | 5 | √ | null |
|
|
||
CODPORTEANESTESICO | char | 1 | √ | null |
|
|
||
CHCUSTOOPERACIONAL | RMDVALOR4 | 17,4 | √ | null |
|
|
||
CHHONORARIOMEDICO | RMDVALOR4 | 17,4 | √ | null |
|
|
||
QTDETOTALCH | RMDVALOR4 | 17,4 | √ | null |
|
|
||
VALORTABELA | RMDVALOR4 | 17,4 | √ | null |
|
|
||
CODPROPRIO | varchar | 15 | √ | null |
|
|
||
PORTECBHPM | varchar | 3 | √ | null |
|
|
||
FATORCBHPM | RMDVALOR2 | 17,2 | √ | null |
|
|
||
VRCUSTOOPERACIONAL | RMDVALOR4 | 17,4 | √ | null |
|
|
||
VRHONORARIO | RMDVALOR4 | 17,4 | √ | null |
|
|
||
TIPO | varchar | 1 | null |
|
|
|||
DATAALTERACAO | DDATETIME | 16,3 | null |
|
|
|||
CODUSUARIO | varchar | 20 | null |
|
|
|||
RECCREATEDBY | varchar | 50 | √ | null |
|
|
||
RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||
RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||
RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
||
QTDEPERMANENCIA | smallint | 2 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PKSZTABPROCSERVLOG | Primary key | Asc/Asc | CODCOLIGADA + SEQ |
Diagram producer might be missing
No diagrams were produced please see application output for any errors