DROP TABLE ems_patient_status;

CREATE TABLE ems_patient_status(
	ems_number	number(10)		not null,
	other_inj	varchar2(50)		null,
	skin		varchar2(50)		null,
	bystander	varchar2(30)		null,
	avpu		varchar2(30)		null,
	pupils		varchar2(30)		null,	
	CONSTRAINT cons_ems_pat_stat_number PRIMARY KEY (ems_number) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;