阳光餐厅--oracle---建表---danrong

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了阳光餐厅--oracle---建表---danrong，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3252字，纯文字阅读大概需要5分钟。

内容图文

select * from manager;
select * from dish;
select * from board;
select * from employee;
select * from orders;
select * from order_detail;


 
-- 菜品表

create table dish
(
  dishID number(10) primary key,
  dishName varchar2(10) not null unique,
  category varchar2(10) not null,
  price number(10) not null,
  picture varchar2(40) not null,
  status number(10) not null
)

create sequence dish_se start with 1 increment by 1
maxvalue 5000;

insert into dish (dishID,dishName,category,price,picture,status)
values(dish_se.nextval,‘XX‘,‘XX‘,‘XX‘,‘XX‘,‘XX‘);


select * from dish;



--管理员表
create table manager 
(
mid  number(10) primary key,  
mname varchar2(10)  not null unique,
password  varchar2(10)  not null
)
create sequence manager_se start with 1 increment by 1
maxvalue 5000;

insert into manager (mid,mname,password)
values(manager_se.nextval,‘1‘,‘1‘);
 
 select * from manager;
 
 
 
--餐桌表
create table board  
(
  boardid number(10) primary key,
  capacity number(10) not null
)

create sequence board_se start with 1 increment by 1
maxvalue 5000;

insert into board (boardid,capacity)
values(board_se.nextval,‘4‘);
 
select * from board;

--职员表 

create table employee  
(
  eID number(10) primary key,
  ename varchar2(10) not null,
  sex varchar2(10) not null,   
  position varchar2(10) not null,   
  epassword varchar2(10) not null
)


create sequence emp_se start with 1 increment by 1
maxvalue 5000;

insert into employee(eID,ename,sex,position,epassword) 
values (emp_se.nextval,‘1‘,‘男‘,‘服务员‘,‘1‘); 

select * from employee;


--创建订单表
create table orders 
(
  orderID number(10) primary key,
  boardID number(10) not null, --外键
  pnumber number(10) not null,
  client varchar2(10), --允许为空
  mobile_number varchar2(20),--允许为空
  order_time varchar2(20) not null,
  arrive_time varchar2(20) not null,
  cash number(10),
  change number(10),
  status number(10) not null
)

--外键约束
alter table orders add 
constraint fk_order_boardID foreign key (boardID) references board (boardID);

create sequence order_se start with 1 increment by 1
maxvalue 5000;

insert into orders (orderID,boardID,pnumber,client,mobile_number,order_time,arrive_time,cash,change,status)
values(order_se.nextval,‘1‘,‘4‘,‘yz‘,null,sysdate,‘2017-1-9‘,100,1,1);



select * from orders;



-- 订单详情表


create table order_detail
(
  odID number(10) primary key,
  orderID number(10) not null, -- 外键
  eID number(10) not null,-- 外键
  dishID number(10) not null,-- 外键
  taste number(10) not null,
  price number(10) not null,
  count number(10) not null,
  status number(10) not null
)

--外键约束
alter table order_detail add
constraint fk_ordt_orderID foreign key (orderID) references orders (orderID);
alter table order_detail add
constraint fk_ordt_eID foreign key (eID) references employee (eID);
alter table order_detail add
constraint fk_ordt_dishID foreign key (dishID) references dish (dishID);

create sequence ordt_se start with 1 increment by 1
maxvalue 5000;



insert into order_detail (odID,orderID,eID,dishID,taste,price,count,status)
values(ordt_se.nextval,1,1,3,1,10,1,1);

　　

阳光餐厅--oracle---建表---danrong

标签：oar   for   null   seq   pass   manage   管理员   number   blog   

本文系统来源：http://www.cnblogs.com/ipetergo/p/6265836.html

内容总结

以上是互联网集市为您收集整理的阳光餐厅--oracle---建表---danrong全部内容，希望文章能够帮你解决阳光餐厅--oracle---建表---danrong所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---