...
Because we cannot beforehand know how many attribute values we need to store for a given user (multiple emails, group memberships, entitlements) we will store the AA data in a flat table that mimics a key value store.
Database CO_AA
Table attr
| Code Block |
|---|
CREATE TABLE `attr` (
`attr_values_id` int(11) NOT NULL AUTO_INCREMENT,
`v_id` int(11) NOT NULL,
`u_id` int(11) NOT NULL,
`a_id` int(11) NOT NULL,
`a_val` varchar(2048) DEFAULT NULL,
PRIMARY KEY (`attr_values_id`),
KEY `v_id` (`v_id`,`u_id`)
) |