VMware VCLOUD SDK FOR JAVA 1.0 - DEVELOPER S GUIDE Manual do Utilizador descarregar pdf (Página 56)

Hybrid Cloud Application Architecture

Deployment Guide 54

unitprice decimal(10,2) not null,

constraint pk_lineitem primary key (orderid, linenum)

)

HUB(ALL)

PARTITION BY column(orderid) COLOCATE WITH (orders);

create table category (

catid varchar(10) not null,

name varchar(80) ,

descn varchar(255) ,

constraint pk_category primary key (catid)

)

REPLICATE;

create table product (

productid varchar(10) not null,

category varchar(10) not null,

name varchar(80) ,

descn varchar(255) ,

constraint pk_product primary key (productid),

constraint fk_productCat foreign key (category)

references category (catid)

)

REPLICATE;

-- create index productCat on product (category);

create index productName on product (name);

create table item (

itemid varchar(10) not null,

productid varchar(10) not null,

listprice decimal(10,2) ,

unitcost decimal(10,2) ,

supplier int ,

status varchar(2) ,

attr1 varchar(80) ,

attr2 varchar(80) ,

attr3 varchar(80) ,

attr4 varchar(80) ,

attr5 varchar(80) ,

constraint pk_item primary key (itemid),

constraint fk_itemProd foreign key (productid)

references product (productid),

constraint fk_itemSup foreign key (supplier)

1 2 ... 51 52 53 54 55 56 57 58 59 60 61 ... 64 65

Sem comentários

VMware VCLOUD SDK FOR JAVA 1.0 - DEVELOPER S GUIDE Manual do Utilizador Página 56