Kasual_Gelegenheit

Number of rows:12
FieldTypeNullKeyDefaultExtra
Gidint(6)NOPRI0
Gkurzvarchar(1000)YES
Gdat1varchar(1000)YES
Gdat1_yearint(4)YES
Gdat2varchar(1000)YES
Gortjvarchar(1000)YES
Glandjvarchar(1000)YES
Gortdvarchar(1000)YES
Glanddvarchar(1000)YES
Ganlassvarchar(1000)YES
Gbemerkungvarchar(1000)YES
Gdatvarchar(1000)YES

Kasual_Werk

Number of rows:40
FieldTypeNullKeyDefaultExtra
Widint(6)NOPRI0
Wgidint(6)YESMUL
Wtextvarchar(1000)YES
Wexemplarvarchar(1000)YES
Wgelegenheitswerknummervarchar(60)YES
Wtitelvarchar(2000)YES
Wwidmungvarchar(1000)YES
Wsprachevarchar(1000)YES
Wbesetzungvarchar(1000)YES
Wbesetzung1varchar(1000)YES
Wbesetzung2varchar(1000)YES
Winstrint(10)YES
Wvokint(10)YES
Wbcint(3)YES
Wtonartvarchar(1000)YES
Wtaktvarchar(1000)YES
Wgattung_originalvarchar(1000)YES
Wgattung_modernvarchar(1000)YES
Waufbauvarchar(1000)YES
Wmelodievarchar(1000)YES
Wtextgrundlagevarchar(1000)YES
Wincipitvarchar(1000)YES
Wnotationvarchar(1000)YES
Wstimmenvarchar(1000)YES
Wdhvarchar(1000)YES
Wbindungvarchar(1000)YES
Wblattint(6)YES
Wformatvarchar(1000)YES
Willustrationvarchar(1000)YES
Wweiteretextevarchar(1000)YES
Wverlegervarchar(1000)YES
Wpikturenvarchar(1000)YES
Wdatierungvarchar(1000)YES
Wfundortvarchar(1000)YES
Wbibvarchar(1000)YES
Wrismvarchar(1000)YES
Wbesonderheitvarchar(1000)YES
Wbemerkungvarchar(1000)YES
Wliteraturvarchar(1000)YES
Wdatvarchar(1000)YES

Kasual_Person

Number of rows:18
FieldTypeNullKeyDefaultExtra
Pidint(6)NOPRI0
PNDnummerchar(10)YES
Pnamevarchar(1000)YES
Pname2varchar(1000)YES
Pvornamevarchar(1000)YES
Ptitelvarchar(1000)YES
Pgen1char(5)YES
Pdat1varchar(1000)YES
Pdat_firstvarchar(1000)YES
Pdat_first_explanationvarchar(1000)YES
Port1varchar(1000)YES
Pgen2char(5)YES
Pdat2varchar(1000)YES
Pdat_lastvarchar(1000)YES
Pdat_last_explanationvarchar(1000)YES
Port2varchar(1000)YES
Pbemerkungvarchar(1000)YES
Pdatvarchar(1000)YES

Kasual_GP

Number of rows:6
FieldTypeNullKeyDefaultExtra
GPidint(6)NOPRI0
GPgidint(6)YESMUL
GPpidint(6)YESMUL
GPtypvarchar(1000)YES
GPbemerkungvarchar(1000)YES
GPdatvarchar(1000)YES

Kasual_PBW

Number of rows:11
FieldTypeNullKeyDefaultExtra
PBWidint(6)NOPRI0
PBWpidint(6)YESMUL
PBWberufvarchar(1000)YES
PBWwohnortvarchar(1000)YES
PBWarbeitgebervarchar(1000)YES
PBWgen1char(5)YES
PBWdat1varchar(1000)YES
PBWgen2char(5)YES
PBWdat2varchar(1000)YES
PBWbemerkungvarchar(1000)YES
PBWdatvarchar(1000)YES

Kasual_WD

Number of rows:5
FieldTypeNullKeyDefaultExtra
WDidint(6)NOPRI0
WDwidint(6)YESMUL
WDpidint(6)YESMUL
WDbemerkungvarchar(1000)YES
WDdatvarchar(1000)YES

Kasual_WK

Number of rows:5
FieldTypeNullKeyDefaultExtra
WKidint(6)NOPRI0
WKwidint(6)YESMUL
WKpidint(6)YESMUL
WKbemerkungvarchar(1000)YES
WKdatvarchar(1000)YES