SZ0CONSUMOHOSPITALAR

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CDCOLIGADA DCODCOLIGADA 2 null
SZ0CONSUMOHOSPITALARDETALHE.CDCOLIGADA FKSZ0CONSUMOHOSPDET_SZ0CONHOSPC
SZ0ESQUEMA.CDCOLIGADA FKSZ0CONSUMOHOSP_SZ0ESQUEMAR
SZ0PERIODOCOMPETENCIA.CDCOLIGADA FKSZ0CONSUMOHOSP_SZ0PERIODOCOMR
CDFILIAL smallint 2 null
SZ0CONSUMOHOSPITALARDETALHE.CDFILIAL FKSZ0CONSUMOHOSPDET_SZ0CONHOSPC
SZ0ESQUEMA.CDFILIAL FKSZ0CONSUMOHOSP_SZ0ESQUEMAR
SZ0PERIODOCOMPETENCIA.CDFILIAL FKSZ0CONSUMOHOSP_SZ0PERIODOCOMR
CDCONSUMOHOSPITALAR numeric 12 null
SZ0CONSUMOHOSPITALARDETALHE.CDCONSUMOHOSPITALAR FKSZ0CONSUMOHOSPDET_SZ0CONHOSPC
CDPERIODOCOMPETENCIA numeric 12 null
SZ0PERIODOCOMPETENCIA.CDPERIODOCOMPETENCIA FKSZ0CONSUMOHOSP_SZ0PERIODOCOMR
CDATENDIMENTO varchar 50 null
DTATENDIMENTO DDATETIME 16,3 √ null
CDPACIENTE varchar 25 null
CDCID varchar 10 √ null
SZ0CID.CDCID Implied ConstraintR
CDESQUEMA numeric 12 √ null
SZ0ESQUEMA.CDESQUEMA FKSZ0CONSUMOHOSP_SZ0ESQUEMAR
TPLANCAMENTO varchar 1 √ null
TPATENDIMENTO varchar 50 √ null
DTALTA DDATETIME 16,3 √ 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)
PKSZ0CONSUMOHOSPITALAR Primary key Asc/Asc/Asc CDCOLIGADA + CDFILIAL + CDCONSUMOHOSPITALAR

Relationships

Close relationships within degrees of separation