This figure shows the fields in the database tables and the relationship between the database tables. The following lists the tables and their fields:

CUSTOMER_ADDRESS

• CUSTID : VARCHAR2(20)

• ADDRESSID : VARCHAR2(4000)

• Primary key: CUSTOMER_ADDRESS_PK on CUSTID, ADDRESSID

• Unique key: CUSTOMER_ADDRESS_UK1 on ADDRESSID

• Foreign key: CUSTOMER_ADDRESS_ADDRESS_FK1

• Foreign key: CUSTOMER_ADDRESS_CUSTOMER_FK1

• CUSTOMER_ADDRESS table to ADDRESS table is a many-to-one relationship.

CUSTOMER

• CUSTID : VARCHAR2(40)

• FNAME : VARCHAR2(40)

• LNAME : VARCHAR2(40)

• PHONENUMBER : VARCHAR2(40)

• EMAIL : VARCHAR2(40)

• PASSWORD : VARCHAR2(40)

• CREDITCARDTYPE : VARCHAR2(40)

• CREDITCARDNUMBER : VARCHAR2(40)

• STATUS : VARCHAR2(10)

• Primary key: CUSTOMER_PK on CUSTID

• CUSTOMER table to CUSTOMER_ADDRESS table is a one-to-many relationship.

• CUSTOMER table to ORDERS table is a one-to-many relationship.

ADDRESS

• STREET : VARCHAR2(40)

• STATE : VARCHAR2(40)

• ZIP : VARCHAR2(10)

• COUNTRY : VARCHAR2(40)

• ADDRESSTYPE : VARCHAR2(10)

• ADDRID : VARCHAR2(4000)

• CITY : VARCHAR2(40)

• Primary key: ADDRESS_PK on ADDRID

• ADDRESS table to CUSTOMER_ADDRESS table is a one-to-many relationship.

ORDERS

• CUSTID : VARCHAR2(10)

• ORDID : VARCHAR2(10)

• ORDERDATE : DATE

• PRICE : NUMBER(9, 2)

• STATUS : VARCHAR2(10)

• COMMENTS : VARCHAR2(4000)

• Primary key: ORDERS_PK on ORDID

• Foreign key: ORDERS_CUSTOMER_FK1

• ORDERS table to CUSTOMER table is a many-to-one relationship.

• ORDERS table to ITEMS table is a one-to-many relationship.

ITEMS

• ITEMID : VARCHAR2(10)

• PRODID : NUMBER

• PRODUCTNAME : VARCHAR2(50)

• PARTNUM : VARCHAR2(20)

• PRICE : NUMBER(9, 2)

• QUANTITY : NUMBER(9)

• ORDID : VARCHAR2(10)

• Primary key: ITEMS_PK on ORDID, ITEMID

• Foreign key: ITEMS_ORDERS_FK1

• ITEMS table to ORDERS table is a many-to-one relationship.

PRODUCT

• ID : NUMBER

• PRODID : NUMBER

• NAME : VARCHAR2(200)

• DESCRIPTION : VARCHAR2(4000)

• CATEGORY : VARCHAR2(4000)

• LIST_PRICE : NUMBER

• PRODUCER : VARCHAR2(4000)

• IMAGE : BLOB

• IMAGEURL : VARCHAR2(4000)

• Primary key: PRODUCT_PK on PRODID

FEDEXSHIPMENT

• ORDERID : VARCHAR2(20)

• FNAME : VARCHAR2(50)

• LNAME : VARCHAR2(50)

• STREET : VARCHAR2(50)

• CITY : VARCHAR2(50)

• STATE : VARCHAR2(2)

• ZIPCODE : VARCHAR2(5)

• Primary key: FEDEXSHIPMENT_PK on ORDERID

SSN

• CUSTOMERID : VARCHAR2(40)

• SSN : VARCHAR2(40)

EJB_TAB_ID_GEN

• ID_NAME : VARCHAR2(4000)

• SEQ_VALUE : NUMBER(*, 0)