enrj, PostgreSQL - rextester

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.

stackse - search stackoverflow differently