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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
