DROP TABLE detail;

CREATE TABLE detail(
	corporation	number(20)		not null,
	badge		number(10)		not null,
	years		number(10)		not null,
	dob		varchar2(50)		not null,
	nok		varchar2(100)		null,
	address		varchar2(100)		not null,
	phone_h		number(20)		null,
	phone_w		number(20)		null,
	mobile		number(20)		null,
	email		varchar(50)		null,
	CONSTRAINT con_corporation PRIMARY KEY (corporation) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;