Legend

This legend is a guide to reading and interpreting the table listings under 0NF through 3NF.

• TableName: - Table names will be bolded and end with a colon. (e.g.: **TableName:**)
• (Column, Names) - Column names for a table will be enclosed in (rounded parenthesis).
• PrimaryKeyFields - Primary key fields will be bold and inside a box. (e.g: <b class="pk">PrimaryKeyFields</b>)
• ForeignKeyFields - Foreign key fields will be a wavy underline in italic and green. (e.g.: <u class="fk">ForeignKeyFields</u>)
• {Repeating Groups} - Groups of repeating fields will be identified in 0NF stage, and will be enclosed in orange curly braces. (e.g.: <b class="rg">{</b>Repeating, Group, Fields<b class="rg">}</b>)

Styling

Most of the styling is done by the default conversion from Markdown (.md) to Markup (.html). Additional styling for primary keys, foreign keys, and notes are made through the following stylesheet. Note: Mardown text can include regular HTML elements, but not all elements are rendered on GitHub.com by default (such as the <style> and <script> elements).

<style type="text/css">
.md {
    display: inline-block;
    vertical-align: top;
    white-space:normal;
}
.md::before {
    content: '(';
    font-size: 1.25em;
    font-weight: bold;
}
.md::after {
    content: ')';
    font-size: 1.25em;
    font-weight: bold;
}
.pk {
    font-weight: 700;
    display: inline-block;
    border: thin solid #00f;
    padding: 0 2px;
    position: relative;
}
.pk::before {
    content: 'P';
    font-size:.55em;
    font-weight: bold;
    color: white;
    background-color: #72c4f7;
    position: absolute;
    left: -5px;
    top: -15px;
    border-radius: 50%;
    border: solid thin blue;
    width: 1.4em;
    height: 1.4em;
    padding:3px;
    text-align:center;
}
.fk {
    color: green;
    font-style: italic;
    text-decoration: wavy underline green;
    padding: 0 2px;
    position: relative;
}
.fk::before {
    content: 'F';
    font-size:.65em;
    position: absolute;
    left: -1px;
    bottom: -17px;
    color:darkgreen;
    background-color: #a7dea7;
    border-radius: 50%;
    border: dashed thin green;
    width: 1.4em;
    height: 1.4em;
    padding:3px;
    text-align:center;
}
.rg::before {
    content: '\007B';
    color: darkorange;
    font-size: 1.2em;
    font-weight: bold;
}
.rg::after {
    content: '\007D';
    color: darkorange;
    font-size: 1.2em;
    font-weight: bold;
}
.rg {
    display: inline-block;
    color: inherit;
    font-size: 1em;
    font-weight: normal;
}
.note {
    font-weight: bold;
    color: brown;
    font-size: 1.1em;
}
</style>