Anatomy of a Field Specification

A field specification incorporates various elements that define every attribute of a field. All of the elements within the specification are categorized as general elements, physical elements, or logical elements. These element categories enable you to focus on a distinct aspect of the field as you're defining the specification, and they provide a way for you to find a particular element quite easily.

Here are the elements within each category:

  • General Elements: Field Name, Parent Table, Label, Specification Type, Source Specification, Shared By, Alias(es), Description

  • Physical Elements: Data Type, Length, Decimal Places, Character Support, Input Mask, Display Format

  • Logical Elements: Key Type, Key Structure, ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.