DROP TABLE ITEM;
DROP TABLE ITEM_DETAIL;


CREATE TABLE ITEM (
   ITEM_ID INTEGER NOT NULL AUTO_INCREMENT,
   NAME VARCHAR(100),
   PRIMARY KEY(ITEM_ID)
);


CREATE TABLE ITEM_DETAIL (
   SEQ_ID INTEGER NOT NULL AUTO_INCREMENT,
   ITEM_ID INTEGER,  
   NAME VARCHAR(100),
   PRIMARY KEY(SEQ_ID),
   FOREIGN KEY(ITEM_ID) REFERENCES ITEM(ITEM_ID)
);



