[sql] D_d
Viewer
*** This page was generated with the meta tag "noindex, nofollow". This happened because you selected this option before saving or the system detected it as spam. This means that this page will never get into the search engines and the search bot will not crawl it. There is nothing to worry about, you can still share it with anyone.
- CREATE TABLE Klienci (
- ID_klienta INT PRIMARY KEY,
- Imię VARCHAR(50),
- Nazwisko VARCHAR(50),
- Adres VARCHAR(100),
- Numer_telefonu VARCHAR(20)
- );
- CREATE TABLE Zamówienia (
- ID_zamówienia INT PRIMARY KEY,
- ID_klienta INT,
- Data_zamówienia DATE,
- Kwota DECIMAL(10, 2),
- FOREIGN KEY (ID_klienta) REFERENCES Klienci(ID_klienta)
- );
- CREATE TABLE Produkty (
- ID_produktu INT PRIMARY KEY,
- Nazwa_produktu VARCHAR(100),
- Cena DECIMAL(10, 2),
- Kategoria VARCHAR(50)
- );
- CREATE TABLE Pracownicy (
- ID_pracownika INT PRIMARY KEY,
- Imię VARCHAR(50),
- Nazwisko VARCHAR(50),
- Stanowisko VARCHAR(50),
- Data_zatrudnienia DATE
- );
- ALTER TABLE Zamówienia
- ADD CONSTRAINT FK_Zamówienia_Klienci
- FOREIGN KEY (ID_klienta) REFERENCES Klienci(ID_klienta);
- ALTER TABLE Zamówienia
- ADD CONSTRAINT FK_Zamówienia_Produkty
- FOREIGN KEY (ID_produktu) REFERENCES Produkty(ID_produktu);
Editor
You can edit this paste and save as new: