I have to do table with timestamp (timestamp), status (int ID), activity , original (BOOL),ts_changed (timestamp), DELETED BOOL. Table refreshes every 2 mins with new data
I dont know,can we write a postgresql code and find when it was modifiewd and delted, i know know much i just created table , dont know what to do next, can anyone help me please,
CREATE TABLE ActivityLog (
timestamp TIMESTAMP NOT NULL,
status INT,
activity INT,
original BOOLEAN,
ts_changed TIMESTAMP,
deleted BOOLEAN,
modified_by VARCHAR(255),
deleted_by VARCHAR(255)
);
parsi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.