eapim-portal/script/portal/tibero/comment.sql

COMMENT ON TABLE PORTAL.PT_ID IS '테이블 식별자 관리';

COMMENT ON COLUMN PORTAL.PT_ID.TABLE_NAME IS '테이블 이름';
COMMENT ON COLUMN PORTAL.PT_ID.NEXT_ID IS '다음 ID';

COMMENT ON TABLE PORTAL.PT_CODE IS '공통 코드 관리';

COMMENT ON COLUMN PORTAL.PT_CODE.CODE_ID IS '코드 ID';
COMMENT ON COLUMN PORTAL.PT_CODE.CODE_ID_NAME IS '코드 이름';
COMMENT ON COLUMN PORTAL.PT_CODE.CODE_ID_DC IS '코드 설명';
COMMENT ON COLUMN PORTAL.PT_CODE.USE_YN IS '사용 여부';
COMMENT ON COLUMN PORTAL.PT_CODE.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_CODE.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_CODE.LAST_MODIFIED_ON IS '마지막 수정 일시';
COMMENT ON COLUMN PORTAL.PT_CODE.LAST_MODIFIED_BY IS '마지막 수정자';

COMMENT ON TABLE PORTAL.PT_DETAIL_CODE IS '상세 코드 관리';

COMMENT ON COLUMN PORTAL.PT_DETAIL_CODE.CODE_ID IS '코드 ID';
COMMENT ON COLUMN PORTAL.PT_DETAIL_CODE.CODE IS '상세 코드';
COMMENT ON COLUMN PORTAL.PT_DETAIL_CODE.CODE_VALUE IS '상세 코드 값';
COMMENT ON COLUMN PORTAL.PT_DETAIL_CODE.CODE_DC IS '상세 코드 설명';
COMMENT ON COLUMN PORTAL.PT_DETAIL_CODE.USE_YN IS '사용 여부';
COMMENT ON COLUMN PORTAL.PT_DETAIL_CODE.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_DETAIL_CODE.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_DETAIL_CODE.LAST_MODIFIED_ON IS '마지막 수정 일시';
COMMENT ON COLUMN PORTAL.PT_DETAIL_CODE.LAST_MODIFIED_BY IS '마지막 수정자';

COMMENT ON TABLE PORTAL.PT_USER_SECURITY IS '사용자 보안 설정';

COMMENT ON COLUMN PORTAL.PT_USER_SECURITY.USER_ESNTL_ID IS '사용자 식별자';
COMMENT ON COLUMN PORTAL.PT_USER_SECURITY.MBER_TY_CODE IS '회원 유형 코드';
COMMENT ON COLUMN PORTAL.PT_USER_SECURITY.AUTHOR_CODE IS '권한 코드';

COMMENT ON TABLE PORTAL.PT_BOARD_MASTER IS '게시판 마스터 정보';

COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.BOARD_ID IS '게시판 ID';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.BOARD_NAME IS '게시판 이름';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.BOARD_DESC IS '게시판 설명';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.BOARD_TYPE IS '게시판 유형';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.REPLY_POSBL_YN IS '답글 가능 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.FILE_ATCH_POSBL_YN IS '파일 첨부 가능 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.ATCH_POSBL_FILE_NUMBER IS '첨부 가능 파일 수';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.ATCH_POSBL_FILE_SIZE IS '첨부 가능 파일 크기';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.USE_YN IS '사용 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.TMPLAT_ID IS '템플릿 ID';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_BOARD_MASTER.LAST_MODIFIED_ON IS '마지막 수정 일시';

COMMENT ON TABLE PORTAL.PT_BOARD_AUTHORITY IS '게시판 권한 관리';

COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.AUTHORITY_ID IS '권한 ID';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.BBS_ID IS '게시판 ID';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.AUTHORITY_CODE IS '권한 코드';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.ESNTL_ID IS '사용자 식별 키';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.READ_YN IS '읽기 권한 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.WRITE_YN IS '쓰기 권한 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.MODIFY_YN IS '수정 권한 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.DELETE_YN IS '삭제 권한 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.ADMIN_YN IS '관리자 권한 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_BOARD_AUTHORITY.LAST_MODIFIED_ON IS '마지막 수정 일시';

COMMENT ON TABLE PORTAL.PT_BOARD_ARTICLE IS '게시판 게시물';

COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.BOARD_ID IS '게시판 ID';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.NTT_NO IS '게시물 번호';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.NTT_ID IS '게시물 ID';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.NTT_SJ IS '게시물 제목';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.NTT_CN IS '게시물 내용';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.ANSWER_YN IS '답글 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.PARNTSCTT_NO IS '부모 게시물 번호';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.ANSWER_LC IS '답글 위치';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.SORT_ORDR IS '정렬 순서';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.RDCNT IS '조회수';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.USE_YN IS '사용 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.NTCE_BGNDE IS '공지 시작일';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.NTCE_ENDDE IS '공지 종료일';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.NTCR_ID IS '게시자 ID';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.NTCR_NAME IS '게시자 이름';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.PASSWORD IS '비밀번호';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.FILE_ID IS '첨부파일 ID';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.NOTICE_YN IS '공지 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.SJ_BOLD_YN IS '제목 볼드 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.SECRET_YN IS '비밀글 여부';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.LAST_MODIFIED_ON IS '마지막 수정 일시';
COMMENT ON COLUMN PORTAL.PT_BOARD_ARTICLE.LAST_MODIFIED_BY IS '마지막 수정자';

COMMENT ON TABLE PORTAL.PT_FILE IS '파일 속성 정보';

COMMENT ON COLUMN PORTAL.PT_FILE.FILE_ID IS '파일 ID';
COMMENT ON COLUMN PORTAL.PT_FILE.USE_YN IS '사용 여부';
COMMENT ON COLUMN PORTAL.PT_FILE.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_FILE.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_FILE.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_FILE.LAST_MODIFIED_ON IS '마지막 수정 일시';

COMMENT ON TABLE PORTAL.PT_FILE_DETAIL IS '파일 상세 정보';

COMMENT ON COLUMN PORTAL.PT_FILE_DETAIL.FILE_ID IS '파일 ID';
COMMENT ON COLUMN PORTAL.PT_FILE_DETAIL.FILE_SN IS '파일 일련 번호';
COMMENT ON COLUMN PORTAL.PT_FILE_DETAIL.ORIGNL_FILE_NAME IS '원본 파일 이름';
COMMENT ON COLUMN PORTAL.PT_FILE_DETAIL.FILE_EXTSN IS '파일 확장자';
COMMENT ON COLUMN PORTAL.PT_FILE_DETAIL.FILE_CN IS '파일 내용';
COMMENT ON COLUMN PORTAL.PT_FILE_DETAIL.FILE_SIZE IS '파일 크기';

COMMENT ON TABLE PORTAL.PT_FAQ IS 'FAQ 정보';

COMMENT ON COLUMN PORTAL.PT_FAQ.FAQ_ID IS 'FAQ ID';
COMMENT ON COLUMN PORTAL.PT_FAQ.TITLE IS '질문 제목';
COMMENT ON COLUMN PORTAL.PT_FAQ.QUESTION IS '질문 내용';
COMMENT ON COLUMN PORTAL.PT_FAQ.ANSWER IS '답변 내용';
COMMENT ON COLUMN PORTAL.PT_FAQ.RDCNT IS '조회수';
COMMENT ON COLUMN PORTAL.PT_FAQ.FILE_ID IS '첨부파일 ID';
COMMENT ON COLUMN PORTAL.PT_FAQ.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_FAQ.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_FAQ.LAST_MODIFIED_ON IS '마지막 수정 일시';
COMMENT ON COLUMN PORTAL.PT_FAQ.LAST_MODIFIED_BY IS '마지막 수정자';

COMMENT ON TABLE PORTAL.REVINFO IS '리비전 정보';

COMMENT ON COLUMN PORTAL.REVINFO.REV IS '리비전 번호';
COMMENT ON COLUMN PORTAL.REVINFO.REVTSTMP IS '리비전 타임스탬프';

COMMENT ON TABLE PORTAL.PT_USER IS '내부 사용자 정보';

COMMENT ON COLUMN PORTAL.PT_USER.ESNTL_ID IS '사용자 식별 키';
COMMENT ON COLUMN PORTAL.PT_USER.USER_ID IS '사용자 ID';
COMMENT ON COLUMN PORTAL.PT_USER.USER_NAME IS '사용자 이름';
COMMENT ON COLUMN PORTAL.PT_USER.STATUS IS '상태';
COMMENT ON COLUMN PORTAL.PT_USER.MOBILE_PHONE IS '모바일 전화번호';
COMMENT ON COLUMN PORTAL.PT_USER.PASSWORD IS '비밀번호';
COMMENT ON COLUMN PORTAL.PT_USER.PASSWORD_HINT IS '비밀번호 힌트';
COMMENT ON COLUMN PORTAL.PT_USER.PASSWORD_CNSR IS '비밀번호 확인';
COMMENT ON COLUMN PORTAL.PT_USER.LOCK_YN IS '잠금 여부';
COMMENT ON COLUMN PORTAL.PT_USER.LOCK_CNT IS '잠금 횟수';
COMMENT ON COLUMN PORTAL.PT_USER.LAST_LOCK_DATE IS '마지막 잠금 일시';
COMMENT ON COLUMN PORTAL.PT_USER.LAST_CHANGE_PASSWORD_DATE IS '마지막 비밀번호 변경 일시';
COMMENT ON COLUMN PORTAL.PT_USER.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_USER.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_USER.LAST_MODIFIED_ON IS '마지막 수정 일시';
COMMENT ON COLUMN PORTAL.PT_USER.LAST_MODIFIED_BY IS '마지막 수정자';

