RelativeTech

create table worker (
     id integer not null,
     created_by varchar(255),
     in_utc timestamp not null,
     last_modified_by varchar(255),
     out_utc timestamp,
     audit_id varchar(255),
     compensation double not null,
     worker_code varchar(255),
     worker_name varchar(255),

RelativeTech

SELECT *
FROM ORDERS
WHERE SELLER_NAME = 'One First'

RelativeTech

CREATE INDEX INDEX_SELLER_NAME
ON ORDERS(SELLER_NAME)

RelativeTech

create unique index UKbe6uin1lttt8dh3oddmrb6g6d on worker (audit_id, out_utc);

RelativeTech

delete from employee where id = 1

RelativeTech

GRANT ALL ON TABLE EMPLOYEE_HR TO USER USER_HR

RelativeTech

INSERT INTO WORKER(ID, AUDIT_ID, IN_UTC, OUT_UTC, WORKER_CODE, WORKER_NAME, COMPENSATION, CREATED_BY, LAST_MODIFIED_BY)
VALUES(1, '00000000-0000-0000-0000-000000000001', CURRENT_TIMESTAMP - CURRENT_TIMEZONE, '9999-12-31', 'CODE-1', 'One First', 120000.00, 'unknown', 'unknown');

RelativeTech

INSERT INTO WORKER VALUES(1, '00000000-0000-0000-0000-000000000001', CURRENT_TIMESTAMP - CURRENT_TIMEZONE, '9999-12-31', 'CODE-1', 'One First', 120000.00, 'unknown', 'unknown');

RelativeTech

INSERT INTO WORKER(ID, AUDIT_ID, WORKER_CODE, WORKER_NAME, COMPENSATION)
VALUES(1, '00000000-0000-0000-0000-000000000001', 'CODE-1', 'One First', 120000.00);

RelativeTech

update worker
set compensation = 200000,
worker_code = 'CODE-X'
where id = 3