%!PS-Adobe-3.0 EPSF-3.0 %%Creator: graphviz version 2.26.3 (20100126.1600) %%Title: test %%Pages: 1 %%BoundingBox: 36 36 716 1746 %%EndComments save %%BeginProlog /DotDict 200 dict def DotDict begin /setupLatin1 { mark /EncodingVector 256 array def EncodingVector 0 ISOLatin1Encoding 0 255 getinterval putinterval EncodingVector 45 /hyphen put % Set up ISO Latin 1 character encoding /starnetISO { dup dup findfont dup length dict begin { 1 index /FID ne { def }{ pop pop } ifelse } forall /Encoding EncodingVector def currentdict end definefont } def /Times-Roman starnetISO def /Times-Italic starnetISO def /Times-Bold starnetISO def /Times-BoldItalic starnetISO def /Helvetica starnetISO def /Helvetica-Oblique starnetISO def /Helvetica-Bold starnetISO def /Helvetica-BoldOblique starnetISO def /Courier starnetISO def /Courier-Oblique starnetISO def /Courier-Bold starnetISO def /Courier-BoldOblique starnetISO def cleartomark } bind def %%BeginResource: procset graphviz 0 0 /coord-font-family /Times-Roman def /default-font-family /Times-Roman def /coordfont coord-font-family findfont 8 scalefont def /InvScaleFactor 1.0 def /set_scale { dup 1 exch div /InvScaleFactor exch def scale } bind def % styles /solid { [] 0 setdash } bind def /dashed { [9 InvScaleFactor mul dup ] 0 setdash } bind def /dotted { [1 InvScaleFactor mul 6 InvScaleFactor mul] 0 setdash } bind def /invis {/fill {newpath} def /stroke {newpath} def /show {pop newpath} def} bind def /bold { 2 setlinewidth } bind def /filled { } bind def /unfilled { } bind def /rounded { } bind def /diagonals { } bind def % hooks for setting color /nodecolor { sethsbcolor } bind def /edgecolor { sethsbcolor } bind def /graphcolor { sethsbcolor } bind def /nopcolor {pop pop pop} bind def /beginpage { % i j npages /npages exch def /j exch def /i exch def /str 10 string def npages 1 gt { gsave coordfont setfont 0 0 moveto (\() show i str cvs show (,) show j str cvs show (\)) show grestore } if } bind def /set_font { findfont exch scalefont setfont } def % draw text fitted to its expected width /alignedtext { % width text /text exch def /width exch def gsave width 0 gt { [] 0 setdash text stringwidth pop width exch sub text length div 0 text ashow } if grestore } def /boxprim { % xcorner ycorner xsize ysize 4 2 roll moveto 2 copy exch 0 rlineto 0 exch rlineto pop neg 0 rlineto closepath } bind def /ellipse_path { /ry exch def /rx exch def /y exch def /x exch def matrix currentmatrix newpath x y translate rx ry scale 0 0 1 0 360 arc setmatrix } bind def /endpage { showpage } bind def /showpage { } def /layercolorseq [ % layer color sequence - darkest to lightest [0 0 0] [.2 .8 .8] [.4 .8 .8] [.6 .8 .8] [.8 .8 .8] ] def /layerlen layercolorseq length def /setlayer {/maxlayer exch def /curlayer exch def layercolorseq curlayer 1 sub layerlen mod get aload pop sethsbcolor /nodecolor {nopcolor} def /edgecolor {nopcolor} def /graphcolor {nopcolor} def } bind def /onlayer { curlayer ne {invis} if } def /onlayers { /myupper exch def /mylower exch def curlayer mylower lt curlayer myupper gt or {invis} if } def /curlayer 0 def %%EndResource %%EndProlog %%BeginSetup 14 default-font-family set_font 1 setmiterlimit % /arrowlength 10 def % /arrowwidth 5 def % make sure pdfmark is harmless for PS-interpreters other than Distiller /pdfmark where {pop} {userdict /pdfmark /cleartomark load put} ifelse % make '<<' and '>>' safe on PS Level 1 devices /languagelevel where {pop languagelevel}{1} ifelse 2 lt { userdict (<<) cvn ([) cvn load put userdict (>>) cvn ([) cvn load put } if %%EndSetup setupLatin1 %%Page: 1 1 %%PageBoundingBox: 36 36 716 1746 %%PageOrientation: Portrait 0 0 1 beginpage gsave 36 36 680 1710 boxprim clip newpath 1 1 set_scale 0 rotate 40 41 translate % node1 gsave 0 0 1 nodecolor newpath 310.3 1550.8 moveto 310.3 1701.2 lineto 485.7 1701.2 lineto 485.7 1550.8 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 310.3 1550.8 moveto 310.3 1701.2 lineto 485.7 1701.2 lineto 485.7 1550.8 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 387.89 1684.6 moveto 20.21 (self) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 310.3 1676.4 moveto 485.7 1676.4 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 318.3 1659.8 moveto 121.3 (self_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 318.3 1643 moveto 159.39 (self_handle VARCHAR [U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 318.3 1626.2 moveto 119.36 (use_hsm BOOLEAN) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 318.3 1609.4 moveto 138.38 (crl_interval BIGINT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 318.3 1592.6 moveto 151.6 (regen_margin BIGINT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 318.3 1575.8 moveto 155.5 (bpki_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 318.3 1559 moveto 158.63 (bpki_glue LONGBLOB [N]) alignedtext grestore % node2 gsave 0 0 1 nodecolor newpath 156.2 1346.4 moveto 156.2 1513.6 lineto 365.8 1513.6 lineto 365.8 1346.4 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 156.2 1346.4 moveto 156.2 1513.6 lineto 365.8 1513.6 lineto 365.8 1346.4 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 251.67 1497 moveto 18.66 (bsc) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 156.2 1488.8 moveto 365.8 1488.8 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 164.2 1472.2 moveto 119.75 (bsc_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 164.2 1455.4 moveto 157.84 (bsc_handle VARCHAR [U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 164.2 1438.6 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 164.2 1421.8 moveto 189.72 (pkcs10_request LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 164.2 1405 moveto 117.4 (hash_alg ENUM [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 164.2 1388.2 moveto 171.84 (signing_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 164.2 1371.4 moveto 193.6 (signing_cert_crl LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 164.2 1354.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext grestore % node1->node2 gsave 1 setlinewidth 0 0 0 edgecolor newpath 345.42 1550.78 moveto 338.89 1541.43 332.15 1531.79 325.46 1522.21 curveto stroke 0 0 0 edgecolor newpath 325.33 1522.03 moveto 323.29 1511.25 lineto 322.46 1517.93 lineto 319.6 1513.83 lineto 319.6 1513.83 lineto 319.6 1513.83 lineto 322.46 1517.93 lineto 315.91 1516.41 lineto 325.33 1522.03 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 325.33 1522.03 moveto 323.29 1511.25 lineto 322.46 1517.93 lineto 319.6 1513.83 lineto 319.6 1513.83 lineto 319.6 1513.83 lineto 322.46 1517.93 lineto 315.91 1516.41 lineto 325.33 1522.03 lineto closepath stroke grestore % node3 gsave 0 0 1 nodecolor newpath 283.86 1142.4 moveto 283.86 1309.6 lineto 512.14 1309.6 lineto 512.14 1142.4 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 283.86 1142.4 moveto 283.86 1309.6 lineto 512.14 1309.6 lineto 512.14 1142.4 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 369.62 1293 moveto 56.76 (repository) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 283.86 1284.8 moveto 512.14 1284.8 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1268.2 moveto 157.85 (repository_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1251.4 moveto 195.95 (repository_handle VARCHAR [U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1234.6 moveto 156.26 (peer_contact_uri TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1217.8 moveto 155.5 (bpki_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1201 moveto 158.63 (bpki_glue LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1184.2 moveto 212.27 (last_cms_timestamp DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1167.4 moveto 118.18 (bsc_id BIGINT [FK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1150.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext grestore % node1->node3 gsave 1 setlinewidth 0 0 0 edgecolor newpath 398 1550.76 moveto 398 1485.41 398 1390.45 398 1320.08 curveto stroke 0 0 0 edgecolor newpath 398 1319.89 moveto 402.5 1309.89 lineto 398 1314.89 lineto 398 1309.89 lineto 398 1309.89 lineto 398 1309.89 lineto 398 1314.89 lineto 393.5 1309.89 lineto 398 1319.89 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 398 1319.89 moveto 402.5 1309.89 lineto 398 1314.89 lineto 398 1309.89 lineto 398 1309.89 lineto 398 1309.89 lineto 398 1314.89 lineto 393.5 1309.89 lineto 398 1319.89 lineto closepath stroke grestore % node4 gsave 0 0 1 nodecolor newpath 280.86 870.8 moveto 280.86 1105.2 lineto 509.14 1105.2 lineto 509.14 870.8 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 280.86 870.8 moveto 280.86 1105.2 lineto 509.14 1105.2 lineto 509.14 870.8 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 377.51 1088.6 moveto 34.98 (parent) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 280.86 1080.4 moveto 509.14 1080.4 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 1063.8 moveto 136.07 (parent_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 1047 moveto 174.16 (parent_handle VARCHAR [U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 1030.2 moveto 185.05 (bpki_cms_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 1013.4 moveto 188.18 (bpki_cms_glue LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 996.6 moveto 156.26 (peer_contact_uri TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 979.8 moveto 109.62 (sia_base TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 963 moveto 136.05 (sender_name TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 946.2 moveto 148.49 (recipient_name TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 929.4 moveto 212.27 (last_cms_timestamp DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 912.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 895.8 moveto 118.18 (bsc_id BIGINT [FK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 288.86 879 moveto 156.29 (repository_id BIGINT [FK]) alignedtext grestore % node1->node4 gsave 1 setlinewidth 0 0 0 edgecolor newpath 444.54 1550.49 moveto 497.74 1454.14 571.35 1283.05 521 1142 curveto 517.65 1132.61 513.45 1123.37 508.63 1114.38 curveto stroke 0 0 0 edgecolor newpath 508.53 1114.19 moveto 507.55 1103.27 lineto 506.08 1109.83 lineto 503.63 1105.47 lineto 503.63 1105.47 lineto 503.63 1105.47 lineto 506.08 1109.83 lineto 499.7 1107.68 lineto 508.53 1114.19 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 508.53 1114.19 moveto 507.55 1103.27 lineto 506.08 1109.83 lineto 503.63 1105.47 lineto 503.63 1105.47 lineto 503.63 1105.47 lineto 506.08 1109.83 lineto 499.7 1107.68 lineto 508.53 1114.19 lineto closepath stroke grestore % node7 gsave 0 0 1 nodecolor newpath -.14 1150.8 moveto -.14 1301.2 lineto 228.14 1301.2 lineto 228.14 1150.8 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath -.14 1150.8 moveto -.14 1301.2 lineto 228.14 1301.2 lineto 228.14 1150.8 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 100 1284.6 moveto 28 (child) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath -.14 1276.4 moveto 228.14 1276.4 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 7.86 1259.8 moveto 129.09 (child_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 7.86 1243 moveto 167.18 (child_handle VARCHAR [U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 7.86 1226.2 moveto 155.5 (bpki_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 7.86 1209.4 moveto 158.63 (bpki_glue LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 7.86 1192.6 moveto 212.27 (last_cms_timestamp DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 7.86 1175.8 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 7.86 1159 moveto 118.18 (bsc_id BIGINT [FK]) alignedtext grestore % node1->node7 gsave 1 setlinewidth 0 0 0 edgecolor newpath 310.16 1609.91 moveto 254.31 1594.88 185.51 1566.53 147 1514 curveto 104.58 1456.14 99.17 1373.4 102.71 1311.45 curveto stroke 0 0 0 edgecolor newpath 102.72 1311.28 moveto 107.87 1301.59 lineto 103.05 1306.29 lineto 103.38 1301.3 lineto 103.38 1301.3 lineto 103.38 1301.3 lineto 103.05 1306.29 lineto 98.89 1301 lineto 102.72 1311.28 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 102.72 1311.28 moveto 107.87 1301.59 lineto 103.05 1306.29 lineto 103.38 1301.3 lineto 103.38 1301.3 lineto 103.38 1301.3 lineto 103.05 1306.29 lineto 98.89 1301 lineto 102.72 1311.28 lineto closepath stroke grestore % node10 gsave 0 0 1 nodecolor newpath 493.8 154.8 moveto 493.8 305.2 lineto 662.2 305.2 lineto 662.2 154.8 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 493.8 154.8 moveto 493.8 305.2 lineto 662.2 305.2 lineto 662.2 154.8 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 569.06 288.6 moveto 17.88 (roa) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 493.8 280.4 moveto 662.2 280.4 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 501.8 263.8 moveto 118.97 (roa_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 501.8 247 moveto 69.58 (asn BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 501.8 230.2 moveto 100.69 (cert LONGBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 501.8 213.4 moveto 97.58 (roa LONGBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 501.8 196.6 moveto 152.4 (published DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 501.8 179.8 moveto 119.74 (self_id BIGINT [FK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 501.8 163 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext grestore % node1->node10 gsave 1 setlinewidth 0 0 0 edgecolor newpath 483.92 1550.75 moveto 493.77 1539.22 502.84 1526.85 510 1514 curveto 574.05 1399.13 578 1357.52 578 1226 curveto 578 1226 578 1226 578 741 curveto 578 591.33 578 417.01 578 315.52 curveto stroke 0 0 0 edgecolor newpath 578 315.33 moveto 582.5 305.33 lineto 578 310.33 lineto 578 305.33 lineto 578 305.33 lineto 578 305.33 lineto 578 310.33 lineto 573.5 305.33 lineto 578 315.33 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 578 315.33 moveto 582.5 305.33 lineto 578 310.33 lineto 578 305.33 lineto 578 305.33 lineto 578 305.33 lineto 578 310.33 lineto 573.5 305.33 lineto 578 315.33 lineto closepath stroke grestore % node2->node3 gsave 1 setlinewidth 0 0 0 edgecolor newpath 317.32 1346.14 moveto 323.48 1336.97 329.77 1327.6 335.99 1318.33 curveto stroke 0 0 0 edgecolor newpath 336.11 1318.16 moveto 345.42 1312.37 lineto 338.89 1314.01 lineto 341.68 1309.86 lineto 341.68 1309.86 lineto 341.68 1309.86 lineto 338.89 1314.01 lineto 337.95 1307.35 lineto 336.11 1318.16 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 336.11 1318.16 moveto 345.42 1312.37 lineto 338.89 1314.01 lineto 341.68 1309.86 lineto 341.68 1309.86 lineto 341.68 1309.86 lineto 338.89 1314.01 lineto 337.95 1307.35 lineto 336.11 1318.16 lineto closepath stroke grestore % node2->node4 gsave 1 setlinewidth 0 0 0 edgecolor newpath 251.99 1346.35 moveto 248.73 1287.39 250.67 1207.59 275 1142 curveto 278.45 1132.7 282.68 1123.52 287.46 1114.55 curveto stroke 0 0 0 edgecolor newpath 287.55 1114.39 moveto 296.35 1107.84 lineto 289.98 1110.02 lineto 292.42 1105.65 lineto 292.42 1105.65 lineto 292.42 1105.65 lineto 289.98 1110.02 lineto 288.49 1103.46 lineto 287.55 1114.39 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 287.55 1114.39 moveto 296.35 1107.84 lineto 289.98 1110.02 lineto 292.42 1105.65 lineto 292.42 1105.65 lineto 292.42 1105.65 lineto 289.98 1110.02 lineto 288.49 1103.46 lineto 287.55 1114.39 lineto closepath stroke grestore % node2->node7 gsave 1 setlinewidth 0 0 0 edgecolor newpath 200.57 1346.14 moveto 191.89 1334.09 182.95 1321.68 174.27 1309.64 curveto stroke 0 0 0 edgecolor newpath 174.15 1309.47 moveto 171.95 1298.73 lineto 171.23 1305.41 lineto 168.3 1301.36 lineto 168.3 1301.36 lineto 168.3 1301.36 lineto 171.23 1305.41 lineto 164.65 1303.99 lineto 174.15 1309.47 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 174.15 1309.47 moveto 171.95 1298.73 lineto 171.23 1305.41 lineto 168.3 1301.36 lineto 168.3 1301.36 lineto 168.3 1301.36 lineto 171.23 1305.41 lineto 164.65 1303.99 lineto 174.15 1309.47 lineto closepath stroke grestore % node3->node4 gsave 1 setlinewidth 0 0 0 edgecolor newpath 396.94 1142.09 moveto 396.83 1133.44 396.72 1124.51 396.61 1115.52 curveto stroke 0 0 0 edgecolor newpath 396.61 1115.35 moveto 400.98 1105.29 lineto 396.54 1110.35 lineto 396.48 1105.35 lineto 396.48 1105.35 lineto 396.48 1105.35 lineto 396.54 1110.35 lineto 391.98 1105.41 lineto 396.61 1115.35 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 396.61 1115.35 moveto 400.98 1105.29 lineto 396.54 1110.35 lineto 396.48 1105.35 lineto 396.48 1105.35 lineto 396.48 1105.35 lineto 396.54 1110.35 lineto 391.98 1105.41 lineto 396.61 1115.35 lineto closepath stroke grestore % node5 gsave 0 0 1 nodecolor newpath 274.21 649 moveto 274.21 833 lineto 511.79 833 lineto 511.79 649 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 274.21 649 moveto 274.21 833 lineto 511.79 833 lineto 511.79 649 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 386.79 816.4 moveto 12.43 (ca) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 274.21 808.2 moveto 511.79 808.2 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 282.21 791.6 moveto 113.52 (ca_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 282.21 774.8 moveto 111.57 (last_crl_sn BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 282.21 758 moveto 145.01 (last_manifest_sn BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 282.21 741.2 moveto 221.59 (next_manifest_update DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 282.21 724.4 moveto 188.15 (next_crl_update DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 282.21 707.6 moveto 131.8 (last_issued_sn BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 282.21 690.8 moveto 100.29 (sia_uri TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 282.21 674 moveto 185.79 (parent_resource_class TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 282.21 657.2 moveto 134.5 (parent_id BIGINT [FK]) alignedtext grestore % node4->node5 gsave 1 setlinewidth 0 0 0 edgecolor newpath 394.05 870.65 moveto 393.98 861.51 393.9 852.34 393.83 843.31 curveto stroke 0 0 0 edgecolor newpath 393.83 843.2 moveto 398.25 833.16 lineto 393.79 838.2 lineto 393.75 833.2 lineto 393.75 833.2 lineto 393.75 833.2 lineto 393.79 838.2 lineto 389.25 833.24 lineto 393.83 843.2 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 393.83 843.2 moveto 398.25 833.16 lineto 393.79 838.2 lineto 393.75 833.2 lineto 393.75 833.2 lineto 393.75 833.2 lineto 393.79 838.2 lineto 389.25 833.24 lineto 393.83 843.2 lineto closepath stroke grestore % node6 gsave 0 0 1 nodecolor newpath 256.09 343 moveto 256.09 611 lineto 513.91 611 lineto 513.91 343 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 256.09 343 moveto 256.09 611 lineto 513.91 611 lineto 513.91 343 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 359.73 594.4 moveto 50.53 (ca_detail) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 256.09 586.2 moveto 513.91 586.2 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 569.6 moveto 151.62 (ca_detail_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 552.8 moveto 164.84 (public_key LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 536 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 519.2 moveto 153.94 (latest_crl LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 502.4 moveto 174.16 (crl_published DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 485.6 moveto 179.59 (latest_ca_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 468.8 moveto 241.82 (manifest_private_key_id LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 452 moveto 220.05 (manifest_public_key LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 435.2 moveto 215.36 (latest_manifest_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 418.4 moveto 187.38 (latest_manifest LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 401.6 moveto 207.6 (manifest_published DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 384.8 moveto 70.37 (state ENUM) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 368 moveto 125.15 (ca_cert_uri TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 264.09 351.2 moveto 111.95 (ca_id BIGINT [FK]) alignedtext grestore % node5->node6 gsave 1 setlinewidth 0 0 0 edgecolor newpath 390.2 648.67 moveto 389.93 639.71 389.65 630.49 389.37 621.19 curveto stroke 0 0 0 edgecolor newpath 389.37 621.06 moveto 393.56 610.93 lineto 389.21 616.06 lineto 389.06 611.07 lineto 389.06 611.07 lineto 389.06 611.07 lineto 389.21 616.06 lineto 384.56 611.2 lineto 389.37 621.06 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 389.37 621.06 moveto 393.56 610.93 lineto 389.21 616.06 lineto 389.06 611.07 lineto 389.06 611.07 lineto 389.06 611.07 lineto 389.21 616.06 lineto 384.56 611.2 lineto 389.37 621.06 lineto closepath stroke grestore % node8 gsave 0 0 1 nodecolor newpath 78.47 163.2 moveto 78.47 296.8 lineto 251.53 296.8 lineto 251.53 163.2 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 78.47 163.2 moveto 78.47 296.8 lineto 251.53 296.8 lineto 251.53 163.2 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 137.01 280.2 moveto 55.98 (child_cert) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 78.47 272 moveto 251.53 272 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 86.47 255.4 moveto 157.07 (child_cert_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 86.47 238.6 moveto 100.69 (cert LONGBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 86.47 221.8 moveto 152.4 (published DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 86.47 205 moveto 90.59 (ski TINYBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 86.47 188.2 moveto 127.52 (child_id BIGINT [FK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 86.47 171.4 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext grestore % node6->node8 gsave 1 setlinewidth 0 0 0 edgecolor newpath 265.34 342.66 moveto 253.66 329.54 242.12 316.59 231.26 304.39 curveto stroke 0 0 0 edgecolor newpath 231.25 304.38 moveto 227.95 293.91 lineto 227.92 300.64 lineto 224.59 296.91 lineto 224.59 296.91 lineto 224.59 296.91 lineto 227.92 300.64 lineto 221.23 299.9 lineto 231.25 304.38 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 231.25 304.38 moveto 227.95 293.91 lineto 227.92 300.64 lineto 224.59 296.91 lineto 224.59 296.91 lineto 224.59 296.91 lineto 227.92 300.64 lineto 221.23 299.9 lineto 231.25 304.38 lineto closepath stroke grestore % node9 gsave 0 0 1 nodecolor newpath 285.92 171.6 moveto 285.92 288.4 lineto 476.08 288.4 lineto 476.08 171.6 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 285.92 171.6 moveto 285.92 288.4 lineto 476.08 288.4 lineto 476.08 171.6 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 344.46 271.8 moveto 73.07 (revoked_cert) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 285.92 263.6 moveto 476.08 263.6 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 293.92 247 moveto 174.16 (revoked_cert_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 293.92 230.2 moveto 81.24 (serial BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 293.92 213.4 moveto 120.12 (revoked DATETIME) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 293.92 196.6 moveto 115.45 (expires DATETIME) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 293.92 179.8 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext grestore % node6->node9 gsave 1 setlinewidth 0 0 0 edgecolor newpath 382.82 342.66 moveto 382.58 327.51 382.34 312.58 382.11 298.79 curveto stroke 0 0 0 edgecolor newpath 382.11 298.49 moveto 386.45 288.41 lineto 382.03 293.49 lineto 381.95 288.49 lineto 381.95 288.49 lineto 381.95 288.49 lineto 382.03 293.49 lineto 377.45 288.56 lineto 382.11 298.49 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 382.11 298.49 moveto 386.45 288.41 lineto 382.03 293.49 lineto 381.95 288.49 lineto 381.95 288.49 lineto 381.95 288.49 lineto 382.03 293.49 lineto 377.45 288.56 lineto 382.11 298.49 lineto closepath stroke grestore % node6->node10 gsave 1 setlinewidth 0 0 0 edgecolor newpath 489.97 342.66 moveto 497.78 332.67 505.51 322.78 512.96 313.24 curveto stroke 0 0 0 edgecolor newpath 512.99 313.2 moveto 522.69 308.09 lineto 516.07 309.26 lineto 519.14 305.32 lineto 519.14 305.32 lineto 519.14 305.32 lineto 516.07 309.26 lineto 515.6 302.55 lineto 512.99 313.2 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 512.99 313.2 moveto 522.69 308.09 lineto 516.07 309.26 lineto 519.14 305.32 lineto 519.14 305.32 lineto 519.14 305.32 lineto 516.07 309.26 lineto 515.6 302.55 lineto 512.99 313.2 lineto closepath stroke grestore % node7->node8 gsave 1 setlinewidth 0 0 0 edgecolor newpath 117.85 1150.73 moveto 127.29 966.37 151.5 493.71 161.04 307.28 curveto stroke 0 0 0 edgecolor newpath 161.06 307 moveto 166.06 297.24 lineto 161.31 302.01 lineto 161.57 297.01 lineto 161.57 297.01 lineto 161.57 297.01 lineto 161.31 302.01 lineto 157.07 296.78 lineto 161.06 307 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 161.06 307 moveto 166.06 297.24 lineto 161.31 302.01 lineto 161.57 297.01 lineto 161.57 297.01 lineto 161.57 297.01 lineto 161.31 302.01 lineto 157.07 296.78 lineto 161.06 307 lineto closepath stroke grestore % node11 gsave 0 0 1 nodecolor newpath 483.7 .6 moveto 483.7 117.4 lineto 672.3 117.4 lineto 672.3 .6 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 483.7 .6 moveto 483.7 117.4 lineto 672.3 117.4 lineto 672.3 .6 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 548.85 100.8 moveto 58.3 (roa_prefix) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 483.7 92.6 moveto 672.3 92.6 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 491.7 76 moveto 136.07 (prefix VARCHAR [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 491.7 59.2 moveto 141.49 (prefixlen TINYINT [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 491.7 42.4 moveto 172.59 (max_prefixlen TINYINT [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 491.7 25.6 moveto 101.46 (version TINYINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 491.7 8.8 moveto 138.79 (roa_id BIGINT [PK,FK]) alignedtext grestore % node10->node11 gsave 1 setlinewidth 0 0 0 edgecolor newpath 578 154.5 moveto 578 145.56 578 136.47 578 127.64 curveto stroke 0 0 0 edgecolor newpath 578 127.4 moveto 582.5 117.4 lineto 578 122.4 lineto 578 117.4 lineto 578 117.4 lineto 578 117.4 lineto 578 122.4 lineto 573.5 117.4 lineto 578 127.4 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 578 127.4 moveto 582.5 117.4 lineto 578 122.4 lineto 578 117.4 lineto 578 117.4 lineto 578 117.4 lineto 578 122.4 lineto 573.5 117.4 lineto 578 127.4 lineto closepath stroke grestore endpage showpage grestore %%PageTrailer %%EndPage: 1 %%Trailer end restore %%EOF