240709 12주차 화요일 - 미니 프로젝트 쇼핑몰 제작 06

 

 

#navbarSupportedContent{background-color: orange;} 추가

<a class="nav-link" aria-current="page" href="<%= root %>/shop/products.product">Product</a> 클래스에 액티브 삭제함

 

create table customer(
id nvarchar2(100) not null,
name nvarchar2(100) not null ,
pw nvarchar2(100) not null ,
birthday date not null
);

create table product(
productimage nvarchar2(100) not null ,
pcode nvarchar2(100) not null ,
pname nvarchar2(100) not null ,
price number not null ,
info  nvarchar2(100),
factory  nvarchar2(100) not null ,
groups  nvarchar2(100) not null ,
inven  number not null ,
state nvarchar2(100) not null
);

 

alter table coustomer add primary key(id);

alter table product add primary key(pcode);

create table basket(
b_num number not null,
cart_id nvarchar2(100) not null,
pcode nvarchar2(100) not null,
count number not null
);
create sequence b_seq start with 1 increment by 1;
alter table basket add primary key(b_num);


create table order_history(
cart_id nvarchar2(100),
order_number nvarchar2(100) ,
address nvarchar2(100) not null ,
phone number not null ,
shipdate date not null ,
order_password nvarchar2(100)
);

alter table order_history add primary key(order_number);


create table product_io(
io_num number not null ,
order_number nvarchar2(100) ,
type nvarchar2(100) not null,
pcode nvarchar2(100) not null,
amount number not null,
io_date date  not null
);

create sequence io_seq start with 1 increment by 1;
alter table product_io add primary key(io_num);


ALTER TABLE product_io ADD CONSTRAINT fk_order_number FOREIGN KEY(order_number) REFERENCES order_history(order_number);


commit;