Lern-Fabrik.digital
Tabellen
BERG
B_NAME (varchar(20))
GEBIRGE (varchar(25))
HOEHE (double(16,4))
JAHR (int(11))
LAENGE (double(16,4))
BREITE (double(16,4))
EBENE
E_NAME (varchar(25))
HOEHE (double(16,4))
FLAECHE (double(16,4))
FLUSS
F_NAME (varchar(20))
FLUSS (varchar(20))
SEE (varchar(25))
MEER (varchar(25))
LAENGE (int(11))
LAENGEU (double(16,4))
BREITEU (double(16,4))
LAENGEM (double(16,4))
BREITEM (double(16,4))
GEHT_UEBER_IN
MEER1 (varchar(25))
MEER2 (varchar(25))
GEO_BERG
id (int(11))
L_ID (varchar(4))
LT_ID (varchar(4))
B_NAME (varchar(20))
GEO_EBENE
LT_ID (varchar(4))
L_ID (varchar(4))
E_NAME (varchar(25))
GEO_FLUSS
id (int(11))
L_ID (varchar(4))
LT_ID (varchar(50))
F_NAME (varchar(20))
GEO_INSEL
LT_ID (varchar(4))
L_ID (varchar(4))
I_NAME (varchar(25))
GEO_MEER
id (int(11))
LT_ID (varchar(4))
L_ID (varchar(4))
M_NAME (varchar(25))
GEO_SEE
id (int(11))
LT_ID (varchar(4))
L_ID (varchar(4))
S_NAME (varchar(25))
GEO_WUESTE
LT_ID (varchar(4))
L_ID (varchar(4))
W_NAME (varchar(25))
HAT_SITZ_IN
ST_NAME (varchar(25))
LT_ID (varchar(4))
L_ID (varchar(4))
ABKUERZUNG (varchar(20))
INSEL
I_NAME (varchar(25))
INSELGRUPPE (varchar(25))
FLAECHE (double(16,4))
LAENGE (double(16,4))
BREITE (double(16,4))
IST_BENACHBART_ZU
id (int(11))
LAND1 (varchar(4))
LAND2 (varchar(4))
IST_MITGLIED_VON
L_ID (varchar(4))
ABKUERZUNG (varchar(20))
ART (varchar(25))
KONTINENT
K_NAME (varchar(10))
FLAECHE (double(16,4))
LAND
L_ID (varchar(4))
L_NAME (varchar(50))
EINWOHNER (double(16,4))
FLAECHE (double(16,4))
HAUPTSTADT (varchar(25))
LT_ID (varchar(4))
LANDTEIL
id (int(11))
LT_ID (varchar(4))
L_ID (varchar(4))
LT_NAME (varchar(50))
EINWOHNER (double(16,4))
LAGE (char(2))
HAUPTSTADT (varchar(25))
LIEGT_AN
id (int(11))
ST_NAME (varchar(25))
LT_ID (varchar(4))
L_ID (varchar(4))
F_NAME (varchar(20))
S_NAME (varchar(25))
M_NAME (varchar(25))
MEER
M_NAME (varchar(25))
TIEFE (double(16,4))
ORGANISATION
id (int(11))
O_NAME (varchar(70))
ABKUERZUNG (varchar(20))
SEE
S_NAME (varchar(25))
TIEFE (double(16,4))
FLAECHE (double(16,4))
STADT
ST_NAME (varchar(25))
L_ID (varchar(4))
LT_ID (varchar(4))
EINWOHNER (int(11))
BREITE (double(16,4))
LAENGE (double(16,4))
UMFASST
id (int(11))
L_ID (varchar(4))
K_NAME (varchar(10))
PROZENT (double(16,4))
WUESTE
id (int(11))
W_NAME (varchar(25))
FLAECHE (double(16,4))
WUESTENART (varchar(17))
aufgaben
id (int(11))
aufgabe (text)
loesung (text)
schwierigkeit (int(11))
hinweis (varchar(250))
SQL Editor
SQL ausführen
SQL herunterladen
Editor löschen
Übungsaufgaben
Ergebnisse
Keine Ergebnisse gefunden.