Difference between revisions of "HypertWiki:Sandbox"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
Tene's app chalkboard / back-of-envelope | |||
==Tables== | |||
*'''Markets''' | |||
*'''Stores''' | |||
**id | |||
**name_etc | |||
**type_id | |||
*'''Locations''' | |||
*'''Users''' | |||
*'''Leads''' | |||
**assigned_user_id | |||
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 | |||
Revision as of 21:31, 1 September 2005
Tene's app chalkboard / back-of-envelope
Tables
- Markets
- Stores
- id
- name_etc
- type_id
- Locations
- Users
- Leads
- assigned_user_id
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