SeanNotman97

CREATE TABLE  "CUSTOMER_SN" 
   (	"CUSTOMERID" NUMBER(3,0) NOT NULL ENABLE, 
	"USERNAME" VARCHAR2(15) NOT NULL ENABLE, 
	"EMAIL" VARCHAR2(50), 
	"CUSTOMERTYPE" VARCHAR2(6) DEFAULT 'Bronze' NOT NULL ENABLE, 
	 CONSTRAINT "CUSTOMER_SN_PK" PRIMARY KEY ("CUSTOMERID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "CUSTOMER_SN_UK1" UNIQUE ("USERNAME", "EMAIL")
  USING INDEX  ENABLE, 
	 CONSTRAINT "CHECK_TYPE" CHECK (CustomerType IN ('Bronze', 'Silver', 'Gold')) ENABLE