You are here

Добавить комментарий

Tables used in examples

Table tverkauf (salesman) :


    CREATE TABLE tverkauf (
    vnum INTEGER NOT NULL UNIQUE PRIMARY KEY,
    vname CHAR(40),
    stadt CHAR(40),
    prov DECIMAL );

Table tkunden (customers) :


    CREATE TABLE tkunden (
    knum INTEGER NOT NULL UNIQUE PRIMARY KEY,
    kname CHAR(40),
    stadt CHAR(40),
    rating INTEGER,
    vnum INTEGER );

Table torder (customer orders) :


    CREATE TABLE torder (
    onum INTEGER NOT NULL UNIQUE PRIMARY KEY,
    preis DECIMAL(2,30),
    anz REAL,
    odatum DATE,
    knum INTEGER
    vnum INTEGER );

Table tposition (order items) :


    CREATE TABLE tposition (
    pnum INTEGER NOT NULL UNIQUE PRIMARY KEY,
    onum INTEGER,
    anum INTEGER,
    menge INTEGER );

Table tartikel (products) :


    CREATE TABLE tartikel (
    anum INTEGER NOT NULL UNIQUE PRIMARY KEY,
    name CHAR(40),
    preis DECIMAL(2,30),
    hnum INTEGER );