create table ORGAN_STOP (_ID varchar(100) PRIMARY KEY, 
ROOT_ID varchar(100),
NAME varchar(200),
NAME_LANGUAGE varchar(100),
SUBTYPE varchar(100))

Simpleton tool to make ER database diagrams: http://highered.mcgraw-hill.com/sites/0072942207/student_view0/e_r_assistant.html - Decided not to use this because can't see a way to change the size of the Entity boxes.

Now using DBVisualizer, Free version. This lets you type SQL and modify the underlying SQLite DB, and it will draw the relationships. I added “Foreign Key” references to support this.

• DBVisualizer Docs

• Stop
  • _ID
  • Name
  • Root Stop ID (for Synonym stop names)
  • Language (German, Dutch, etc.)
  • Type (Reed, flue, etc.)
  • Description
• Manual Type
  • _ID
  • Name (Pedal, Great, Echo, etc.)
• Organ
  • _ID
  • Name
  • Location_ID
• Location
  • _ID
  • ADDRESS_1
  • ADDRESS_2
  • CITY
  • STATE
  • COUNTRY
  • POSTAL_CODE
• Manual For Organ
  • _ID
  • MANUAL_TYPE_ID
  • ORGAN_ID
• Stop For Manual
  • _ID
  • MANUAL_ID
  • STOP_ID
  • PIPE_SIZE_ID
  • MINIMUM_NOTE (e.g., C1)
  • MAXIMUM_NOTE (e.g., C5)

create table STOP_FOR_MANUAL(_ID integer primary key, MANUAL_ID integer, STOP_ID integer, PIPE_SIZE_ID integer, MINIMUM_NOTE varchar(5), MAXIMUM_NOTE varchar(5))

• Coupler For Manual
  • _ID
  • CONTROLLER_MANUAL_ID
  • SOUNDING_MANUAL_ID