path: root/rpkid/doc/rpkid.eps

%!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