오라클에서 사용한 스크립트

create table Dis_User (

Dis_Sequenceid number(15) NOT NULL,

Dis_Crestedby varchar2(30) NOT NULL,

Dis_Createdate date NOT NULL,

Dis_Modifiedby varchar2(30) NOT NULL,

Dis_Modifieddate date NOT NULL,

Dis_Name varchar2(30) NOT NULL,

Dis_Empid varchar2(10) PRIMARY KEY,

Dis_Password varchar2(20),

Dis_Email varchar2(50),

Dis_Groupid number(15) NOT NULL,

Dis_Assigneegroupid varchar2(30) NOT NULL,

Dis_Deptname number(1) NOT NULL,

Dis_Appyn varchar2(14),

Dis_Cell varchar2(14),

Dis_Tel varchar2(14),

Dis_Faxno varchar2(10),

Dis_Deptcode varchar2(20) NOT NULL,

Dis_IPaddress number(1),

Dis_Class varchar2(40),

Dis_Residentno varchar2(13),

Dis_Worknamecode varchar2(10),

Dis_Classcode varchar2(10) NOT NULL,

Dis_Hobongcode varchar2(10) NOT NULL,

Dis_Enteringdate date,

Dis_Expireddate date,

Dis_Incubmentstatus varchar2(1),

constraint Dis_Sequenceid_UK UNIQUE (Dis_Sequenceid)

);

create index Dis_Deptname_IDX ON Dis_User (Dis_Deptname);

create index Dis_Appyn_IDX ON Dis_User (Dis_Appyn);

create index Dis_Deptcode_IDX ON Dis_User (Dis_Deptcode);

어떻게 해야 하는지 자세히 알려주세요

감사 합니다.