Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
primary key identifier |
|||
| tablename | VARCHAR | 255 |
|
|
tablename of the new field |
|||||
| name | VARCHAR | 255 |
|
|
name of the field |
|||||
| VARCHAR | 32 |
|
|
is an authorised value category |
||||||
| marcfield | VARCHAR | 16 |
|
|
contains the marc field to copied into the record |
|||||
| marcfield_mode | enum('get', 'set') | 4 | get |
|
|
mode of operation (get or set) for marcfield |
||||
| searchable | BIT | 0 | 0 |
|
|
is the field searchable? |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| fields_uniq | Must be unique | Asc/Asc | tablename + name |
Relationships
Close relationships within degrees of separation
