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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License