HypertWiki:Sandbox

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