學習時的一些腳本，記錄下來：


drop table user_orders;

create table user_orders (?? ?
??? user_id int8 references userinfos(user_id),
??? order_id int8 references orders(order_id)
);


drop table user_orders;

create table? user_orders (
??? user_id int8,
??? order_id int8,
??? foreign key (user_id) references userinfos(user_id),
??? foreign key (order_id) references orders(order_id)
);
drop table partners;
create table partners
(
?partner_id int8 primary key,
?partner_name varchar(80)
);

drop table partner_tables;

create? table partner_orders
(
??? partner_id int8 references partners(partner_id),
??? order_id int8 references orders(order_id),
???
??? primary key (partner_id,order_id)

);

drop table prepaid_cards;

create table prepaid_cards
(
??? prepaid_card_id int8 primary key,
??? price float
)


drop table packages;


create table packages
(
? package_id int8 primary key,
? package_name varchar(80)
);

drop table package_cards;

create table package_cards
(
? package_id int8 references packages(package_id),
? prepaid_card_id int8 references prepaid_cards(prepaid_card_id),
?
? primary key (package_id,prepaid_card_id)
);

drop table prepaid_cards;

create table prepaid_cards
(

??? prepaid_card_id int8 primary key,
??? prepaid_card_no varchar(30)

)

drop table order_detials;

create table order_detials
(
??? order_id int8 references orders(order_id),
??? package_id int8 references packages(package_id),
??? count int4 ,?? ?
??? primary key (order_id,package_id)
)

drop table aa;

create table aa
(
user_id int8 default nextval('seq_user_id') primary key ,
user_name varchar(40)
);


drop table category;

create table category
(
??? category_id int8 primary key,
??? parent_id int8 references category(category_id),
??? category_name varchar(80)
);

drop sequence? seq_category_id ;
create sequence seq_category_id increment 1 start 300000;


alter table category? alter column category_id set default nextval('seq_category_id');
?



|----------------------------------------------------------------------------------------|
                           版權聲明  版權所有 @zhyiwww
            引用請注明來源 http://m.tkk7.com/zhyiwww   
|----------------------------------------------------------------------------------------|