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.