DROP TABLE member;

CREATE TABLE member(
	pps		number(10)		not null,
	name 		varchar2(50)		not null,
	corporation	number(10)		not null,
	rid		number(2)		not null,
	gid		number(2)		not null,
	tid		number(2)		not null,
	bid		number(2)		not null,
	CONSTRAINT cons_pps PRIMARY KEY (pps) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;