Table SQL definition for table Dubbasic
Number of columns=6Field | Type | Null | Key | Default | Extra |
|---|
| dnr | int(6) | NO | PRI | 0 | |
Uub | char(20) | YES | | | | DubNr | int(6) | YES | | | | WName | char(30) | YES | | | | WTitle | char(60) | YES | | | | TitleNr | int(2) | YES | | | | Full_title | varchar(500) | YES | | | | Scoring | char(254) | YES | | | | VolSig | char(25) | YES | | | | VolOrd | char(10) | YES | | | | VolPage | char(25) | YES | | | | Vnr | int(6) | YES | | | | Volpage1 | int(3) | YES | | | | Volpage2 | char(1) | YES | | | | Volpage3 | int(3) | YES | | | | Volpage4 | char(1) | YES | | | | Notation | char(10) | YES | | | | Format | char(5) | YES | | | | TintenNr | int(4) | YES | | | | Date | char(15) | YES | | | | Dateref | char(30) | YES | | | | Feast | char(50) | YES | | | | Lang | char(10) | YES | | | | Genorig | char(30) | YES | | | | Lit | char(254) | YES | | | | Voices | char(5) | YES | | | | Strings | char(4) | YES | | | | Winds | char(3) | YES | | | | Brass | char(2) | YES | | | | Skbd | char(2) | YES | | | | Bc | char(50) | YES | | | | Doubling | char(30) | YES | | | | Cap | char(1) | YES | | | | Rip | char(1) | YES | | | | Scorecom | char(254) | YES | | | | Opt_part | char(2) | YES | | | | Pencil_no | char(20) | YES | | | | Main_hand | char(30) | YES | | | | Handref | char(80) | YES | | | | Ascript | char(80) | YES | | | | Initial | char(20) | YES | | | | SComments | text | YES | | | | Rec_date | char(10) | YES | | | | Edit_date | char(10) | YES | | | |
