Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table XTRACK_VEHICLE | Next Table |
Comment |
---|
Tabele przechowująca pojazdy z ws xtrack |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | PK do XTRACK_VEHICLE | |
2 | NAME | VARCHAR2(300 BYTE) | Nazwa | ||
3 | REGISTRATIONNUMBER | VARCHAR2(100 BYTE) | Numer rejestracyjny | ||
4 | REGISTRATIONDOCUMENT | VARCHAR2(100 BYTE) | Numer dokumntu rejestracyjnego | ||
5 | VIN | VARCHAR2(100 BYTE) | Numer VIN | ||
6 | PRODUCTIONDATE | NUMBER | Data produkcji | ||
7 | MARK | VARCHAR2(100 BYTE) | Marka pojazdu | ||
8 | MODEL | VARCHAR2(100 BYTE) | Model pojazdu | ||
9 | CARDNUMBER | VARCHAR2(100 BYTE) | Numer karty | ||
10 | KERBWEIGHT | NUMBER | Masa własna | ||
11 | ENGINENUMBER | VARCHAR2(100 BYTE) | Numer silniak | ||
12 | ENGINEDISPLACEMENT | NUMBER | Pojemność silnika | ||
13 | ENGINEPOWER | NUMBER | Moc silnika | ||
14 | SIDENUMBER | VARCHAR2(100 BYTE) | Numer strony | ||
15 | EMPLOYEEID | NUMBER | Id pracownika | ||
16 | GROUPID | NUMBER | Id grupy | ||
17 | GROUPNAME | VARCHAR2(100 BYTE) | Nazwa grupy | ||
18 | FUELTYPE | VARCHAR2(100 BYTE) | Typ paliwa | ||
19 | FUELNORMNOMINAL | NUMBER | Norma paliwa - nominalna | ||
20 | FUELNORMDRIVE | NUMBER | Norma paliwa - kierowcy | ||
21 | FUELNORMWORK | NUMBER | Norma paliwa - w trasie | ||
22 | FUELNORMSTAY | NUMBER | Norma paliwa - stała | ||
23 | RECORDERNUMBER | NUMBER | Numer rejestratora |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
UNIQUE | PK_XTRACK_VEHICLE_ID | NORMAL | ID | <none> |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_XTRACK_VEHICLE_ID | Check | "ID" IS NOT NULL | ENABLED | ID |
PK_XTRACK_VEHICLE_ID | Primary Key | ENABLED | ID |
Partitions |
Foreign Key Constraints |
Redaction Policies |