COMMENT ON TABLE PORTAL.PT_USER_AUD IS '사용자 이력 정보';

COMMENT ON COLUMN PORTAL.PT_USER_AUD.ESNTL_ID IS '사용자 식별 키';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.REV IS '리비전 번호';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.USER_ID IS '사용자 ID';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.USER_NAME IS '사용자 이름';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.STATUS IS '상태';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.MOBILE_PHONE IS '모바일 전화번호';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.PASSWORD IS '비밀번호';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.PASSWORD_HINT IS '비밀번호 힌트';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.PASSWORD_CNSR IS '비밀번호 확인';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.LOCK_YN IS '잠금 여부';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.LOCK_CNT IS '잠금 횟수';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.LAST_LOCK_DATE IS '마지막 잠금 일시';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.LAST_CHANGE_PASSWORD_DATE IS '마지막 비밀번호 변경 일시';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.LAST_MODIFIED_ON IS '마지막 수정 일시';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_USER_AUD.REVTYPE IS '리비전 유형';

COMMENT ON TABLE PORTAL.PT_ENT_USER IS '기업 사용자 정보';

COMMENT ON COLUMN PORTAL.PT_ENT_USER.ESNTL_ID IS '사용자 식별 키';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.USER_ID IS '사용자 ID';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.USER_NAME IS '사용자 이름';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.STATUS IS '상태';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.IP_ADDRESS IS 'IP 주소';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.MOBILE_PHONE IS '모바일 전화번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.OFFICE_PHONE IS '사무실 전화번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.COMPANY_NAME IS '회사 이름';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.CEO_NAME IS '대표자 이름';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.BIZRNO IS '사업자 등록번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.JURIRNO IS '법인 등록번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.ZIP IS '우편번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.ADRES IS '주소';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.DETAIL_ADRES IS '상세 주소';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.FXNUM IS '팩스번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.INDUTY_CODE IS '산업 코드';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.PASSWORD IS '비밀번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.PASSWORD_HINT IS '비밀번호 힌트';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.PASSWORD_CNSR IS '비밀번호 확인';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.ENTRPRS_SE_CODE IS '기업 유형 코드';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.LOCK_YN IS '잠금 여부';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.LOCK_CNT IS '잠금 횟수';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.LAST_LOCK_DATE IS '마지막 잠금 일시';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.LAST_CHANGE_PASSWORD_DATE IS '마지막 비밀번호 변경 일시';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.LAST_MODIFIED_ON IS '마지막 수정 일시';
COMMENT ON COLUMN PORTAL.PT_ENT_USER.LAST_MODIFIED_BY IS '마지막 수정자';

COMMENT ON TABLE PORTAL.PT_ENT_USER_AUD IS '기업 사용자 이력 정보';

COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.ESNTL_ID IS '사용자 식별 키';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.REV IS '리비전 번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.USER_ID IS '사용자 ID';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.USER_NAME IS '사용자 이름';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.STATUS IS '상태';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.IP_ADDRESS IS 'IP 주소';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.MOBILE_PHONE IS '모바일 전화번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.OFFICE_PHONE IS '사무실 전화번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.COMPANY_NAME IS '회사 이름';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.CEO_NAME IS '대표자 이름';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.BIZRNO IS '사업자 등록번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.JURIRNO IS '법인 등록번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.ZIP IS '우편번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.ADRES IS '주소';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.DETAIL_ADRES IS '상세 주소';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.FXNUM IS '팩스번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.INDUTY_CODE IS '산업 코드';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.PASSWORD IS '비밀번호';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.PASSWORD_HINT IS '비밀번호 힌트';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.PASSWORD_CNSR IS '비밀번호 확인';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.ENTRPRS_SE_CODE IS '기업 유형 코드';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.LOCK_YN IS '잠금 여부';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.LOCK_CNT IS '잠금 횟수';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.LAST_LOCK_DATE IS '마지막 잠금 일시';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.LAST_CHANGE_PASSWORD_DATE IS '마지막 비밀번호 변경 일시';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.LAST_MODIFIED_ON IS '마지막 수정 일시';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_ENT_USER_AUD.REVTYPE IS '리비전 유형';

