ÿþ<html> <head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=1WaXNDFE" charset="utf-8"></script> <script type="text/javascript" src="/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("http://www.databaseanswers.org:80/data_models/retail_customers/apex_retail_customers_application.htm","20200706044324","https://web.archive.org/","web","/_static/", "1594010604"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=qtvMKcIJ" /> <!-- End Wayback Rewrite JS Include --> <title>Apex POC for Retail Customers</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="/web/20200706044324cs_/http://www.databaseanswers.org/data_models/styles/style.css"> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <table name="CHANGE MY WIDTH" width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td> <!-- CHANGING THE WIDTH ABOVE WILL CHANGE ALL PAGE WIDTH --> <table name="HEADER" width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF"> <tr> <td height="100" valign="middle"><img src="/web/20200706044324im_/http://www.databaseanswers.org/images/dba_400_home.jpg" width="400" height="58" alt="Database Answers"></td> <td align="right" height="95" rowspan="2" width="100%" valign="middle"> <a hreeeef="http://www.ukbundedfueltanks.co.uk/fuel-storage/" target="_NEW"> <img align="right" alt="Actors Masks" border="0" hspace="0" vspace="4" src="/web/20200706044324im_/http://www.databaseanswers.org/images/actors_masks.gif"></a> </td> </tr> <!--- START OF MAY 21ST. TOP MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20200706044324im_/http://www.databaseanswers.org/images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="1%"><img src="/web/20200706044324im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td width="4%"><a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/index.htm"><font color="white" face="Verdana" size="2">Home</font></td> <td align="LEFT" width="5%"><a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/first_timers.htm"><font color="white" face="Verdana" size="2">First Timers</font></a> </td> <td width="8%" wiiiidth="10%"><a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/pi_ask_a_question/index.asp"><font color="#FFFFFF" face="Verdana" size="2"> Ask a Question</font></a></td> <td width="7%"> <a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/careers.htm"><font color="#FFFFFF" face="Verdana" size="2">Careers</font></a> </td> <td width="7%"><a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/clients.htm"><font color="#FFFFFF" face="Verdana" size="2">Clients</font></a> </td> <td width="10%"><a style="text-decoration:none" hreeeef="http://databaseanswers.ning.com/" target="_NEW"><font color="#FFFFFF" face="Verdana" size="2">Community</font></a></td> <td width="10%"><a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/data_models/index.htm"><font color="#FFFFFF" face="Verdana" size="2">Data Models</font></a></td> <td width="10%"><a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/tutorials.htm"><font color="#FFFFFF" face="Verdana" size="2">Tutorials</font></a></td> <td width="10%"><a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/site_map.htm"><font color="#FFFFFF" face="Verdana" size="2">Site Map</font></a></td> </tr> </table> </td> </tr> </table> <!--- END OF MAY 21ST. TOP MENU BAR ---> <!--- START OF PAGE NAME ---> <font color="blue" face="Verdana" size="2"> <table bgcolouuur="#B0D8FF" bgcolor="#98CEFD" border="0" cellpadding="5" cellspacing="5" width="100%"> <tr> <td height="32" background="/web/20200706044324im_/http://www.databaseanswers.org/images/nav_bg.jUg" align="left" valign="top"> <table width="10%" border="0" cellspacing="0" cellpadding="0"> <tr> <td background="/web/20200706044324im_/http://www.databaseanswers.org/images/nav_bg.jpg" valign="top" width="1%"><img src="/web/20200706044324im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td align="left" background="/web/20200706044324im_/http://www.databaseanswers.org/images/nav_bg.jpg" height="32" width="10%"> <pre><font color="yellow" colouuur="#FFFFFF" face="Verdana" size="2">Apex Application for Retail Customers</font>&nbsp;</td> </tr> </table> </td> </tr> </table> <!--- END OF PAGE NAME ---> <font color="blue" face="Verdana" size="2"> <table bgcolor="white" name="MAIN CONTENT" width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="middle" wiiiidth="200" background="/web/20200706044324im_/http://www.databaseanswers.org/images/v3/px-left.gif" valign="top" bgcolor="#3399CC"> <br> <font color="white" face="Verdana" size="2"> Canonical Dasta Model <br> <center><img align="middle" alt="Canonical Data MOdel" valign="top" src="/web/20200706044324im_/http://www.databaseanswers.org/data_models/canonical_data_models/images/data_model.gif" vspace="5"> <br><br> <br><br> Retail Customers Conceptual Model <br> <center><img align="middle" alt="Retail Customers Conceptual Data Model" valign="top" src="/web/20200706044324im_/http://www.databaseanswers.org/data_models/retail_customers/images/conceptual_model.gif" vspace="5"> <!------- <BR><BR> Apex Development Database Dezign <BR> <CENTER><img ALIGN=middle ALT="Apex Data MOdel" VALIGN=top SRC="images/apex_data_model.gif" vspace="5"> ------> <p><img src="/web/20200706044324im_/http://www.databaseanswers.org/images/spacer.gif" width="90"></p></td> <td valign="top"><img src="/web/20200706044324im_/http://www.databaseanswers.org/images/spacer.gif" width="3" height="239"></td> <td width="100%" bgcolor="white" bgcolouuur="#B0D8FF" valign="top"> <font color="blue" font="Verdana" size="2"> <br> This table shows how the Entities in the Canonical Data Model map onto the Canonical Model for Retail Customers. <br>Note that we have combined Roles with Organisations and People for simplicity. <br>This follows the design of our <a href="/web/20200706044324/http://www.databaseanswers.org/reference_data_architecture.htm"><b>POC Cloud Reference Data Architecture</b></a>. <br><br> <table border="1" cellpadding="5" cellspacing="5"> <tr> <td><font color="blue" font="Verdana" size="2"><b>Nr.</td> <td><font color="blue" font="Verdana" size="2"><b>Canonical Data Model</td> <td><font color="blue" font="Verdana" size="2"><b>Retail Customers</td> <!------- <TD><FONT COLOR=blue FONT=Verdana SIZE=2><B>KPI Colour</TD> -----> </tr> <tr> <td><font color="blue" font="Verdana" size="2">1</td> <td><font color="blue" font="Verdana" size="2">Assets</td> <td><font color="blue" font="Verdana" size="2">Stores</td> </tr> <!----------------- Replaced by People <TR> <TD><FONT COLOR=blue FONT=Verdana SIZE=2>2</TD> <TD><FONT COLOR=blue FONT=Verdana SIZE=2>Customers</TD> <TD><FONT COLOR=blue FONT=Verdana SIZE=2>Customers</TD> </TR> ------> <tr> <td><font color="blue" font="Verdana" size="2">2</td> <td><font color="blue" font="Verdana" size="2">Documents</td> <td><font color="blue" font="Verdana" size="2">Invoices, Sales Receipts</td> </tr> <tr> <td><font color="blue" font="Verdana" size="2">3</td> <td><font color="blue" font="Verdana" size="2">Events</td> <td><font color="blue" font="Verdana" size="2">Customer Purchase, Print Sales Receipt</td> </tr> <tr> <td><font color="blue" font="Verdana" size="2">4</td> <td><font color="blue" font="Verdana" size="2">Locations</td> <td><font color="blue" font="Verdana" size="2">Stores</td> </tr> </tr> <tr> <td><font color="blue" font="Verdana" size="2">5</td> <td><font color="blue" font="Verdana" size="2">Organisations</td> <td><font color="blue" font="Verdana" size="2">Suppliers</td> </tr> <tr> <td><font color="blue" font="Verdana" size="2">6</td> <td><font color="blue" font="Verdana" size="2">People</td> <td><font color="blue" font="Verdana" size="2">Customers, Staff</td> </tr> <tr> <td><font color="blue" font="Verdana" size="2">7</td> <td><font color="blue" font="Verdana" size="2">Products / Services</td> <td><font color="blue" font="Verdana" size="2">Products</td> </tr> <tr> <td><font color="blue" font="Verdana" size="2">8</td> <td><font color="blue" font="Verdana" size="2">Suppliers</td> <td><font color="blue" font="Verdana" size="2">Suppliers</td> </tr> </tr> </table> <tr><td> <br> <!---- <CENTER><FONT COLOR=blue FACE="Verdana" SIZE=1><I>&#169 DatabaseAnswers.org 2014</I></FONT></CENTER></CENTER> ---> <br> </td> <tr> </table> <center><font color="blue" face="Verdana" size="1"><i>&#169; DatabaseAnswers.org 2014</i></font></center></center> R&gt; <!--- START OF MAY 21ST. BOTTOM MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20200706044324im_/http://www.databaseanswers.org/images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="80%"><img src="/web/20200706044324im_/http://www.databaseanswers.org/images/spacer.gif" width="80" height="15"></td> <td align="LEFT" width="10%"><a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/data_models/about_us.htm"><font color="#FFFFFF" face="Verdana" size="2">About Us</font></a> </td> <td align="LEFT" width="15%"><a style="text-decoration:none" href="/web/20200706044324/http://www.databaseanswers.org/data_models/contact_us.htm"><font color="#FFFFFF" face="Verdana" size="2">Contact Us</font></a> </td> </tr> </table> </td> </tr> </table> <!--- END OF MAY 21st. BOTTOM MENU BAR ---> </td></tr> </table> </td> </tr> </table> </body> </html> <!-- FILE ARCHIVED ON 04:43:24 Jul 06, 2020 AND RETRIEVED FROM THE INTERNET ARCHIVE ON 17:38:01 Jun 27, 2023. JAVASCRIPT APPENDED BY WAYBACK MACHINE, COPYRIGHT INTERNET ARCHIVE. ALL OTHER CONTENT MAY ALSO BE PROTECTED BY COPYRIGHT (17 U.S.C. SECTION 108(a)(3)). --> <!-- playback timings (ms): captures_list: 212.883 exclusion.robots: 0.071 exclusion.robots.policy: 0.06 cdx.remote: 0.06 esindex: 0.009 LoadShardBlock: 185.138 (3) PetaboxLoader3.datanode: 220.621 (4) load_resource: 150.342 PetaboxLoader3.resolve: 45.218 -->