| 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) |
