"127.0.0.1:E:\kmodel\BrCCMExV\db\VITKOVICEZPO.FDB". Tabulky |

TAVBY

Popis

Tabulka počítaných taveb

Pole

PK | FK | Pole | Doména | Typ | NN | Default | Popis |  | ID |  | INTEGER |  |  |
|  | TAVBA |  | INTEGER |  |  |
|  | NAHRADNI |  | INTEGER |  | 0 |
|  | SEKVENCE |  | INTEGER |  |  |
|  | PORADI |  | INTEGER |  |  |
|  | CASZAHAJENI |  | TIMESTAMP |  |  |
|  | CASUKONCENI |  | TIMESTAMP |  |  |
|  | ODLITADELKA |  | FLOAT |  |  |
|  | CHYBA |  | INTEGER |  | 0 |
|  | OCEL |  | INTEGER |  |  |
|  | UKONCENA |  | INTEGER |  | 0 |
|  | SKUPINA |  | INTEGER |  |  |
|  | SIRKA |  | INTEGER |  |  |
|  | TLOUSTKA |  | INTEGER |  |  |
|  | RYCHLOST |  | FLOAT |  |  |
|  | TLICI |  | FLOAT |  |  |
|  | HLADINA |  | FLOAT |  |  |
|  | TKRVSTUP |  | FLOAT |  |  |
|  | TKRVELKY |  | FLOAT |  |  |

Spouště

(There are no triggers for table TAVBY)

Indexy

(There are no indices on table TAVBY)

References

(There are no references for table TAVBY)

Referenced By

(There are no tables referenced by table TAVBY)

Definition

``

    CREATE TABLE TAVBY (
        ID           INTEGER NOT NULL,
        TAVBA        INTEGER NOT NULL,
        NAHRADNI     INTEGER DEFAULT 0,
        SEKVENCE     INTEGER,
        PORADI       INTEGER,
        CASZAHAJENI  TIMESTAMP,
        CASUKONCENI  TIMESTAMP,
        ODLITADELKA  FLOAT,
        CHYBA        INTEGER DEFAULT 0,
        OCEL         INTEGER,
        UKONCENA     INTEGER DEFAULT 0,
        SKUPINA      INTEGER,
        SIRKA        INTEGER,
        TLOUSTKA     INTEGER,
        RYCHLOST     FLOAT,
        TLICI        FLOAT,
        HLADINA      FLOAT,
        TKRVSTUP     FLOAT,
        TKRVELKY     FLOAT
    );

    ALTER TABLE TAVBY ADD PRIMARY KEY (ID);