SZSUSHEMOAPAC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
NUMEROCONTA varchar 14 null
SEQUENCIALCONTA int 4 null
SEQAPAC int 4 null
DATAINIAPAC datetime 16,3 √ null
DATAINITRAT datetime 16,3 √ null
CIDPRINCIPAL varchar 4 √ null
CIDSECUNDARIO varchar 4 √ null
INDTRANSPLANTE varchar 1 √ null
INSCTRANSPLANTE varchar 1 √ null
DATAINSC datetime 16,3 √ null
TRANSPREALIZ int 4 √ null
DATATRANSP1 datetime 16,3 √ null
DATATRANSP2 datetime 16,3 √ null
DATATRANSP3 datetime 16,3 √ null
CREATININA RMDVALOR2 17,2 √ null
UREIAPRE RMDVALOR2 17,2 √ null
UREIAPOS RMDVALOR2 17,2 √ null
HEPC varchar 1 √ null
HBSAG varchar 1 √ null
HIV varchar 1 √ null
HLA varchar 1 √ null
DIAGINICIAL MEMO 2147483647 √ null
LAUDOPSSC MEMO 2147483647 √ null
LAUDOPRPD MEMO 2147483647 √ 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)
PKSZSUSHEMOAPAC Primary key Asc/Asc/Asc/Asc CODCOLIGADA + NUMEROCONTA + SEQUENCIALCONTA + SEQAPAC

Check Constraints

Constraint Name Constraint
CK__SZSUSHEMOAPAC__503D80CA ([HBSAG] = 'P' or [HBSAG] = 'N')
CK__SZSUSHEMOAPAC__540E11AE ([HIV] = 'P' or [HIV] = 'N')
CK__SZSUSHEMOAPAC__5225C93C ([INSCTRANSPLANTE] = 'S' or [INSCTRANSPLANTE] = 'N')
CK__SZSUSHEMOAPAC__5131A503 ([INDTRANSPLANTE] = 'S' or [INDTRANSPLANTE] = 'N')
CK__SZSUSHEMOAPAC__5319ED75 ([HEPC] = 'P' or [HEPC] = 'N')
CK__SZSUSHEMOAPAC__550235E7 ([HLA] = 'S' or [HLA] = 'N')

Diagram producer might be missing

No diagrams were produced please see application output for any errors