diff options
-rw-r--r-- | rpkid/doc/irdbd.dot | 1 | ||||
-rw-r--r-- | rpkid/doc/irdbd.eps | 44 | ||||
-rw-r--r-- | rpkid/doc/irdbd.png | bin | 5391 -> 6668 bytes | |||
-rw-r--r-- | rpkid/doc/rpkid.dot | 3 | ||||
-rw-r--r-- | rpkid/doc/rpkid.eps | 1115 | ||||
-rw-r--r-- | rpkid/doc/rpkid.png | bin | 25260 -> 27767 bytes |
6 files changed, 660 insertions, 503 deletions
diff --git a/rpkid/doc/irdbd.dot b/rpkid/doc/irdbd.dot index 8541092d..42bafefc 100644 --- a/rpkid/doc/irdbd.dot +++ b/rpkid/doc/irdbd.dot @@ -9,6 +9,7 @@ digraph test { node3 [label="{registrant_net\n|registrant_net_id\ SERIAL\ [PK]\lstart_ip\ VARCHAR\lend_ip\ VARCHAR\lversion\ TINYINT\lregistrant_id\ BIGINT\ [FK]\l}"]; node4 [label="{roa_request\n|roa_request_id\ SERIAL\ [PK]\lroa_request_handle\ VARCHAR\lasn\ BIGINT\l}"]; node5 [label="{roa_request_prefix\n|prefix\ VARCHAR\ [PK]\lprefixlen\ TINYINT\ [PK]\lmax_prefixlen\ TINYINT\ [PK]\lversion\ TINYINT\lroa_request_id\ BIGINT\ [PK,FK]\l}"]; + node6 [label="{ghostbuster_request\n|ghostbuster_request_id\ SERIAL\ [PK]\lself_handle\ VARCHAR\lparent_handle\ VARCHAR\ [N]\lvcard\ LONGBLOB\l}"]; node1 -> node2 [arrowtail=none, arrowhead=crow]; node1 -> node3 [arrowtail=none, arrowhead=crow]; node4 -> node5 [arrowtail=none, arrowhead=crow]; diff --git a/rpkid/doc/irdbd.eps b/rpkid/doc/irdbd.eps index 60f7fd43..28e869a5 100644 --- a/rpkid/doc/irdbd.eps +++ b/rpkid/doc/irdbd.eps @@ -2,7 +2,7 @@ %%Creator: graphviz version 2.26.3 (20100126.1600) %%Title: test %%Pages: 1 -%%BoundingBox: 36 36 672 316 +%%BoundingBox: 36 36 916 316 %%EndComments save %%BeginProlog @@ -178,11 +178,11 @@ def %%EndSetup setupLatin1 %%Page: 1 1 -%%PageBoundingBox: 36 36 672 316 +%%PageBoundingBox: 36 36 916 316 %%PageOrientation: Portrait 0 0 1 beginpage gsave -36 36 636 280 boxprim clip newpath +36 36 880 280 boxprim clip newpath 1 1 set_scale 0 rotate 40 41 translate % node1 gsave @@ -476,6 +476,44 @@ newpath 527 127.47 moveto 527 127.47 lineto closepath stroke grestore +% node6 +gsave +0 0 1 nodecolor +newpath 643.47 163 moveto +643.47 263 lineto +872.53 263 lineto +872.53 163 lineto +closepath fill +1 setlinewidth +filled +0 0 0 nodecolor +newpath 643.47 163 moveto +643.47 263 lineto +872.53 263 lineto +872.53 163 lineto +closepath stroke +0 0 0 nodecolor +14 /Times-Roman set_font +702.01 246.4 moveto 111.97 (ghostbuster_request) alignedtext +1 setlinewidth +filled +0 0 0 nodecolor +newpath 643.47 238.2 moveto +872.53 238.2 lineto +stroke +0 0 0 nodecolor +14 /Times-Roman set_font +651.47 221.6 moveto 213.06 (ghostbuster_request_id SERIAL [PK]) alignedtext +0 0 0 nodecolor +14 /Times-Roman set_font +651.47 204.8 moveto 136.47 (self_handle VARCHAR) alignedtext +0 0 0 nodecolor +14 /Times-Roman set_font +651.47 188 moveto 174.16 (parent_handle VARCHAR [N]) alignedtext +0 0 0 nodecolor +14 /Times-Roman set_font +651.47 171.2 moveto 110.79 (vcard LONGBLOB) alignedtext +grestore endpage showpage grestore diff --git a/rpkid/doc/irdbd.png b/rpkid/doc/irdbd.png Binary files differindex ea28dab0..fadc04f0 100644 --- a/rpkid/doc/irdbd.png +++ b/rpkid/doc/irdbd.png diff --git a/rpkid/doc/rpkid.dot b/rpkid/doc/rpkid.dot index 037905eb..7d8d33da 100644 --- a/rpkid/doc/rpkid.dot +++ b/rpkid/doc/rpkid.dot @@ -15,11 +15,13 @@ digraph test { node9 [label="{revoked_cert\n|revoked_cert_id\ SERIAL\ [PK]\lserial\ BIGINT\lrevoked\ DATETIME\lexpires\ DATETIME\lca_detail_id\ BIGINT\ [FK]\l}"]; node10 [label="{roa\n|roa_id\ SERIAL\ [PK]\lasn\ BIGINT\lcert\ LONGBLOB\lroa\ LONGBLOB\lpublished\ DATETIME\ [N]\lself_id\ BIGINT\ [FK]\lca_detail_id\ BIGINT\ [FK]\l}"]; node11 [label="{roa_prefix\n|prefix\ VARCHAR\ [PK]\lprefixlen\ TINYINT\ [PK]\lmax_prefixlen\ TINYINT\ [PK]\lversion\ TINYINT\lroa_id\ BIGINT\ [PK,FK]\l}"]; + node12 [label="{ghostbuster\n|ghostbuster_id\ SERIAL\ [PK]\lvcard\ LONGBLOB\lcert\ LONGBLOB\lghostbuster\ LONGBLOB\lpublished\ DATETIME\ [N]\lself_id\ BIGINT\ [FK]\lca_detail_id\ BIGINT\ [FK]\l}"]; node2 -> node7 [arrowtail=none, arrowhead=crow]; node2 -> node4 [arrowtail=none, arrowhead=crow]; node2 -> node3 [arrowtail=none, arrowhead=crow]; node5 -> node6 [arrowtail=none, arrowhead=crow]; node6 -> node8 [arrowtail=none, arrowhead=crow]; + node6 -> node12 [arrowtail=none, arrowhead=crow]; node6 -> node9 [arrowtail=none, arrowhead=crow]; node6 -> node10 [arrowtail=none, arrowhead=crow]; node7 -> node8 [arrowtail=none, arrowhead=crow]; @@ -28,6 +30,7 @@ digraph test { node10 -> node11 [arrowtail=none, arrowhead=crow]; node1 -> node2 [arrowtail=none, arrowhead=crow]; node1 -> node7 [arrowtail=none, arrowhead=crow]; + node1 -> node12 [arrowtail=none, arrowhead=crow]; node1 -> node4 [arrowtail=none, arrowhead=crow]; node1 -> node3 [arrowtail=none, arrowhead=crow]; node1 -> node10 [arrowtail=none, arrowhead=crow]; diff --git a/rpkid/doc/rpkid.eps b/rpkid/doc/rpkid.eps index 75644e0e..73284be5 100644 --- a/rpkid/doc/rpkid.eps +++ b/rpkid/doc/rpkid.eps @@ -2,7 +2,7 @@ %%Creator: graphviz version 2.26.3 (20100126.1600) %%Title: test %%Pages: 1 -%%BoundingBox: 36 36 716 1746 +%%BoundingBox: 36 36 838 1746 %%EndComments save %%BeginProlog @@ -178,139 +178,139 @@ def %%EndSetup setupLatin1 %%Page: 1 1 -%%PageBoundingBox: 36 36 716 1746 +%%PageBoundingBox: 36 36 838 1746 %%PageOrientation: Portrait 0 0 1 beginpage gsave -36 36 680 1710 boxprim clip newpath +36 36 802 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 +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 310.3 1550.8 moveto -310.3 1701.2 lineto -485.7 1701.2 lineto -485.7 1550.8 lineto +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 -387.89 1684.6 moveto 20.21 (self) alignedtext +484.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 +newpath 407.3 1676.4 moveto +582.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 +415.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 +415.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 +415.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 +415.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 +415.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 +415.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 +415.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 +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 156.2 1346.4 moveto -156.2 1513.6 lineto -365.8 1513.6 lineto -365.8 1346.4 lineto +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 -251.67 1497 moveto 18.66 (bsc) alignedtext +277.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 +newpath 182.2 1488.8 moveto +391.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 +190.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 +190.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 +190.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 +190.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 +190.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 +190.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 +190.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 +190.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 +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 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 +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 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 +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 @@ -367,127 +367,127 @@ grestore gsave 1 setlinewidth 0 0 0 edgecolor -newpath 398 1550.76 moveto -398 1485.41 398 1390.45 398 1320.08 curveto +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 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 +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 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 +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 280.86 870.8 moveto -280.86 1105.2 lineto -509.14 1105.2 lineto -509.14 870.8 lineto +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 280.86 870.8 moveto -280.86 1105.2 lineto -509.14 1105.2 lineto -509.14 870.8 lineto +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 -377.51 1088.6 moveto 34.98 (parent) alignedtext +380.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 +newpath 283.86 1080.4 moveto +512.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 +291.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 +291.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 +291.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 +291.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 +291.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 +291.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 +291.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 +291.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 +291.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 +291.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 +291.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 +291.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 +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.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 +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.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 +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 @@ -541,715 +541,830 @@ grestore 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 +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 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 +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 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 +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 493.8 154.8 moveto -493.8 305.2 lineto -662.2 305.2 lineto -662.2 154.8 lineto +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 493.8 154.8 moveto -493.8 305.2 lineto -662.2 305.2 lineto -662.2 154.8 lineto +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 -569.06 288.6 moveto 17.88 (roa) alignedtext +501.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 +newpath 425.8 280.4 moveto +594.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 +433.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 +433.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 +433.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 +433.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 +433.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 +433.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 +433.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 +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 591.33 578 417.01 578 315.52 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 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 +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 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 +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 317.32 1346.14 moveto -323.48 1336.97 329.77 1327.6 335.99 1318.33 curveto +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 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 +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 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 +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 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 +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.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 +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.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 +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 200.57 1346.14 moveto -191.89 1334.09 182.95 1321.68 174.27 1309.64 curveto +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 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 +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 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 +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 396.94 1142.09 moveto -396.83 1133.44 396.72 1124.51 396.61 1115.52 curveto +newpath 398 1142.09 moveto +398 1133.44 398 1124.51 398 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 +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 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 +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 274.21 649 moveto -274.21 833 lineto -511.79 833 lineto -511.79 649 lineto +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 274.21 649 moveto -274.21 833 lineto -511.79 833 lineto -511.79 649 lineto +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 -386.79 816.4 moveto 12.43 (ca) alignedtext +391.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 +newpath 279.21 808.2 moveto +516.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 +287.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 +287.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 +287.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 +287.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 +287.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 +287.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 +287.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 +287.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 +287.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 +newpath 398 870.65 moveto +398 861.51 398 852.34 398 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 +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 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 +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 256.09 343 moveto -256.09 611 lineto -513.91 611 lineto -513.91 343 lineto +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 256.09 343 moveto -256.09 611 lineto -513.91 611 lineto -513.91 343 lineto +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 -359.73 594.4 moveto 50.53 (ca_detail) alignedtext +372.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 +newpath 269.09 586.2 moveto +526.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 +277.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 +277.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 +277.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 +277.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 +277.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 +277.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 +277.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 +277.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 +277.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 +277.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 +277.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 +277.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 +277.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 +277.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 +newpath 398 648.67 moveto +398 639.71 398 630.49 398 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 +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 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 +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 78.47 163.2 moveto -78.47 296.8 lineto -251.53 296.8 lineto -251.53 163.2 lineto +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 78.47 163.2 moveto -78.47 296.8 lineto -251.53 296.8 lineto -251.53 163.2 lineto +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 -137.01 280.2 moveto 55.98 (child_cert) alignedtext +86.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 +newpath 27.47 272 moveto +200.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 +35.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 +35.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 +35.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 +35.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 +35.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 +35.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 +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 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 +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 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 +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 285.92 171.6 moveto -285.92 288.4 lineto -476.08 288.4 lineto -476.08 171.6 lineto +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 285.92 171.6 moveto -285.92 288.4 lineto -476.08 288.4 lineto -476.08 171.6 lineto +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 -344.46 271.8 moveto 73.07 (revoked_cert) alignedtext +276.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 +newpath 217.92 263.6 moveto +408.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 +225.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 +225.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 +225.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 +225.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 +225.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 +newpath 351.77 342.66 moveto +346.45 327.21 341.22 312 336.4 297.98 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 +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 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 +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 489.97 342.66 moveto -497.78 332.67 505.51 322.78 512.96 313.24 curveto +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 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 +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 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 +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 117.85 1150.73 moveto -127.29 966.37 151.5 493.71 161.04 307.28 curveto +newpath 114 1150.73 moveto +114 966.37 114 493.71 114 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 +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 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 +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 483.7 .6 moveto -483.7 117.4 lineto -672.3 117.4 lineto -672.3 .6 lineto +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 483.7 .6 moveto -483.7 117.4 lineto -672.3 117.4 lineto -672.3 .6 lineto +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 -548.85 100.8 moveto 58.3 (roa_prefix) alignedtext +480.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 +newpath 415.7 92.6 moveto +604.3 92.6 lineto stroke 0 0 0 nodecolor 14 /Times-Roman set_font -491.7 76 moveto 136.07 (prefix VARCHAR [PK]) alignedtext +423.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 +423.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 +423.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 +423.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 +423.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 +newpath 510 154.5 moveto +510 145.56 510 136.47 510 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 +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 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 +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 diff --git a/rpkid/doc/rpkid.png b/rpkid/doc/rpkid.png Binary files differindex ad3bae2e..e5d1cbb4 100644 --- a/rpkid/doc/rpkid.png +++ b/rpkid/doc/rpkid.png |