src/sql/oracle-id-table-schema.sql

                                        
-----------------------------------------------------------------------------
-- ID_TABLE
-----------------------------------------------------------------------------
drop table ID_TABLE cascade constraints;
drop sequence ID_TABLE_SEQ;

CREATE TABLE ID_TABLE
(
    ID_TABLE_ID INT NOT NULL,
    TABLE_NAME VARCHAR2 (255) NOT NULL,
    NEXT_ID INT,
    QUANTITY INT,
    UNIQUE (TABLE_NAME)
);

ALTER TABLE ID_TABLE
    ADD CONSTRAINT ID_TABLE_PK 
PRIMARY KEY (ID_TABLE_ID);