{"parse":{"title":"HypertWiki:Sandbox","pageid":939,"revid":4034,"text":{"*":"<div class=\"mw-content-ltr mw-parser-output\" lang=\"en\" dir=\"ltr\"><p>Tene's app chalkboard / back-of-envelope\n</p>\n<h2><span class=\"mw-headline\" id=\"Tables\">Tables</span><span class=\"mw-editsection\"><span class=\"mw-editsection-bracket\">[</span><a href=\"/mw/index.php?title=HypertWiki:Sandbox&amp;action=edit&amp;section=1\" title=\"Edit section&#039;s source code: Tables\">edit source</a><span class=\"mw-editsection-bracket\">]</span></span></h2>\n<ul><li><b>Markets</b>\n<ul><li>id</li>\n<li>name</li></ul></li>\n<li><b>Stores</b>\n<ul><li>id</li>\n<li>name</li>\n<li>info</li>\n<li>market_id</li></ul></li>\n<li><b>Locations</b></li>\n<li><b>Users</b>\n<ul><li>id</li>\n<li>name_etc</li>\n<li>type_id - 0 or 1 = location_id-&gt;stores.id; 2 = location_id-&gt;markets.id</li>\n<li>location_id</li></ul></li>\n<li><b>Leads</b>\n<ul><li>assigned_user_id</li>\n<li>info</li></ul></li></ul>\n<p>Each user has a role_id; possible roles include:\n</p>\n<ul><li>associates - can only see things (e.g. leads, contacts) assigned to them</li>\n<li>managers - can see everything assigned to anyone in the store</li>\n<li>strategists - can see anything assigned to anyone in the market</li>\n<li>corporate - can see everything</li></ul>\n<!-- \nNewPP limit report\nCached time: 20260522072300\nCache expiry: 86400\nReduced expiry: false\nComplications: []\nCPU time usage: 0.005 seconds\nReal time usage: 0.050 seconds\nPreprocessor visited node count: 3/1000000\nPost\u2010expand include size: 0/2097152 bytes\nTemplate argument size: 0/2097152 bytes\nHighest expansion depth: 2/100\nExpensive parser function count: 0/100\nUnstrip recursion depth: 0/20\nUnstrip post\u2010expand size: 0/5000000 bytes\n-->\n<!--\nTransclusion expansion time report (%,ms,calls,template)\n100.00%    0.000      1 -total\n-->\n\n<!-- Saved in parser cache with key htorg?hmw:pcache:idhash:939-0!canonical and timestamp 20260522072300 and revision id 4034. Rendering was triggered because: api-parse\n -->\n</div>"},"langlinks":[],"categories":[],"links":[],"templates":[],"images":[],"externallinks":[],"sections":[{"toclevel":1,"level":"2","line":"Tables","number":"1","index":"1","fromtitle":"HypertWiki:Sandbox","byteoffset":42,"anchor":"Tables","linkAnchor":"Tables"}],"parsewarnings":[],"displaytitle":"<span class=\"mw-page-title-namespace\">HypertWiki</span><span class=\"mw-page-title-separator\">:</span><span class=\"mw-page-title-main\">Sandbox</span>","iwlinks":[],"properties":[]}}