===================================== Admin 테이블 정의서 V4.2 ===================================== :download:`download [MSP DB 테이블 명세서] ` +-------------------------+----------------------------------+ | **TABLE INFORMATION** | **　** | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | **TABLE NAME** | **TB\_CMP\_APPROVAL** | +-------------------------+----------------------------------+ | **COMMENT** | 캠페인 승인 테이블 | +-------------------------+----------------------------------+ +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 1 | APPROVAL\_SEQNO | NUMBER | PK | NOT NULL | 　 | 승인 테이블 시퀀스 번호 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 2 | TYPE | CHAR(1) | 　 | 　 | 'E' | E:개별발송, A:전체발송, G:그 룹발송, C:CSV발송 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 3 | PSID | CLOB | 　 | 　 | 　 | 푸쉬발송토큰 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 4 | CUID | CLOB | 　 | 　 | 　 | 아이디, PSID가 Blank일 경우일 때 만 사용됨 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 5 | GROUPSEQ | VARCHAR2(50) | 　 | 　 | 　 | 그룹 시퀀스번호 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 6 | MESSAGE | VARCHAR2(4000) | 　 | NOT NULL | 　 | 푸쉬 메세지 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 7 | PRIORITY | NUMBER | 　 | 　 | '3' | 발송 우선순위 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 8 | BADGENO | NUMBER | 　 | 　 | '1' | IOS 단말 APNS전송만 필요 (그외 OS는 1 세팅) | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 9 | RESERVEDATE | DATE | 　 | 　 | 　 | 예약발송일시(YYYYMMDD HHMISS, 즉시발송은 Blank) | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 10 | SERVICECODE | VARCHAR2(20) | 　 | NOT NULL | 　 | 푸시서비스 코드 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 11 | SOUNDFILE | VARCHAR2(20) | 　 | 　 | 'alert.aif' | 사운드 파일명 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 12 | EXT | VARCHAR2(255) | 　 | 　 | 　 | PUSH 부가 히든메시지. 없으면 빈값(blank) 처리. PUSH 커스텀 메시지 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 13 | SENDERCODE | VARCHAR2(50) | 　 | NOT NULL | 　 | 메시지 구분코드 (발송자 코드) | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 14 | APP\_ID | VARCHAR2(255) | 　 | NOT NULL | 　 | 어플리케이션 식별 정보 (패 키지명) | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 15 | ATTACHFILE | VARCHAR2(255) | 　 | 　 | 　 | CSV 파일 전송 시 저장된 파일 Path | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 16 | DB\_IN | CHAR(1) | 　 | 　 | 'N' | N:발송이력 DB저장 안함, Y:발 송이력 DB저장 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 17 | CMP\_TYPE | CHAR(1) | 　 | 　 | 'N' | N:일반발송, C:캠페인발송 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 18 | TEXT\_TYPE | CHAR(1) | 　 | 　 | 'T' | T:TEXT, R:RICH | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 19 | REGDATE | DATE | 　 | 　 | SYSDATE | 등록일시 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 20 | RESERVE\_FLAG | CHAR(1) | 　 | 　 | 'N' | N:즉시발송, Y:예약발송 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 21 | APPROVAL\_SENDERCODE | VARCHAR2(50) | 　 | 　 | 　 | 승인자 SENDERCODE | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 22 | APPROVAL\_FLAG | CHAR(1) | 　 | 　 | 'S' | S:승인대기, A:승인완 료, R:승인거부, C:승인취소 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 23 | ADMIN\_TITLE | VARCHAR2(100) | 　 | 　 | 　 | 메세지명 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ +-------------------------+----------------------------------+ | **TABLE INFORMATION** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **TABLE NAME** | **TB\_CMP\_TARGET\_CONDITION** | +-------------------------+----------------------------------+ | **COMMENT** | 캠페인 푸시 타게팅 조건 | +-------------------------+----------------------------------+ +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 1 | TRG\_SEQ | NUMBER | PK | NOT NULL | 　 | 시퀀스 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 2 | TRG\_CD | VARCHAR2(11) | 　 | 　 | 　 | 조건 코드 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 3 | TRG\_UP\_CD | VARCHAR2(11) | 　 | 　 | 　 | 조건 상위코드 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 4 | TRG\_NM | VARCHAR2(45) | 　 | 　 | 　 | 조건명 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 5 | TRG\_SORT | NUMBER | 　 | 　 | 　 | 순서 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 6 | TRG\_DEPTH | NUMBER | 　 | 　 | 　 | DEPTH | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 7 | TRG\_TYPE | VARCHAR2(11) | 　 | 　 | 　 | 대분류 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 8 | TRG\_VAL | VARCHAR2(10) | 　 | 　 | 　 | 해당되는 VAL정보 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 9 | REG\_DT | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 10 | REG\_NM | VARCHAR2(20) | 　 | 　 | 　 | 등록자 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 11 | MOD\_DT | DATE | 　 | 　 | 　 | 수정일시 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 12 | MOD\_NM | VARCHAR2(20) | 　 | 　 | 　 | 수정자 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ +-------------------------+----------------------------------+ | **TABLE INFORMATION** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **TABLE NAME** | **TB\_SYS\_MENU\_AUTH** | +-------------------------+----------------------------------+ | **COMMENT** | 시스템\_메뉴권한 | +-------------------------+----------------------------------+ +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 1 | MENU\_ID | VARCHAR2(10) | PK | NOT NULL | 　 | 메뉴ID | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 2 | AUTH\_GRP\_ID | VARCHAR2(20) | PK | 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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **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** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **TABLE NAME** | **T\_PUSH\_APPLICATION** | +-------------------------+----------------------------------+ | **COMMENT** | 어플리케이션 | +-------------------------+----------------------------------+ +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 1 | APPID | VARCHAR2(256) | PK | NOT NULL | 　 | 다운로드일련번호앱식별자 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 2 | APPNAME | VARCHAR2(50) | 　 | 　 | 　 | 어플리케이션명 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 3 | ISDELETED | VARCHAR2(1) | 　 | 　 | 　 | 삭제여부 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 4 | REGDATE | DATE | 　 | 　 | 　 | 등록일시 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 5 | MODDATE | DATE | 　 | 　 | 　 | 변경일시 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 6 | SVC\_ID | NUMBER(10) | 　 | 　 | 　 | 서비스ID | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 7 | SVC\_DTL | VARCHAR2(255) | 　 | 　 | 　 | 　 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ +-------------------------+----------------------------------+ | **TABLE INFORMATION** | **　** | +-------------------------+----------------------------------+ | | | +-------------------------+----------------------------------+ | **TABLE NAME** | **T\_PUSH\_USER** | +-------------------------+----------------------------------+ | **COMMENT** | 　 | +-------------------------+----------------------------------+ +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 1 | CUID | VARCHAR2(50) | PK | NOT NULL | 　 | 　 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 2 | CNAME | VARCHAR2(50) | 　 | 　 | 　 | 　 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 3 | VAL1 | VARCHAR2(50) | 　 | 　 | 　 | 타게팅 조건1 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 4 | VAL2 | VARCHAR2(50) | 　 | 　 | 　 | 타게팅 조건2 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 5 | VAL3 | VARCHAR2(50) | 　 | 　 | 　 | 타게팅 조건3 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 6 | VAL4 | VARCHAR2(50) | 　 | 　 | 　 | 타게팅 조건4 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 7 | VAL5 | VARCHAR2(50) | 　 | 　 | 　 | 타게팅 조건5 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 8 | VAL6 | VARCHAR2(50) | 　 | 　 | 　 | 타게팅 조건6 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 9 | VAL7 | VARCHAR2(50) | 　 | 　 | 　 | 타게팅 조건7 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 10 | VAL8 | VARCHAR2(50) | 　 | 　 | 　 | 타게팅 조건8 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 11 | VAL9 | VARCHAR2(50) | 　 | 　 | 　 | 타게팅 조건9 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 12 | REGDT | DATE | 　 | 　 | 　 | 　 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+ | 13 | MODDT | DATE | 　 | 　 | 　 | 　 | +-------------------------+----------------------------------+------------------+-----------+----------------+---------------+---------------------------------------------------------------------+