Table | cm_co_petition_attributes |
---|---|
Description | Per-CO enrollment petition attributes |
Column | Format | Description | Definition | Comments |
---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
co_petition_id | integer, foreign key | CO Petition Record ID | cm_co_petitions:id |
|
co_enrollment_attribute_id | integer, foreign key | CO Enrollment Attribute Record ID |
| |
attribute | varchar(80) | Name of this attribute |
| A single co_enrollment_attribute_id can point to more than one attribute, since (eg) the enrollment attribute 'Name' actually has several attributes (given, middle, surname, etc) |
value | varchar(160) | Value of this attribute requested for this Petition |
| Note values are cast to varchar. |
attribute_foreign_key | integer | Row identifier of this value in the table described by co_enrollment_attribute_id |
| The intent of this column is to link the attribute stored in the petition to the table that implements the production value. This linkage is primarily intended for the early part of the petition lifecycle, eg: to edit a petition. There is no referential integrity enforced on this column, and over time the foreign keys may become invalid. |