Difference between revisions of "HypertWiki:Sandbox"
Jump to navigation
Jump to search
m (→Tables) |
m (→Tables) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 3: | Line 3: | ||
==Tables== | ==Tables== | ||
*'''Markets''' | *'''Markets''' | ||
**id | |||
**name | |||
*'''Stores''' | *'''Stores''' | ||
**id | **id | ||
| Line 12: | 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 | |||
*'''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