all_food.sql

来自「该系统是一个B/S结构的公司定饭系统,整套软件由JSP编制,希望大家能够多提宝贵」· SQL 代码 · 共 23 行

/*	菜单表	all_food
	food_id	菜名ID
	food_nm	菜名
	food_price	价钱
	food_tel	定菜电话
*/
drop sequence all_foodsq;
CREATE	SEQUENCE  all_foodsq
	MINVALUE	1
	INCREMENT BY	1;
DROP TABLE all_food;
CREATE TABLE all_food
(
	food_id number(4,0),
	food_nm VARCHAR2(20)	NOT NULL,
	food_price	NUMBER(6,2)	NOT NULL,
	food_tel	VARCHAR2(15)	NOT NULL,
	CONSTRAINT all_foodidx PRIMARY KEY 
	(
		food_nm,
		food_tel
	)
);