How to read the SQL create statements

At the end of the discussion of each relation I list the SQL create statements needed to create the tables necessary to represent the relation. The statement looks something like the following:

create table A (
   a_id type,
   a_name type,
   primary key (a_id));

The interpretation of this is

  • The table is called A
  • There are two columns, a_id and a_name, of indeterminate type
  • There are zero or more columns (<a_other>) about the A entity
  • The primary key is a_id

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