common.data_import_field_types
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| dift_id | int(11) | NO | PRI | auto_increment | Primary key | |
| dift_type | varchar(50) | NO | MUL | Name of the field type, for example: DOB, Gender | ||
| dift_function | varchar(100) | NO | The name of the barebones function used to format/parse the data | |||
| dift_divt_id | int(11) | YES | MUL | Foreign key | ||
| dift_comments | text | YES | Any comments/notes related to this field type | |||
| dift_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| dift_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||
|---|---|---|---|---|---|
| dift_id |
|