DataDictionary


Description

Data field dictionary defining field metadata, descriptions, and custom naming for database fields. This data dictionary table manages field definitions with their descriptions, data types, categories, and custom names to support data documentation, field customization, and metadata management for healthcare data systems.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
FieldID int identity 4 √ null
Fields.fkDataDictionaryID FK_Fields_DataDictionary R

Primary key - Unique identifier for each field definition
FieldName varchar 50 √ null

Field name - Original database field name
FieldDesc varchar 500 √ null

Field description - Description of the field purpose and content
DataType varchar 20 √ null

Data type - Data type of the field (varchar, int, datetime, etc.)
Category varchar 20 √ null

Field category - Category or grouping for the field
CustomFieldName varchar 100 √ null

Custom field name - User-defined custom name for the field
CustomFieldDesc varchar 500 √ null

Custom field description - User-defined custom description for the field

Indexes

Constraint Name Type Sort Column(s)
PK__DataDictionary__47BEE010 Primary key Asc FieldID

Relationships

Close relationships within degrees of separation