CREATE TABLE products (
  id SERIAL PRIMARY KEY,
  categoryid INT NOT NULL REFERENCES categories (id),
  title VARCHAR(255) NOT NULL,
  description TEXT NOT NULL,
  price DECIMAL(7,2) NOT NULL,
  create_timestamp BIGINT NOT NULL,
  modify_timestamp BIGINT NOT NULL,
  online_timestamp BIGINT NOT NULL
);

CREATE INDEX ON products (categoryid);