/*------------------------------------------------------------------------------
-- 객체명 : SEOUL_LOST.T_TAKEUSER
-- 생성일 : 2008-09-24 오후 4:39:28
-- 최종수정일 : 2008-09-24 오후 4:39:29
-- 상태 : VALID
------------------------------------------------------------------------------*/
DROP TABLE SEOUL_LOST.T_TAKEUSER CASCADE CONSTRAINTS;

CREATE TABLE SEOUL_LOST.T_TAKEUSER (
  IDX              NUMBER           NOT NULL,
  CODE             VARCHAR2(20)         NULL,
  TAKE_ID          VARCHAR2(30)         NULL,
  TAKE_PWD         VARCHAR2(30)         NULL,
  TAKE_NAME        VARCHAR2(30)         NULL,
  TAKE_PHONE       VARCHAR2(14)         NULL,
  TAKE_EMAIL       VARCHAR2(50)         NULL,
  TAKE_LEVEL       VARCHAR2(10)         NULL,
  TAKE_AREA        VARCHAR2(30)         NULL,
  TAKE_POSITION    VARCHAR2(30)         NULL,
  DRIVE_NUM        VARCHAR2(30)         NULL,
  CAR_NUM          VARCHAR2(30)         NULL,
  REG_DATE         DATE                 NULL
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 0
INITRANS 1
MAXTRANS 255
STORAGE (
    INITIAL 64 K
    MINEXTENTS 1
    MAXEXTENTS UNLIMITED
)
LOGGING
NOCACHE
MONITORING
NOPARALLEL
;

COMMENT ON TABLE SEOUL_LOST.T_TAKEUSER IS '담당자 등록 테이블';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.CODE IS '코드';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.TAKE_ID IS '담당자 아이디';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.TAKE_PWD IS '담당자 비밀번호';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.TAKE_NAME IS '담당자 이름';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.TAKE_PHONE IS '담당자 전화번호';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.TAKE_EMAIL IS '담당자 이메일';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.TAKE_LEVEL IS '담당자 등급';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.TAKE_AREA IS '담당자 지역';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.TAKE_POSITION IS '담당자 소속';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.DRIVE_NUM IS '노선번호';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.CAR_NUM IS '차량번호';

COMMENT ON COLUMN SEOUL_LOST.T_TAKEUSER.REG_DATE IS '등록일';

ALTER TABLE SEOUL_LOST.T_TAKEUSER ADD
(
    CONSTRAINT PK_T_TAKEUSER
    PRIMARY KEY ( IDX )
        USING INDEX
        TABLESPACE USERS
        PCTFREE 10
        INITRANS 2
        MAXTRANS 255
        STORAGE (
            INITIAL 64 K
            MINEXTENTS 1
            MAXEXTENTS UNLIMITED
        )
);