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 |
|||||
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 |