The following tables are added to support many-to-many relationships between Categories, Groups that can service the Categories, and Locations that groups are able to service. This is all used for the Auto-Assignment functionality. Used to build a list of Service Locations valid for the Category.
|
Field |
Data Type |
Reference |
Remarks |
|---|---|---|---|
|
id |
INTEGER UNIQUE NOT_NULL KEY |
|
Unique (to the table) Numeric ID |
|
l_attr |
STRING 30 |
|
left hand attribute name |
|
l_persid |
STRING 60 |
|
left hand key |
|
l_sql |
INTEGER |
|
left hand sort order |
|
r_attr |
STRING 30 |
|
right hand attribute name |
|
r_persid |
STRING 60 |
|
right hand key |
|
r_sql |
INTEGER |
|
right hand sort order |
|
Copyright © 2013 CA.
All rights reserved.
|
|