?? pointbase.create.sql
字號:
CREATE TABLE ADDRESSBEAN (ADDRESSID VARCHAR(256) NOT NULL,STREET VARCHAR(256) NULL,STATE VARCHAR(256) NULL,ZIP VARCHAR(256) NULL,CITY VARCHAR(256) NULL,CUSTOMERBEAN_CUSTOMERID VARCHAR(256) NULL,CONSTRAINT PK_ADDRESSBEAN PRIMARY KEY (ADDRESSID));CREATE TABLE CUSTOMERBEAN (FIRSTNAME VARCHAR(256) NULL,CUSTOMERID VARCHAR(256) NOT NULL,LASTNAME VARCHAR(256) NULL,CONSTRAINT PK_CUSTOMERBEAN PRIMARY KEY (CUSTOMERID));CREATE TABLE SUBSCRIPTIONBEAN (TYPE BLOB(10240) NULL,TITLE VARCHAR(256) NOT NULL,CONSTRAINT PK_SUBSCRIPTIONBEAN PRIMARY KEY (TITLE));CREATE TABLE CUSTOMERBEANSUBSCRIPTIONBEAN (CUSTOMERBEAN_CUSTOMERID96 VARCHAR(256) NULL,SUBSCRIPTIONBEAN_TITLE VARCHAR(256) NULL);ALTER TABLE ADDRESSBEAN ADD CONSTRAINT FK_THISRELATIONSHIPFIELDWASGENERATEDBYTHENAMEMAPPER1 FOREIGN KEY (CUSTOMERBEAN_CUSTOMERID) REFERENCES CUSTOMERBEAN (CUSTOMERID);ALTER TABLE CUSTOMERBEANSUBSCRIPTIONBEAN ADD CONSTRAINT FK_SUBSCRIPTIONS FOREIGN KEY (CUSTOMERBEAN_CUSTOMERID96) REFERENCES CUSTOMERBEAN (CUSTOMERID);ALTER TABLE CUSTOMERBEANSUBSCRIPTIONBEAN ADD CONSTRAINT FK_CUSTOMERS FOREIGN KEY (SUBSCRIPTIONBEAN_TITLE) REFERENCES SUBSCRIPTIONBEAN (TITLE);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -