앞선 글에서 언급했던 요구사항을 만족하는 ERD입니다.
특이사항
-
비회원 고객은 티켓 예매 이후의 기능에서만 인증이 필요하기 때문에 고객 엔티티가 아닌 티켓 엔티티에 넣도록 하였습니다.
-
관리자 계정은 섬 엔티티처럼 보이지만, 실제로는 고객과 관리자 사이에 Authority_User라는 별도의 엔티티를 만들어 Spring Boot에서의 접근이 편리하도록 할 예정입니다.
-
코드 엔티티타입을 통해 관리할 내용은 아래와 같습니다.
- 상영관 타입
- 장르
- 상영등급
- 이미지 엔티티역시 섬 엔티티로 존재하는 이유는 다른 여러 엔티티와 연관되어 있고, 확장도 가능하기 때문입니다.
DDL(스크롤 주의)
Erwin에서 자동으로 생성해준 DDL 파일입니다. 추후 설정할 Sequence까지 만들어줍니다. 직접 DDL을 추출하셔서 사용하실 분들은 여기서 마무리하고 다음 글로 넘어가셔도 무관합니다.
--------------------------------------------------------
-- 파일이 생성됨 - 토요일-6월-03-2023
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Sequence ADMIN_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."ADMIN_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 112 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence CAST_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."CAST_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 42 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence CUSTOMER_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."CUSTOMER_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 122 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence GENRE_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."GENRE_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 61 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence MEMBER_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."MEMBER_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 3 NOCACHE NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence MOVIE_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."MOVIE_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 81 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence POSTER_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."POSTER_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 81 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence RATING_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."RATING_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 103 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence SCHEDULE_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."SCHEDULE_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence SQ_CINDY
--------------------------------------------------------
CREATE SEQUENCE "JWK"."SQ_CINDY" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence THEATER_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."THEATER_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Sequence TICKET_SEQUENCE
--------------------------------------------------------
CREATE SEQUENCE "JWK"."TICKET_SEQUENCE" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ;
--------------------------------------------------------
-- DDL for Table ADMIN
--------------------------------------------------------
CREATE TABLE "JWK"."ADMIN"
( "ADMIN_ID" NUMBER,
"NAME" VARCHAR2(30 BYTE),
"LOGIN_ID" VARCHAR2(20 BYTE),
"PASSWORD" VARCHAR2(60 BYTE),
"CREATED_AT" TIMESTAMP (6)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table AUTHORITY_USER
--------------------------------------------------------
CREATE TABLE "JWK"."AUTHORITY_USER"
( "LOGIN_ID" VARCHAR2(20 BYTE),
"AUTHORITY" VARCHAR2(20 BYTE),
"PASSWORD" VARCHAR2(60 BYTE),
"ADMIN_ID" NUMBER,
"CUSTOMER_ID" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CAST
--------------------------------------------------------
CREATE TABLE "JWK"."CAST"
( "CAST_ID" NUMBER,
"NAME" VARCHAR2(30 BYTE),
"BIRTHDATE" DATE,
"NATIONALITY" CHAR(2 BYTE),
"INFO" CLOB,
"PROFILE_IMAGE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS"
LOB ("INFO") STORE AS SECUREFILE (
TABLESPACE "USERS" ENABLE STORAGE IN ROW 4000 CHUNK 8192
NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES
STORAGE(INITIAL 262144 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
--------------------------------------------------------
-- DDL for Table CODE
--------------------------------------------------------
CREATE TABLE "JWK"."CODE"
( "CODE" VARCHAR2(5 BYTE),
"NAME" VARCHAR2(60 BYTE),
"UPPER_CODE" VARCHAR2(5 BYTE)
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table CUSTOMER
--------------------------------------------------------
CREATE TABLE "JWK"."CUSTOMER"
( "CUSTOMER_ID" NUMBER,
"NAME" VARCHAR2(30 BYTE),
"LOGIN_ID" VARCHAR2(20 BYTE),
"PASSWORD" VARCHAR2(60 BYTE),
"NICKNAME" VARCHAR2(20 BYTE),
"BIRTHDATE" DATE,
"GENDER" NUMBER(*,0),
"PHONE_NUMBER" CHAR(11 BYTE),
"EMAIL" VARCHAR2(60 BYTE),
"POINT" NUMBER(*,0),
"CREATED_AT" TIMESTAMP (6)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table GENRE_REGISTER
--------------------------------------------------------
CREATE TABLE "JWK"."GENRE_REGISTER"
( "GENRE_ID" VARCHAR2(5 BYTE),
"MOVIE_ID" NUMBER
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table IMAGE
--------------------------------------------------------
CREATE TABLE "JWK"."IMAGE"
( "IMAGE_ID" NUMBER,
"UUID" VARCHAR2(36 BYTE),
"FILE_NAME" VARCHAR2(255 BYTE),
"FILE_URL" VARCHAR2(255 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table MOVIE
--------------------------------------------------------
CREATE TABLE "JWK"."MOVIE"
( "MOVIE_ID" NUMBER,
"TITLE" VARCHAR2(255 BYTE),
"RELEASE_DATE" DATE,
"RUNNING_TIME" NUMBER(*,0),
"INFO" CLOB,
"COUNTRY" CHAR(2 BYTE),
"LANGUAGE" VARCHAR2(30 BYTE),
"POSTER" NUMBER,
"DIRECTOR" NUMBER,
"RATING" VARCHAR2(5 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS"
LOB ("INFO") STORE AS SECUREFILE (
TABLESPACE "USERS" ENABLE STORAGE IN ROW 4000 CHUNK 8192
NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES
STORAGE(INITIAL 262144 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
--------------------------------------------------------
-- DDL for Table PAYMENT
--------------------------------------------------------
CREATE TABLE "JWK"."PAYMENT"
( "PAYMENT_ID" NUMBER,
"PRICE" NUMBER(*,0),
"PAYMENT_TIME" TIMESTAMP (6),
"METHOD" VARCHAR2(5 BYTE),
"STATUS" NUMBER(*,0),
"TICKET_ID" NUMBER
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table ROLE
--------------------------------------------------------
CREATE TABLE "JWK"."ROLE"
( "ROLE" VARCHAR2(30 BYTE),
"STARRING" NUMBER(*,0),
"CAST_ID" NUMBER,
"MOVIE_ID" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table SCHEDULE
--------------------------------------------------------
CREATE TABLE "JWK"."SCHEDULE"
( "SCHEDULE_ID" NUMBER,
"START_TIME" TIMESTAMP (6),
"DISCOUNT" VARCHAR2(20 BYTE),
"MOVIE_ID" NUMBER,
"THEATER_ID" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table SEAT
--------------------------------------------------------
CREATE TABLE "JWK"."SEAT"
( "SEAT_ID" VARCHAR2(11 BYTE),
"PRICE" NUMBER(*,0),
"THEATER_ID" NUMBER,
"ROW_NUM" CHAR(1 BYTE),
"COL_NUM" NUMBER(10,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table THEATER
--------------------------------------------------------
CREATE TABLE "JWK"."THEATER"
( "THEATER_ID" NUMBER,
"NAME" VARCHAR2(40 BYTE),
"TYPE" VARCHAR2(5 BYTE),
"FLOOR" NUMBER(*,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table TICKET
--------------------------------------------------------
CREATE TABLE "JWK"."TICKET"
( "TICKET_ID" NUMBER,
"PHONE_NUMBER" CHAR(11 BYTE),
"PASSWORD" VARCHAR2(60 BYTE),
"TICKETING_TIME" TIMESTAMP (6),
"SCHEDULE_ID" NUMBER,
"CUSTOMER_ID" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Table TICKET_SEAT
--------------------------------------------------------
CREATE TABLE "JWK"."TICKET_SEAT"
( "TICKET_ID" NUMBER,
"SEAT_ID" VARCHAR2(20 BYTE),
"THEATER_ID" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
REM INSERTING into JWK.ADMIN
SET DEFINE OFF;
REM INSERTING into JWK.AUTHORITY_USER
SET DEFINE OFF;
REM INSERTING into JWK.CAST
SET DEFINE OFF;
REM INSERTING into JWK.CODE
SET DEFINE OFF;
REM INSERTING into JWK.CUSTOMER
SET DEFINE OFF;
REM INSERTING into JWK.GENRE_REGISTER
SET DEFINE OFF;
REM INSERTING into JWK.IMAGE
SET DEFINE OFF;
REM INSERTING into JWK.MOVIE
SET DEFINE OFF;
REM INSERTING into JWK.PAYMENT
SET DEFINE OFF;
REM INSERTING into JWK.ROLE
SET DEFINE OFF;
REM INSERTING into JWK.SCHEDULE
SET DEFINE OFF;
REM INSERTING into JWK.SEAT
SET DEFINE OFF;
REM INSERTING into JWK.THEATER
SET DEFINE OFF;
REM INSERTING into JWK.TICKET
SET DEFINE OFF;
REM INSERTING into JWK.TICKET_SEAT
SET DEFINE OFF;
--------------------------------------------------------
-- DDL for Index SYS_IL0000083295C00005$$
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."SYS_IL0000083295C00005$$" ON "JWK"."CAST" (
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS"
PARALLEL (DEGREE 0 INSTANCES 0) ;
--------------------------------------------------------
-- DDL for Index SYS_IL0000083305C00005$$
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."SYS_IL0000083305C00005$$" ON "JWK"."MOVIE" (
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS"
PARALLEL (DEGREE 0 INSTANCES 0) ;
--------------------------------------------------------
-- DDL for Index XPKADMIN
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKADMIN" ON "JWK"."ADMIN" ("ADMIN_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKAUTHORITY_USER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKAUTHORITY_USER" ON "JWK"."AUTHORITY_USER" ("LOGIN_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKCAST
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKCAST" ON "JWK"."CAST" ("CAST_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKCODE
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKCODE" ON "JWK"."CODE" ("CODE")
PCTFREE 10 INITRANS 2 MAXTRANS 255
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKCUSTOMER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKCUSTOMER" ON "JWK"."CUSTOMER" ("CUSTOMER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKGENRE_REGISTER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKGENRE_REGISTER" ON "JWK"."GENRE_REGISTER" ("GENRE_ID", "MOVIE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKMOVIE
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKMOVIE" ON "JWK"."MOVIE" ("MOVIE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKPAYMENT
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKPAYMENT" ON "JWK"."PAYMENT" ("PAYMENT_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKPOSTER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKPOSTER" ON "JWK"."IMAGE" ("IMAGE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKROLE
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKROLE" ON "JWK"."ROLE" ("CAST_ID", "MOVIE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKSCHEDULE
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKSCHEDULE" ON "JWK"."SCHEDULE" ("SCHEDULE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKSEAT
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKSEAT" ON "JWK"."SEAT" ("SEAT_ID", "THEATER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKTHEATER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKTHEATER" ON "JWK"."THEATER" ("THEATER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKTICKETING
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKTICKETING" ON "JWK"."TICKET" ("TICKET_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKTICKETING_SEAT
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKTICKETING_SEAT" ON "JWK"."TICKET_SEAT" ("TICKET_ID", "SEAT_ID", "THEATER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKADMIN
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKADMIN" ON "JWK"."ADMIN" ("ADMIN_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKAUTHORITY_USER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKAUTHORITY_USER" ON "JWK"."AUTHORITY_USER" ("LOGIN_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKCAST
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKCAST" ON "JWK"."CAST" ("CAST_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKCODE
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKCODE" ON "JWK"."CODE" ("CODE")
PCTFREE 10 INITRANS 2 MAXTRANS 255
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKCUSTOMER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKCUSTOMER" ON "JWK"."CUSTOMER" ("CUSTOMER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKGENRE_REGISTER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKGENRE_REGISTER" ON "JWK"."GENRE_REGISTER" ("GENRE_ID", "MOVIE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKPOSTER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKPOSTER" ON "JWK"."IMAGE" ("IMAGE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKMOVIE
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKMOVIE" ON "JWK"."MOVIE" ("MOVIE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKPAYMENT
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKPAYMENT" ON "JWK"."PAYMENT" ("PAYMENT_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKROLE
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKROLE" ON "JWK"."ROLE" ("CAST_ID", "MOVIE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKSCHEDULE
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKSCHEDULE" ON "JWK"."SCHEDULE" ("SCHEDULE_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKSEAT
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKSEAT" ON "JWK"."SEAT" ("SEAT_ID", "THEATER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKTHEATER
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKTHEATER" ON "JWK"."THEATER" ("THEATER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKTICKETING
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKTICKETING" ON "JWK"."TICKET" ("TICKET_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- DDL for Index XPKTICKETING_SEAT
--------------------------------------------------------
CREATE UNIQUE INDEX "JWK"."XPKTICKETING_SEAT" ON "JWK"."TICKET_SEAT" ("TICKET_ID", "SEAT_ID", "THEATER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
-- Constraints for Table ADMIN
--------------------------------------------------------
ALTER TABLE "JWK"."ADMIN" MODIFY ("ADMIN_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."ADMIN" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "JWK"."ADMIN" MODIFY ("LOGIN_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."ADMIN" MODIFY ("PASSWORD" NOT NULL ENABLE);
ALTER TABLE "JWK"."ADMIN" MODIFY ("CREATED_AT" NOT NULL ENABLE);
ALTER TABLE "JWK"."ADMIN" ADD CONSTRAINT "XPKADMIN" PRIMARY KEY ("ADMIN_ID")
USING INDEX "JWK"."XPKADMIN" ENABLE;
--------------------------------------------------------
-- Constraints for Table AUTHORITY_USER
--------------------------------------------------------
ALTER TABLE "JWK"."AUTHORITY_USER" MODIFY ("LOGIN_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."AUTHORITY_USER" MODIFY ("AUTHORITY" NOT NULL ENABLE);
ALTER TABLE "JWK"."AUTHORITY_USER" MODIFY ("PASSWORD" NOT NULL ENABLE);
ALTER TABLE "JWK"."AUTHORITY_USER" ADD CONSTRAINT "XPKAUTHORITY_USER" PRIMARY KEY ("LOGIN_ID")
USING INDEX "JWK"."XPKAUTHORITY_USER" ENABLE;
--------------------------------------------------------
-- Constraints for Table CAST
--------------------------------------------------------
ALTER TABLE "JWK"."CAST" MODIFY ("CAST_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."CAST" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "JWK"."CAST" MODIFY ("BIRTHDATE" NOT NULL ENABLE);
ALTER TABLE "JWK"."CAST" MODIFY ("PROFILE_IMAGE" NOT NULL ENABLE);
ALTER TABLE "JWK"."CAST" MODIFY ("NATIONALITY" NOT NULL ENABLE);
ALTER TABLE "JWK"."CAST" MODIFY ("INFO" NOT NULL ENABLE);
ALTER TABLE "JWK"."CAST" ADD CONSTRAINT "XPKCAST" PRIMARY KEY ("CAST_ID")
USING INDEX "JWK"."XPKCAST" ENABLE;
--------------------------------------------------------
-- Constraints for Table CODE
--------------------------------------------------------
ALTER TABLE "JWK"."CODE" MODIFY ("CODE" NOT NULL ENABLE);
ALTER TABLE "JWK"."CODE" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "JWK"."CODE" MODIFY ("UPPER_CODE" NOT NULL ENABLE);
ALTER TABLE "JWK"."CODE" ADD CONSTRAINT "XPKCODE" PRIMARY KEY ("CODE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
TABLESPACE "USERS" ENABLE;
--------------------------------------------------------
-- Constraints for Table CUSTOMER
--------------------------------------------------------
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("CUSTOMER_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("LOGIN_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("PASSWORD" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("NICKNAME" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("BIRTHDATE" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("GENDER" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("PHONE_NUMBER" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("EMAIL" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("POINT" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" MODIFY ("CREATED_AT" NOT NULL ENABLE);
ALTER TABLE "JWK"."CUSTOMER" ADD CONSTRAINT "XPKCUSTOMER" PRIMARY KEY ("CUSTOMER_ID")
USING INDEX "JWK"."XPKCUSTOMER" ENABLE;
--------------------------------------------------------
-- Constraints for Table GENRE_REGISTER
--------------------------------------------------------
ALTER TABLE "JWK"."GENRE_REGISTER" MODIFY ("GENRE_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."GENRE_REGISTER" MODIFY ("MOVIE_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."GENRE_REGISTER" ADD CONSTRAINT "XPKGENRE_REGISTER" PRIMARY KEY ("GENRE_ID", "MOVIE_ID")
USING INDEX "JWK"."XPKGENRE_REGISTER" ENABLE;
--------------------------------------------------------
-- Constraints for Table IMAGE
--------------------------------------------------------
ALTER TABLE "JWK"."IMAGE" MODIFY ("IMAGE_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."IMAGE" MODIFY ("UUID" NOT NULL ENABLE);
ALTER TABLE "JWK"."IMAGE" MODIFY ("FILE_NAME" NOT NULL ENABLE);
ALTER TABLE "JWK"."IMAGE" MODIFY ("FILE_URL" NOT NULL ENABLE);
ALTER TABLE "JWK"."IMAGE" ADD CONSTRAINT "XPKPOSTER" PRIMARY KEY ("IMAGE_ID")
USING INDEX "JWK"."XPKPOSTER" ENABLE;
--------------------------------------------------------
-- Constraints for Table MOVIE
--------------------------------------------------------
ALTER TABLE "JWK"."MOVIE" MODIFY ("MOVIE_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."MOVIE" MODIFY ("TITLE" NOT NULL ENABLE);
ALTER TABLE "JWK"."MOVIE" MODIFY ("RELEASE_DATE" NOT NULL ENABLE);
ALTER TABLE "JWK"."MOVIE" MODIFY ("RUNNING_TIME" NOT NULL ENABLE);
ALTER TABLE "JWK"."MOVIE" MODIFY ("INFO" NOT NULL ENABLE);
ALTER TABLE "JWK"."MOVIE" MODIFY ("COUNTRY" NOT NULL ENABLE);
ALTER TABLE "JWK"."MOVIE" MODIFY ("LANGUAGE" NOT NULL ENABLE);
ALTER TABLE "JWK"."MOVIE" MODIFY ("POSTER" NOT NULL ENABLE);
ALTER TABLE "JWK"."MOVIE" MODIFY ("DIRECTOR" NOT NULL ENABLE);
ALTER TABLE "JWK"."MOVIE" ADD CONSTRAINT "XPKMOVIE" PRIMARY KEY ("MOVIE_ID")
USING INDEX "JWK"."XPKMOVIE" ENABLE;
--------------------------------------------------------
-- Constraints for Table PAYMENT
--------------------------------------------------------
ALTER TABLE "JWK"."PAYMENT" MODIFY ("PAYMENT_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."PAYMENT" MODIFY ("PRICE" NOT NULL ENABLE);
ALTER TABLE "JWK"."PAYMENT" MODIFY ("PAYMENT_TIME" NOT NULL ENABLE);
ALTER TABLE "JWK"."PAYMENT" MODIFY ("METHOD" NOT NULL ENABLE);
ALTER TABLE "JWK"."PAYMENT" MODIFY ("STATUS" NOT NULL ENABLE);
ALTER TABLE "JWK"."PAYMENT" MODIFY ("TICKET_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."PAYMENT" ADD CONSTRAINT "XPKPAYMENT" PRIMARY KEY ("PAYMENT_ID")
USING INDEX "JWK"."XPKPAYMENT" ENABLE;
--------------------------------------------------------
-- Constraints for Table ROLE
--------------------------------------------------------
ALTER TABLE "JWK"."ROLE" MODIFY ("ROLE" NOT NULL ENABLE);
ALTER TABLE "JWK"."ROLE" MODIFY ("STARRING" NOT NULL ENABLE);
ALTER TABLE "JWK"."ROLE" MODIFY ("CAST_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."ROLE" MODIFY ("MOVIE_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."ROLE" ADD CONSTRAINT "XPKROLE" PRIMARY KEY ("CAST_ID", "MOVIE_ID")
USING INDEX "JWK"."XPKROLE" ENABLE;
--------------------------------------------------------
-- Constraints for Table SCHEDULE
--------------------------------------------------------
ALTER TABLE "JWK"."SCHEDULE" MODIFY ("SCHEDULE_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."SCHEDULE" MODIFY ("START_TIME" NOT NULL ENABLE);
ALTER TABLE "JWK"."SCHEDULE" MODIFY ("THEATER_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."SCHEDULE" MODIFY ("MOVIE_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."SCHEDULE" ADD CONSTRAINT "XPKSCHEDULE" PRIMARY KEY ("SCHEDULE_ID")
USING INDEX "JWK"."XPKSCHEDULE" ENABLE;
--------------------------------------------------------
-- Constraints for Table SEAT
--------------------------------------------------------
ALTER TABLE "JWK"."SEAT" MODIFY ("SEAT_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."SEAT" MODIFY ("COL_NUM" NOT NULL ENABLE);
ALTER TABLE "JWK"."SEAT" MODIFY ("PRICE" NOT NULL ENABLE);
ALTER TABLE "JWK"."SEAT" MODIFY ("THEATER_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."SEAT" ADD CONSTRAINT "XPKSEAT" PRIMARY KEY ("SEAT_ID", "THEATER_ID")
USING INDEX "JWK"."XPKSEAT" ENABLE;
--------------------------------------------------------
-- Constraints for Table THEATER
--------------------------------------------------------
ALTER TABLE "JWK"."THEATER" MODIFY ("THEATER_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."THEATER" MODIFY ("NAME" NOT NULL ENABLE);
ALTER TABLE "JWK"."THEATER" MODIFY ("TYPE" NOT NULL ENABLE);
ALTER TABLE "JWK"."THEATER" MODIFY ("FLOOR" NOT NULL ENABLE);
ALTER TABLE "JWK"."THEATER" ADD CONSTRAINT "XPKTHEATER" PRIMARY KEY ("THEATER_ID")
USING INDEX "JWK"."XPKTHEATER" ENABLE;
--------------------------------------------------------
-- Constraints for Table TICKET
--------------------------------------------------------
ALTER TABLE "JWK"."TICKET" MODIFY ("TICKET_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."TICKET" MODIFY ("TICKETING_TIME" NOT NULL ENABLE);
ALTER TABLE "JWK"."TICKET" MODIFY ("SCHEDULE_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."TICKET" ADD CONSTRAINT "XPKTICKETING" PRIMARY KEY ("TICKET_ID")
USING INDEX "JWK"."XPKTICKETING" ENABLE;
--------------------------------------------------------
-- Constraints for Table TICKET_SEAT
--------------------------------------------------------
ALTER TABLE "JWK"."TICKET_SEAT" MODIFY ("TICKET_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."TICKET_SEAT" MODIFY ("SEAT_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."TICKET_SEAT" MODIFY ("THEATER_ID" NOT NULL ENABLE);
ALTER TABLE "JWK"."TICKET_SEAT" ADD CONSTRAINT "XPKTICKETING_SEAT" PRIMARY KEY ("TICKET_ID", "SEAT_ID", "THEATER_ID")
USING INDEX "JWK"."XPKTICKETING_SEAT" ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table AUTHORITY_USER
--------------------------------------------------------
ALTER TABLE "JWK"."AUTHORITY_USER" ADD CONSTRAINT "R_26" FOREIGN KEY ("ADMIN_ID")
REFERENCES "JWK"."ADMIN" ("ADMIN_ID") ON DELETE SET NULL ENABLE;
ALTER TABLE "JWK"."AUTHORITY_USER" ADD CONSTRAINT "R_27" FOREIGN KEY ("CUSTOMER_ID")
REFERENCES "JWK"."CUSTOMER" ("CUSTOMER_ID") ON DELETE SET NULL ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CAST
--------------------------------------------------------
ALTER TABLE "JWK"."CAST" ADD CONSTRAINT "R_15" FOREIGN KEY ("PROFILE_IMAGE")
REFERENCES "JWK"."IMAGE" ("IMAGE_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CODE
--------------------------------------------------------
ALTER TABLE "JWK"."CODE" ADD CONSTRAINT "R_32" FOREIGN KEY ("CODE")
REFERENCES "JWK"."CODE" ("CODE") ON DELETE SET NULL ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table GENRE_REGISTER
--------------------------------------------------------
ALTER TABLE "JWK"."GENRE_REGISTER" ADD CONSTRAINT "R_11" FOREIGN KEY ("GENRE_ID")
REFERENCES "JWK"."CODE" ("CODE") ENABLE;
ALTER TABLE "JWK"."GENRE_REGISTER" ADD CONSTRAINT "R_13" FOREIGN KEY ("MOVIE_ID")
REFERENCES "JWK"."MOVIE" ("MOVIE_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table MOVIE
--------------------------------------------------------
ALTER TABLE "JWK"."MOVIE" ADD CONSTRAINT "R_4" FOREIGN KEY ("RATING")
REFERENCES "JWK"."CODE" ("CODE") ENABLE;
ALTER TABLE "JWK"."MOVIE" ADD CONSTRAINT "R_3" FOREIGN KEY ("POSTER")
REFERENCES "JWK"."IMAGE" ("IMAGE_ID") ENABLE;
ALTER TABLE "JWK"."MOVIE" ADD CONSTRAINT "R_8" FOREIGN KEY ("DIRECTOR")
REFERENCES "JWK"."CAST" ("CAST_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table PAYMENT
--------------------------------------------------------
ALTER TABLE "JWK"."PAYMENT" ADD CONSTRAINT "R_23" FOREIGN KEY ("METHOD")
REFERENCES "JWK"."CODE" ("CODE") ENABLE;
ALTER TABLE "JWK"."PAYMENT" ADD CONSTRAINT "R_24" FOREIGN KEY ("TICKET_ID")
REFERENCES "JWK"."TICKET" ("TICKET_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table ROLE
--------------------------------------------------------
ALTER TABLE "JWK"."ROLE" ADD CONSTRAINT "R_6" FOREIGN KEY ("CAST_ID")
REFERENCES "JWK"."CAST" ("CAST_ID") ENABLE;
ALTER TABLE "JWK"."ROLE" ADD CONSTRAINT "R_7" FOREIGN KEY ("MOVIE_ID")
REFERENCES "JWK"."MOVIE" ("MOVIE_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table SCHEDULE
--------------------------------------------------------
ALTER TABLE "JWK"."SCHEDULE" ADD CONSTRAINT "R_16" FOREIGN KEY ("MOVIE_ID")
REFERENCES "JWK"."MOVIE" ("MOVIE_ID") ENABLE;
ALTER TABLE "JWK"."SCHEDULE" ADD CONSTRAINT "R_17" FOREIGN KEY ("THEATER_ID")
REFERENCES "JWK"."THEATER" ("THEATER_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table SEAT
--------------------------------------------------------
ALTER TABLE "JWK"."SEAT" ADD CONSTRAINT "R_14" FOREIGN KEY ("THEATER_ID")
REFERENCES "JWK"."THEATER" ("THEATER_ID") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table THEATER
--------------------------------------------------------
ALTER TABLE "JWK"."THEATER" ADD CONSTRAINT "R_20" FOREIGN KEY ("TYPE")
REFERENCES "JWK"."CODE" ("CODE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table TICKET
--------------------------------------------------------
ALTER TABLE "JWK"."TICKET" ADD CONSTRAINT "R_18" FOREIGN KEY ("SCHEDULE_ID")
REFERENCES "JWK"."SCHEDULE" ("SCHEDULE_ID") ENABLE;
ALTER TABLE "JWK"."TICKET" ADD CONSTRAINT "R_19" FOREIGN KEY ("CUSTOMER_ID")
REFERENCES "JWK"."CUSTOMER" ("CUSTOMER_ID") ON DELETE SET NULL ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table TICKET_SEAT
--------------------------------------------------------
ALTER TABLE "JWK"."TICKET_SEAT" ADD CONSTRAINT "R_21" FOREIGN KEY ("TICKET_ID")
REFERENCES "JWK"."TICKET" ("TICKET_ID") ENABLE;
ALTER TABLE "JWK"."TICKET_SEAT" ADD CONSTRAINT "R_22" FOREIGN KEY ("SEAT_ID", "THEATER_ID")
REFERENCES "JWK"."SEAT" ("SEAT_ID", "THEATER_ID") ENABLE;
Backend Engineer