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