Tables and Sample Values
To prepare the list of tables, we start with the physical objects or persons we can observe in the sentences built from the documents gathering phase. Then we have a look at all the elements and build new tables to accommodate them.
In the following table descriptions, the table layout is followed by design comments when appropriate.
Code Tables
Usually the following tables are designed first because they are easier to model and they are needed for establishing the relations from more complex tables.
|
table: airport |
column name |
sample value |
|---|---|---|
|
*id |
1 | |
|
international_code |
YUL | |
|
description |
Montreal-Trudeau |
The airport table could contain other columns like the address, phone, and website.
|
table: airline |
column name |
sample ... |
|---|
Get Creating your MySQL Database: Practical Design Tips and Techniques 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.
