CREATE TABLE JPARS_STUDENT (ID NUMBER(19) NOT NULL, NAME VARCHAR2(255) NULL, PRIMARY KEY (ID))
CREATE TABLE JPARS_COURSE (ID NUMBER(19) NOT NULL, NAME VARCHAR2(255) NULL, PRIMARY KEY (ID))
CREATE TABLE JPARS_STUDENT_JPARS_COURSE (students_ID NUMBER(19) NOT NULL, courses_ID NUMBER(19) NOT NULL, PRIMARY KEY (students_ID, courses_ID))
ALTER TABLE JPARS_STUDENT_JPARS_COURSE ADD CONSTRAINT JPRSSTDENTJPARSACOURSEstdntsID FOREIGN KEY (students_ID) REFERENCES JPARS_STUDENT (ID)
ALTER TABLE JPARS_STUDENT_JPARS_COURSE ADD CONSTRAINT JPRSSTUDENTJPARSACOURSEcrsesID FOREIGN KEY (courses_ID) REFERENCES JPARS_COURSE (ID)
CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR2(50) NOT NULL, SEQ_COUNT NUMBER(38) NULL, PRIMARY KEY (SEQ_NAME))
INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)