Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE Computronix
- CREATE TABLE Uzytkownicy
- (
- Uz_Id INTEGER IDENTITY PRIMARY KEY,
- Uz_AdId INTEGER, --Adresy
- Uz_KntId INTEGER, --Kontakty
- Uz_Login VARCHAR(30) NOT NULL,
- Uz_Haslo VARCHAR(30) NOT NULL,
- Uz_Imie VARCHAR(30),
- Uz_Nazwisko VARCHAR(30),
- Uz_UpnId INTEGER NOT NULL, --Uprawnienia
- Uz_DataUtworzenia DATETIME NOT NULL
- )
- CREATE TABLE Uprawnienia
- (
- Upn_Id INTEGER IDENTITY PRIMARY KEY,
- Upn_Nazwa VARCHAR(40) NOT NULL,
- Upn_PoziomUprawnien INTEGER NOT NULL
- )
- CREATE TABLE Kontakty
- (
- Knt_Id INTEGER IDENTITY PRIMARY KEY,
- Knt_Telefon1 VARCHAR(30),
- Knt_Telefon2 VARCHAR(30),
- Knt_Email VARCHAR(40),
- )
- CREATE TABLE Adresy
- (
- Ad_Id INTEGER IDENTITY PRIMARY KEY,
- Ad_Nazwa1 VARCHAR(50),
- Ad_Nazwa2 VARCHAR(50),
- Ad_KodP VARCHAR(10),
- Ad_Miasto VARCHAR(30),
- Ad_Ulica VARCHAR(30),
- Ad_Wojewodztwo VARCHAR(30)
- )
- CREATE TABLE Zamowienia
- (
- Zam_Id INTEGER IDENTITY PRIMARY KEY,
- Zam_KlId INTEGER NOT NULL, --Klienci
- Zam_AdId INTEGER NOT NULL, --Adresy
- Zam_PtId INTEGER NOT NULL, --Platnosci
- Zam_DataZamowienia DATETIME NOT NULL,
- Zam_WartoscNetto DECIMAL(15,2) NOT NULL,
- Zam_WartoscBrutto DECIMAL(15,2) NOT NULL
- )
- CREATE TABLE ZamowieniaElementy
- (
- ZaE_Id INTEGER IDENTITY PRIMARY KEY,
- ZaE_TwrId INTEGER NOT NULL, --Towary
- ZaE_ZamId INTEGER NOT NULL, --Zamowienia
- ZaE_Ilosc INTEGER NOT NULL,
- ZaE_Rabat DECIMAL(5,2)
- )
- CREATE TABLE Platnosci
- (
- Pt_Id INTEGER IDENTITY PRIMARY KEY,
- Pt_Forma INTEGER NOT NULL,
- Pt_Kwota DECIMAL(12,2) NOT NULL,
- Pt_Rozliczona TINYINT NOT NULL,
- Pt_Termin DATETIME NOT NULL
- )
- CREATE TABLE Towary
- (
- Twr_Id INTEGER IDENTITY PRIMARY KEY,
- Twr_Kod VARCHAR(40) NOT NULL,
- Twr_Nazwa VARCHAR(225) NOT NULL,
- Twr_EAN VARCHAR(40),
- Twr_CenaNetto DECIMAL(10,2) NOT NULL,
- Twr_CenaBrutto DECIMAL(10,2) NOT NULL,
- Twr_StawkaVat DECIMAL(5,2) NOT NULL,
- Twr_TwKId INTEGER, --TowaryKategorie
- Twr_TwPId INTEGER --TowaryProducenci
- )
- CREATE TABLE Opinia
- (
- Op_Id INTEGER IDENTITY PRIMARY KEY,
- Op_UzId INTEGER NOT NULL,
- Op_TwrId INTEGER NOT NULL,
- Op_Tresc INTEGER NOT NULL,
- Op_Data DATETIME NOT NULL,
- Op_Ocena TINYINT NOT NULL
- )
- CREATE TABLE TowaryKategorie
- (
- TwK_Id INTEGER IDENTITY PRIMARY KEY,
- TwK_Kod VARCHAR(40) NOT NULL,
- TwK_Nazwa VARCHAR(225) NOT NULL
- )
- CREATE TABLE TowaryProducenci
- (
- TwP_Id INTEGER IDENTITY PRIMARY KEY,
- TwP_AdId INTEGER NOT NULL,
- TwP_URL VARCHAR(50),
- )
- CREATE TABLE Koszyk
- (
- Ksz_Id INTEGER IDENTITY PRIMARY KEY,
- Ksz_UzId INTEGER NOT NULL, --Użytkownik
- Ksz_DataUtworzenia DATETIME NOT NULL,
- )
- CREATE TABLE KoszykElem
- (
- KszE_Id INTEGER IDENTITY PRIMARY KEY,
- KszE_KszId INTEGER NOT NULL, --Koszyk
- KszE_TwrId INTEGER NOT NULL, --Towary
- KszE_Ilosc INTEGER NOT NULL
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement