#副標=OpenSource整合性開發工具(8)
#大標=以RDB design plug in協助建立資料庫
#眉標=eclipse
#作者=文／Doug Chen




==============box 程式1==============
CREATE TABLE people (
　id INTEGER NOT NULL AUTO_INCREMENT
     , name VARCHAR(256)
     , PRIMARY KEY (id)
     )TYPE=InnoDB;
     
CREATE TABLE tel (
　id INTEGER NOT NULL AUTO_INCREMENT
      , user_id INTEGER
      , tel CHAR(20)
      , PRIMARY KEY (id)
      , CONSTRAINT FK_tel_1 FOREIGN KEY (user_id)
       REFERENCES people (id)
     )TYPE=InnoDB;

==============end==============



     
===========利用Generate SQL所產生的SQL DDL========
DROP TABLE DEFAULT_SCHEMA.tel;
DROP TABLE DEFAULT_SCHEMA.user;

CREATE TABLE DEFAULT_SCHEMA.user (
       id INTEGER NOT NULL AUTO_INCREMENT
     , name VARCHAR(256)
     , PRIMARY KEY (id)
)TYPE=InnoDB;

CREATE TABLE DEFAULT_SCHEMA.tel (
       id INTEGER NOT NULL AUTO_INCREMENT
     , user_id INTEGER
     , tel CHAR(20)
     , PRIMARY KEY (id)
     , INDEX (user_id)
     , CONSTRAINT FK_tel_1 FOREIGN KEY (user_id)
                  REFERENCES DEFAULT_SCHEMA.user (id)
)TYPE=InnoDB;
     
===================end=======================