CREATE TABLE ADD_INVOICE
(add_INV_NO NUMBER(30) primary key,
supplier_NAME VARCHAR2(200),
add_INV_DATE DATE,
PAY_TYPE VARCHAR2(50),
PAID NUMBER(30),
REMANING NUMBER(30),
PAID_DATE DATE
);
----------------------------------------
CREATE TABLE ADD_INVoice_DETAIL
(SEQ NUMBER (30) PRIMARY KEY,
ITEM_ID NUMBER(30),
ITEM_NAME VARCHAR2(200),
QUANTITY NUMBER(30),
INVOICE_BUY_ID NUMBER(30),
PRICE NUMBER(30),
TOTAL_PRICE NUMBER(30),
add_INV_NO REFERENCES ADD_INVOICE(add_INV_NO)
	 );

-----------------------------------------
create table s_numbers
(s_number varchar2(200),
SEQ REFERENCES ADD_INVoice_DETAIL(SEQ)
);