1
edit
Changes
→DDL Statements (CREATE TABLE)
CONSTRAINT ad_advcost_ck CHECK(AdvCost > 0)
);
</pre>
8. CLIENT
<pre>
RefID NUMBER(6),
CONSTRAINT client_clientid_pk PRIMARY KEY(ClientID),
CONSTRAINT client_phone_uk UNIQUE(Phone), CONSTRAINT client_email_uk UNIQUE(Email), CONSTRAINT client_refid_fk FOREIGN KEY(RefID) REFERENCES CLEINTCLIENT(ClientID)
);
</pre>