当前位置:Gxlcms > 数据库问题 > 阳光餐厅--oracle---建表---danrong

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

时间:2021-07-01 10:21:17 帮助过:18人阅读

  1. select * from manager;
  2. select * from dish;
  3. select * from board;
  4. select * from employee;
  5. select * from orders;
  6. select * from order_detail;
  7. -- 菜品表
  8. create table dish
  9. (
  10. dishID number(10) primary key,
  11. dishName varchar2(10) not null unique,
  12. category varchar2(10) not null,
  13. price number(10) not null,
  14. picture varchar2(40) not null,
  15. status number(10) not null
  16. )
  17. create sequence dish_se start with 1 increment by 1
  18. maxvalue 5000;
  19. insert into dish (dishID,dishName,category,price,picture,status)
  20. values(dish_se.nextval,‘XX‘,‘XX‘,‘XX‘,‘XX‘,‘XX‘);
  21. select * from dish;
  22. --管理员表
  23. create table manager
  24. (
  25. mid number(10) primary key,
  26. mname varchar2(10) not null unique,
  27. password varchar2(10) not null
  28. )
  29. create sequence manager_se start with 1 increment by 1
  30. maxvalue 5000;
  31. insert into manager (mid,mname,password)
  32. values(manager_se.nextval,‘1‘,‘1‘);
  33. select * from manager;
  34. --餐桌表
  35. create table board
  36. (
  37. boardid number(10) primary key,
  38. capacity number(10) not null
  39. )
  40. create sequence board_se start with 1 increment by 1
  41. maxvalue 5000;
  42. insert into board (boardid,capacity)
  43. values(board_se.nextval,‘4‘);
  44. select * from board;
  45. --职员表
  46. create table employee
  47. (
  48. eID number(10) primary key,
  49. ename varchar2(10) not null,
  50. sex varchar2(10) not null,
  51. position varchar2(10) not null,
  52. epassword varchar2(10) not null
  53. )
  54. create sequence emp_se start with 1 increment by 1
  55. maxvalue 5000;
  56. insert into employee(eID,ename,sex,position,epassword)
  57. values (emp_se.nextval,‘1‘,‘男‘,‘服务员‘,‘1‘);
  58. select * from employee;
  59. --创建订单表
  60. create table orders
  61. (
  62. orderID number(10) primary key,
  63. boardID number(10) not null, --外键
  64. pnumber number(10) not null,
  65. client varchar2(10), --允许为空
  66. mobile_number varchar2(20),--允许为空
  67. order_time varchar2(20) not null,
  68. arrive_time varchar2(20) not null,
  69. cash number(10),
  70. change number(10),
  71. status number(10) not null
  72. )
  73. --外键约束
  74. alter table orders add
  75. constraint fk_order_boardID foreign key (boardID) references board (boardID);
  76. create sequence order_se start with 1 increment by 1
  77. maxvalue 5000;
  78. insert into orders (orderID,boardID,pnumber,client,mobile_number,order_time,arrive_time,cash,change,status)
  79. values(order_se.nextval,‘1‘,‘4‘,‘yz‘,null,sysdate,‘2017-1-9‘,100,1,1);
  80. select * from orders;
  81. -- 订单详情表
  82. create table order_detail
  83. (
  84. odID number(10) primary key,
  85. orderID number(10) not null, -- 外键
  86. eID number(10) not null,-- 外键
  87. dishID number(10) not null,-- 外键
  88. taste number(10) not null,
  89. price number(10) not null,
  90. count number(10) not null,
  91. status number(10) not null
  92. )
  93. --外键约束
  94. alter table order_detail add
  95. constraint fk_ordt_orderID foreign key (orderID) references orders (orderID);
  96. alter table order_detail add
  97. constraint fk_ordt_eID foreign key (eID) references employee (eID);
  98. alter table order_detail add
  99. constraint fk_ordt_dishID foreign key (dishID) references dish (dishID);
  100. create sequence ordt_se start with 1 increment by 1
  101. maxvalue 5000;
  102. insert into order_detail (odID,orderID,eID,dishID,taste,price,count,status)
  103. values(ordt_se.nextval,1,1,3,1,10,1,1);

  

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

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

人气教程排行