CREATE TABLE Member ( MemberID NUMBER(14) NOT NULL UNIQUE, FirstName VARCHAR2(100) NOT NULL, LastName VARCHAR2(100) NOT NULL, Email VARCHAR2(100) NOT NULL UNIQUE, EmailBouncing CHAR(1) DEFAULT 'F' CHECK (EmailBouncing in ('T', 'F')), Password CHAR(30) NOT NULL, RegistrationDate Date, CONSTRAINT MEMBER_PRIMARY_KEY PRIMARY KEY (MemberID) );
Example 1: The Member table.