View source for 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