정말 죄송합니다. 에러가 너무 안 잡혀서 질문 드려요.
이 부분은 테이블 생성 코드 입니다.
오라클10g 입니다.
/*
alter table DeliveryService drop constraint Delivery_1;
drop table Shoppingmall;
drop table DeliveryService;
drop table Pay;
drop table Client;
drop table Coupon;
drop table Product;
drop table paymentoffice;
create table paymentoffice(
crn1 varchar2(10),
paymentmethod varchar2(30),
name varchar2(20),
charge varchar2(20),
primary key(crn1));
create table Product(
product_number varchar2(10),
type varchar2(20),
price varchar2(10),
expiration_date varchar2(10),
primary key(product_number));
create table Coupon(
P_number varchar2(10),
coupon_number varchar2(20),
period varchar2(20),
primary key(P_number,coupon_number));
create table Client(
client_number varchar2(10),
name varchar2(20),
address varchar2(30),
p_pro varchar2(10),
primary key(client_number),
foreign key(p_pro) references Product(product_number));
create table Pay(
P_name varchar2(5),
C_num varchar2(50),
primary key(P_name, C_num),
foreign key(P_name) references Client(client_number),
foreign key(C_num) references Paymentoffice(crn1));
create table DeliveryService (
crn varchar2(10),
transportation varchar2(20),
S_dom varchar2(10),
C_clin varchar2(10),
P_pro_num varchar2(10),
primary key(crn),
foreign key(C_clin) references Client(client_number),
foreign key(P_pro_num) references Product(product_number));
create table Shoppingmall(
domain varchar2(10),
saleslist varchar2(20),
T_name varchar2(10),
T_num varchar2(10),
C_num varchar2(10),
primary key(domain),
foreign key(T_name) references DeliveryService(crn),
foreign key(T_num) references paymentoffice(crn1),
foreign key(C_num) references Client(client_number));
alter table DeliveryService
add constraint delivery_1 foreign key(S_dom) references Shoppingmall(domain);
*/
그리고 인서트 부분입니다.
insert into paymentoffice (crn1,paymentmethod,name,charge) values('하나','카드','서울','20억');
insert into paymentoffice (crn1,paymentmethod,name,charge) values('신한','무통장','부산','30억');
insert into product (product_number,type,price,expiration_date) values('1111','의류','100000원','2010년');
insert into product (product_number,type,price,expiration_date) values('1112','가구','900000원','2020년');
insert into Coupon(p_number,coupon_number,period) values('1111','0707','2011년');
insert into Coupon(p_number,coupon_number,period) values('1112','0606','2012년');
insert into Client (client_number,name,address,p_pro) values('211','허윤경','부천','1111');
insert into Client (client_number,name,address,p_pro) values('212','박준성','목동','1112');
insert into Deliveryservice (crn,transportation,S_dom,C_clin,P_pro_num) values('00','트럭','옥션','211','1111');
insert into Deliveryservice (crn,transportation,S_dom,C_clin,P_pro_num) values('01','배','마켓' ,'212','1112');
insert into Shoppingmall (domain,saleslist,T_name,T_num,C_num) values('옥션','옷','00','하나','211');
insert into Shoppingmall (domain,saleslist,T_name,T_num,C_num) values('마켓','가방','01','신한','212');
꼭 마지막 4줄에서 부모키가 없닫고 나오는데 정말 죽겠네요. 왜 그럴까요?
포린티 설정을 alter로 추가한것이 이렇게 된걸까요? |