<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1235160711;
mso-list-type:hybrid;
mso-list-template-ids:363789064 -1101081030 536870915 536870917 536870913 536870915 536870917 536870913 536870915 536870917;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:\F0D8;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:Calibri;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=en-SE link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-US'>Wayne,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-US'>Thanks for the comments, this gives me a bit more insight into the organization. <o:p></o:p></span></p><p class=MsoNormal><span lang=en-SE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><ul style='margin-top:0cm' type=disc><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo1'>- Interested Parties can be individuals. How will that be handled? (e.g. create a dummy org for each individual?)<o:p></o:p></li><ul style='margin-top:0cm' type=circle><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level2 lfo1'><span lang=EN-US>From what I gathered from the V2 registry, they’re currently entered as a Member_Org as well with their personal name. At current, the system already supports this method. Do we want to keep this? Perhaps we could keep this method of operating, but add a “isIndividual” flag to the organization for more clarity.</span><o:p></o:p></li></ul></ul><p class=MsoListParagraph><o:p> </o:p></p><ul style='margin-top:0cm' type=disc><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo1'>If we're going to eventually use this system to drive mailing list subscriptions, then we need to be able to define subcommittees. We may be able to just use the existing group structure, but there are some differences (e.g. subcommittees don't vote, and you need to be a member of the WG to join a SC).<o:p></o:p></li><ul style='margin-top:0cm' type=circle><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level2 lfo1'><span lang=EN-US>So, yes, my original idea was to use the Forum Group functions for this. It’s specifically why I didn’t call it Working Groups in the system. </span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level2 lfo1'><span lang=EN-US>Regarding the differences:</span><o:p></o:p></li><ul style='margin-top:0cm' type=square><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level3 lfo1'><span lang=EN-US>“No voting for subcommittees”: I’ve translated it currently as the fact that voting is done only on ballots. Ballots in turn are connected to a forum group. Technically that could means someone could create a ballot for a subcommittee in the system, but I’m kind of trusting that the members using the system will abide by the rules already in place. Not that only administrators (which all Chairs and Vice-Chairs should be) can create ballots and register votes that have been done by email. </span><o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level3 lfo1'><span lang=EN-US>“Y</span>ou need to be a member of the WG to join a SC<span lang=EN-US>”: We should be able to tackle that technically I suppose, setting that group B (a subcommittee) “belongs to” group A (a WG). </span><o:p></o:p></li></ul></ul></ul><p class=MsoListParagraph><o:p> </o:p></p><ul style='margin-top:0cm' type=disc><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo1'>- I'm assuming that there won't be a "Forum" group since the bylaws dictate that Forum membership is a function of WG membership. We'll just need to be able to aggregate WG membership to create attendance lists for Forum meetings.<o:p></o:p></li><ul style='margin-top:0cm' type=circle><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level2 lfo1'><span lang=EN-US>My idea was that it would have, since it does have meetings and thus attendance registration and minutes. I may need more clarity on this item though. Perhaps we can discuss more, or on the next call.</span><o:p></o:p></li></ul></ul><p class=MsoListParagraph><o:p> </o:p></p><ul style='margin-top:0cm' type=disc><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level1 lfo1'>- It'd be nice to add a column to member orgs to track IPR agreements. This could be a URL to the signed agreement. Individual Interested Parties also sign these agreements<span lang=EN-US>.</span><o:p></o:p></li><ul style='margin-top:0cm' type=circle><li class=MsoListParagraph style='margin-left:0cm;mso-list:l0 level2 lfo1'><span lang=EN-US>I’ll incorporate that, no problem!</span><o:p></o:p></li></ul></ul><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US>Regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Martijn<o:p></o:p></span></p><p class=MsoNormal><span lang=en-SE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US>From:</span></b><span lang=EN-US> Wayne Thayer <wthayer@gmail.com> <br><b>Sent:</b> Friday, 11 March 2022 18:10<br><b>To:</b> Martijn Katerbarg <martijn.katerbarg@sectigo.com><br><b>Cc:</b> infrastructure@cabforum.org<br><b>Subject:</b> Re: [Infrastructure] Member management database structure<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div style='border:solid black 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt'><p class=MsoNormal style='line-height:12.0pt;background:#FAFA03'><span style='font-size:10.0pt;color:black'>CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><div><p class=MsoNormal>Martijn,<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>The schema looks quite comprehensive! Here are a few additional ideas to consider:<o:p></o:p></p></div><div><p class=MsoNormal>- Interested Parties can be individuals. How will that be handled? (e.g. create a dummy org for each individual?)<o:p></o:p></p></div><div><p class=MsoNormal>- If we're going to eventually use this system to drive mailing list subscriptions, then we need to be able to define subcommittees. We may be able to just use the existing group structure, but there are some differences (e.g. subcommittees don't vote, and you need to be a member of the WG to join a SC).<o:p></o:p></p></div><div><p class=MsoNormal>- I'm assuming that there won't be a "Forum" group since the bylaws dictate that Forum membership is a function of WG membership. We'll just need to be able to aggregate WG membership to create attendance lists for Forum meetings.<o:p></o:p></p></div><div><p class=MsoNormal>- It'd be nice to add a column to member orgs to track IPR agreements. This could be a URL to the signed agreement. Individual Interested Parties also sign these agreements<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thanks,<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Wayne<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Wed, Mar 9, 2022 at 9:47 AM Martijn Katerbarg via Infrastructure <<a href="mailto:infrastructure@cabforum.org">infrastructure@cabforum.org</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Hi all,</span><span lang=en-SE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><span lang=en-SE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>As just discussed on the call, attached is a diagram of the current database setup for the new member management system.</span><span lang=en-SE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><span lang=en-SE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>As Wayne pointed out, there have been requests to have specific members (type people) that should have voting rights in 1 WG, but not in another. This part has not been included in this version, but I’ll get working on that.</span><span lang=en-SE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> </span><span lang=en-SE><o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Regards,<br><br>Martijn</span><span lang=en-SE><o:p></o:p></span></p></div></div><p class=MsoNormal>_______________________________________________<br>Infrastructure mailing list<br><a href="mailto:Infrastructure@cabforum.org" target="_blank">Infrastructure@cabforum.org</a><br><a href="https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.cabforum.org%2Fmailman%2Flistinfo%2Finfrastructure&data=04%7C01%7Cmartijn.katerbarg%40sectigo.com%7C601ee1807d264b901c8708da03820684%7C0e9c48946caa465d96604b6968b49fb7%7C0%7C0%7C637826154244720258%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=vddqmhpze2da%2Fo%2B34IAYiDQScKTmgM8ExBh1MOzwk0s%3D&reserved=0" target="_blank">https://lists.cabforum.org/mailman/listinfo/infrastructure</a><o:p></o:p></p></blockquote></div></div></div></body></html>