SZHISTRESERVALEITO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SZLEITO.CODCOLIGADA FKSZLEITO_SZHISTRESERVALEITOR
GCOLIGADA.CODCOLIGADA FKSZHISTRESERVALEITO_GCOLIGADAR
SZLEITO.CODCOLIGADA FKSZHISTRESERVALEITO_SZLEITOR
CODRESERVA int 4 null
SZLEITO.CODRESERVA FKSZLEITO_SZHISTRESERVALEITOR
CODLEITO int 4 null
SZLEITO.CODLEITO FKSZHISTRESERVALEITO_SZLEITOR
DATAALTERACAO DDATETIME 16,3 null
ACAO varchar 1 √ ('R')
CODPACIENTE int 4 √ null
CODATENDIMENTO int 4 √ null
ECNTATENDIM.CODATENDIMENTO Implied ConstraintR
RESPALTERACAO varchar 30 √ null
MOTIVORESERVA varchar 255 √ 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)
PKSZHISTRESERVALEITO Primary key Asc/Asc CODCOLIGADA + CODRESERVA

Check Constraints

Constraint Name Constraint
CK__SZHISTRESE__ACAO__03EB3AB5 ([ACAO] = 'R' or [ACAO] = 'L' or [ACAO] = 'O' or [ACAO] is null)

Relationships

Close relationships within degrees of separation