오라클에서 사용한 스크립트
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);
어떻게 해야 하는지 자세히 알려주세요
감사 합니다.
|