02_create_table.sql

-- Change session to Pluggable DataBase (PDB)
ALTER SESSION SET container = ORCLPDB1;

-- No idea where it was created
CREATE TABLE SLEUTH_DEV.POST(
    id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY INCREMENT BY 1 MAXVALUE 9999999999999999999999999999 MINVALUE 1 CACHE 20 NOT NULL,
    TITLE VARCHAR2(50 BYTE),
    BODY VARCHAR2(1000 BYTE),
    CREATEDAT TIMESTAMP(6),
    CREATEDBY VARCHAR2(50 BYTE),
    UPDATEDAT TIMESTAMP(6),
    UPDATEDBY VARCHAR2(50 BYTE),
    PRIMARY KEY(id)
);