商品进销存数据库

商品进销存数据库

drop table market_provider;

create table market_provider

(

p_id varchar2(7) primary key,

p_name varchar2(50),

p_tel varchar2(11),

p_addr varchar2(20),

p_email varchar2(50)

);

insert into market_provider values ('001','¹ã¶«ºÃǡǡʳƷÓÐÏÞ¹«Ë¾','072454544','¹ã¶«ÉîÛÚ','haoqiaqia@yahoo.com');

drop table market_operator;

create table market_operator

(

o_id varchar2(7) primary key,

o_name varchar2(50),

o_pwd varchar2(50),

o_title varchar2(10) check(o_title in ('Óû§','¹ÜÀíÔ±')), o_sex varchar2(2) check(o_sex in ('ÄÐ','Å®'))

);

insert into market_operator values ('001','lydia','lydia','¹ÜÀíÔ±','Å®');

drop table market_goods;

create table market_goods

(

g_id varchar2(7) primary key,

g_price varchar2(10),

g_name varchar2(50)

);

insert into market_goods values ('001','10.2','ºÃ³Ôµã');

drop sequence market_se;

create sequence market_se

start with 100

increment by 1

order;