COMMENT ON TABLE PORTAL.PT_APPROVAL IS '승인 요청 정보';

COMMENT ON COLUMN PORTAL.PT_APPROVAL.ID IS '승인 요청 ID';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.APPROVAL_TYPE IS '승인 유형';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.BODY IS '승인 내용';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.ENDED_ON IS '종료 일시';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.REQUESTER_ID IS '요청자 ID';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.STATUS IS '승인 상태';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.TARGET_ID IS '대상 ID';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.TITLE IS '승인 제목';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_APPROVAL.LAST_MODIFIED_ON IS '마지막 수정 일시';

COMMENT ON TABLE PORTAL.PT_APPROVAL_APPROVER IS '승인자 정보';

COMMENT ON COLUMN PORTAL.PT_APPROVAL_APPROVER.APPROVAL_ID IS '승인 요청 ID';
COMMENT ON COLUMN PORTAL.PT_APPROVAL_APPROVER.ORDINAL IS '승인 순서';
COMMENT ON COLUMN PORTAL.PT_APPROVAL_APPROVER.APPROVED_ON IS '승인 일시';
COMMENT ON COLUMN PORTAL.PT_APPROVAL_APPROVER.MESSAGE IS '메시지';
COMMENT ON COLUMN PORTAL.PT_APPROVAL_APPROVER.STATUS IS '승인 상태';
COMMENT ON COLUMN PORTAL.PT_APPROVAL_APPROVER.USER_ID IS '승인자 ID';

COMMENT ON TABLE PORTAL.PT_ROUTE_INFO IS 'API 라우트 정보';

COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.ID IS '라우트 ID';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.API_PATH IS 'API 경로';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.DESCRIPTION IS '라우트 설명';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.LOG_CONTENT_ENCODE_YN IS '로그 내용 인코딩 여부';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.LOG_LEVEL IS '로그 레벨';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.NAME IS '라우트 이름';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.ORDER_NO IS '라우트 순서 번호';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.PATH IS '라우트 경로';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.METHOD IS 'HTTP 메서드';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.META_DATA_STR IS '메타 데이터 문자열';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.RESPONSE_TYPE IS '응답유형';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.MOCK_URL IS 'Mock 응답주소';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.SAMPLE_RESPONSE IS '샘플 응답';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.STATUS IS '라우트 상태';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.TYPE IS '라우트 유형';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.URI IS '라우트 URI';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.USE_YN IS '사용 여부';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.FILE_ID IS '첨부파일 ID';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_ROUTE_INFO.LAST_MODIFIED_ON IS '마지막 수정 일시';

COMMENT ON TABLE PORTAL.PT_API_KEY IS 'API 키 정보';

COMMENT ON COLUMN PORTAL.PT_API_KEY.ID IS 'API 키 ID';
COMMENT ON COLUMN PORTAL.PT_API_KEY.OWNER IS 'API 키 소유자';
COMMENT ON COLUMN PORTAL.PT_API_KEY.NAME IS 'API 키 이름';
COMMENT ON COLUMN PORTAL.PT_API_KEY.ENV IS '환경';
COMMENT ON COLUMN PORTAL.PT_API_KEY.CLIENT_ID IS '클라이언트 ID';
COMMENT ON COLUMN PORTAL.PT_API_KEY.CLIENT_SECRET IS '클라이언트 비밀 번호';
COMMENT ON COLUMN PORTAL.PT_API_KEY.REDIRECT_URL IS '리다이렉트 URL';
COMMENT ON COLUMN PORTAL.PT_API_KEY.RESPONSE_TYPE IS '응답 유형';
COMMENT ON COLUMN PORTAL.PT_API_KEY.SCOPE IS 'API 범위';
COMMENT ON COLUMN PORTAL.PT_API_KEY.STATUS IS 'API 키 상태';
COMMENT ON COLUMN PORTAL.PT_API_KEY.DESCRIPTION IS 'API 키 설명';
COMMENT ON COLUMN PORTAL.PT_API_KEY.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_API_KEY.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_API_KEY.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_API_KEY.LAST_MODIFIED_ON IS '마지막 수정 일시';

COMMENT ON TABLE PORTAL.PT_API_KEY_API IS 'API 키와 라우트 정보 매핑';

