SZPEPENFLANCAMENTOLOG

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
IDPEPENFLANC int 4 null
SEQLOG int 4 null
OPERACAO varchar 1 null
MOTIVO MEMO 2147483647 √ null
CODPACIENTE int 4 null
CODATENDIMENTO int 4 null
ECNTATENDIM.CODATENDIMENTO Implied ConstraintR
IDITEMENF int 4 null
DTLANC DDATETIME 16,3 null
DTINI DDATETIME 16,3 √ null
DTFIM DDATETIME 16,3 √ null
QTD RMDVALOR2 17,2 null
CODUSUARIO varchar 20 null
OBS MEMO 2147483647 √ null
SEQINFCIRURGIA int 4 √ null
IDASSDIG int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATAHORARIO DDATETIME 16,3 √ null
UND varchar 5 √ null
VALIDADE DDATETIME 16,3 √ null
LOTE varchar 50 √ null
LOCAL varchar 100 √ null
FABRICANTE varchar 100 √ null
IDPRD int 4 √ null
TPRODUTO.IDPRD Implied ConstraintR
CODVERSAOCID int 4 √ null
SZVERSAOCID.CODVERSAOCID Implied ConstraintR
CODCID varchar 6 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSZPEPENFLANCAMENTOLOG Primary key Asc/Asc/Asc CODCOLIGADA + IDPEPENFLANC + SEQLOG

Relationships

Close relationships within degrees of separation