Difference between revisions of "HypertWiki:Sandbox"

From HypertWiki
Jump to navigation Jump to search
 
(2 intermediate revisions by 2 users not shown)
Line 3: Line 3:
==Tables==
==Tables==
*'''Markets'''
*'''Markets'''
**id
**name
*'''Stores'''
*'''Stores'''
**id
**id
**name_etc
**name
**type_id
**info
**market_id
*'''Locations'''
*'''Locations'''
*'''Users'''
*'''Users'''
**id
**name_etc
**type_id - 0 or 1 = location_id->stores.id; 2 = location_id->markets.id
**location_id
*'''Leads'''
*'''Leads'''
**assigned_user_id
**assigned_user_id
**info


Each user has a role_id; possible roles include:
Each user has a role_id; possible roles include:

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