Symbolic field names

As with table names, you specify symbolic field names using the following syntax:

db.field.name.<symbolic_field_name> = <internal_field_name>

By default, these settings are as follows:

db.field.name.adj_count = adj_count
db.field.name.avrg_rtg = avrg_rtg
db.field.name.genre_id = genre_id
db.field.name.image = image
db.field.name.item_id = item_id
db.field.name.label = label
db.field.name.name = name
db.field.name.num_item = num_item
db.field.name.num_mentors = num_mentors
db.field.name.num_rtg = num_rtg

Fields that occur in multiple tables must have the same name, in order to maintain the tables' referential integrity. For example, the item_id field must have the same name in every table in which it occurs.

Parent topic: Mapping symbolic database table and field names


Home |