Category Manager

This describes possible "category manager" sub-systems that can potentially be used to manage "big wads" of categories often found in larger organizations.

[Under Constru

---

Sample Schema

 categories  // table
 ------------
 categ_id  
 title     // consider enforcing uniqueness
 descript
 starts_on  // date/time
 expires_on  // date/time
 created_by
 created_on   // date/time
 changed_by   
 changed_on   // date/time 

 categ_assoc  // table
 ---------------
 categ_ref_1  // considered the "from" if using directional associations
 categ_ref_2  // considered the "to" if using direction assocations
 starts_on  // date/time
 expires_on  // date/time
 created_by
 created_on   // date/time
 changed_by   
 changed_on   // date/time 

 (Note: consider moving the created/changed info to a log instead of the main schema.)

---

Sample Screens:

  -----------------------------
  Search Category: [___________]  [contains|v]   // typical starts-with, ends-with, etc. matching
  .
  Title..............Last-Modified.......Actions
  -----------------------------------------------------
  Discount...........12/12/2012.........[Details][Edit]
  Holiday Discount...12/13/2012.........[Details][Edit]
  Surplus Pricing....12/13/2012.........[Details][Edit]