Difference between revisions of "HypertWiki:Sandbox"

From HypertWiki
Jump to navigation Jump to search
 
Line 14: Line 14:
**id
**id
**name_etc
**name_etc
**type_id
**type_id - 0 or 1 = location_id->stores.id; 2 = location_id->markets.id
**location_id
**location_id
*'''Leads'''
*'''Leads'''

Latest revision as of 21:36, 1 September 2005

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