pg Table

/* CREATE TABLE */
CREATE TABLE  lisrEmployees(
IdPersonPK serial primary key ,
FIO  VARCHAR(100),
dataR  integer,
adres  VARCHAR(100),
pasport  integer,
vidanBy  VARCHAR(100),
position  VARCHAR(100)
);

/* INSERT QUERY NO: 1 */
INSERT INTO lisrEmployees(IdPersonPK, FIO, dataR, adres, pasport, vidanBy, position)
VALUES (1.00, 'FIO1', 1980.00, 'strit1', 998, 'MvdSevas', 'PIC');


/* CREATE TABLE */
CREATE TABLE listTypeWork(
TypIdPK   serial primary key,
TypRabot   VARCHAR(100),
value   VARCHAR(100),
DengaDen    integer,
position    VARCHAR(100)
);

/* INSERT QUERY NO: 1 */
INSERT INTO listTypeWork(TypIdPK, TypRabot, value, DengaDen, position)
VALUES (1, 'lifting', 'chas', 8000, 'PIC');


/* CREATE TABLE */
CREATE TABLE listBrigade(
Id      serial primary key,
BrigadaId    INTEGER,
TypIdFK  INTEGER,
IdPersonFK  INTEGER,
executHours  INTEGER
);

/* INSERT QUERY NO: 1 */
INSERT INTO listBrigade(Id, BrigadaId, TypIdFK, IdPersonFK, executHours)
VALUES (1, 1, 1, 1, 50);