This page describes the contents of the example database. To see how the values are represented, look at the content listings of the tables.
create table Object ( ObjectId varchar(8) not null, DateRegistered date, constraint pk_object primary key (ObjectId) );View contents of table Object
create table ObjectName ( ObjectId varchar(8) not null, Language varchar(20) not null, ObjectName varchar(40) not null, constraint pk_objectname primary key (ObjectId, Language), constraint fk_objectname_object foreign key (ObjectId) references Object );View contents of table ObjectName
create table Material ( MaterialId varchar(8) not null, AddOnPrice decimal(5,2), constraint pk_material primary key (MaterialId), constraint fk_material_object foreign key (MaterialId) references Object );View contents of table Material
create table Category ( CategoryId varchar(8) not null, ListingSeqNo smallint, constraint pk_category primary key (CategoryId), constraint fk_category_object foreign key (CategoryId) references Object );View contents of table Category
create table ProductType ( ProductId varchar(8) not null, Description varchar(1000), Picture varchar(120), ProductCategory varchar(8) not null, constraint pk_producttype primary key (ProductId), constraint fk_producttype_object foreign key (ProductId) references Object );View contents of table ProductType
create table Product ( ProductId varchar(8) not null, ModelId varchar(20), Price decimal(5,2), constraint pk_product primary key (ProductId,ModelId), constraint fk_product_type foreign key (ProductId) references ProductType );View contents of table Product
create table Contents ( ProductId varchar(8) not null, MaterialId varchar(8) not null, constraint pk_contents primary key (ProductId,MaterialId), constraint fk_contents_producttype foreign key (ProductId) references ProductType, constraint fk_contents_material foreign key (MaterialId) references Material );View contents of table Contents
create table Customer ( CustomerId integer not null, Name varchar(60) not null, Address varchar(80) not null, PaymentCategory varchar(20), AreaCode varchar(20) not null, Phone varchar(20), Email varchar(60) constraint pk_customer primary key (CustomerId) );View contents of table Customer
create table Ordered ( OrderId integer not null, WhenMade date not null, Customer integer not null, WayIssued varchar(20), PaymentBy varchar(20) not null, TotalPrice decimal(6,2) not null, constraint pk_order primary key (OrderId) );View contents of table Ordered
create table ItemOrdered ( OrderId integer not null, ItemNo smallint not null, ProductId varchar(8) not null, ModelId varchar(20) not null, Amount smallint not null, constraint pk_ItemOrdered primary key (OrderId,ItemNo), constraint fk_IO_Product foreign key (ProductId,ModelId) references Product, constraint fk_item_order foreign key (OrderId) references Ordered );View contents of table ItemOrdered
create table AddOn ( OrderId integer not null, ItemNo smallint not null, MaterialId varchar(8) not null, Amount smallint not null, constraint pk_AddOn primary key (OrderId,ItemNo,MaterialId), constraint fk_AddOn_Item foreign key (OrderId,ItemNo) references ItemOrdered, constraint fk_AddOn_Material foreign key (MaterialId) references Material );View contents of table AddOn
create table DeliveryBoy ( BoyId varchar(20) not null, Name varchar (60) not null, DeliveryArea varchar (20), constraint pk_deliveryBoy primary key (BoyId) );View contents of table DeliveryBoy
create table Delivery ( OrderId integer not null, WhenAssigned date not null, DeliveredBy varchar(20) not null, WhenDelivered date, constraint pk_delivery primary key (OrderId), constraint fk_Delivery_Boy foreign key (DeliveredBy) references DeliveryBoy, constraint fk_delivery_order foreign key (OrderId) references Ordered );View contents of table Delivery
The other tables of the database are currently empty and thus not explained here.