Integrity-Related Terms
Field Specification
A field specification (traditionally known as a domain) represents all the elements of a field. Each field specification incorporates three types of elements: general, physical, and logical.
-
General elements constitute the most fundamental information about the field and include items such as Field Name, Description, and Parent Table.
-
Physical elements determine how a field is built and how it is represented to the person using it. This category includes items such as Data Type, Length, and Display Format.
-
Logical elements describe the values stored in a field and include items such as Required Value, Range of Values, and Default Value.
You'll learn all of the elements associated with ...
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.
