Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
enrj
CREATE TABLE Gamintojas ( Gamintojo_kodas CHAR(4) NOT NULL, Pavadinimas VARCHAR(35) NOT NULL, PRIMARY KEY (Gamintojo_kodas) ); CREATE TABLE Sandelis ( Nr SMALLINT NOT NULL, Daiktu_sk SMALLINT CHECK (Daiktu_sk >= 0 AND Daiktu_sk < 50), PRIMARY KEY (Nr) ); CREATE TABLE Uzsakymas ( Nr CHAR(7) NOT NULL, Pirkejas CHAR(6) NOT NULL, Prekiu_kiekis SMALLINT NOT NULL, Suma DECIMAL(5,2) NOT NULL CHECK(Suma > 10 AND Suma < 3000), Uzsakymo_data DATE NOT NULL, Issiuntimo_data DATE NOT NULL CHECK (Issiuntimo_data >= Uzsakymo_data), PRIMARY KEY (Nr) ); CREATE TABLE Preke ( Kodas CHAR(5) NOT NULL, Pavadinimas VARCHAR(35) NOT NULL, SN CHAR(7), Gamintojas CHAR(4) NOT NULL, Kaina DECIMAL(4,2) NOT NULL CONSTRAINT Kainos_dydis CHECK (Kaina > 0 AND Kaina < 300), Uzsakymas CHAR(7) NOT NULL, Sandelis SMALLINT NOT NULL, PRIMARY KEY (Kodas) ); CREATE TABLE Pirkejas ( Pirkejo_ID CHAR(6) NOT NULL, Vardas VARCHAR(35) NOT NULL, Pavarde VARCHAR(35) NOT NULL, Adresas VARCHAR(35) NOT NULL, Telefono_nr CHAR(9) NOT NULL, PRIMARY KEY(Pirkejo_ID) ); INSERT INTO Gamintojas VALUES ('1234', 'ROZET'); INSERT INTO Gamintojas VALUES ('4356', 'KOM'); INSERT INTO Gamintojas VALUES ('7534', 'FIJI'); INSERT INTO Gamintojas VALUES ('2434', 'RAPOI'); INSERT INTO Sandelis VALUES (01, 6); INSERT INTO Sandelis VALUES (02, 5); INSERT INTO Sandelis VALUES (03, 11); INSERT INTO Sandelis VALUES (04, 0); INSERT INTO Sandelis VALUES (05, 3); INSERT INTO Uzsakymas VALUES ('G65UGJY', 'JA0026', 5, 123.66, '2020-04-11', '2020-06-05'); INSERT INTO Uzsakymas VALUES ('DFJY5HJ', 'AJ0112', 8, 568.99, '2020-05-24', '2020-06-30'); INSERT INTO Uzsakymas VALUES ('KHJ6567', 'AA0121', 2, 54.54, '2020-04-29', '2020-05-31'); INSERT INTO Uzsakymas VALUES ('SDJKD74', 'NP0014', 5, 111.89, '2020-05-01', '2020-06-04'); INSERT INTO Uzsakymas VALUES ('ERLKJ58', 'GG0018', 4, 23.00, '2020-05-17', '2020-06-01'); INSERT INTO Uzsakymas VALUES ('283DJ44', 'JA0026', 1, 12.69, '2020-04-25', '2020-05-31'); INSERT INTO Pirkejas VALUES ('AJ0112', 'Adomas', 'Jonaitis', 'Minija 1 - 1', '866780634'); INSERT INTO Pirkejas VALUES ('NP0014', 'Neringa', 'Petraityte', 'Upe 2 - 23', '868796785'); INSERT INTO Pirkejas VALUES ('GG0018', 'Gabija', 'Gigaityte', 'Tikslioji 67 - 23', '862435674'); INSERT INTO Pirkejas VALUES ('JA0026', 'Justinas', 'Andriukaitis', 'Mazuciai 11-25', '863416232'); INSERT INTO Pirkejas VALUES ('AA0121', 'Adomas', 'Andriulaitis', 'Upe 20 - 20', '8623ll344'); INSERT INTO Preke VALUES ('G4G4J', 'Zaidimu ausines', NULL, '4356', 24.67, 'G65UGJY', 03); INSERT INTO Preke VALUES ('BHH56', 'Belaides ausines', 'HN78776', '1234', 99.99, 'DFJY5HJ', 05); INSERT INTO Preke VALUES ('NKJ45', 'Optine laidine pele', NULL, '2434', 5.00, 'ERLKJ58', 01); INSERT INTO Preke VALUES ('35NMN', 'Klaviatura', 'AA4444', '1234', 158.89, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('J4JH4', 'Garso kolonele', NULL, '4356', 34.78, 'SDJKD74', 02); INSERT INTO Preke VALUES ('J54NL', 'Optine laidine pele', NULL, '2434', 5.00, 'G65UGJY', 03); INSERT INTO Preke VALUES ('5J4EF', 'Zaidimu ausines', NULL, '7534', 24.01, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('FDNK6', 'Optine laidine pele', NULL, '2434', 5.00, 'ERLKJ58', 02); INSERT INTO Preke VALUES ('N5N54', 'Ausiniu stovas', NULL, '4356', 13.99, 'G65UGJY', 01); INSERT INTO Preke VALUES ('LL223', 'Zaidimu pele', 'KL56411', '1234', 47.23, 'KHJ6567', 01); INSERT INTO Preke VALUES ('M3KM4', 'USB sakotuvas', NULL, '2434', 1.89, 'SDJKD74', 03); INSERT INTO Preke VALUES ('KM34K', 'Lazerine belaide pele', NULL, '4356', 44.44, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('23M33', 'Peles kilimelis', NULL, '2434', 4.55, 'ERLKJ58', 03); INSERT INTO Preke VALUES ('43M9M', 'Nesiojama garso kolonele', 'BV54534', '1234', 65.89, 'G65UGJY', 01); INSERT INTO Preke VALUES ('09SSD', 'Belaides ausines', 'HN66474', '1234', 99.99, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('JNAJ8', 'Lazerine belaide pele', NULL, '7534', 7.31, 'KHJ6567', 02); INSERT INTO Preke VALUES ('MKMK0', 'Vaizdo kamera', NULL, '2434', 14.11, 'G65UGJY', 03); INSERT INTO Preke VALUES ('MKI09', 'Belaides ausines', 'HN43544', '1234', 99.99, 'DFJY5HJ', 01); INSERT INTO Preke VALUES ('908IJ', 'Klaviatura', NULL, '2434', 19.99, 'SDJKD74', 03); INSERT INTO Preke VALUES ('46UI9', 'Klaviaturos rieso atrama', NULL, '4356', 21.48, 'DFJY5HJ', 05); INSERT INTO Preke VALUES ('SMNM8', 'Peles kilimelis', NULL, '2434', 12.69, '283DJ44', 02); INSERT INTO Preke VALUES ('1J1J1', 'Adapteris Type C/3.5mm', NULL, '2434', 8.45, 'ERLKJ58', 01); INSERT INTO Preke VALUES ('6NN6N', 'Klavaitura', NULL, '7534', 43.78, 'SDJKD74', 05); INSERT INTO Preke VALUES ('4354G', 'Mikrofonas', NULL, '7534', 20.20, 'DFJY5HJ', 03); INSERT INTO Preke VALUES ('4909H', 'Zaidimu pele', NULL, '2434', 11.45, 'SDJKD74', 02);
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
test jsonb_set of PostgreSQL
filme
Recursive inefficiency
Stack
POSTGRESQL_CLOSEST_VALUE
create myStudents table
timestamp sample
Transform sequential key value data to row based key value data
postgresql example hierarchy with addresses
Query workaround in order to avoid IN Operator in WHERE Clause
Please log in to post a comment.