APT관리프로그램
APT관리프로그램 -SQL (DataBase)
햄찌개
2020. 9. 14. 09:52
-------------------------------------------------------
-- 파일이 생성됨 - 목요일-9월-10-2020
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Table ADDR
--------------------------------------------------------
CREATE TABLE "APT2"."ADDR"
( "ADDR_NUM" NUMBER(10,0),
"ADDR_CARNUM" 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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table CAR
--------------------------------------------------------
CREATE TABLE "APT2"."CAR"
( "CAR_NUM" NUMBER(10,0),
"CAR_OWNER" VARCHAR2(20 BYTE),
"CAR_TYPE" VARCHAR2(20 BYTE),
"CAR_LOC" NUMBER(10,0),
"ADDR_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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table COMMUNITY
--------------------------------------------------------
CREATE TABLE "APT2"."COMMUNITY"
( "WRITER_DATE" DATE,
"WRITER_SUGGESTIONS" VARCHAR2(200 BYTE),
"WRITER_REPL" VARCHAR2(50 BYTE),
"WRITER_NUM" NUMBER(38,0),
"RESIDENT_ID" VARCHAR2(20 BYTE),
"MANAGER_ID" VARCHAR2(20 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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table EXPENSES
--------------------------------------------------------
CREATE TABLE "APT2"."EXPENSES"
( "EXPENSES_ELECTRICITY" NUMBER(38,0),
"EXPENSES_WATER" NUMBER(38,0),
"EXPENSES_GUARD" NUMBER(38,0),
"ADDR_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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table GUEST
--------------------------------------------------------
CREATE TABLE "APT2"."GUEST"
( "GUEST_CARNUM" NUMBER(10,0),
"GUEST_NAME" VARCHAR2(20 BYTE),
"ADDR_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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table MANAGER
--------------------------------------------------------
CREATE TABLE "APT2"."MANAGER"
( "MANAGER_ID" VARCHAR2(20 BYTE),
"MANAGER_PASS" VARCHAR2(20 BYTE),
"MANAGER_NAME" VARCHAR2(20 BYTE),
"MANAGER_HP" VARCHAR2(20 BYTE),
"MANAGER_CODE" NUMBER(10,0) DEFAULT 2
) 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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table PARKING
--------------------------------------------------------
CREATE TABLE "APT2"."PARKING"
( "PARKING_LOC" NUMBER(10,0),
"PARKING_ADDR" NUMBER(10,0) DEFAULT NULL,
"CAR_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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table POST
--------------------------------------------------------
CREATE TABLE "APT2"."POST"
( "POST_NAME" VARCHAR2(20 BYTE),
"ADDR_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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table RESIDENT
--------------------------------------------------------
CREATE TABLE "APT2"."RESIDENT"
( "RESIDENT_ID" VARCHAR2(20 BYTE),
"RESIDENT_PASS" VARCHAR2(20 BYTE),
"RESIDENT_NAME" VARCHAR2(20 BYTE),
"RESIDENT_CODE" NUMBER(2,0) DEFAULT 1,
"ADDR_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 "SYSTEM" ;
REM INSERTING into APT2.ADDR
SET DEFINE OFF;
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1101,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1102,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1201,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1202,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1301,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1302,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1401,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1402,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1501,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1502,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1601,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1602,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1701,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1702,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1801,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1802,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1901,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (1902,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2101,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2102,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2201,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2202,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2301,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2302,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2401,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2402,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2501,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2502,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2601,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2602,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2701,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2702,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2801,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2802,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2901,null);
Insert into APT2.ADDR (ADDR_NUM,ADDR_CARNUM) values (2902,null);
REM INSERTING into APT2.CAR
SET DEFINE OFF;
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (3615,'박찬','스파크',null,1101);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (7777,'전진원','부가티',null,1201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (2654,'전진원','펠리세이드',null,1201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (8909,'전진원','스파크',null,1201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (7878,'박찬','벨로스터DCT',null,2201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (7979,'박찬','스파크',null,2201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (1234,'박찬','asd',null,2201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (9999,'박찬','마세라티',null,2201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (9966,'김좌진','마티즈',null,1801);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (1000,'관리자','제네시스',null,1101);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (1243,'박찬','펠리세이드',null,2201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (9783,'박찬','제네시스',null,2201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (8989,'박찬','스파크',null,2201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (7653,'박찬','람보르기니',null,2201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (8787,'전진원','람보르기니',null,1201);
Insert into APT2.CAR (CAR_NUM,CAR_OWNER,CAR_TYPE,CAR_LOC,ADDR_NUM) values (8743,'박찬','마티즈',null,2201);
REM INSERTING into APT2.COMMUNITY
SET DEFINE OFF;
Insert into APT2.COMMUNITY (WRITER_DATE,WRITER_SUGGESTIONS,WRITER_REPL,WRITER_NUM,RESIDENT_ID,MANAGER_ID) values (to_date('2020/09/10','YYYY/MM/DD'),'가나다라마바사','하이',0,'a123','admin');
Insert into APT2.COMMUNITY (WRITER_DATE,WRITER_SUGGESTIONS,WRITER_REPL,WRITER_NUM,RESIDENT_ID,MANAGER_ID) values (to_date('2020/09/10','YYYY/MM/DD'),'나는바보입니다',null,1,'a123',null);
Insert into APT2.COMMUNITY (WRITER_DATE,WRITER_SUGGESTIONS,WRITER_REPL,WRITER_NUM,RESIDENT_ID,MANAGER_ID) values (to_date('2020/09/10','YYYY/MM/DD'),null,null,2,null,null);
Insert into APT2.COMMUNITY (WRITER_DATE,WRITER_SUGGESTIONS,WRITER_REPL,WRITER_NUM,RESIDENT_ID,MANAGER_ID) values (to_date('2020/09/10','YYYY/MM/DD'),null,null,3,null,null);
Insert into APT2.COMMUNITY (WRITER_DATE,WRITER_SUGGESTIONS,WRITER_REPL,WRITER_NUM,RESIDENT_ID,MANAGER_ID) values (to_date('2020/09/10','YYYY/MM/DD'),'전기가 안나와요',null,4,'wlsdnjs123',null);
Insert into APT2.COMMUNITY (WRITER_DATE,WRITER_SUGGESTIONS,WRITER_REPL,WRITER_NUM,RESIDENT_ID,MANAGER_ID) values (to_date('2020/09/10','YYYY/MM/DD'),'물도안나와요',null,5,'wlsdnjs123',null);
Insert into APT2.COMMUNITY (WRITER_DATE,WRITER_SUGGESTIONS,WRITER_REPL,WRITER_NUM,RESIDENT_ID,MANAGER_ID) values (to_date('2020/09/10','YYYY/MM/DD'),'5',null,6,'wlsdnjs123',null);
Insert into APT2.COMMUNITY (WRITER_DATE,WRITER_SUGGESTIONS,WRITER_REPL,WRITER_NUM,RESIDENT_ID,MANAGER_ID) values (to_date('2020/09/10','YYYY/MM/DD'),'전기',null,7,'cks123',null);
Insert into APT2.COMMUNITY (WRITER_DATE,WRITER_SUGGESTIONS,WRITER_REPL,WRITER_NUM,RESIDENT_ID,MANAGER_ID) values (to_date('2020/09/10','YYYY/MM/DD'),'sadfiv9ipou2 ufoignfdpofiakjhsfoisaiifbyhuosladfkjgsadfgasdgfoiewifhsdagfv',null,8,'cks123',null);
REM INSERTING into APT2.EXPENSES
SET DEFINE OFF;
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11850,24090,2101);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (29544,12080,24090,2102);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11850,24090,2201);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (29544,12080,24090,2202);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11850,24090,2301);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (29544,12080,24090,2302);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11850,24090,2401);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (29544,12080,24090,2402);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11850,24090,2501);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (29544,12080,24090,2502);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11850,24090,2601);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (29544,12080,24090,2602);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11850,24090,2701);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (29544,12080,24090,2702);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11850,24090,2801);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (29544,12080,24090,2802);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11850,24090,2901);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (29544,12080,24090,2902);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (20280,11350,24090,1101);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (39544,12380,24090,1102);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (20280,11350,24090,1201);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (39544,12380,24090,1202);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (20280,11350,24090,1301);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (39544,12380,24090,1302);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (20280,11350,24090,1401);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (39544,12380,24090,1402);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (20280,11350,24090,1501);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (39544,12380,24090,1502);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (20280,11450,24090,1601);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (39544,12580,24090,1602);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (20280,11650,24090,1701);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (19544,12780,24090,1702);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (30280,11750,24090,1801);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (19544,12880,24090,1802);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (20280,11150,24090,1901);
Insert into APT2.EXPENSES (EXPENSES_ELECTRICITY,EXPENSES_WATER,EXPENSES_GUARD,ADDR_NUM) values (19544,12280,24090,1902);
REM INSERTING into APT2.GUEST
SET DEFINE OFF;
Insert into APT2.GUEST (GUEST_CARNUM,GUEST_NAME,ADDR_NUM) values (8000,'박찬',1102);
Insert into APT2.GUEST (GUEST_CARNUM,GUEST_NAME,ADDR_NUM) values (9823,'안녕하',1102);
REM INSERTING into APT2.MANAGER
SET DEFINE OFF;
Insert into APT2.MANAGER (MANAGER_ID,MANAGER_PASS,MANAGER_NAME,MANAGER_HP,MANAGER_CODE) values ('admin2','123123123','관리자','010-5316-5120',2);
Insert into APT2.MANAGER (MANAGER_ID,MANAGER_PASS,MANAGER_NAME,MANAGER_HP,MANAGER_CODE) values ('admin','qweasd123','관리자','010-5315-6512',2);
REM INSERTING into APT2.PARKING
SET DEFINE OFF;
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (102,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (103,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (104,2201,7653);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (105,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (106,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (107,1201,8787);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (108,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (109,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (110,2201,8743);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (111,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (112,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (113,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (114,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (115,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (116,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (117,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (118,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (119,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (120,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (121,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (122,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (123,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (124,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (125,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (126,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (127,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (128,1201,7777);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (129,1201,3615);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (130,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (101,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (201,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (202,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (203,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (204,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (205,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (206,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (207,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (208,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (209,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (210,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (211,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (212,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (213,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (214,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (215,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (216,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (217,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (218,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (219,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (220,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (221,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (222,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (223,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (224,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (225,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (226,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (227,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (228,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (229,null,null);
Insert into APT2.PARKING (PARKING_LOC,PARKING_ADDR,CAR_NUM) values (230,null,null);
REM INSERTING into APT2.POST
SET DEFINE OFF;
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('HONEY',1101);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('CUP',1102);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('WATER',1201);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,1202);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,1301);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,1302);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('PHONE',1401);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('MOUSE',1402);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('KEYBOARD',1501);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('COMPUTER',1502);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,1601);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,1701);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('MASKE',1702);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('PEN',1801);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,1802);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('FAN',1901);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,1902);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('WATER',2101);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('COFFEE',2102);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('SHOSE',2201);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('JORDEN',2202);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('NIKE',2301);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,2302);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('CANDY',2401);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('WATCH',2402);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('DRINK',2501);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,2502);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('LISTERINE',2601);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('PORK',2602);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('MEAT',2701);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values (null,2702);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('TV',2801);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('SMARTTV',2802);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('IPHONE',2901);
Insert into APT2.POST (POST_NAME,ADDR_NUM) values ('SMARTPHONE',2902);
REM INSERTING into APT2.RESIDENT
SET DEFINE OFF;
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('a001','qweasd123','이영만',0,1201);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('qwe123','qweasd123','박찬',1,1101);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('qweasd','qweasd123','박찬',1,1202);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('yco1234','123123123','박찬',1,1101);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('yco1798','tkfkdgo072','박찬',1,1101);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('op123','123123123','박찬',1,1201);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('kl123','123123123','박찬',1,1101);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('tkyco1790','tkfkdgo072','박찬',1,1202);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('jk0909','tkfkdgo072','박크찬',1,2101);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('wlsdnjs123','wlsdnjs123','전진원',1,1201);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('a123','aaaaaaaa','전진원',1,1202);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('a003','zzzzzzzz','흡연',1,2602);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('cks123','qkrcks123','박찬',1,2201);
Insert into APT2.RESIDENT (RESIDENT_ID,RESIDENT_PASS,RESIDENT_NAME,RESIDENT_CODE,ADDR_NUM) values ('a789','aaaaaaaa','김좌진',1,1801);
--------------------------------------------------------
-- DDL for Index XPKRESIDENT
--------------------------------------------------------
CREATE UNIQUE INDEX "APT2"."XPKRESIDENT" ON "APT2"."RESIDENT" ("RESIDENT_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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index XPKPARKING
--------------------------------------------------------
CREATE UNIQUE INDEX "APT2"."XPKPARKING" ON "APT2"."PARKING" ("PARKING_LOC")
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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index XPKPOST
--------------------------------------------------------
CREATE UNIQUE INDEX "APT2"."XPKPOST" ON "APT2"."POST" ("ADDR_NUM")
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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index XPKEXPENSES
--------------------------------------------------------
CREATE UNIQUE INDEX "APT2"."XPKEXPENSES" ON "APT2"."EXPENSES" ("ADDR_NUM")
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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index XPKADDR
--------------------------------------------------------
CREATE UNIQUE INDEX "APT2"."XPKADDR" ON "APT2"."ADDR" ("ADDR_NUM")
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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index XPKCOMMUNITY
--------------------------------------------------------
CREATE UNIQUE INDEX "APT2"."XPKCOMMUNITY" ON "APT2"."COMMUNITY" ("WRITER_NUM")
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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index XPKGUEST
--------------------------------------------------------
CREATE UNIQUE INDEX "APT2"."XPKGUEST" ON "APT2"."GUEST" ("GUEST_NAME", "GUEST_CARNUM")
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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index XPKCAR
--------------------------------------------------------
CREATE UNIQUE INDEX "APT2"."XPKCAR" ON "APT2"."CAR" ("CAR_NUM")
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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index XPKMANAGER
--------------------------------------------------------
CREATE UNIQUE INDEX "APT2"."XPKMANAGER" ON "APT2"."MANAGER" ("MANAGER_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 "SYSTEM" ;
--------------------------------------------------------
-- DDL for Trigger TD_ADDR
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TD_ADDR" AFTER DELETE ON ADDR for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- DELETE trigger on ADDR
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR RESIDENT on parent delete set null */
/* ERWIN_RELATION:CHECKSUM="000427d5", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="RESIDENT"
P2C_VERB_PHRASE="R/6", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_6", FK_COLUMNS="ADDR_NUM" */
UPDATE RESIDENT
SET
/* %SetFK(RESIDENT,NULL) */
RESIDENT.ADDR_NUM = NULL
WHERE
/* %JoinFKPK(RESIDENT,:%Old," = "," AND") */
RESIDENT.ADDR_NUM = :old.ADDR_NUM;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR CAR on parent delete set null */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="CAR"
P2C_VERB_PHRASE="R/11", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_11", FK_COLUMNS="ADDR_NUM" */
UPDATE CAR
SET
/* %SetFK(CAR,NULL) */
CAR.ADDR_NUM = NULL
WHERE
/* %JoinFKPK(CAR,:%Old," = "," AND") */
CAR.ADDR_NUM = :old.ADDR_NUM;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR GUEST on parent delete set null */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="GUEST"
P2C_VERB_PHRASE="R/14", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_14", FK_COLUMNS="ADDR_NUM" */
UPDATE GUEST
SET
/* %SetFK(GUEST,NULL) */
GUEST.ADDR_NUM = NULL
WHERE
/* %JoinFKPK(GUEST,:%Old," = "," AND") */
GUEST.ADDR_NUM = :old.ADDR_NUM;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR EXPENSES on parent delete restrict */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="EXPENSES"
P2C_VERB_PHRASE="R/15", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_15", FK_COLUMNS="ADDR_NUM" */
SELECT count(*) INTO NUMROWS
FROM EXPENSES
WHERE
/* %JoinFKPK(EXPENSES,:%Old," = "," AND") */
EXPENSES.ADDR_NUM = :old.ADDR_NUM;
IF (NUMROWS > 0)
THEN
raise_application_error(
-20001,
'Cannot delete ADDR because EXPENSES exists.'
);
END IF;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR POST on parent delete restrict */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="POST"
P2C_VERB_PHRASE="R/16", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_16", FK_COLUMNS="ADDR_NUM" */
SELECT count(*) INTO NUMROWS
FROM POST
WHERE
/* %JoinFKPK(POST,:%Old," = "," AND") */
POST.ADDR_NUM = :old.ADDR_NUM;
IF (NUMROWS > 0)
THEN
raise_application_error(
-20001,
'Cannot delete ADDR because POST exists.'
);
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TD_ADDR" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TD_CAR
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TD_CAR" AFTER DELETE ON CAR for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- DELETE trigger on CAR
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* CAR PARKING on parent delete set null */
/* ERWIN_RELATION:CHECKSUM="0000ac17", PARENT_OWNER="", PARENT_TABLE="CAR"
CHILD_OWNER="", CHILD_TABLE="PARKING"
P2C_VERB_PHRASE="R/13", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_13", FK_COLUMNS="CAR_NUM" */
UPDATE PARKING
SET
/* %SetFK(PARKING,NULL) */
PARKING.CAR_NUM = NULL
WHERE
/* %JoinFKPK(PARKING,:%Old," = "," AND") */
PARKING.CAR_NUM = :old.CAR_NUM;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TD_CAR" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TD_MANAGER
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TD_MANAGER" AFTER DELETE ON MANAGER for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- DELETE trigger on MANAGER
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* MANAGER COMMUNITY on parent delete set null */
/* ERWIN_RELATION:CHECKSUM="0000c762", PARENT_OWNER="", PARENT_TABLE="MANAGER"
CHILD_OWNER="", CHILD_TABLE="COMMUNITY"
P2C_VERB_PHRASE="R/8", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_8", FK_COLUMNS="MANAGER_ID" */
UPDATE COMMUNITY
SET
/* %SetFK(COMMUNITY,NULL) */
COMMUNITY.MANAGER_ID = NULL
WHERE
/* %JoinFKPK(COMMUNITY,:%Old," = "," AND") */
COMMUNITY.MANAGER_ID = :old.MANAGER_ID;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TD_MANAGER" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TD_RESIDENT
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TD_RESIDENT" AFTER DELETE ON RESIDENT for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- DELETE trigger on RESIDENT
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* RESIDENT COMMUNITY on parent delete set null */
/* ERWIN_RELATION:CHECKSUM="0000c732", PARENT_OWNER="", PARENT_TABLE="RESIDENT"
CHILD_OWNER="", CHILD_TABLE="COMMUNITY"
P2C_VERB_PHRASE="R/7", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_7", FK_COLUMNS="RESIDENT_ID" */
UPDATE COMMUNITY
SET
/* %SetFK(COMMUNITY,NULL) */
COMMUNITY.RESIDENT_ID = NULL
WHERE
/* %JoinFKPK(COMMUNITY,:%Old," = "," AND") */
COMMUNITY.RESIDENT_ID = :old.RESIDENT_ID;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TD_RESIDENT" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TI_CAR
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TI_CAR" BEFORE INSERT ON CAR for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- INSERT trigger on CAR
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR CAR on child insert set null */
/* ERWIN_RELATION:CHECKSUM="0000dc6d", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="CAR"
P2C_VERB_PHRASE="R/11", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_11", FK_COLUMNS="ADDR_NUM" */
UPDATE CAR
SET
/* %SetFK(CAR,NULL) */
CAR.ADDR_NUM = NULL
WHERE
NOT EXISTS (
SELECT * FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM
)
/* %JoinPKPK(CAR,:%New," = "," AND") */
and CAR.CAR_NUM = :new.CAR_NUM;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TI_CAR" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TI_COMMUNITY
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TI_COMMUNITY" BEFORE INSERT ON COMMUNITY for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- INSERT trigger on COMMUNITY
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* RESIDENT COMMUNITY on child insert set null */
/* ERWIN_RELATION:CHECKSUM="00020a91", PARENT_OWNER="", PARENT_TABLE="RESIDENT"
CHILD_OWNER="", CHILD_TABLE="COMMUNITY"
P2C_VERB_PHRASE="R/7", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_7", FK_COLUMNS="RESIDENT_ID" */
UPDATE COMMUNITY
SET
/* %SetFK(COMMUNITY,NULL) */
COMMUNITY.RESIDENT_ID = NULL
WHERE
NOT EXISTS (
SELECT * FROM RESIDENT
WHERE
/* %JoinFKPK(:%New,RESIDENT," = "," AND") */
:new.RESIDENT_ID = RESIDENT.RESIDENT_ID
)
/* %JoinPKPK(COMMUNITY,:%New," = "," AND") */
and COMMUNITY.WRITER_NUM = :new.WRITER_NUM;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* MANAGER COMMUNITY on child insert set null */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="MANAGER"
CHILD_OWNER="", CHILD_TABLE="COMMUNITY"
P2C_VERB_PHRASE="R/8", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_8", FK_COLUMNS="MANAGER_ID" */
UPDATE COMMUNITY
SET
/* %SetFK(COMMUNITY,NULL) */
COMMUNITY.MANAGER_ID = NULL
WHERE
NOT EXISTS (
SELECT * FROM MANAGER
WHERE
/* %JoinFKPK(:%New,MANAGER," = "," AND") */
:new.MANAGER_ID = MANAGER.MANAGER_ID
)
/* %JoinPKPK(COMMUNITY,:%New," = "," AND") */
and COMMUNITY.WRITER_NUM = :new.WRITER_NUM;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TI_COMMUNITY" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TI_EXPENSES
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TI_EXPENSES" BEFORE INSERT ON EXPENSES for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- INSERT trigger on EXPENSES
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR EXPENSES on child insert restrict */
/* ERWIN_RELATION:CHECKSUM="0000eebe", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="EXPENSES"
P2C_VERB_PHRASE="R/15", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_15", FK_COLUMNS="ADDR_NUM" */
SELECT count(*) INTO NUMROWS
FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
NUMROWS = 0
)
THEN
raise_application_error(
-20002,
'Cannot insert EXPENSES because ADDR does not exist.'
);
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TI_EXPENSES" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TI_GUEST
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TI_GUEST" BEFORE INSERT ON GUEST for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- INSERT trigger on GUEST
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR GUEST on child insert set null */
/* ERWIN_RELATION:CHECKSUM="0000fb8e", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="GUEST"
P2C_VERB_PHRASE="R/14", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_14", FK_COLUMNS="ADDR_NUM" */
UPDATE GUEST
SET
/* %SetFK(GUEST,NULL) */
GUEST.ADDR_NUM = NULL
WHERE
NOT EXISTS (
SELECT * FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM
)
/* %JoinPKPK(GUEST,:%New," = "," AND") */
and GUEST.GUEST_NAME = :new.GUEST_NAME AND
GUEST.GUEST_CARNUM = :new.GUEST_CARNUM;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TI_GUEST" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TI_PARKING
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TI_PARKING" BEFORE INSERT ON PARKING for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- INSERT trigger on PARKING
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* CAR PARKING on child insert set null */
/* ERWIN_RELATION:CHECKSUM="0000e6c4", PARENT_OWNER="", PARENT_TABLE="CAR"
CHILD_OWNER="", CHILD_TABLE="PARKING"
P2C_VERB_PHRASE="R/13", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_13", FK_COLUMNS="CAR_NUM" */
UPDATE PARKING
SET
/* %SetFK(PARKING,NULL) */
PARKING.CAR_NUM = NULL
WHERE
NOT EXISTS (
SELECT * FROM CAR
WHERE
/* %JoinFKPK(:%New,CAR," = "," AND") */
:new.CAR_NUM = CAR.CAR_NUM
)
/* %JoinPKPK(PARKING,:%New," = "," AND") */
and PARKING.PARKING_LOC = :new.PARKING_LOC;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TI_PARKING" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TI_POST
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TI_POST" BEFORE INSERT ON POST for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- INSERT trigger on POST
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR POST on child insert restrict */
/* ERWIN_RELATION:CHECKSUM="0000eb57", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="POST"
P2C_VERB_PHRASE="R/16", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_16", FK_COLUMNS="ADDR_NUM" */
SELECT count(*) INTO NUMROWS
FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
NUMROWS = 0
)
THEN
raise_application_error(
-20002,
'Cannot insert POST because ADDR does not exist.'
);
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TI_POST" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TI_RESIDENT
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TI_RESIDENT" BEFORE INSERT ON RESIDENT for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- INSERT trigger on RESIDENT
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR RESIDENT on child insert set null */
/* ERWIN_RELATION:CHECKSUM="0000efa6", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="RESIDENT"
P2C_VERB_PHRASE="R/6", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_6", FK_COLUMNS="ADDR_NUM" */
UPDATE RESIDENT
SET
/* %SetFK(RESIDENT,NULL) */
RESIDENT.ADDR_NUM = NULL
WHERE
NOT EXISTS (
SELECT * FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM
)
/* %JoinPKPK(RESIDENT,:%New," = "," AND") */
and RESIDENT.RESIDENT_ID = :new.RESIDENT_ID;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TI_RESIDENT" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TU_ADDR
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TU_ADDR" AFTER UPDATE ON ADDR for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- UPDATE trigger on ADDR
DECLARE NUMROWS INTEGER;
BEGIN
/* ADDR RESIDENT on parent update set null */
/* ERWIN_RELATION:CHECKSUM="000495d7", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="RESIDENT"
P2C_VERB_PHRASE="R/6", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_6", FK_COLUMNS="ADDR_NUM" */
IF
/* %JoinPKPK(:%Old,:%New," <> "," OR ") */
:old.ADDR_NUM <> :new.ADDR_NUM
THEN
UPDATE RESIDENT
SET
/* %SetFK(RESIDENT,NULL) */
RESIDENT.ADDR_NUM = NULL
WHERE
/* %JoinFKPK(RESIDENT,:%Old," = ",",") */
RESIDENT.ADDR_NUM = :old.ADDR_NUM;
END IF;
/* ADDR CAR on parent update set null */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="CAR"
P2C_VERB_PHRASE="R/11", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_11", FK_COLUMNS="ADDR_NUM" */
IF
/* %JoinPKPK(:%Old,:%New," <> "," OR ") */
:old.ADDR_NUM <> :new.ADDR_NUM
THEN
UPDATE CAR
SET
/* %SetFK(CAR,NULL) */
CAR.ADDR_NUM = NULL
WHERE
/* %JoinFKPK(CAR,:%Old," = ",",") */
CAR.ADDR_NUM = :old.ADDR_NUM;
END IF;
/* ADDR GUEST on parent update set null */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="GUEST"
P2C_VERB_PHRASE="R/14", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_14", FK_COLUMNS="ADDR_NUM" */
IF
/* %JoinPKPK(:%Old,:%New," <> "," OR ") */
:old.ADDR_NUM <> :new.ADDR_NUM
THEN
UPDATE GUEST
SET
/* %SetFK(GUEST,NULL) */
GUEST.ADDR_NUM = NULL
WHERE
/* %JoinFKPK(GUEST,:%Old," = ",",") */
GUEST.ADDR_NUM = :old.ADDR_NUM;
END IF;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR EXPENSES on parent update restrict */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="EXPENSES"
P2C_VERB_PHRASE="R/15", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_15", FK_COLUMNS="ADDR_NUM" */
IF
/* %JoinPKPK(:%Old,:%New," <> "," OR ") */
:old.ADDR_NUM <> :new.ADDR_NUM
THEN
SELECT count(*) INTO NUMROWS
FROM EXPENSES
WHERE
/* %JoinFKPK(EXPENSES,:%Old," = "," AND") */
EXPENSES.ADDR_NUM = :old.ADDR_NUM;
IF (NUMROWS > 0)
THEN
raise_application_error(
-20005,
'Cannot update ADDR because EXPENSES exists.'
);
END IF;
END IF;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR POST on parent update restrict */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="POST"
P2C_VERB_PHRASE="R/16", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_16", FK_COLUMNS="ADDR_NUM" */
IF
/* %JoinPKPK(:%Old,:%New," <> "," OR ") */
:old.ADDR_NUM <> :new.ADDR_NUM
THEN
SELECT count(*) INTO NUMROWS
FROM POST
WHERE
/* %JoinFKPK(POST,:%Old," = "," AND") */
POST.ADDR_NUM = :old.ADDR_NUM;
IF (NUMROWS > 0)
THEN
raise_application_error(
-20005,
'Cannot update ADDR because POST exists.'
);
END IF;
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TU_ADDR" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TU_CAR
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TU_CAR" AFTER UPDATE ON CAR for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- UPDATE trigger on CAR
DECLARE NUMROWS INTEGER;
BEGIN
/* CAR PARKING on parent update set null */
/* ERWIN_RELATION:CHECKSUM="0001e926", PARENT_OWNER="", PARENT_TABLE="CAR"
CHILD_OWNER="", CHILD_TABLE="PARKING"
P2C_VERB_PHRASE="R/13", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_13", FK_COLUMNS="CAR_NUM" */
IF
/* %JoinPKPK(:%Old,:%New," <> "," OR ") */
:old.CAR_NUM <> :new.CAR_NUM
THEN
UPDATE PARKING
SET
/* %SetFK(PARKING,NULL) */
PARKING.CAR_NUM = NULL
WHERE
/* %JoinFKPK(PARKING,:%Old," = ",",") */
PARKING.CAR_NUM = :old.CAR_NUM;
END IF;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR CAR on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="CAR"
P2C_VERB_PHRASE="R/11", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_11", FK_COLUMNS="ADDR_NUM" */
SELECT count(*) INTO NUMROWS
FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
:new.ADDR_NUM IS NOT NULL AND
NUMROWS = 0
)
THEN
raise_application_error(
-20007,
'Cannot update CAR because ADDR does not exist.'
);
END IF;.
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TU_CAR" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TU_COMMUNITY
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TU_COMMUNITY" AFTER UPDATE ON COMMUNITY for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- UPDATE trigger on COMMUNITY
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* RESIDENT COMMUNITY on child update no action */
/* ERWIN_RELATION:CHECKSUM="00022d02", PARENT_OWNER="", PARENT_TABLE="RESIDENT"
CHILD_OWNER="", CHILD_TABLE="COMMUNITY"
P2C_VERB_PHRASE="R/7", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_7", FK_COLUMNS="RESIDENT_ID" */
SELECT count(*) INTO NUMROWS
FROM RESIDENT
WHERE
/* %JoinFKPK(:%New,RESIDENT," = "," AND") */
:new.RESIDENT_ID = RESIDENT.RESIDENT_ID;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
:new.RESIDENT_ID IS NOT NULL AND
NUMROWS = 0
)
THEN
raise_application_error(
-20007,
'Cannot update COMMUNITY because RESIDENT does not exist.'
);
END IF;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* MANAGER COMMUNITY on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="MANAGER"
CHILD_OWNER="", CHILD_TABLE="COMMUNITY"
P2C_VERB_PHRASE="R/8", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_8", FK_COLUMNS="MANAGER_ID" */
SELECT count(*) INTO NUMROWS
FROM MANAGER
WHERE
/* %JoinFKPK(:%New,MANAGER," = "," AND") */
:new.MANAGER_ID = MANAGER.MANAGER_ID;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
:new.MANAGER_ID IS NOT NULL AND
NUMROWS = 0
)
THEN
raise_application_error(
-20007,
'Cannot update COMMUNITY because MANAGER does not exist.'
);
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TU_COMMUNITY" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TU_EXPENSES
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TU_EXPENSES" AFTER UPDATE ON EXPENSES for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- UPDATE trigger on EXPENSES
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR EXPENSES on child update restrict */
/* ERWIN_RELATION:CHECKSUM="0000f3df", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="EXPENSES"
P2C_VERB_PHRASE="R/15", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_15", FK_COLUMNS="ADDR_NUM" */
SELECT count(*) INTO NUMROWS
FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
NUMROWS = 0
)
THEN
raise_application_error(
-20007,
'Cannot update EXPENSES because ADDR does not exist.'
);
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TU_EXPENSES" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TU_GUEST
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TU_GUEST" AFTER UPDATE ON GUEST for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- UPDATE trigger on GUEST
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR GUEST on child update no action */
/* ERWIN_RELATION:CHECKSUM="0000f53c", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="GUEST"
P2C_VERB_PHRASE="R/14", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_14", FK_COLUMNS="ADDR_NUM" */
SELECT count(*) INTO NUMROWS
FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
:new.ADDR_NUM IS NOT NULL AND
NUMROWS = 0
)
THEN
raise_application_error(
-20007,
'Cannot update GUEST because ADDR does not exist.'
);
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TU_GUEST" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TU_MANAGER
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TU_MANAGER" AFTER UPDATE ON MANAGER for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- UPDATE trigger on MANAGER
DECLARE NUMROWS INTEGER;
BEGIN
/* MANAGER COMMUNITY on parent update set null */
/* ERWIN_RELATION:CHECKSUM="0000ed40", PARENT_OWNER="", PARENT_TABLE="MANAGER"
CHILD_OWNER="", CHILD_TABLE="COMMUNITY"
P2C_VERB_PHRASE="R/8", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_8", FK_COLUMNS="MANAGER_ID" */
IF
/* %JoinPKPK(:%Old,:%New," <> "," OR ") */
:old.MANAGER_ID <> :new.MANAGER_ID
THEN
UPDATE COMMUNITY
SET
/* %SetFK(COMMUNITY,NULL) */
COMMUNITY.MANAGER_ID = NULL
WHERE
/* %JoinFKPK(COMMUNITY,:%Old," = ",",") */
COMMUNITY.MANAGER_ID = :old.MANAGER_ID;
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TU_MANAGER" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TU_PARKING
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TU_PARKING" AFTER UPDATE ON PARKING for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- UPDATE trigger on PARKING
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* CAR PARKING on child update no action */
/* ERWIN_RELATION:CHECKSUM="0000e7f4", PARENT_OWNER="", PARENT_TABLE="CAR"
CHILD_OWNER="", CHILD_TABLE="PARKING"
P2C_VERB_PHRASE="R/13", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_13", FK_COLUMNS="CAR_NUM" */
SELECT count(*) INTO NUMROWS
FROM CAR
WHERE
/* %JoinFKPK(:%New,CAR," = "," AND") */
:new.CAR_NUM = CAR.CAR_NUM;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
:new.CAR_NUM IS NOT NULL AND
NUMROWS = 0
)
THEN
raise_application_error(
-20007,
'Cannot update PARKING because CAR does not exist.'
);
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TU_PARKING" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TU_POST
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TU_POST" AFTER UPDATE ON POST for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- UPDATE trigger on POST
DECLARE NUMROWS INTEGER;
BEGIN
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR POST on child update restrict */
/* ERWIN_RELATION:CHECKSUM="0000edf1", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="POST"
P2C_VERB_PHRASE="R/16", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_16", FK_COLUMNS="ADDR_NUM" */
SELECT count(*) INTO NUMROWS
FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
NUMROWS = 0
)
THEN
raise_application_error(
-20007,
'Cannot update POST because ADDR does not exist.'
);
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TU_POST" ENABLE;
--------------------------------------------------------
-- DDL for Trigger TU_RESIDENT
--------------------------------------------------------
CREATE OR REPLACE TRIGGER "APT2"."TU_RESIDENT" AFTER UPDATE ON RESIDENT for each row
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
-- UPDATE trigger on RESIDENT
DECLARE NUMROWS INTEGER;
BEGIN
/* RESIDENT COMMUNITY on parent update set null */
/* ERWIN_RELATION:CHECKSUM="0001f436", PARENT_OWNER="", PARENT_TABLE="RESIDENT"
CHILD_OWNER="", CHILD_TABLE="COMMUNITY"
P2C_VERB_PHRASE="R/7", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_7", FK_COLUMNS="RESIDENT_ID" */
IF
/* %JoinPKPK(:%Old,:%New," <> "," OR ") */
:old.RESIDENT_ID <> :new.RESIDENT_ID
THEN
UPDATE COMMUNITY
SET
/* %SetFK(COMMUNITY,NULL) */
COMMUNITY.RESIDENT_ID = NULL
WHERE
/* %JoinFKPK(COMMUNITY,:%Old," = ",",") */
COMMUNITY.RESIDENT_ID = :old.RESIDENT_ID;
END IF;
/* ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18 */
/* ADDR RESIDENT on child update no action */
/* ERWIN_RELATION:CHECKSUM="00000000", PARENT_OWNER="", PARENT_TABLE="ADDR"
CHILD_OWNER="", CHILD_TABLE="RESIDENT"
P2C_VERB_PHRASE="R/6", C2P_VERB_PHRASE="",
FK_CONSTRAINT="R_6", FK_COLUMNS="ADDR_NUM" */
SELECT count(*) INTO NUMROWS
FROM ADDR
WHERE
/* %JoinFKPK(:%New,ADDR," = "," AND") */
:new.ADDR_NUM = ADDR.ADDR_NUM;
IF (
/* %NotnullFK(:%New," IS NOT NULL AND") */
:new.ADDR_NUM IS NOT NULL AND
NUMROWS = 0
)
THEN
raise_application_error(
-20007,
'Cannot update RESIDENT because ADDR does not exist.'
);
END IF;
-- ERwin Builtin 2020년 9월 9일 수요일 오후 2:00:18
END;
/
ALTER TRIGGER "APT2"."TU_RESIDENT" ENABLE;
--------------------------------------------------------
-- Constraints for Table CAR
--------------------------------------------------------
ALTER TABLE "APT2"."CAR" ADD CONSTRAINT "XPKCAR" PRIMARY KEY ("CAR_NUM")
USING INDEX 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 "SYSTEM" ENABLE;
--------------------------------------------------------
-- Constraints for Table COMMUNITY
--------------------------------------------------------
ALTER TABLE "APT2"."COMMUNITY" ADD CONSTRAINT "XPKCOMMUNITY" PRIMARY KEY ("WRITER_NUM")
USING INDEX 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 "SYSTEM" ENABLE;
ALTER TABLE "APT2"."COMMUNITY" MODIFY ("WRITER_NUM" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table PARKING
--------------------------------------------------------
ALTER TABLE "APT2"."PARKING" ADD CONSTRAINT "XPKPARKING" PRIMARY KEY ("PARKING_LOC")
USING INDEX 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 "SYSTEM" ENABLE;
ALTER TABLE "APT2"."PARKING" MODIFY ("PARKING_LOC" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table EXPENSES
--------------------------------------------------------
ALTER TABLE "APT2"."EXPENSES" ADD CONSTRAINT "XPKEXPENSES" PRIMARY KEY ("ADDR_NUM")
USING INDEX 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 "SYSTEM" ENABLE;
ALTER TABLE "APT2"."EXPENSES" MODIFY ("ADDR_NUM" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table POST
--------------------------------------------------------
ALTER TABLE "APT2"."POST" ADD CONSTRAINT "XPKPOST" PRIMARY KEY ("ADDR_NUM")
USING INDEX 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 "SYSTEM" ENABLE;
ALTER TABLE "APT2"."POST" MODIFY ("ADDR_NUM" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table RESIDENT
--------------------------------------------------------
ALTER TABLE "APT2"."RESIDENT" ADD CONSTRAINT "XPKRESIDENT" PRIMARY KEY ("RESIDENT_ID")
USING INDEX 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 "SYSTEM" ENABLE;
ALTER TABLE "APT2"."RESIDENT" MODIFY ("RESIDENT_NAME" NOT NULL ENABLE);
ALTER TABLE "APT2"."RESIDENT" MODIFY ("RESIDENT_PASS" NOT NULL ENABLE);
ALTER TABLE "APT2"."RESIDENT" MODIFY ("RESIDENT_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table MANAGER
--------------------------------------------------------
ALTER TABLE "APT2"."MANAGER" ADD CONSTRAINT "XPKMANAGER" PRIMARY KEY ("MANAGER_ID")
USING INDEX 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 "SYSTEM" ENABLE;
ALTER TABLE "APT2"."MANAGER" MODIFY ("MANAGER_ID" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table GUEST
--------------------------------------------------------
ALTER TABLE "APT2"."GUEST" ADD CONSTRAINT "XPKGUEST" PRIMARY KEY ("GUEST_NAME", "GUEST_CARNUM")
USING INDEX 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 "SYSTEM" ENABLE;
ALTER TABLE "APT2"."GUEST" MODIFY ("GUEST_NAME" NOT NULL ENABLE);
ALTER TABLE "APT2"."GUEST" MODIFY ("GUEST_CARNUM" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table ADDR
--------------------------------------------------------
ALTER TABLE "APT2"."ADDR" ADD CONSTRAINT "XPKADDR" PRIMARY KEY ("ADDR_NUM")
USING INDEX 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 "SYSTEM" ENABLE;
ALTER TABLE "APT2"."ADDR" MODIFY ("ADDR_NUM" NOT NULL ENABLE);
--------------------------------------------------------
-- Ref Constraints for Table CAR
--------------------------------------------------------
ALTER TABLE "APT2"."CAR" ADD CONSTRAINT "R_11" FOREIGN KEY ("ADDR_NUM")
REFERENCES "APT2"."ADDR" ("ADDR_NUM") ON DELETE SET NULL ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table COMMUNITY
--------------------------------------------------------
ALTER TABLE "APT2"."COMMUNITY" ADD CONSTRAINT "R_7" FOREIGN KEY ("RESIDENT_ID")
REFERENCES "APT2"."RESIDENT" ("RESIDENT_ID") ON DELETE SET NULL ENABLE;
ALTER TABLE "APT2"."COMMUNITY" ADD CONSTRAINT "R_8" FOREIGN KEY ("MANAGER_ID")
REFERENCES "APT2"."MANAGER" ("MANAGER_ID") ON DELETE SET NULL ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table EXPENSES
--------------------------------------------------------
ALTER TABLE "APT2"."EXPENSES" ADD CONSTRAINT "R_15" FOREIGN KEY ("ADDR_NUM")
REFERENCES "APT2"."ADDR" ("ADDR_NUM") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table GUEST
--------------------------------------------------------
ALTER TABLE "APT2"."GUEST" ADD CONSTRAINT "R_14" FOREIGN KEY ("ADDR_NUM")
REFERENCES "APT2"."ADDR" ("ADDR_NUM") ON DELETE SET NULL ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table PARKING
--------------------------------------------------------
ALTER TABLE "APT2"."PARKING" ADD CONSTRAINT "R_13" FOREIGN KEY ("CAR_NUM")
REFERENCES "APT2"."CAR" ("CAR_NUM") ON DELETE SET NULL ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table POST
--------------------------------------------------------
ALTER TABLE "APT2"."POST" ADD CONSTRAINT "R_16" FOREIGN KEY ("ADDR_NUM")
REFERENCES "APT2"."ADDR" ("ADDR_NUM") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table RESIDENT
--------------------------------------------------------
ALTER TABLE "APT2"."RESIDENT" ADD CONSTRAINT "R_6" FOREIGN KEY ("ADDR_NUM")
REFERENCES "APT2"."ADDR" ("ADDR_NUM") ON DELETE SET NULL ENABLE;