%!PS-Adobe-3.0 EPSF-3.0 %%Creator: graphviz version 2.26.3 (20100126.1600) %%Title: test %%Pages: 1 %%BoundingBox: 36 36 838 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 838 1746 %%PageOrientation: Portrait 0 0 1 beginpage gsave 36 36 802 1710 boxprim clip newpath 1 1 set_scale 0 rotate 40 41 translate % node1 gsave 0 0 1 nodecolor newpath 407.3 1550.8 moveto 407.3 1701.2 lineto 582.7 1701.2 lineto 582.7 1550.8 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 407.3 1550.8 moveto 407.3 1701.2 lineto 582.7 1701.2 lineto 582.7 1550.8 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 484.89 1684.6 moveto 20.21 (self) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 407.3 1676.4 moveto 582.7 1676.4 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 415.3 1659.8 moveto 121.3 (self_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 415.3 1643 moveto 159.39 (self_handle VARCHAR [U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 415.3 1626.2 moveto 119.36 (use_hsm BOOLEAN) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 415.3 1609.4 moveto 138.38 (crl_interval BIGINT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 415.3 1592.6 moveto 151.6 (regen_margin BIGINT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 415.3 1575.8 moveto 155.5 (bpki_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 415.3 1559 moveto 158.63 (bpki_glue LONGBLOB [N]) alignedtext grestore % node2 gsave 0 0 1 nodecolor newpath 182.2 1346.4 moveto 182.2 1513.6 lineto 391.8 1513.6 lineto 391.8 1346.4 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 182.2 1346.4 moveto 182.2 1513.6 lineto 391.8 1513.6 lineto 391.8 1346.4 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 277.67 1497 moveto 18.66 (bsc) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 182.2 1488.8 moveto 391.8 1488.8 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 190.2 1472.2 moveto 119.75 (bsc_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 190.2 1455.4 moveto 157.84 (bsc_handle VARCHAR [U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 190.2 1438.6 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 190.2 1421.8 moveto 189.72 (pkcs10_request LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 190.2 1405 moveto 117.4 (hash_alg ENUM [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 190.2 1388.2 moveto 171.84 (signing_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 190.2 1371.4 moveto 193.6 (signing_cert_crl LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 190.2 1354.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext grestore % node1->node2 gsave 1 setlinewidth 0 0 0 edgecolor newpath 415.18 1550.78 moveto 404.75 1540.96 393.98 1530.81 383.32 1520.77 curveto stroke 0 0 0 edgecolor newpath 383.24 1520.69 moveto 379.05 1510.56 lineto 379.6 1517.26 lineto 375.96 1513.83 lineto 375.96 1513.83 lineto 375.96 1513.83 lineto 379.6 1517.26 lineto 372.88 1517.11 lineto 383.24 1520.69 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 383.24 1520.69 moveto 379.05 1510.56 lineto 379.6 1517.26 lineto 375.96 1513.83 lineto 375.96 1513.83 lineto 375.96 1513.83 lineto 379.6 1517.26 lineto 372.88 1517.11 lineto 383.24 1520.69 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 476.76 1550.76 moveto 460.87 1485.27 437.79 1390.06 420.71 1319.65 curveto stroke 0 0 0 edgecolor newpath 420.7 1319.61 moveto 422.72 1308.83 lineto 419.52 1314.75 lineto 418.34 1309.89 lineto 418.34 1309.89 lineto 418.34 1309.89 lineto 419.52 1314.75 lineto 413.97 1310.95 lineto 420.7 1319.61 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 420.7 1319.61 moveto 422.72 1308.83 lineto 419.52 1314.75 lineto 418.34 1309.89 lineto 418.34 1309.89 lineto 418.34 1309.89 lineto 419.52 1314.75 lineto 413.97 1310.95 lineto 420.7 1319.61 lineto closepath stroke grestore % node4 gsave 0 0 1 nodecolor newpath 283.86 870.8 moveto 283.86 1105.2 lineto 512.14 1105.2 lineto 512.14 870.8 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 283.86 870.8 moveto 283.86 1105.2 lineto 512.14 1105.2 lineto 512.14 870.8 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 380.51 1088.6 moveto 34.98 (parent) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 283.86 1080.4 moveto 512.14 1080.4 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1063.8 moveto 136.07 (parent_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1047 moveto 174.16 (parent_handle VARCHAR [U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1030.2 moveto 185.05 (bpki_cms_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 1013.4 moveto 188.18 (bpki_cms_glue LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 996.6 moveto 156.26 (peer_contact_uri TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 979.8 moveto 109.62 (sia_base TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 963 moveto 136.05 (sender_name TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 946.2 moveto 148.49 (recipient_name TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 929.4 moveto 212.27 (last_cms_timestamp DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 912.6 moveto 133.34 (self_id BIGINT [FK,U]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 895.8 moveto 118.18 (bsc_id BIGINT [FK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 291.86 879 moveto 156.29 (repository_id BIGINT [FK]) alignedtext grestore % node1->node4 gsave 1 setlinewidth 0 0 0 edgecolor newpath 516.4 1550.53 moveto 540.17 1453.12 569.27 1279.79 521 1142 curveto 517.69 1132.55 513.53 1123.26 508.76 1114.2 curveto stroke 0 0 0 edgecolor newpath 508.64 1113.97 moveto 507.73 1103.04 lineto 506.22 1109.59 lineto 503.8 1105.22 lineto 503.8 1105.22 lineto 503.8 1105.22 lineto 506.22 1109.59 lineto 499.86 1107.4 lineto 508.64 1113.97 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 508.64 1113.97 moveto 507.73 1103.04 lineto 506.22 1109.59 lineto 503.8 1105.22 lineto 503.8 1105.22 lineto 503.8 1105.22 lineto 506.22 1109.59 lineto 499.86 1107.4 lineto 508.64 1113.97 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 407.06 1605.79 moveto 322.91 1584.69 204.29 1549.74 173 1514 curveto 124.68 1458.8 112.02 1374.78 110.21 1311.72 curveto stroke 0 0 0 edgecolor newpath 110.2 1311.39 moveto 114.5 1301.3 lineto 110.1 1306.39 lineto 110 1301.39 lineto 110 1301.39 lineto 110 1301.39 lineto 110.1 1306.39 lineto 105.5 1301.48 lineto 110.2 1311.39 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 110.2 1311.39 moveto 114.5 1301.3 lineto 110.1 1306.39 lineto 110 1301.39 lineto 110 1301.39 lineto 110 1301.39 lineto 110.1 1306.39 lineto 105.5 1301.48 lineto 110.2 1311.39 lineto closepath stroke grestore % node10 gsave 0 0 1 nodecolor newpath 425.8 154.8 moveto 425.8 305.2 lineto 594.2 305.2 lineto 594.2 154.8 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 425.8 154.8 moveto 425.8 305.2 lineto 594.2 305.2 lineto 594.2 154.8 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 501.06 288.6 moveto 17.88 (roa) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 425.8 280.4 moveto 594.2 280.4 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 433.8 263.8 moveto 118.97 (roa_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 433.8 247 moveto 69.58 (asn BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 433.8 230.2 moveto 100.69 (cert LONGBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 433.8 213.4 moveto 97.58 (roa LONGBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 433.8 196.6 moveto 152.4 (published DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 433.8 179.8 moveto 119.74 (self_id BIGINT [FK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 433.8 163 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext grestore % node1->node10 gsave 1 setlinewidth 0 0 0 edgecolor newpath 536.51 1550.64 moveto 541.79 1538.66 546.54 1526.19 550 1514 curveto 585.13 1390.29 578 1354.6 578 1226 curveto 578 1226 578 1226 578 741 curveto 578 562.69 565.55 517.85 536 342 curveto 534.55 333.35 532.82 324.36 530.97 315.42 curveto stroke 0 0 0 edgecolor newpath 530.91 315.13 moveto 533.23 304.42 lineto 529.87 310.24 lineto 528.83 305.35 lineto 528.83 305.35 lineto 528.83 305.35 lineto 529.87 310.24 lineto 524.43 306.29 lineto 530.91 315.13 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 530.91 315.13 moveto 533.23 304.42 lineto 529.87 310.24 lineto 528.83 305.35 lineto 528.83 305.35 lineto 528.83 305.35 lineto 529.87 310.24 lineto 524.43 306.29 lineto 530.91 315.13 lineto closepath stroke grestore % node12 gsave 0 0 1 nodecolor newpath 612.18 154.8 moveto 612.18 305.2 lineto 793.82 305.2 lineto 793.82 154.8 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 612.18 154.8 moveto 612.18 305.2 lineto 793.82 305.2 lineto 793.82 154.8 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 670.73 288.6 moveto 64.55 (ghostbuster) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 612.18 280.4 moveto 793.82 280.4 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 620.18 263.8 moveto 165.64 (ghostbuster_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 620.18 247 moveto 110.79 (vcard LONGBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 620.18 230.2 moveto 100.69 (cert LONGBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 620.18 213.4 moveto 144.25 (ghostbuster LONGBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 620.18 196.6 moveto 152.4 (published DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 620.18 179.8 moveto 119.74 (self_id BIGINT [FK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 620.18 163 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext grestore % node1->node12 gsave 1 setlinewidth 0 0 0 edgecolor newpath 556.48 1550.64 moveto 564.44 1538.81 571.93 1526.39 578 1514 curveto 636.55 1394.62 659 1358.97 659 1226 curveto 659 1226 659 1226 659 741 curveto 659 590.99 678.05 417.13 691.08 315.76 curveto stroke 0 0 0 edgecolor newpath 691.12 315.5 moveto 696.87 306.16 lineto 691.76 310.54 lineto 692.4 305.58 lineto 692.4 305.58 lineto 692.4 305.58 lineto 691.76 310.54 lineto 687.94 305 lineto 691.12 315.5 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 691.12 315.5 moveto 696.87 306.16 lineto 691.76 310.54 lineto 692.4 305.58 lineto 692.4 305.58 lineto 692.4 305.58 lineto 691.76 310.54 lineto 687.94 305 lineto 691.12 315.5 lineto closepath stroke grestore % node2->node3 gsave 1 setlinewidth 0 0 0 edgecolor newpath 332.63 1346.14 moveto 337.52 1337.16 342.51 1327.98 347.45 1318.9 curveto stroke 0 0 0 edgecolor newpath 347.59 1318.65 moveto 356.32 1312.01 lineto 349.98 1314.25 lineto 352.37 1309.86 lineto 352.37 1309.86 lineto 352.37 1309.86 lineto 349.98 1314.25 lineto 348.42 1307.71 lineto 347.59 1318.65 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 347.59 1318.65 moveto 356.32 1312.01 lineto 349.98 1314.25 lineto 352.37 1309.86 lineto 352.37 1309.86 lineto 352.37 1309.86 lineto 349.98 1314.25 lineto 348.42 1307.71 lineto 347.59 1318.65 lineto closepath stroke grestore % node2->node4 gsave 1 setlinewidth 0 0 0 edgecolor newpath 267.47 1346.29 moveto 257.56 1287.48 251.92 1207.88 275 1142 curveto 278.31 1132.55 282.47 1123.26 287.24 1114.2 curveto stroke 0 0 0 edgecolor newpath 287.36 1113.97 moveto 296.14 1107.4 lineto 289.78 1109.59 lineto 292.2 1105.22 lineto 292.2 1105.22 lineto 292.2 1105.22 lineto 289.78 1109.59 lineto 288.27 1103.04 lineto 287.36 1113.97 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 287.36 1113.97 moveto 296.14 1107.4 lineto 289.78 1109.59 lineto 292.2 1105.22 lineto 292.2 1105.22 lineto 292.2 1105.22 lineto 289.78 1109.59 lineto 288.27 1103.04 lineto 287.36 1113.97 lineto closepath stroke grestore % node2->node7 gsave 1 setlinewidth 0 0 0 edgecolor newpath 215.89 1346.14 moveto 205.56 1333.97 194.94 1321.45 184.63 1309.29 curveto stroke 0 0 0 edgecolor newpath 184.37 1308.98 moveto 181.34 1298.45 lineto 181.14 1305.17 lineto 177.91 1301.36 lineto 177.91 1301.36 lineto 177.91 1301.36 lineto 181.14 1305.17 lineto 174.47 1304.27 lineto 184.37 1308.98 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 184.37 1308.98 moveto 181.34 1298.45 lineto 181.14 1305.17 lineto 177.91 1301.36 lineto 177.91 1301.36 lineto 177.91 1301.36 lineto 181.14 1305.17 lineto 174.47 1304.27 lineto 184.37 1308.98 lineto closepath stroke grestore % node3->node4 gsave 1 setlinewidth 0 0 0 edgecolor newpath 398 1142.09 moveto 398 1133.44 398 1124.51 398 1115.52 curveto stroke 0 0 0 edgecolor newpath 398 1115.35 moveto 402.5 1105.35 lineto 398 1110.35 lineto 398 1105.35 lineto 398 1105.35 lineto 398 1105.35 lineto 398 1110.35 lineto 393.5 1105.35 lineto 398 1115.35 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 398 1115.35 moveto 402.5 1105.35 lineto 398 1110.35 lineto 398 1105.35 lineto 398 1105.35 lineto 398 1105.35 lineto 398 1110.35 lineto 393.5 1105.35 lineto 398 1115.35 lineto closepath stroke grestore % node5 gsave 0 0 1 nodecolor newpath 279.21 649 moveto 279.21 833 lineto 516.79 833 lineto 516.79 649 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 279.21 649 moveto 279.21 833 lineto 516.79 833 lineto 516.79 649 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 391.79 816.4 moveto 12.43 (ca) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 279.21 808.2 moveto 516.79 808.2 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 287.21 791.6 moveto 113.52 (ca_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 287.21 774.8 moveto 111.57 (last_crl_sn BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 287.21 758 moveto 145.01 (last_manifest_sn BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 287.21 741.2 moveto 221.59 (next_manifest_update DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 287.21 724.4 moveto 188.15 (next_crl_update DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 287.21 707.6 moveto 131.8 (last_issued_sn BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 287.21 690.8 moveto 100.29 (sia_uri TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 287.21 674 moveto 185.79 (parent_resource_class TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 287.21 657.2 moveto 134.5 (parent_id BIGINT [FK]) alignedtext grestore % node4->node5 gsave 1 setlinewidth 0 0 0 edgecolor newpath 398 870.65 moveto 398 861.51 398 852.34 398 843.31 curveto stroke 0 0 0 edgecolor newpath 398 843.2 moveto 402.5 833.2 lineto 398 838.2 lineto 398 833.2 lineto 398 833.2 lineto 398 833.2 lineto 398 838.2 lineto 393.5 833.2 lineto 398 843.2 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 398 843.2 moveto 402.5 833.2 lineto 398 838.2 lineto 398 833.2 lineto 398 833.2 lineto 398 833.2 lineto 398 838.2 lineto 393.5 833.2 lineto 398 843.2 lineto closepath stroke grestore % node6 gsave 0 0 1 nodecolor newpath 269.09 343 moveto 269.09 611 lineto 526.91 611 lineto 526.91 343 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 269.09 343 moveto 269.09 611 lineto 526.91 611 lineto 526.91 343 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 372.73 594.4 moveto 50.53 (ca_detail) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 269.09 586.2 moveto 526.91 586.2 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 569.6 moveto 151.62 (ca_detail_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 552.8 moveto 164.84 (public_key LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 536 moveto 186.61 (private_key_id LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 519.2 moveto 153.94 (latest_crl LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 502.4 moveto 174.16 (crl_published DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 485.6 moveto 179.59 (latest_ca_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 468.8 moveto 241.82 (manifest_private_key_id LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 452 moveto 220.05 (manifest_public_key LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 435.2 moveto 215.36 (latest_manifest_cert LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 418.4 moveto 187.38 (latest_manifest LONGBLOB [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 401.6 moveto 207.6 (manifest_published DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 384.8 moveto 70.37 (state ENUM) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 368 moveto 125.15 (ca_cert_uri TEXT [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 277.09 351.2 moveto 111.95 (ca_id BIGINT [FK]) alignedtext grestore % node5->node6 gsave 1 setlinewidth 0 0 0 edgecolor newpath 398 648.67 moveto 398 639.71 398 630.49 398 621.19 curveto stroke 0 0 0 edgecolor newpath 398 621.07 moveto 402.5 611.07 lineto 398 616.07 lineto 398 611.07 lineto 398 611.07 lineto 398 611.07 lineto 398 616.07 lineto 393.5 611.07 lineto 398 621.07 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 398 621.07 moveto 402.5 611.07 lineto 398 616.07 lineto 398 611.07 lineto 398 611.07 lineto 398 611.07 lineto 398 616.07 lineto 393.5 611.07 lineto 398 621.07 lineto closepath stroke grestore % node8 gsave 0 0 1 nodecolor newpath 27.47 163.2 moveto 27.47 296.8 lineto 200.53 296.8 lineto 200.53 163.2 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 27.47 163.2 moveto 27.47 296.8 lineto 200.53 296.8 lineto 200.53 163.2 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 86.01 280.2 moveto 55.98 (child_cert) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 27.47 272 moveto 200.53 272 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 35.47 255.4 moveto 157.07 (child_cert_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 35.47 238.6 moveto 100.69 (cert LONGBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 35.47 221.8 moveto 152.4 (published DATETIME [N]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 35.47 205 moveto 90.59 (ski TINYBLOB) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 35.47 188.2 moveto 127.52 (child_id BIGINT [FK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 35.47 171.4 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext grestore % node6->node8 gsave 1 setlinewidth 0 0 0 edgecolor newpath 268.88 364.7 moveto 245.03 343.95 220.68 322.78 198.57 303.55 curveto stroke 0 0 0 edgecolor newpath 198.39 303.4 moveto 193.8 293.44 lineto 194.62 300.12 lineto 190.85 296.84 lineto 190.85 296.84 lineto 190.85 296.84 lineto 194.62 300.12 lineto 187.89 300.23 lineto 198.39 303.4 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 198.39 303.4 moveto 193.8 293.44 lineto 194.62 300.12 lineto 190.85 296.84 lineto 190.85 296.84 lineto 190.85 296.84 lineto 194.62 300.12 lineto 187.89 300.23 lineto 198.39 303.4 lineto closepath stroke grestore % node9 gsave 0 0 1 nodecolor newpath 217.92 171.6 moveto 217.92 288.4 lineto 408.08 288.4 lineto 408.08 171.6 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 217.92 171.6 moveto 217.92 288.4 lineto 408.08 288.4 lineto 408.08 171.6 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 276.46 271.8 moveto 73.07 (revoked_cert) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 217.92 263.6 moveto 408.08 263.6 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 225.92 247 moveto 174.16 (revoked_cert_id SERIAL [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 225.92 230.2 moveto 81.24 (serial BIGINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 225.92 213.4 moveto 120.12 (revoked DATETIME) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 225.92 196.6 moveto 115.45 (expires DATETIME) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 225.92 179.8 moveto 150.05 (ca_detail_id BIGINT [FK]) alignedtext grestore % node6->node9 gsave 1 setlinewidth 0 0 0 edgecolor newpath 351.77 342.66 moveto 346.45 327.21 341.22 312 336.4 297.98 curveto stroke 0 0 0 edgecolor newpath 336.38 297.94 moveto 337.38 287.02 lineto 334.75 293.21 lineto 333.13 288.49 lineto 333.13 288.49 lineto 333.13 288.49 lineto 334.75 293.21 lineto 328.87 289.95 lineto 336.38 297.94 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 336.38 297.94 moveto 337.38 287.02 lineto 334.75 293.21 lineto 333.13 288.49 lineto 333.13 288.49 lineto 333.13 288.49 lineto 334.75 293.21 lineto 328.87 289.95 lineto 336.38 297.94 lineto closepath stroke grestore % node6->node10 gsave 1 setlinewidth 0 0 0 edgecolor newpath 458.92 342.66 moveto 463.22 333.17 467.48 323.77 471.61 314.67 curveto stroke 0 0 0 edgecolor newpath 471.72 314.43 moveto 479.94 307.18 lineto 473.78 309.88 lineto 475.85 305.32 lineto 475.85 305.32 lineto 475.85 305.32 lineto 473.78 309.88 lineto 471.75 303.46 lineto 471.72 314.43 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 471.72 314.43 moveto 479.94 307.18 lineto 473.78 309.88 lineto 475.85 305.32 lineto 475.85 305.32 lineto 475.85 305.32 lineto 473.78 309.88 lineto 471.75 303.46 lineto 471.72 314.43 lineto closepath stroke grestore % node6->node12 gsave 1 setlinewidth 0 0 0 edgecolor newpath 527.35 372.25 moveto 552.99 351.49 579.52 330 603.95 310.21 curveto stroke 0 0 0 edgecolor newpath 604.04 310.14 moveto 614.64 307.35 lineto 607.92 307 lineto 611.81 303.85 lineto 611.81 303.85 lineto 611.81 303.85 lineto 607.92 307 lineto 608.98 300.35 lineto 604.04 310.14 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 604.04 310.14 moveto 614.64 307.35 lineto 607.92 307 lineto 611.81 303.85 lineto 611.81 303.85 lineto 611.81 303.85 lineto 607.92 307 lineto 608.98 300.35 lineto 604.04 310.14 lineto closepath stroke grestore % node7->node8 gsave 1 setlinewidth 0 0 0 edgecolor newpath 114 1150.73 moveto 114 966.37 114 493.71 114 307.28 curveto stroke 0 0 0 edgecolor newpath 114 307.01 moveto 118.5 297.01 lineto 114 302.01 lineto 114 297.01 lineto 114 297.01 lineto 114 297.01 lineto 114 302.01 lineto 109.5 297.01 lineto 114 307.01 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 114 307.01 moveto 118.5 297.01 lineto 114 302.01 lineto 114 297.01 lineto 114 297.01 lineto 114 297.01 lineto 114 302.01 lineto 109.5 297.01 lineto 114 307.01 lineto closepath stroke grestore % node11 gsave 0 0 1 nodecolor newpath 415.7 .6 moveto 415.7 117.4 lineto 604.3 117.4 lineto 604.3 .6 lineto closepath fill 1 setlinewidth filled 0 0 0 nodecolor newpath 415.7 .6 moveto 415.7 117.4 lineto 604.3 117.4 lineto 604.3 .6 lineto closepath stroke 0 0 0 nodecolor 14 /Times-Roman set_font 480.85 100.8 moveto 58.3 (roa_prefix) alignedtext 1 setlinewidth filled 0 0 0 nodecolor newpath 415.7 92.6 moveto 604.3 92.6 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font 423.7 76 moveto 136.07 (prefix VARCHAR [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 423.7 59.2 moveto 141.49 (prefixlen TINYINT [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 423.7 42.4 moveto 172.59 (max_prefixlen TINYINT [PK]) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 423.7 25.6 moveto 101.46 (version TINYINT) alignedtext 0 0 0 nodecolor 14 /Times-Roman set_font 423.7 8.8 moveto 138.79 (roa_id BIGINT [PK,FK]) alignedtext grestore % node10->node11 gsave 1 setlinewidth 0 0 0 edgecolor newpath 510 154.5 moveto 510 145.56 510 136.47 510 127.64 curveto stroke 0 0 0 edgecolor newpath 510 127.4 moveto 514.5 117.4 lineto 510 122.4 lineto 510 117.4 lineto 510 117.4 lineto 510 117.4 lineto 510 122.4 lineto 505.5 117.4 lineto 510 127.4 lineto closepath fill 1 setlinewidth solid 0 0 0 edgecolor newpath 510 127.4 moveto 514.5 117.4 lineto 510 122.4 lineto 510 117.4 lineto 510 117.4 lineto 510 117.4 lineto 510 122.4 lineto 505.5 117.4 lineto 510 127.4 lineto closepath stroke grestore endpage showpage grestore %%PageTrailer %%EndPage: 1 %%Trailer end restore %%EOF