Purchase order table (PURCHASEORDER)

The purchase order table identifies every purchase order by a purchase order ID and lists basic purchase order information.

The purchase order table is created with the following CREATE TABLE and ALTER TABLE statements:

CREATE TABLE PURCHASEORDER
           ( POID        BIGINT NOT NULL, 
             STATUS      VARCHAR(10) NOT NULL WITH DEFAULT('Unshipped'), 
             CUSTID      BIGINT
             ORDERDATE   DATE
             PORDER      XML
             COMMENTS    VARCHAR(1000),
             PRIMARY KEY (POID) )

ALTER TABLE PURCHASEORDER
           ADD FOREIGN KEY FK_PO_CUST(CUSTID)
               REFERENCES CUSTOMER(CID)
           ON DELETE CASCADE