수정

create table Admin ( admin_id number(10) primary key, id varchar2(30) unique, pwd varchar2(30) unique, menu_id number(10) );

create table menu ( menu_id number(10) primary key, category varchar2(30), menu_name varchar2(30), menu_price number(20) );

create table addition

(addition_id number(10) primary key,

menu_id varchar2(10),

hot_ice varchar2(10),

volume varchar2(10),

milk varchar2(10),

shot number(5),

quantity number(5)

);

create table basket ( basket_id number(10) primary key, quantity number(20) );

create table orders ( order_id number(10) primary key, pay_info varchar2(30) );

select * from admin; select * from orders; select * from basket; select * from menu; select * from addition;

basket table 삭제

—> drop table basket;