create table item_h;
( ITEM_CODE                                NUMBER(10)
 ITEM_NAME                                VARCHAR2(14)
 ITEM_RATE                                NUMBER(10)
 ITEM_SIZE                                VARCHAR2(6))
/

create table customer
(CUS_CODE                                 NUMBER(5)
 CUS_NAME                                 VARCHAR2(10)
 CUS_ADDRESS                              VARCHAR2(20)
 CUS_PHONE                                NUMBER(10))
/

create table item_stock
(ITEM_STOCK_CODE                          NUMBER(10)
 ITEM_STOCK_NAME                          VARCHAR2(14)
 ITEM_BATCH                               VARCHAR2(10)
 ITEM_EXP_DATE                            DATE
 ITEM_QTY                                 NUMBER(10)
 ITEM_RATE                                NUMBER(5))
/

create table customer_1
(CUS_CODE                                 NUMBER(5)
 CUS_NAME                                 VARCHAR2(10)
 CUS_ADDRESS                              VARCHAR2(20)
 WDATE                                    DATE
 CUS_PHONE                                NUMBER(10)
 INV_NO                                   NUMBER(5))
/
CREATE TABLE INV
( ITEM_CODE                                NUMBER(10)
 ITEM_NAME                                VARCHAR2(10)
 ITEM_BATCH                               VARCHAR2(10)
 ITEM_EXP                                 DATE
 ITEM_RATE                                NUMBER(5)
 ITEM_TOTAL                               NUMBER(8)
 CUSTOMER                                 VARCHAR2(10)
 MAX_QTY                                  NUMBER(7)
 BALANCE                                  NUMBER(5)
 INV_NO                                   NUMBER(5))
/