HypertWiki:Sandbox

From HypertWiki
Revision as of 21:36, 1 September 2005 by Woozle (talk | contribs) (→‎Tables)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Tene's app chalkboard / back-of-envelope

Tables

  • Markets
    • id
    • name
  • Stores
    • id
    • name
    • info
    • market_id
  • Locations
  • Users
    • id
    • name_etc
    • type_id - 0 or 1 = location_id->stores.id; 2 = location_id->markets.id
    • location_id
  • Leads
    • assigned_user_id
    • info

Each user has a role_id; possible roles include:

  • associates - can only see things (e.g. leads, contacts) assigned to them
  • managers - can see everything assigned to anyone in the store
  • strategists - can see anything assigned to anyone in the market
  • corporate - can see everything