Table SQL definition for table Dubparts
Number of columns=6Field | Type | Null | Key | Default | Extra |
Pnr | int(6) | NO | PRI | 0 | |
Dnr | int(6) | YES | | | | Part_no | char(3) | YES | | | | Ruden_no | char(10) | YES | | | | Part | char(80) | YES | | | | Title_page | text | YES | | | | Heading | char(200) | YES | | | | Ascrip | char(80) | YES | | | | Format | char(10) | YES | | | | Size | char(10) | YES | | | | Gath | char(20) | YES | | | | Pages | char(10) | YES | | | | Nota | char(10) | YES | | | | Ksig | char(8) | YES | | | | Clef | char(20) | YES | | | | Dynamics | char(80) | YES | | | | Watermark | char(60) | YES | | | | N_field | char(20) | YES | | | | Watdate | char(20) | YES | | | | Watref | char(100) | YES | | | | Hand | char(60) | YES | | | | Old_hand | char(60) | YES | | | | Handref | char(80) | YES | | | | Musinchead | char(30) | YES | | | | Musincnum | char(60) | YES | | | | Range | char(15) | YES | | | | Initials | char(5) | YES | | | | Comments | text | YES | | | | rec_date | char(10) | YES | | | | edit_date | char(10) | YES | | | |