COMMENT ON COLUMN PORTAL.PT_API_KEY_API.API_KEY_ID IS 'API 키 ID';
COMMENT ON COLUMN PORTAL.PT_API_KEY_API.API_ID IS 'API 라우트 ID';

COMMENT ON TABLE PORTAL.PT_API_KEY_AUD IS 'API 키 이력 정보';

COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.ID IS 'API 키 ID';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.REV IS '리비전 번호';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.REVTYPE IS '리비전 유형';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.OWNER IS 'API 키 소유자';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.NAME IS 'API 키 이름';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.ENV IS '환경';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.CLIENT_ID IS '클라이언트 ID';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.CLIENT_SECRET IS '클라이언트 비밀 번호';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.REDIRECT_URL IS '리다이렉트 URL';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.RESPONSE_TYPE IS '응답 유형';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.SCOPE IS 'API 범위';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.STATUS IS 'API 키 상태';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.DESCRIPTION IS 'API 키 설명';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_API_KEY_AUD.LAST_MODIFIED_ON IS '마지막 수정 일시';

COMMENT ON TABLE PORTAL.PT_API_KEY_API_AUD IS 'API 키와 라우트 정보 매핑 이력';

COMMENT ON COLUMN PORTAL.PT_API_KEY_API_AUD.API_KEY_ID IS 'API 키 ID';
COMMENT ON COLUMN PORTAL.PT_API_KEY_API_AUD.API_ID IS 'API 라우트 ID';
COMMENT ON COLUMN PORTAL.PT_API_KEY_API_AUD.REV IS '리비전 번호';
COMMENT ON COLUMN PORTAL.PT_API_KEY_API_AUD.REVTYPE IS '리비전 유형';

COMMENT ON TABLE PORTAL.PT_AGREEMENTS IS '약관 정보';

COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.AGREEMENTS_TYPE IS '약관 유형';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.REVISION IS '리비전 번호';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.AGREEMENTS_NAME IS '약관 이름';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.AGREEMENTS_CONTENTS IS '약관 내용';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.STATUS IS '약관 상태';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.PUBLISHED_ON IS '발행 일시';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.SCHEDULED_ON IS '예정 일시';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_AGREEMENTS.LAST_MODIFIED_ON IS '마지막 수정 일시';

COMMENT ON TABLE PORTAL.PT_MESSAGE_TEMPLATE IS '메시지 템플릿';

COMMENT ON COLUMN PORTAL.PT_MESSAGE_TEMPLATE.MESSAGE_KEY IS '메시지 키';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_TEMPLATE.MESSAGE_TYPE IS '메시지 유형';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_TEMPLATE.SUBJECT IS '메시지 제목';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_TEMPLATE.CONTENTS IS '메시지 내용';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_TEMPLATE.USE_YN IS '사용 여부';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_TEMPLATE.REGISTERED_BY IS '등록자';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_TEMPLATE.REGISTERED_ON IS '등록 일시';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_TEMPLATE.LAST_MODIFIED_BY IS '마지막 수정자';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_TEMPLATE.LAST_MODIFIED_ON IS '마지막 수정 일시';

COMMENT ON TABLE PORTAL.PT_MESSAGE_RECIPIENT IS '메시지 수신자';

COMMENT ON COLUMN PORTAL.PT_MESSAGE_RECIPIENT.MESSAGE_KEY IS '메시지 키';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_RECIPIENT.MESSAGE_TYPE IS '메시지 유형';
COMMENT ON COLUMN PORTAL.PT_MESSAGE_RECIPIENT.ESNTL_ID IS '수신자 식별 키';

COMMENT ON TABLE PORTAL.PT_TOKEN IS '토큰 관리';

COMMENT ON COLUMN PORTAL.PT_TOKEN.TOKEN IS '토큰 값';
COMMENT ON COLUMN PORTAL.PT_TOKEN.EMAIL IS '이메일 주소';
COMMENT ON COLUMN PORTAL.PT_TOKEN.EXPIRES_ON IS '토큰 만료 일시';

COMMENT ON TABLE PORTAL.PT_TWO_FACTOR_AUTH IS '2단계 인증 정보';

COMMENT ON COLUMN PORTAL.PT_TWO_FACTOR_AUTH.RECIPIENT IS '인증 수신자';
COMMENT ON COLUMN PORTAL.PT_TWO_FACTOR_AUTH.AUTH_NUMBER IS '인증 번호';
COMMENT ON COLUMN PORTAL.PT_TWO_FACTOR_AUTH.EXPIRES_ON IS '인증 만료 시간';