DROP TABLE staff;

CREATE TABLE staff(
	rank		varchar2(50)		not null,
	badge_number	number(10)		not null,
	service_years	number(10)		not null,
	dob		varchar2(50)		not null,
	first_name	varchar2(50)		not null,
	initial_	varchar2(5)		null,
	surname		varchar2(50)		not null,
	next_of_kin	varchar2(100)		null,
	blood_group  	varchar2(5)		null,
	gender		varchar2(10)		not null,
	address		varchar2(100)		not null,
	town		varchar2(50)		null,
	county		varchar2(50)		null,
	postcode	varchar2(10)		null,
	telephone_home	number(20)		null,
	telephone_work	number(20)		null,
	mobile		number(20)		null,
	email		varchar(50)		null,
	pps		number(20)		not null,
	corporation_no	number(20)		not null,
	training	varchar(200)		null,
	CONSTRAINT con_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;