DokuWiki Instructions (local)
DokuWiki Manual
Site Checker (Orphans Wanted)
This is an old revision of the document!
| Table Name | Column | Spec | Notes |
|---|---|---|---|
| ORGAN_STOP | _ID | varchar(100) | Main ID, required field, value suggest by Android (1) |
| ROOT_ID | varchar(100) | Specifies the main root ID, if this is a synonym | |
| NAME | varchar(200) | Stop Name | |
| NAME_LANGUAGE | varchar(100) | Language of the stop name, e.g., German, Dutch | |
| SUBTYPE | varchar(100) | Sub-Type, such as “mixture” or “percussion” |
create table ORGAN_STOP (_ID varchar(100) PRIMARY KEY, ROOT_ID varchar(100), NAME varchar(200), NAME_LANGUAGE varchar(100), SUBTYPE varchar(100))
Tool to make ER database diagrams: http://highered.mcgraw-hill.com/sites/0072942207/student_view0/e_r_assistant.html
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))
