How to read the table structure representation
After each of the possible relations I list a table structure that looks something like the following:
B(__b_id__, b_name, fk_b_a*, <b_other>)
The interpretation of this is
- The table is called B
- The primary key consists of the column b_id
- One column in the table is called b_name
- A foreign key embedded in this table is fk_b_a. The asterisk (*) indicates that this is a foreign key. The field name more clearly identifies where the field is located and what table it references. This foreign key is in the B table and references the A table.
- Other information about the B entity is also stored in this table
Return to the ER to SQL page.
page revision: 1, last edited: 20 Aug 2008 15:58