common.data_import_fields

Field Type Null Default Key Extra Comment
dif_id int(11) NO PRI auto_increment Primary key
dif_dirt_id int(11) NO MUL Foreign key
dif_required tinyint(1) NO 0 Indicates if the field is required for import
dif_disabled tinyint(1) NO 0 Indicates if the field is available for import
dif_field_name varchar(100) NO MUL Field name for the Azalea templates (e.g. Patient ID, Last Name)
dif_dift_id int(11) YES MUL Foreign key
dif_db_table varchar(50) YES MUL Name of the database table containing the corresponding field (e.g. patients, insurances_repository)
dif_db_field varchar(100) YES MUL Name of the corresponding database field (e.g. pat_pid_ext, pat_lname)
dif_comments text YES Field name for the Azalea templates (e.g. Patient ID, Last Name)
dif_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
dif_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References