===================================== Admin 테이블 정의서 V2.8 ===================================== +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +=========================+================================+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_CD\_GRP** | +-------------------------+--------------------------------+ | **COMMENT** | 시스템\_공통코드그룹 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | CD\_GRP\_ID | VARCHAR2(5) | PK | NOT NULL | 　 | 코드그룹ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | GRP\_NM | VARCHAR2(20) | 　 | 　 | 　 | 코드그룹명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | GRP\_DESC | VARCHAR2(200) | 　 | 　 | 　 | 코드그룹설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | LANG\_CD | CHAR(2) | 　 | 　 | 　 | 언어코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | MOD\_YN | CHAR(1) | 　 | 　 | 　 | 수정가능여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +=========================+================================+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SVC** | +-------------------------+--------------------------------+ | **COMMENT** | 서비스 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | SVC\_ID | NUMBER(10) | PK | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | SVC\_NM | VARCHAR2(50) | 　 | 　 | 　 | 서비스명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | SVC\_TP | CHAR(2) | 　 | 　 | 　 | 사용제품구분 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | APP\_ID | VARCHAR2(50) | 　 | 　 | 　 | 앱구분ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | SVC\_DTL | VARCHAR2(255) | 　 | 　 | 　 | 서비스 설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_USER** | +-------------------------+--------------------------------+ | **COMMENT** | 통합관리자 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | USER\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 관리자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | USER\_NM | VARCHAR2(50) | 　 | 　 | 　 | 사용자명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | USER\_PW | VARCHAR2(100) | 　 | 　 | 　 | 비밀번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | EMAIL | VARCHAR2(100) | 　 | 　 | 　 | 이메일주소 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 변경ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | MOD\_DTTM | DATE | 　 | 　 | 　 | 변경일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | USER\_TP | VARCHAR2(14) | 　 | 　 | 　 | 연락처 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | USER\_EP | VARCHAR2(14) | 　 | 　 | 　 | 비상연락망 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | LOGIN\_LOCK | CHAR(1) | 　 | 　 | 'N' | 로그인 잠금 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 13 | LOCK\_TIME | DATE | 　 | 　 | 　 | 로그인 잠긴 시간 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 14 | LOGIN\_STATUS | CHAR(1) | 　 | 　 | 'N' | 로그인 여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 15 | LOGIN\_FAIL\_CNT | NUMBER | 　 | 　 | 0 | 로그인 실패횟수 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_LOGIN\_HIST** | +-------------------------+--------------------------------+ | **COMMENT** | 시스템\_로그인이력 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | HIST\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 로그인이력IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | LOGIN\_DTTM | DATE | 　 | 　 | 　 | 로그인일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | REMOTE\_IP | VARCHAR2(20) | 　 | 　 | 　 | 접속IP | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | USER\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 관리자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_MENU** | +-------------------------+--------------------------------+ | **COMMENT** | 시스템\_메뉴 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | MENU\_ID | VARCHAR2(10) | PK | NOT NULL | 　 | 메뉴ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | MENU\_NM | VARCHAR2(50) | 　 | 　 | 　 | 메뉴명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | MENU\_URL | VARCHAR2(100) | 　 | 　 | 　 | 메뉴URL | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | POPUP\_YN | CHAR(1) | 　 | 　 | 　 | 팝업여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | POPUP\_W | NUMBER(5) | 　 | 　 | 　 | 팝업창\_WIDTH | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | POPUP\_H | NUMBER(5) | 　 | 　 | 　 | 팝업창\_HEIGHT | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | STS\_CD | CHAR(1) | 　 | 　 | 　 | 상태코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | SORT\_NO | NUMBER(3) | 　 | 　 | 　 | 정렬순서 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | UP\_MENU\_ID | VARCHAR2(10) | 　 | 　 | 　 | 상위메뉴ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 변경자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 13 | MOD\_DTTM | DATE | 　 | 　 | 　 | 변경일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 14 | MENU\_DESC | VARCHAR2(100) | 　 | 　 | 　 | 비고 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_AUTH\_GRP** | +-------------------------+--------------------------------+ | **COMMENT** | 시스템\_권한그룹 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | AUTH\_GRP\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 그룹ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | AUTH\_GRP\_NM | VARCHAR2(50) | 　 | 　 | 　 | 그룹명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | AUTH\_GRP\_DESC | VARCHAR2(200) | 　 | 　 | 　 | 그룹설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 변경id | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | MOD\_DTTM | DATE | 　 | 　 | 　 | 변경일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | INTRO\_MENU\_ID | VARCHAR2(10) | 　 | 　 | 　 | 초기화면메뉴ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SVC\_AUTH** | +-------------------------+--------------------------------+ | **COMMENT** | 관리자 권한지정 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | SVC\_ID | NUMBER(10) | PK | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | AUTH\_GRP\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 그룹ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **TABLE INFORMATION** | **OWNER** | MSP\_ADMIN | **CREATED** | 2014-12-01 오전 9:08:28 | | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | | **TABLESPACE** | MSP\_ADMIN | **MODIFIED** | 2014-12-01 오전 9:08:28 | | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **TABLE NAME** | **TB\_SYS\_USER\_AUTH\_GRP** | | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **COMMENT** | 시스템\_사용자권한그룹 | | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | | | | | | | | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | USER\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 관리자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | AUTH\_GRP\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 그룹ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_NOTC** | +-------------------------+--------------------------------+ | **COMMENT** | 시스템\_공지 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | NOTC\_IDX | VARCHAR2(10) | PK | NOT NULL | 　 | 공지IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | TITLE | VARCHAR2(100) | 　 | 　 | 　 | 제목 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | CONT | VARCHAR2(2000) | 　 | 　 | 　 | 내용 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_NOTC\_AUTH** | +-------------------------+--------------------------------+ | **COMMENT** | 시스템\_공지권한 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | NOTC\_IDX | VARCHAR2(10) | PK | NOT NULL | 　 | 공지IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | AUTH\_GRP\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 그룹ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_FILE\_ATTACH** | +-------------------------+--------------------------------+ | **COMMENT** | 배포파일 다운로드 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | FILE\_IDX | NUMBER(20) | PK | NOT NULL | 　 | 파일일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | FILE\_ID | VARCHAR2(50) | 　 | 　 | 　 | 파일ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | FILE\_NAME | VARCHAR2(60) | 　 | 　 | 　 | 파일명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | FILE\_EXT | VARCHAR2(10) | 　 | 　 | 　 | 파일확장자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | FILE\_PATH | VARCHAR2(200) | 　 | NOT NULL | 　 | 파일경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | FILE\_SIZE | NUMBER(20) | 　 | 　 | 0 | 파일사이즈 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | FILE\_TYPE | VARCHAR2(1) | 　 | 　 | 　 | 파일타입 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | URL\_CHILD\_PATH | VARCHAR2(100) | 　 | NOT NULL | 　 | 자식URL경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | OBJ\_CODE | VARCHAR2(20) | 　 | NOT NULL | 　 | 대상 TABLE명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | OBJ\_ID | VARCHAR2(20) | 　 | NOT NULL | 　 | DEPLOY 일련번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | REG\_DATE | DATE | 　 | 　 | SYSDATE | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | MD5 | VARCHAR2(50) | 　 | 　 | 　 | MD5 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_AUTH\_ACCESS** | +-------------------------+--------------------------------+ | **COMMENT** | 서비스 권한 액세스 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | AUTH\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 인증ACCESS 순번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | ACCESS\_KEY | VARCHAR2(60) | 　 | NOT NULL | 　 | 접근키 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | REG\_DTTM | DATE | 　 | 　 | 　 | 생성일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | CONSUMER\_KEY | VARCHAR2(60) | 　 | 　 | 　 | 컨슈머키 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_REST\_API** | +-------------------------+--------------------------------+ | **COMMENT** | rest API | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | API\_IDX | NUMBER(10) | PK | NOT NULL | 　 | API\_IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | URL\_PATH | VARCHAR2(200) | 　 | 　 | 　 | URL\_경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | CONTENTS | VARCHAR2(500) | 　 | 　 | 　 | 설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DTTM | DATE | 　 | 　 | 　 | 생성일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_API\_AUTH\_ACCESS** | +-------------------------+--------------------------------+ | **COMMENT** | API서비스권한액세스 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | AUTH\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 인증ACCESS 순번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | API\_IDX | NUMBER(10) | PK | NOT NULL | 　 | API\_IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | REG\_DTTM | CHAR(18) | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_FAVRT** | +-------------------------+--------------------------------+ | **COMMENT** | 즐겨찾기 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | USER\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 관리자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | MENU\_ID | VARCHAR2(10) | 　 | NOT NULL | 　 | 메뉴ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_DUMMY** | +-------------------------+--------------------------------+ | **COMMENT** | DUMMY API 데이터 관리 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | DUMMY\_IDX | NUMBER | 　 | NOT NULL | 　 | 일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | SVC\_ID | NUMBER | 　 | NOT NULL | 　 | 서비스 ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | API\_URL | VARCHAR2(50) | 　 | NOT NULL | 　 | API URL | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | API\_NM | VARCHAR2(255) | 　 | 　 | 　 | API 명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | RSP\_BODY | VARCHAR2(4000) | 　 | 　 | 　 | 응답결과(JSON FORMAT) | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_SVC** | +-------------------------+--------------------------------+ | **COMMENT** | 모바일서비스 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | SVC\_ID | NUMBER(10) | PK | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | SVC\_DTL | VARCHAR2(255) | 　 | 　 | 　 | 서비스설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_SVC\_UPDATE** | +-------------------------+--------------------------------+ | **COMMENT** | 앱업데이트 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | APP\_UP\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 앱업데이트순번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | CURRENT\_APP\_VERSION | VARCHAR2(20) | 　 | NOT NULL | 　 | 현재앱버젼 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | DOWNLOAD\_MARKET\_URL | VARCHAR2(200) | 　 | 　 | 　 | 업데이트 주소 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | DEVICE\_TYPE | VARCHAR2(1) | 　 | 　 | 　 | 디바이스 유형 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | USE\_YN | VARCHAR2(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REQUIRED\_APP\_VERSION | VARCHAR2(20) | 　 | 　 | 　 | 필수앱버젼 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | SVC\_ID | NUMBER(10) | 　 | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | CHOICE\_APP\_VERSION | VARCHAR2(100) | 　 | 　 | 　 | 선택앱버젼 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | MEMO | VARCHAR2(4000) | 　 | 　 | 　 | 업데이트 공지 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_RSC\_FILE** | +-------------------------+--------------------------------+ | **COMMENT** | 리소스 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | RSC\_FILE\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 리소스일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | FILE\_NM | VARCHAR2(100) | 　 | 　 | 　 | 파일명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | FILE\_PATH | VARCHAR2(200) | 　 | 　 | 　 | 파일경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | FILE\_EXT | VARCHAR2(10) | 　 | 　 | 　 | 파일확장자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | FILE\_TP | VARCHAR2(10) | 　 | 　 | 　 | 파일타입 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | FILE\_SIZE | NUMBER(10) | 　 | 　 | 　 | 파일크기 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | DEL\_YN | CHAR(1) | 　 | 　 | 　 | 삭제여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | STS\_CD | CHAR(1) | 　 | 　 | 　 | 상태코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | MOD\_DTTM | DATE | 　 | 　 | 　 | 변경일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | SVC\_ID | NUMBER(10) | 　 | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | RSC\_ID | NUMBER(5) | 　 | 　 | 　 | 리소스\_ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_DPLY** | +-------------------------+--------------------------------+ | **COMMENT** | 배포 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | DPLY\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 배포일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | DPLY\_NM | VARCHAR2(50) | 　 | 　 | 　 | 배포명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | DPLY\_VER | VARCHAR2(10) | 　 | 　 | 　 | 버전 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | DPLY\_TP | CHAR(1) | 　 | 　 | 　 | 배포형태 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | DPLY\_FULL\_YN | CHAR(1) | 　 | 　 | 　 | 전체배포여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REF\_VER | VARCHAR2(10) | 　 | 　 | 　 | 참조버전 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | DPLY\_DESC | VARCHAR2(255) | 　 | 　 | 　 | 비고 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | SVC\_ID | NUMBER(10) | PK | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | REG\_ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_DPLY\_DTL** | +-------------------------+--------------------------------+ | **COMMENT** | 배포파일정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | DPLY\_DTL\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 배포파일일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | FILE\_NM | VARCHAR2(100) | 　 | 　 | 　 | 파일명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | FILE\_PATH | VARCHAR2(200) | 　 | 　 | 　 | 파일경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | FILE\_SIZE | NUMBER(10) | 　 | 　 | 　 | 파일크기 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | DEL\_YN | CHAR(1) | 　 | 　 | 　 | 삭제여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | STS\_CD | CHAR(1) | 　 | 　 | 　 | 상태코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | DPLY\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 배포일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | SVC\_ID | NUMBER(10) | PK | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | RSC\_ID | NUMBER(5) | 　 | 　 | 　 | 리소스\_ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_NOTC** | +-------------------------+--------------------------------+ | **COMMENT** | 모바일 공지사항 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | NOTC\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 공지사항순번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | TITLE | VARCHAR2(100) | 　 | 　 | 　 | 제묵 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | CONT | VARCHAR2(2000) | 　 | 　 | 　 | 내용 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | USE\_YN | VARCHAR2(1) | 　 | 　 | 　 | 출력 여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | APP\_ID | VARCHAR2(50) | 　 | NOT NULL | 　 | 앱 아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | START\_DTTM | VARCHAR2(12) | 　 | 　 | 　 | 시작일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | END\_DTTM | VARCHAR2(12) | 　 | 　 | 　 | 만료일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_EVENT\_LOG** | +-------------------------+--------------------------------+ | **COMMENT** | EVENT\_LOG | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | LOG\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 로그일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | APP\_VER | VARCHAR2(20) | 　 | 　 | 　 | 앱버전 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | APP\_NM | VARCHAR2(50) | 　 | 　 | 　 | 앱이름 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | OS\_NM | VARCHAR2(50) | 　 | 　 | 　 | OS명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | OS\_VER | VARCHAR2(50) | 　 | 　 | 　 | OS 버전 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | DEVC\_ID | VARCHAR2(64) | 　 | 　 | 　 | 단말기 식별번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | DEVC\_MD | VARCHAR2(100) | 　 | 　 | 　 | 단말기 모델명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | PHONE\_NO | VARCHAR2(20) | 　 | 　 | 　 | 전화번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | COMP\_CD | VARCHAR2(50) | 　 | 　 | 　 | 전문코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | SVC\_CD | VARCHAR2(50) | 　 | 　 | 　 | 서비스코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | USER\_AGENT | VARCHAR2(150) | 　 | 　 | 　 | 브라우저 AGEN 정보 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | HOST | VARCHAR2(50) | 　 | 　 | 　 | 호스트 정보 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 13 | REG\_DTTM | DATE | 　 | 　 | 　 | 생성일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 14 | USER\_ID | VARCHAR2(20) | 　 | 　 | 　 | 사용자 ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 15 | USER\_NM | VARCHAR2(20) | 　 | 　 | 　 | 사용자명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 16 | REQ\_PAGE | VARCHAR2(50) | 　 | 　 | 　 | 요청페이지 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 17 | SVC\_ID | NUMBER(10) | 　 | 　 | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_RSC\_TEMP\_FILE** | +-------------------------+--------------------------------+ | **COMMENT** | 임시리소스 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | RSC\_FILE\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 임시리소스일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | FILE\_NM | VARCHAR2(100) | 　 | 　 | 　 | 파일명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | FILE\_PATH | VARCHAR2(200) | 　 | 　 | 　 | 파일경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | FILE\_EXT | VARCHAR2(10) | 　 | 　 | 　 | 파일확장자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | FILE\_TP | VARCHAR2(10) | 　 | 　 | 　 | 파일타입 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | FILE\_SIZE | NUMBER(10) | 　 | 　 | 　 | 파일크기 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | STS\_CD | CHAR(1) | 　 | 　 | 　 | 상태코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | SVC\_ID | NUMBER(10) | 　 | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_RSC\_EXT** | +-------------------------+--------------------------------+ | **COMMENT** | 리소스설정확장자 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | FILE\_EXT | VARCHAR2(10) | PK | NOT NULL | 　 | 확장자명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | EXE\_DTL | VARCHAR2(255) | 　 | 　 | 　 | 설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_GROUP** | +-------------------------+--------------------------------+ | **COMMENT** | 그룹정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | GRP\_ID | NUMBER | PK | NOT NULL | 　 | 그룹아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | GRP\_NM | VARCHAR2(20) | 　 | NOT NULL | 　 | 그룹명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | USE\_YN | CHAR(1) | 　 | NOT NULL | 'Y' | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_DT | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | MOD\_DT | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_EMP\_CODE** | +-------------------------+--------------------------------+ | **COMMENT** | 직급코드 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | KIND | CHAR(2) | 　 | NOT NULL | 　 | 구분[default=01] | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | CD\_NM | VARCHAR2(50) | 　 | 　 | 　 | 직급명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | SORT\_NO | NUMBER(5) | 　 | 　 | 　 | 정렬순서(min=1) | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | EMP\_CD | VARCHAR2(10) | PK | NOT NULL | 　 | 직급코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_PLAT** | +-------------------------+--------------------------------+ | **COMMENT** | 플랫폼정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | PLAT\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 플랫폼정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | PLAT\_CD | VARCHAR2(2) | 　 | 　 | 　 | 플랫폼코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | PLAT\_DESC | VARCHAR2(4000) | 　 | 　 | 　 | 플랫폼설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | PLAT\_NM | VARCHAR2(50) | 　 | 　 | 　 | 플랫폼명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | MFG\_CD | VARCHAR2(2) | 　 | 　 | 　 | 제조사 코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | REG\_DTTM | DATE | 　 | NOT NULL | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | MFG\_NM | VARCHAR2(100) | 　 | 　 | 　 | 제조사명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_SVC** | +-------------------------+--------------------------------+ | **COMMENT** | 앱스토어서비스 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | SVC\_ID | NUMBER(10) | PK | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_DIVISION** | +-------------------------+--------------------------------+ | **COMMENT** | 부서정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | DIVISION\_ID | VARCHAR2(10) | PK | NOT NULL | 　 | 부서ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | DIVISION\_NM | VARCHAR2(50) | 　 | 　 | 　 | 부서명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | UP\_DIVISION\_ID | VARCHAR2(10) | 　 | 　 | 　 | 상위\_부서\_ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | DIVISION\_DESC | VARCHAR2(100) | 　 | 　 | 　 | 설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_USER** | +-------------------------+--------------------------------+ | **COMMENT** | 회원정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | EMP\_NO | VARCHAR2(10) | PK | NOT NULL | 　 | 회원번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | EMP\_NM | VARCHAR2(30) | 　 | NOT NULL | 　 | 사용자이름 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | WORK\_CD | VARCHAR2(6) | 　 | 　 | 　 | 사용자구분코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | EMAIL | VARCHAR2(50) | 　 | 　 | 　 | EMAIL\_ADDRESS | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | USERID | VARCHAR2(20) | 　 | 　 | 　 | 사용자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | PASSWD | VARCHAR2(100) | 　 | 　 | 　 | 암호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | USE\_YN | CHAR(1) | 　 | 　 | 'Y' | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | EMP\_CD | VARCHAR2(10) | 　 | 　 | 　 | 직급코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | DIVISION\_ID | VARCHAR2(10) | 　 | 　 | 　 | 　 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_PLAT\_VER** | +-------------------------+--------------------------------+ | **COMMENT** | 플랫폼 버전 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | PLAT\_VER\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 플랫폼버전일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | PLAT\_VER\_CD | VARCHAR2(100) | 　 | 　 | 　 | 플랫폼 버전 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | PLAT\_VER\_NM | VARCHAR2(100) | 　 | 　 | 　 | 플랫폼 버전명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | PLAT\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 플랫폼정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_DEVC** | +-------------------------+--------------------------------+ | **COMMENT** | 단말정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | DEVC\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 단말정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | DEVC\_ID | VARCHAR2(500) | 　 | NOT NULL | 　 | 모델명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | DISP\_WIDTH | NUMBER(5) | 　 | 　 | 　 | 화면사이즈 가로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | BRD\_NM | VARCHAR2(100) | 　 | 　 | 　 | 브랜드명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | MFG\_NM | VARCHAR2(100) | 　 | 　 | 　 | 제조사명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | DISP\_HEIGHT | NUMBER(5) | 　 | 　 | 　 | 화면사이즈 세로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | USE\_YN | CHAR(1) | 　 | NOT NULL | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | MFG\_CD | VARCHAR2(2) | 　 | 　 | 　 | 제조사 코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | PRD\_INFO | VARCHAR2(1000) | 　 | 　 | 　 | 제품 개요 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | PRD\_DESC | VARCHAR2(4000) | 　 | 　 | 　 | 제품 설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | MFG\_YYYYMM | VARCHAR2(10) | 　 | 　 | 　 | 제조년월 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | REG\_DT | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 13 | MGG\_CD\_\_853 | VARCHAR2(2) | 　 | 　 | 　 | 제조사 코드\_\_853 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 14 | PLAT\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 플랫폼정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 15 | PLAT\_VER\_IDX | NUMBER | 　 | 　 | 　 | 플랫폼버젼일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_CATG** | +-------------------------+--------------------------------+ | **COMMENT** | 스토어 카테고리정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | CATG\_CD | VARCHAR2(10) | PK | NOT NULL | 　 | 카테고리코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | CATG\_NM | VARCHAR2(30) | 　 | NOT NULL | 　 | 카테고리명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DT | DATE | 　 | NOT NULL | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_DT | DATE | 　 | 　 | 　 | 수정일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | SORT\_NO | NUMBER(10) | 　 | NOT NULL | 　 | 디스플레이 순서 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | USE\_YN | CHAR(1) | 　 | NOT NULL | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | UP\_CATG\_CD | VARCHAR2(10) | 　 | 　 | 　 | 카테고리 상위코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | CATG\_DESC | VARCHAR2(100) | 　 | 　 | 　 | 카테고리설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | SVC\_ID | NUMBER(10) | 　 | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_BOARD** | +-------------------------+--------------------------------+ | **COMMENT** | 게시판 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | BOARD\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 게시판순번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | SVC\_ID | NUMBER(10) | 　 | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | BOARD\_TYPE | VARCHAR2(6) | 　 | 　 | 　 | 게시판타입 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | BOARD\_DETAIL\_TYPE | VARCHAR2(2) | 　 | 　 | 　 | 게시판상세타입 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | BOARD\_TITLE | VARCHAR2(1000) | 　 | NOT NULL | 　 | 게시판제목 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | BOARD\_CONTENT | VARCHAR2(4000) | 　 | 　 | 　 | 게시판내용 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | HIT | NUMBER(10) | 　 | 　 | 　 | 조회수 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용유무 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | REG\_DT | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | MOD\_DT | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 13 | SECRET\_YN | CHAR(1) | 　 | 　 | 　 | 공개여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 14 | REF | NUMBER | 　 | 　 | 　 | 계층그룹\_최상위부모BOARD\_IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 15 | STP | NUMBER | 　 | 　 | 　 | 계층별단계 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 16 | LVL | NUMBER | 　 | 　 | 　 | 레벨 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_USERGROUP** | +-------------------------+--------------------------------+ | **COMMENT** | 그룹별사용자정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | UG\_IDX | NUMBER | PK | NOT NULL | 　 | 그룹별사용자정보순번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | EMP\_NO | VARCHAR2(10) | 　 | NOT NULL | 　 | 사번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | GRP\_ID | NUMBER | 　 | NOT NULL | 　 | 그룹아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_DT | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | MOD\_DT | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | USE\_YN | CHAR(1) | 　 | 　 | 'Y' | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_USER\_HIST** | +-------------------------+--------------------------------+ | **COMMENT** | 사용자웹\_로그인이력 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | HIST\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 로그인이력IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | LOGIN\_DTTM | DATE | 　 | 　 | 　 | 로그인일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | REMOTE\_IP | VARCHAR2(20) | 　 | 　 | 　 | 접속IP | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | USER\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 사용자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_USERDEVC** | +-------------------------+--------------------------------+ | **COMMENT** | 사용자단말기 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | USERDEVC\_IDX | NUMBER | PK | NOT NULL | 　 | 사용자단말기일련번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | EMP\_NO | VARCHAR2(10) | 　 | 　 | 　 | 사번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | DEVC\_IDX | NUMBER | 　 | 　 | 　 | 단말정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | GUBUN\_CD | VARCHAR2(20) | 　 | 　 | 　 | 단말기구분(대표단말여부)\_ST004 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | PHONE\_NO | VARCHAR2(20) | 　 | 　 | 　 | 전화번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_DEVC\_IMG** | +-------------------------+--------------------------------+ | **COMMENT** | 단말이미지정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | DEVC\_IMG\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 단말이미지일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | FILE\_SIZE | NUMBER(5) | 　 | 　 | 　 | 이미지사이즈 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | EXT\_NM | VARCHAR2(10) | 　 | 　 | 　 | 이미지확장자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | FILE\_PATH | VARCHAR2(200) | 　 | 　 | 　 | 이미지 저장경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | DISP\_NO | NUMBER(3) | 　 | 　 | 　 | 디스플레이 순서 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | FILE\_NM | VARCHAR2(100) | 　 | NOT NULL | 　 | 이미지 파일명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | WIDTH\_SIZE | NUMBER(5) | 　 | 　 | 　 | 이미지가로크기 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | HEIGHT\_SIZE | NUMBER(5) | 　 | 　 | 　 | 이미지세로크기 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | DEVC\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 단말정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_FILE** | +-------------------------+--------------------------------+ | **COMMENT** | 앱스토어파일정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | FILE\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 파일순번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | BOARD\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 게시판순번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | FILE\_NAME | VARCHAR2(100) | 　 | NOT NULL | 　 | 파일이름 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | FILE\_SAVE\_NAME | VARCHAR2(100) | 　 | NOT NULL | 　 | 파일저장이름 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | FILE\_PATH | VARCHAR2(200) | 　 | NOT NULL | 　 | 파일경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | FILE\_EXT | VARCHAR2(10) | 　 | 　 | 　 | 확장자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | FILE\_SIZE | NUMBER(10) | 　 | 　 | 　 | 파일사이즈 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | STS\_CD | CHAR(1) | 　 | 　 | 　 | 상태코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | REG\_DT | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | MOD\_DT | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_APP** | +-------------------------+--------------------------------+ | **COMMENT** | 앱 정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | APP\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 앱정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | PAKG\_ID | VARCHAR2(40) | 　 | 　 | 　 | 앱패키지ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | APP\_NM | VARCHAR2(50) | 　 | 　 | 　 | 앱이름 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | APP\_DESC | VARCHAR2(512) | 　 | 　 | 　 | 설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | STS\_CD | CHAR(1) | 　 | NOT NULL | 　 | 등록상태 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | USE\_YN | CHAR(1) | 　 | NOT NULL | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 변경ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | MOD\_DTTM | DATE | 　 | 　 | 　 | 변경일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | USE\_DT | DATE | 　 | 　 | 　 | 사용일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | APP\_INFO | VARCHAR2(200) | 　 | 　 | 　 | 앱개요 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 13 | SORT\_NO | NUMBER(5) | 　 | 　 | 　 | 정렬순서 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 14 | OUT\_STO\_URL | VARCHAR2(200) | 　 | 　 | 　 | 벤더스토어URL | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 15 | OS\_TP | VARCHAR2(2) | 　 | 　 | 　 | 앱플랫폼유형 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 16 | SVC\_ID | NUMBER(10) | 　 | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 17 | CATG\_CD | VARCHAR2(10) | 　 | NOT NULL | 　 | 카테고리코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 18 | APP\_TYPE | VARCHAR2(2) | 　 | 　 | 　 | 앱분류 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 19 | PUB\_YN | CHAR(1) | 　 | 　 | 　 | 공개여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_APP\_PLAT** | +-------------------------+--------------------------------+ | **COMMENT** | 앱 플랫폼 정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | APP\_PLAT\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 앱별플렛폼일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | DIST\_TYPE | CHAR(1) | 　 | 　 | 　 | 배포타입 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | CALL\_URL | VARCHAR2(200) | 　 | 　 | 　 | 호출URL | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | PLAT\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 플랫폼정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | APP\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 앱정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용유무 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | PAKG\_ID | VARCHAR2(200) | 　 | 　 | 　 | 패키지ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_AUTH** | +-------------------------+--------------------------------+ | **COMMENT** | 권한정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | AUTH\_ID | NUMBER | PK | NOT NULL | 　 | 권한정보순번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | APP\_IDX | NUMBER | 　 | 　 | 　 | 앱정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | EMP\_NO | VARCHAR2(20) | 　 | 　 | 　 | 회원번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | GRP\_ID | NUMBER | 　 | 　 | 　 | 그룹아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | AUTH\_TYPE | VARCHAR2(20) | 　 | 　 | 　 | 권한타입(ST008) | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용유무 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | REG\_DT | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | MOD\_DT | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_APP\_IMG** | +-------------------------+--------------------------------+ | **COMMENT** | 앱 이미지 정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | IMG\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 이미지 일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | FILE\_NM | VARCHAR2(50) | 　 | NOT NULL | 　 | 이미지 파일명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | EXT\_NM | VARCHAR2(10) | 　 | 　 | 　 | 이미지 확장자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | FILE\_SIZE | NUMBER(10) | 　 | 　 | 　 | 이미지 사이즈 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | IMG\_TYPE | VARCHAR2(2) | 　 | NOT NULL | 　 | 이미지 유형 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | DISP\_NO | NUMBER(3) | 　 | 　 | 　 | 디스플레이 순서 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | USE\_YN | CHAR(1) | 　 | NOT NULL | 　 | 이미지 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | REG\_DT | DATE | 　 | 　 | 　 | 이미지 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 이미지 등록자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | MOD\_DT | DATE | 　 | 　 | 　 | 이미지 수정일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 이미지 수정자아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | DL\_URL | VARCHAR2(200) | 　 | NOT NULL | 　 | 이미지 다운로드 URL | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 13 | IMG\_PATH | VARCHAR2(200) | 　 | 　 | 　 | 이미지 경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 14 | IMG\_W | NUMBER(5) | 　 | 　 | 　 | 이미지가로크기 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 15 | IMG\_H | NUMBER(5) | 　 | 　 | 　 | 이미지세로크기 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 16 | APP\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 앱정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_APP\_REVIEW** | +-------------------------+--------------------------------+ | **COMMENT** | 앱 리뷰 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | RV\_NO | NUMBER | PK | NOT NULL | 　 | 리뷰 번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | APP\_PLAT\_IDX | NUMBER | 　 | NOT NULL | 　 | 앱별플렛폼일련번 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | TITLE | VARCHAR2(1000) | 　 | NOT NULL | 　 | 리제목 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | CONTENT | VARCHAR2(4000) | 　 | NOT NULL | 　 | 리뷰 내용 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | HIT | NUMBER | 　 | 　 | 　 | 조회 수 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | USE\_YN | CHAR(1) | 　 | NOT NULL | 　 | 사용유무 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자 아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | REG\_DT | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자 아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | MOD\_DT | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_APP\_DEVC** | +-------------------------+--------------------------------+ | **COMMENT** | 앱지원단말정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | DEVC\_SPT\_NO | NUMBER(10) | PK | NOT NULL | 　 | 앱지원단말정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | DEVC\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 단말정보일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | APP\_PLAT\_IDX | NUMBER(10) | 　 | 　 | 　 | 앱별플랙폼일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_BIN** | +-------------------------+--------------------------------+ | **COMMENT** | 바이너리 정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | BIN\_NO | NUMBER(10) | PK | NOT NULL | 　 | 바이너리일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | BIN\_FILE\_NM | VARCHAR2(100) | 　 | NOT NULL | 　 | 바이너리 파일명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | ORG\_BIN\_FILE\_NM | VARCHAR2(100) | 　 | 　 | 　 | 바이너리 원본 파일명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | FILE\_SIZE | NUMBER(10) | 　 | 　 | 　 | 파일 사이즈 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | BIN\_VER | VARCHAR2(100) | 　 | NOT NULL | 　 | 버전 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | DL\_URL | VARCHAR2(1000) | 　 | NOT NULL | 　 | 다운로드 URL | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | SHORT\_URL | VARCHAR2(500) | 　 | 　 | 　 | 다운로드 단축URL | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | STO\_WEB\_DPLY\_STS | CHAR(1) | 　 | 　 | 　 | 스토어웹 배포상태 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | STO\_WEB\_DPLY\_DT | DATE | 　 | 　 | 　 | 스토어웹 배포일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | MOB\_WEB\_DPLY\_STS | CHAR(1) | 　 | NOT NULL | 　 | 모바일웹 배포상태 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | MOB\_WEB\_DPLY\_DT | DATE | 　 | 　 | 　 | 모바일웹 배포일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 13 | PLAT\_VER\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 플랫폼버전일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 14 | APP\_PLAT\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 앱플랫폼일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 15 | REG\_DTTM | DATE | 　 | NOT NULL | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 16 | REG\_ID | VARCHAR2(20) | 　 | NOT NULL | 　 | 등록자 아이디 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 17 | UPDATE\_DESC | VARCHAR2(1000) | 　 | 　 | 　 | 변경내역 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_APP\_VER** | +-------------------------+--------------------------------+ | **COMMENT** | 스토어 앱버전관리 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | APP\_VER\_ID | VARCHAR2(10) | PK | NOT NULL | 　 | 　 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | BIN\_VER | VARCHAR2(100) | 　 | NOT NULL | 　 | 　 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | PLAT\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 　 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DTTM | DATE | 　 | 　 | 　 | 　 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 　 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 　 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | MOD\_DTTM | DATE | 　 | 　 | 　 | 　 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | SVC\_ID | NUMBER(10) | 　 | NOT NULL | 　 | 　 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | MEMO | VARCHAR2(4000) | 　 | 　 | 　 | 업데이트 공지 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | DOWNLOAD\_MARKET\_URL | VARCHAR2(400) | 　 | 　 | 　 | MARKET URL | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_DL** | +-------------------------+--------------------------------+ | **COMMENT** | 다운로드정보 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | DL\_NO | NUMBER(28) | PK | NOT NULL | 　 | 다운로드일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | IMEI | VARCHAR2(1000) | 　 | NOT NULL | 　 | 단말기식별번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | PHONE\_NO | VARCHAR2(20) | 　 | 　 | 　 | 단말 폰번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | CUID | VARCHAR2(50) | 　 | 　 | 　 | 고객사고유식별번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | REG\_DTTM | DATE | 　 | 　 | 　 | 다운로드 일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | BIN\_NO | NUMBER(10) | 　 | NOT NULL | 　 | 바이너리일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | EMP\_NO | VARCHAR2(10) | 　 | NOT NULL | 　 | EMP\_NO | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | APP\_PLAT\_IDX | NUMBER(10) | 　 | NOT NULL | 　 | 앱별플렛폼일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_CM\_USER** | +-------------------------+--------------------------------+ | **COMMENT** | 서비스사용자 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | USER\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 사용자IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_AUTH\_ACC** | +-------------------------+--------------------------------+ | **COMMENT** | 서비스접근권한 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | AUTH\_ACC\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 서비스권한일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | ACC\_KEY | VARCHAR2(60) | 　 | 　 | 　 | 접근키 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | REG\_DTTM | DATE | 　 | 　 | 　 | 생성일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_REST\_API** | +-------------------------+--------------------------------+ | **COMMENT** | REST\_API | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | URL\_PATH | VARCHAR2(200) | 　 | 　 | 　 | URL경로 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | API\_DESC | VARCHAR2(255) | 　 | 　 | 　 | 설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REST\_API\_IDX | NUMBER(10) | PK | NOT NULL | 　 | API일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_API\_AUTH\_ACC** | +-------------------------+--------------------------------+ | **COMMENT** | API접근권한 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | AUTH\_ACC\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 서비스권한일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | REST\_API\_IDX | NUMBER(10) | PK | NOT NULL | 　 | API일련번호 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_MOB\_CM\_USER** | +-------------------------+--------------------------------+ | **COMMENT** | 리소스사용자 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | USER\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 사용자IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_PUSH\_SVC** | +-------------------------+--------------------------------+ | **COMMENT** | PUSH서비스 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | SVC\_ID | NUMBER(10) | PK | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | SVC\_DTL | VARCHAR2(255) | 　 | 　 | 　 | 서비스 설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_PUSH\_USER** | +-------------------------+--------------------------------+ | **COMMENT** | 푸시사용자 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | USER\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 사용자IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_STO\_CM\_USER** | +-------------------------+--------------------------------+ | **COMMENT** | 앱사용자 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | USER\_IDX | NUMBER(10) | PK | NOT NULL | 　 | 사용자IDX | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SVC\_PRD** | +-------------------------+--------------------------------+ | **COMMENT** | 서비스제품 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | SVC\_TP | CHAR(2) | PK | NOT NULL | 　 | 제품유형 [M,P] | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | SVC\_NM | VARCHAR2(50) | 　 | 　 | 　 | 제품명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | SVC\_ID | NUMBER(10) | PK | NOT NULL | 　 | 서비스ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_MENU\_AUTH** | +-------------------------+--------------------------------+ | **COMMENT** | 시스템\_메뉴권한 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | MENU\_ID | VARCHAR2(10) | 　 | NOT NULL | 　 | 메뉴ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | AUTH\_GRP\_ID | VARCHAR2(20) | 　 | NOT NULL | 　 | 그룹ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | SELECT\_YN | CHAR(1) | 　 | 　 | 　 | 읽기여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | INSERT\_YN | CHAR(1) | 　 | 　 | 　 | 등록여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | UPDATE\_YN | CHAR(1) | 　 | 　 | 　 | 수정여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | DELETE\_YN | CHAR(1) | 　 | 　 | 　 | 삭제여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | EXCEL\_YN | CHAR(1) | 　 | 　 | 　 | 엑셀여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_SYS\_CD\_INFO** | +-------------------------+--------------------------------+ | **COMMENT** | 시스템\_공통코드 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | CD\_GRP\_ID | VARCHAR2(5) | PK | NOT NULL | 　 | 코드그룹ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | CD\_ID | VARCHAR2(20) | PK | NOT NULL | 　 | 코드\_ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | CD\_NM | VARCHAR2(100) | 　 | 　 | 　 | 코드명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | USE\_YN | CHAR(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | LANG\_CD | CHAR(2) | 　 | 　 | 　 | 언어코드 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | SORT\_NO | NUMBER(3) | 　 | 　 | 　 | 정렬순서 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | REG\_ID | VARCHAR2(20) | 　 | 　 | 　 | 등록자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | REG\_DTTM | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | MOD\_ID | VARCHAR2(20) | 　 | 　 | 　 | 수정자 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | MOD\_DTTM | DATE | 　 | 　 | 　 | 수정일시 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | CD\_DESC | VARCHAR2(200) | 　 | 　 | 　 | 코드설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ +-------------------------+--------------------------------+ | **TABLE INFORMATION** | **OWNER** | +-------------------------+--------------------------------+ | | **TABLESPACE** | +-------------------------+--------------------------------+ | **TABLE NAME** | **TB\_FRA\_SVC** | +-------------------------+--------------------------------+ | **COMMENT** | 앱위변조방지\_서비스 | +-------------------------+--------------------------------+ +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 1 | APP\_ID | varchar(50) | PRI | Not Null | 　 | app ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 2 | APP\_VER | varchar(20) | PRI | Not Null | 　 | app version | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 3 | OS\_TYPE | char(1) | PRI | Not Null | 　 | os 타입 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 4 | HASH\_BUILD\_VER | varchar(20) | 　 | 　 | 　 | 해쉬값 빌드 버전 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 5 | HASH\_VAL | longtext | 　 | 　 | 　 | 해쉬값 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 6 | FRA\_DESC | varchar(255) | 　 | 　 | 　 | 설명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 7 | USE\_YN | char(1) | 　 | Not Null | N | 사용여부 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 8 | FILE\_NM | VARCHAR(75) | 　 | Not Null | 　 | 파일명 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 9 | REG\_ID | varchar(20) | 　 | 　 | 　 | 등록자 ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 10 | REG\_DTTM | datetime | 　 | 　 | 　 | 등록 날짜 시각 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 11 | MOD\_ID | varchar(20) | 　 | 　 | 　 | 수정자ID | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | 12 | MOD\_DTTM | timestamp | 　 | Not Null | CURRENT\_TIMESTAMP | 수정 날짜 시각 | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+ | | | | | | | | +-------------------------+--------------------------------+------------------+----------------+---------------------------+----------------------+-----------------------------------+