Rinjae
506 lines
21 KiB
SQL
506 lines
21 KiB
SQL
COMMENT ON TABLE DVPOWN.COMTECOPSEQ IS 'COMTECOPSEQ';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTECOPSEQ.TABLE_NAME IS '테이블 이름';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTECOPSEQ.NEXT_ID IS '다음 아이디';
|
|
|
|
|
|
|
|
COMMENT ON TABLE DVPOWN.COMTCCMMNCODE IS '공통 코드';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNCODE.CODE_ID IS '코드 ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNCODE.CODE_ID_NAME IS '코드ID 이름';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNCODE.CODE_ID_DC IS '코드ID설명';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNCODE.USE_AT IS '사용여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNCODE.CL_CODE IS '분류코드';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNCODE.REGISTERED_ON IS '최초등록시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNCODE.REGISTERED_BY IS '최초등록자ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNCODE.LAST_MODIFIED_ON IS '최종수정시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNCODE.LAST_MODIFIED_BY IS '최종수정자ID';
|
|
|
|
|
|
COMMENT ON TABLE DVPOWN.COMTCCMMNDETAILCODE IS '공통상세코드';
|
|
|
|
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNDETAILCODE.CODE_ID IS '코드ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNDETAILCODE.CODE IS '코드';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNDETAILCODE.CODE_VALUE IS '코드명';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNDETAILCODE.CODE_DC IS '코드설명';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNDETAILCODE.USE_AT IS '사용여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNDETAILCODE.REGISTERED_ON IS '최초등록시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNDETAILCODE.REGISTERED_BY IS '최초등록자ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNDETAILCODE.LAST_MODIFIED_ON IS '최종수정시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTCCMMNDETAILCODE.LAST_MODIFIED_BY IS '최종수정자ID';
|
|
|
|
|
|
COMMENT ON TABLE DVPOWN.COMTNAUTHORINFO IS '권한정보';
|
|
|
|
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNAUTHORINFO.AUTHOR_CODE IS '권한코드';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNAUTHORINFO.AUTHOR_NAME IS '권한명';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNAUTHORINFO.AUTHOR_DC IS '권한설명';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNAUTHORINFO.AUTHOR_CREAT_DE IS '권한생성일';
|
|
|
|
|
|
COMMENT ON TABLE DVPOWN.COMTNEMPLYRSCRTYESTBS IS '사용자보안설정';
|
|
|
|
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNEMPLYRSCRTYESTBS.SCRTY_DTRMN_TRGET_ID IS '보안설정대상ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNEMPLYRSCRTYESTBS.MBER_TY_CODE IS '회원유형코드';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNEMPLYRSCRTYESTBS.AUTHOR_CODE IS '권한코드';
|
|
|
|
|
|
|
|
COMMENT ON TABLE DVPOWN.COMTNBBSMASTER IS '게시판마스터';
|
|
|
|
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.BBS_ID IS '게시판ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.BBS_NAME IS '게시판명';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.BBS_INTRCN IS '게시판소개';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.BBS_TY_CODE IS '게시판유형코드';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.REPLY_POSBL_AT IS '답장가능여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.FILE_ATCH_POSBL_AT IS '파일첨부가능여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.ATCH_POSBL_FILE_NUMBER IS '첨부가능파일숫자';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.ATCH_POSBL_FILE_SIZE IS '첨부가능파일사이즈';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.USE_AT IS '사용여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.TMPLAT_ID IS '템플릿ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.REGISTERED_BY IS '최초등록자ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.REGISTERED_ON IS '최초등록시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.LAST_MODIFIED_BY IS '최종수정자ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.LAST_MODIFIED_ON IS '최종수정시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.BLOG_AT IS '블로그 여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.BLOG_ID IS '블로그 ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBSMASTER.CMMNTY_ID IS '커뮤니티ID';
|
|
|
|
|
|
COMMENT ON TABLE DVPOWN.COMTNBBS IS '게시판';
|
|
|
|
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.NTT_ID IS '게시물ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.BBS_ID IS '게시판ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.NTT_NO IS '게시물번호';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.NTT_SJ IS '게시물제목';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.NTT_CN IS '게시물내용';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.ANSWER_AT IS '댓글여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.PARNTSCTT_NO IS '부모글번호';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.ANSWER_LC IS '댓글위치';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.SORT_ORDR IS '정렬순서';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.USE_AT IS '사용여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.RDCNT IS '조회수';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.NTCE_BGNDE IS '게시시작일';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.NTCE_ENDDE IS '게시 종료일';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.NTCR_ID IS '게시자 ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.NTCR_NAME IS '게시자 이름';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.PASSWORD IS '비밀 번호';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.ATCH_FILE_ID IS '첨부 파일 ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.REGISTERED_ON IS '최초 등록 시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.REGISTERED_BY IS '최초등록자ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.LAST_MODIFIED_ON IS '최종수정시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.LAST_MODIFIED_BY IS '최종수정자ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.BLOG_ID IS '블로그 ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.NOTICE_AT IS '공지사항여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.SECRET_AT IS '비밀글여부';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNBBS.SJ_BOLD_AT IS '제목볼드여부';
|
|
|
|
COMMENT ON TABLE DVPOWN.COMTNFAQINFO IS 'FAQ정보';
|
|
|
|
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.FAQ_ID IS 'FAQID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.QESTN_SJ IS '질문제목';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.QESTN_CN IS '질문내용';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.ANSWER_CN IS '답변내용';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.RDCNT IS '조회수';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.REGISTERED_ON IS '최초등록시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.REGISTERED_BY IS '최초등록자ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.LAST_MODIFIED_ON IS '최종수정시점';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.LAST_MODIFIED_BY IS '최종수정자ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.ATCH_FILE_ID IS '첨부파일ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFAQINFO.QNA_PROCESS_STTUS_CODE IS '질의응답처리상태코드';
|
|
|
|
|
|
|
|
|
|
COMMENT ON TABLE DVPOWN.COMTNFILE IS '파일속성';
|
|
|
|
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFILE.ATCH_FILE_ID IS '첨부파일ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFILE.CREAT_DT IS '생성일시';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFILE.USE_AT IS '사용여부';
|
|
|
|
|
|
|
|
|
|
COMMENT ON TABLE DVPOWN.COMTNFILEDETAIL IS '파일상세정보';
|
|
|
|
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFILEDETAIL.ATCH_FILE_ID IS '첨부파일ID';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFILEDETAIL.FILE_SN IS '파일순번';
|
|
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFILEDETAIL.ORIGNL_FILE_NAME IS '원파일명';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFILEDETAIL.FILE_EXTSN IS '파일확장자';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFILEDETAIL.FILE_CN IS '파일내용';
|
|
|
|
COMMENT ON COLUMN DVPOWN.COMTNFILEDETAIL.FILE_SIZE IS '파일크기';
|
|
|
|
|
|
-- PT_USER
|
|
COMMENT ON TABLE PT_USER IS '내부 사용자 정보';
|
|
|
|
-- PT_USER 의 컬럼
|
|
COMMENT ON COLUMN PT_USER.ESNTL_ID IS '기본 키';
|
|
COMMENT ON COLUMN PT_USER.USER_ID IS '사용자 ID';
|
|
COMMENT ON COLUMN PT_USER.USER_NAME IS '사용자 이름';
|
|
COMMENT ON COLUMN PT_USER.PASSWORD IS '비밀번호';
|
|
COMMENT ON COLUMN PT_USER.PASSWORD_HINT IS '비밀번호 힌트';
|
|
COMMENT ON COLUMN PT_USER.PASSWORD_CNSR IS '비밀번호 확인';
|
|
COMMENT ON COLUMN PT_USER.MBTLNUM IS '모바일 번호';
|
|
COMMENT ON COLUMN PT_USER.EMPLYR_STTUS_CODE IS '상태 코드';
|
|
COMMENT ON COLUMN PT_USER.LOCK_AT IS '잠금 상태';
|
|
COMMENT ON COLUMN PT_USER.LOCK_CNT IS '잠금 횟수';
|
|
COMMENT ON COLUMN PT_USER.LAST_LOCK_DATE IS '마지막 잠금 일시';
|
|
COMMENT ON COLUMN PT_USER.LAST_CHANGE_PASSWORD_DATE IS '마지막 비밀번호 변경 일시';
|
|
COMMENT ON COLUMN PT_USER.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_USER.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_USER.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
COMMENT ON COLUMN PT_USER.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
|
|
-- PT_USER_AUD
|
|
COMMENT ON TABLE PT_USER_AUD IS '사용자 감사 정보';
|
|
|
|
-- PT_USER_AUD
|
|
COMMENT ON COLUMN PT_USER_AUD.ESNTL_ID IS '기본 키';
|
|
COMMENT ON COLUMN PT_USER_AUD.REV IS '감사 리비전 번호';
|
|
COMMENT ON COLUMN PT_USER_AUD.USER_ID IS '사용자 ID';
|
|
COMMENT ON COLUMN PT_USER_AUD.USER_NAME IS '사용자 이름';
|
|
COMMENT ON COLUMN PT_USER_AUD.PASSWORD IS '비밀번호';
|
|
COMMENT ON COLUMN PT_USER_AUD.PASSWORD_HINT IS '비밀번호 힌트';
|
|
COMMENT ON COLUMN PT_USER_AUD.PASSWORD_CNSR IS '비밀번호 확인';
|
|
COMMENT ON COLUMN PT_USER_AUD.MBTLNUM IS '모바일 번호';
|
|
COMMENT ON COLUMN PT_USER_AUD.EMPLYR_STTUS_CODE IS '상태 코드';
|
|
COMMENT ON COLUMN PT_USER_AUD.LOCK_AT IS '잠금 상태';
|
|
COMMENT ON COLUMN PT_USER_AUD.LOCK_CNT IS '잠금 횟수';
|
|
COMMENT ON COLUMN PT_USER_AUD.LAST_LOCK_DATE IS '마지막 잠금 일시';
|
|
COMMENT ON COLUMN PT_USER_AUD.LAST_CHANGE_PASSWORD_DATE IS '마지막 비밀번호 변경 일시';
|
|
COMMENT ON COLUMN PT_USER_AUD.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_USER_AUD.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_USER_AUD.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
COMMENT ON COLUMN PT_USER_AUD.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
COMMENT ON COLUMN PT_USER_AUD.REVTYPE IS '리비전 타입';
|
|
|
|
|
|
-- PT_ENT_USER
|
|
COMMENT ON TABLE PT_ENT_USER IS '기업 사용자 정보';
|
|
|
|
-- PT_ENT_USER 컬럼
|
|
COMMENT ON COLUMN PT_ENT_USER.ESNTL_ID IS '사용자 식별 키';
|
|
COMMENT ON COLUMN PT_ENT_USER.USER_ID IS '사용자 ID';
|
|
COMMENT ON COLUMN PT_ENT_USER.USER_NAME IS '사용자 이름';
|
|
COMMENT ON COLUMN PT_ENT_USER.PASSWORD IS '비밀 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER.STATUS IS '계정 상태';
|
|
COMMENT ON COLUMN PT_ENT_USER.MOBILE_PHONE IS '모바일 전화';
|
|
COMMENT ON COLUMN PT_ENT_USER.OFFICE_PHONE IS '사무실 전화';
|
|
COMMENT ON COLUMN PT_ENT_USER.COMPANY_NAME IS '회사 이름';
|
|
COMMENT ON COLUMN PT_ENT_USER.CEO_NAME IS '대표자 이름';
|
|
COMMENT ON COLUMN PT_ENT_USER.BIZRNO IS '사업자 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER.JURIRNO IS '법인 등록 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER.ZIP IS '우편 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER.ADRES IS '주소';
|
|
COMMENT ON COLUMN PT_ENT_USER.DETAIL_ADRES IS '상세 주소';
|
|
COMMENT ON COLUMN PT_ENT_USER.FXNUM IS '팩스 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER.ENTRPRS_SE_CODE IS '기업 유형 코드';
|
|
COMMENT ON COLUMN PT_ENT_USER.INDUTY_CODE IS '산업 코드';
|
|
COMMENT ON COLUMN PT_ENT_USER.PASSWORD_HINT IS '비밀 번호 힌트';
|
|
COMMENT ON COLUMN PT_ENT_USER.PASSWORD_CNSR IS '비밀 번호 확인';
|
|
COMMENT ON COLUMN PT_ENT_USER.LOCK_AT IS '잠금 상태';
|
|
COMMENT ON COLUMN PT_ENT_USER.LOCK_CNT IS '잠금 횟수';
|
|
COMMENT ON COLUMN PT_ENT_USER.LAST_LOCK_DATE IS '마지막 잠금 일시';
|
|
COMMENT ON COLUMN PT_ENT_USER.LAST_CHANGE_PASSWORD_DATE IS '마지막 비밀 번호 변경 일시';
|
|
COMMENT ON COLUMN PT_ENT_USER.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_ENT_USER.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_ENT_USER.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
COMMENT ON COLUMN PT_ENT_USER.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
|
|
-- PT_ENT_USER_AUD
|
|
COMMENT ON TABLE PT_ENT_USER_AUD IS '기업 사용자 감사 정보';
|
|
|
|
-- PT_ENT_USER_AUD 컬럼
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.ESNTL_ID IS '사용자 식별 키';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.REV IS '감사 리비전 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.USER_ID IS '사용자 ID';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.USER_NAME IS '사용자 이름';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.PASSWORD IS '비밀 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.STATUS IS '계정 상태';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.MOBILE_PHONE IS '모바일 전화';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.OFFICE_PHONE IS '사무실 전화';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.COMPANY_NAME IS '회사 이름';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.CEO_NAME IS '대표자 이름';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.BIZRNO IS '사업자 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.JURIRNO IS '법인 등록 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.ZIP IS '우편 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.ADRES IS '주소';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.DETAIL_ADRES IS '상세 주소';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.FXNUM IS '팩스 번호';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.ENTRPRS_SE_CODE IS '기업 유형 코드';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.INDUTY_CODE IS '산업 코드';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.PASSWORD_HINT IS '비밀 번호 힌트';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.PASSWORD_CNSR IS '비밀 번호 확인';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.LOCK_AT IS '잠금 상태';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.LOCK_CNT IS '잠금 횟수';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.LAST_LOCK_DATE IS '마지막 잠금 일시';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.LAST_CHANGE_PASSWORD_DATE IS '마지막 비밀 번호 변경 일시';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
COMMENT ON COLUMN PT_ENT_USER_AUD.REVTYPE IS '리비전 타입';
|
|
|
|
|
|
-- PT_APPROVAL
|
|
COMMENT ON TABLE PT_APPROVAL IS '승인 요청 정보';
|
|
|
|
-- PT_APPROVAL 컬럼
|
|
COMMENT ON COLUMN PT_APPROVAL.ID IS '승인 요청 ID';
|
|
COMMENT ON COLUMN PT_APPROVAL.APPROVAL_TYPE IS '승인 유형';
|
|
COMMENT ON COLUMN PT_APPROVAL.BODY IS '승인 내용';
|
|
COMMENT ON COLUMN PT_APPROVAL.ENDED_ON IS '종료 일시';
|
|
COMMENT ON COLUMN PT_APPROVAL.REQUESTER_ID IS '요청자 ID';
|
|
COMMENT ON COLUMN PT_APPROVAL.STATUS IS '승인 상태';
|
|
COMMENT ON COLUMN PT_APPROVAL.TARGET_ID IS '대상 ID';
|
|
COMMENT ON COLUMN PT_APPROVAL.TITLE IS '승인 제목';
|
|
COMMENT ON COLUMN PT_APPROVAL.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_APPROVAL.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_APPROVAL.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
COMMENT ON COLUMN PT_APPROVAL.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
|
|
-- PT_APPROVAL_APPROVER
|
|
COMMENT ON TABLE PT_APPROVAL_APPROVER IS '승인자 정보';
|
|
|
|
-- PT_APPROVAL_APPROVER 컬럼
|
|
COMMENT ON COLUMN PT_APPROVAL_APPROVER.APPROVAL_ID IS '승인 요청 ID';
|
|
COMMENT ON COLUMN PT_APPROVAL_APPROVER.ORDINAL IS '승인 순서';
|
|
COMMENT ON COLUMN PT_APPROVAL_APPROVER.APPROVED_ON IS '승인 일시';
|
|
COMMENT ON COLUMN PT_APPROVAL_APPROVER.MESSAGE IS '메시지';
|
|
COMMENT ON COLUMN PT_APPROVAL_APPROVER.STATUS IS '승인 상태';
|
|
COMMENT ON COLUMN PT_APPROVAL_APPROVER.USER_ID IS '승인자 ID';
|
|
|
|
|
|
-- PT_ROUTE_INFO
|
|
COMMENT ON TABLE PT_ROUTE_INFO IS 'API 라우트 정보';
|
|
|
|
-- PT_ROUTE_INFO 컬럼
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.ID IS '라우트 ID (기본 키)';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.API_PATH IS 'API 경로';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.DESCRIPTION IS '라우트 설명';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.LOG_CONTENT_ENCODE_YN IS '로그 내용 인코딩 여부 (Y/N)';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.LOG_LEVEL IS '로그 레벨';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.NAME IS '라우트 이름';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.ORDER_NO IS '라우트 순서 번호';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.PATH IS '라우트 경로';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.METHOD IS 'HTTP 메서드';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.META_DATA_STR IS '메타 데이터 문자열';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.SAMPLE_RESPONSE IS '샘플 응답';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.STATUS IS '라우트 상태';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.TYPE IS '라우트 유형';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.URI IS '라우트 URI';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.USE_YN IS '사용 여부 (Y/N)';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.FILE_ID IS '파일 ID';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
COMMENT ON COLUMN PT_ROUTE_INFO.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
|
|
|
|
-- PT_API_KEY 테이블
|
|
COMMENT ON TABLE PT_API_KEY IS 'API 키 정보 테이블';
|
|
|
|
-- PT_API_KEY 컬럼
|
|
COMMENT ON COLUMN PT_API_KEY.ID IS 'API 키 ID';
|
|
COMMENT ON COLUMN PT_API_KEY.OWNER IS 'API 키 소유자';
|
|
COMMENT ON COLUMN PT_API_KEY.NAME IS 'API 키 이름';
|
|
COMMENT ON COLUMN PT_API_KEY.ENV IS '환경';
|
|
COMMENT ON COLUMN PT_API_KEY.CLIENT_ID IS '클라이언트 ID';
|
|
COMMENT ON COLUMN PT_API_KEY.CLIENT_SECRET IS '클라이언트 비밀 번호';
|
|
COMMENT ON COLUMN PT_API_KEY.REDIRECT_URL IS '리다이렉트 URL';
|
|
COMMENT ON COLUMN PT_API_KEY.RESPONSE_TYPE IS '응답 타입';
|
|
COMMENT ON COLUMN PT_API_KEY.SCOPE IS 'API 범위';
|
|
COMMENT ON COLUMN PT_API_KEY.STATUS IS 'API 키 상태';
|
|
COMMENT ON COLUMN PT_API_KEY.DESCRIPTION IS 'API 키 설명';
|
|
COMMENT ON COLUMN PT_API_KEY.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_API_KEY.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_API_KEY.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
COMMENT ON COLUMN PT_API_KEY.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
|
|
-- PT_API_KEY_API 테이블
|
|
COMMENT ON TABLE PT_API_KEY_API IS 'API 키와 라우트 정보 매핑 테이블';
|
|
|
|
-- PT_API_KEY_API 컬럼
|
|
COMMENT ON COLUMN PT_API_KEY_API.API_KEY_ID IS 'API 키 ID';
|
|
COMMENT ON COLUMN PT_API_KEY_API.API_ID IS 'API 라우트 ID';
|
|
|
|
|
|
-- PT_MESSAGE_TEMPLATE 테이블
|
|
COMMENT ON TABLE PT_MESSAGE_TEMPLATE IS '메시지 템플릿';
|
|
|
|
-- PT_MESSAGE_TEMPLATE 컬럼
|
|
COMMENT ON COLUMN PT_MESSAGE_TEMPLATE.MESSAGE_KEY IS '메시지 키';
|
|
COMMENT ON COLUMN PT_MESSAGE_TEMPLATE.MESSAGE_TYPE IS '메시지 타입(이메일,sms)';
|
|
COMMENT ON COLUMN PT_MESSAGE_TEMPLATE.SUBJECT IS '메시지 제목';
|
|
COMMENT ON COLUMN PT_MESSAGE_TEMPLATE.CONTENTS IS '메시지 내용';
|
|
COMMENT ON COLUMN PT_MESSAGE_TEMPLATE.USE_YN IS '사용 여부';
|
|
COMMENT ON COLUMN PT_MESSAGE_TEMPLATE.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_MESSAGE_TEMPLATE.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_MESSAGE_TEMPLATE.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
COMMENT ON COLUMN PT_MESSAGE_TEMPLATE.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
|
|
-- PT_MESSAGE_RECIPIENT 테이블
|
|
COMMENT ON TABLE PT_MESSAGE_RECIPIENT IS '메시지 추가 수신자';
|
|
|
|
-- PT_MESSAGE_RECIPIENT 컬럼
|
|
COMMENT ON COLUMN PT_MESSAGE_RECIPIENT.MESSAGE_KEY IS '메시지 키';
|
|
COMMENT ON COLUMN PT_MESSAGE_RECIPIENT.MESSAGE_TYPE IS '메시지 타입';
|
|
COMMENT ON COLUMN PT_MESSAGE_RECIPIENT.ESNTL_ID IS '수신자의 고유 ID';
|
|
|
|
-- PT_AGREEMENTS 테이블
|
|
COMMENT ON TABLE PT_AGREEMENTS IS '사용자 동의서 정보';
|
|
|
|
-- PT_AGREEMENTS 컬럼
|
|
COMMENT ON COLUMN PT_AGREEMENTS.AGREEMENTS_TYPE IS '동의서 유형';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.REVISION IS '동의서 리비전 번호';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.AGREEMENTS_NAME IS '동의서 이름';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.AGREEMENTS_CONTENTS IS '동의서 내용';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.STATUS IS '동의서 상태';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.PUBLISHED_ON IS '동의서 발행 일시';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.SCHEDULED_ON IS '동의서 예정 일시';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
COMMENT ON COLUMN PT_AGREEMENTS.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
|
|
-- PT_TOKEN 테이블
|
|
COMMENT ON TABLE PT_TOKEN IS '토큰 관리 테이블';
|
|
|
|
-- PT_TOKEN 컬럼
|
|
COMMENT ON COLUMN PT_TOKEN.TOKEN IS '토큰 값';
|
|
COMMENT ON COLUMN PT_TOKEN.EMAIL IS '이메일 주소';
|
|
COMMENT ON COLUMN PT_TOKEN.EXPIRES_AT IS '토큰 만료 일시';
|
|
|
|
|
|
-- PT_BOARD_AUTHORITY 테이블
|
|
COMMENT ON TABLE PT_BOARD_AUTHORITY IS '게시판 권한 관리 테이블';
|
|
|
|
-- PT_BOARD_AUTHORITY 컬럼
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.AUTHORITY_ID IS '권한 ID';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.BBS_ID IS '게시판 ID';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.AUTHORITY_CODE IS '권한 코드';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.ESNTL_ID IS '기본 ID';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.READ_YN IS '읽기 권한 여부';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.WRITE_YN IS '쓰기 권한 여부';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.MODIFY_YN IS '수정 권한 여부';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.DELETE_YN IS '삭제 권한 여부';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.ADMIN_YN IS '관리자 권한 여부';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.REGISTERED_BY IS '등록자';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.REGISTERED_ON IS '등록 일시';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.LAST_MODIFIED_BY IS '마지막 수정자';
|
|
COMMENT ON COLUMN PT_BOARD_AUTHORITY.LAST_MODIFIED_ON IS '마지막 수정 일시';
|
|
|
|
-- PT_TWO_FACTOR_AUTH 테이블
|
|
COMMENT ON TABLE PT_TWO_FACTOR_AUTH IS '2단계 인증 정보 테이블';
|
|
|
|
-- PT_TWO_FACTOR_AUTH 컬럼
|
|
COMMENT ON COLUMN PT_TWO_FACTOR_AUTH.RECIPIENT IS '인증 수신자';
|
|
COMMENT ON COLUMN PT_TWO_FACTOR_AUTH.AUTH_NUMBER IS '인증 번호';
|
|
COMMENT ON COLUMN PT_TWO_FACTOR_AUTH.EXPIRES_AT IS '인증 만료 시간';
|
|
|
|
-- REVINFO 테이블
|
|
COMMENT ON TABLE REVINFO IS '리비전 정보 테이블';
|
|
|
|
-- REVINFO 컬럼
|
|
COMMENT ON COLUMN REVINFO.REVTSTMP IS '리비전 타임스탬프';
|
|
COMMENT ON COLUMN REVINFO.REV IS '리비전 번호';
|
|
|