KEIPORTAL
Tables (12)
BRD_ATCL (게시물)
- ATCL_SEQ (게시물순번) — NUMBER — Primary key — NOT NULL
- BRD_SEQ (게시판순번) — NUMBER
- WRT_USR_KEY (작성사용자키) — NUMBER
- KEEP_TERM_CD (보존기간코드) — VARCHAR2 (2)
- KEEP_EXPI_DATE (보존만료일자) — CHAR (8 )
- POST_NOTI_YN (게시알림여부) — CHAR (1 )
- IMPO_ANCMT_YN (중요공지여부) — CHAR (1 )
- ANCMT_STRT_DATE (공지시작일자) — CHAR (8 )
- ANCMT_EXPI_DATE (공지만료일자) — CHAR (8 )
- ATCL_TIT (게시물제목) — NVARCHAR2 (500)
- ATCL_CONT (게시물내용) — CLOB
- HIT_CNT (조회수) — NUMBER
- RECOM_CNT (추천수) — NUMBER
- ATCH_FILE_CNT (첨부파일수) — NUMBER
- CNDLC_DATE (경조일자) — NVARCHAR2 (8)
- DOC_VER (문서버전) — NVARCHAR2 (5)
- LOCK_YN (락여부) — CHAR (1 )
- LOCK_USR_KEY (락사용자키) — NUMBER
- LOCK_DTIME (락일시) — CHAR (14)
- BRD_ATCL_SEQ (게시판게시물순번) — NUMBER
- RPLY_PARNT_ATCL_SEQ (답글부모게시물순번) — NUMBER
- RPLY_PARNT_GRP_SEQ (답글부모그룹순번) — NUMBER
- RPLY_PARNT_GRP_ORDER (답글부모그룹순서) — NUMBER
- RPLY_PARNT_ATCL_SEQ_LIST (답글부모게시물순번리스트) — NVARCHAR2 (500)
- RPLY_ATCL_LVL (답글게시물레벨) — NUMBER
- CHLD_CNT (자식수) — NUMBER
- TEMP_STRG_YN (임시보관여부) — CHAR (1 )
- APPR_CD (승인코드) — VARCHAR2 (1)
- DEL_YN (삭제여부) — CHAR (1 )
- TAG (태그) — NVARCHAR2 (100)
- VER_PARNT_ATCL_SEQ (버전부모게시물순번) — NUMBER
- VER_PARNT_YN (버전부모여부) — CHAR (1 )
- ATCL_REG_DTIME (게시물등록일시) — CHAR (14)
- REG_DTIME (등록일시) — CHAR (14)
- REG_USR_KEY (등록사용자키) — NUMBER
- MOD_DTIME (수정일시) — CHAR (14)
- MOD_USR_KEY (수정사용자키) — NUMBER
- RTN_RESN (Field5) — NVARCHAR2 (500)
- ATCL_CATE_CD (게시물분류코드) — VARCHAR2 (10)
- ATCL_STTS_CD (게시물상태코드) — VARCHAR2 (2)
- ATCL_CATE_CD_2 (게시물분류코드2) — VARCHAR2 (2)
- RASER_POST_YN (등록게시여부) — VARCHAR2 (2)
- ATCL_TIT_COLR (게시물제목색상) — VARCHAR2 (7)
- IMPO_YN (중요여부) — CHAR (1 )
- URGENCY_YN (긴급여부) — CHAR (1 )
- ATCL_EXPO_DATE (게시물예정일자) — NUMBER
- LINK_YN (링크여부) — CHAR (1 )
- ADOPT_REWARD (ADOPT보상) — NUMBER
- ADOPT_YN (ADOPT여부) — CHAR (1 )
- UNRECOM_CNT (비추천카운트) — NUMBER
- ETC_01 (기타01) — NVARCHAR2 (100)
- ETC_02 (기타02) — NVARCHAR2 (100)
- ETC_03 (기타03) — NVARCHAR2 (100)
- ETC_04 (기타04) — NVARCHAR2 (100)
- ETC_05 (기타05) — NVARCHAR2 (100)
- ETC_06 (기타06) — NVARCHAR2 (100)
- ATCL_PWD (게시물PWD) — VARCHAR2 (200)
- ATCL_ANON_USE_YN (게시물익명사용여부) — CHAR (1 )
- NOTI_ATCL_YN (공지게시여부) — CHAR (1 )
- ESS_LINK_YN (ESS링크여부) — CHAR (1 )
- … +1
BRD_ATCL_ATCH_FILE_MAP (게시물첨부파일매핑)
- ATCH_FILE_SEQ (첨부파일순번) — NUMBER (10) — Primary key — NOT NULL
- ATCL_SEQ (게시물순번) — NUMBER — Foreign key → BRD_ATCL.ATCL_SEQ — NOT NULL
- REG_DTIME (등록일시) — CHAR (14)
- REG_USR_KEY (등록사용자키) — NUMBER (10)
BRD_ATCL_CMT (게시물댓글)
- ATCL_CMT_SEQ (게시물댓글순번) — NUMBER (10) — Primary key — NOT NULL
- ATCL_SEQ (게시물순번) — NUMBER(10) — Foreign key → BRD_ATCL.ATCL_SEQ — NOT NULL
- USR_KEY (사용자키) — NUMBER (10)
- CMT_CONT (댓글내용) — NVARCHAR2 (1500)
- DEL_YN (삭제여부) — CHAR (1 )
- REG_DTIME (등록일시) — CHAR (14)
- REG_USR_KEY (등록사용자키) — NUMBER (10)
- MOD_DTIME (수정일시) — CHAR (14)
- MOD_USR_KEY (수정사용자키) — NUMBER (10)
- ATCL_STTS_CD (게시물상태코드) — RAW (2)
- PARNT_ATCL_CMT_SEQ (부모게시물댓글순번) — NUMBER (10)
BRD_ATCL_HIST (게시물이력)
- ATCL_HIST_SEQ (게시물이력순번) — NUMBER (10) — Primary key — NOT NULL
- ATCL_SEQ (게시물순번) — NUMBER(10) — Foreign key → BRD_ATCL.ATCL_SEQ — NOT NULL
- USR_KEY (사용자키) — NUMBER (10)
- ATCL_HIST_TYP (게시물이력타입) — VARCHAR2 (1)
- REG_DTIME (등록일시) — CHAR (14)
- REG_USR_KEY (등록사용자키) — NUMBER (10)
BRD_ATCL_HIT_USR (게시물조회자)
- USR_KEY (사용자키) — NUMBER (10) — Primary key — NOT NULL
- ATCL_SEQ (게시물순번) — NUMBER(10) — Foreign key → BRD_ATCL.ATCL_SEQ — NOT NULL
- LAST_HIT_DTIME (최종조회일시) — CHAR (14)
- REG_DTIME (등록일시) — CHAR (14)
- REG_USR_KEY (등록사용자키) — NUMBER (10)
BRD_ATCL_INTRST (게시물즐겨찾기)
- ATCL_SEQ (게시물순번2) — NUMBER(10) — Foreign key → BRD_ATCL.ATCL_SEQ — NOT NULL
- USR_KEY (사용자키) — NUMBER (10)
- INTRST_REG_DTIME (관심등록일자) — CHAR (14)
BRD_ATCL_RECOM_HIST (게시물추천이력)
- ATCL_SEQ (게시물순번2) — NUMBER(10) — Foreign key → BRD_ATCL.ATCL_SEQ — NOT NULL
- USR_KEY (사용자키) — NUMBER (10)
- RECOM_DTIME (게시물이력타입) — CHAR (14)
- REG_DTIME (등록일시) — CHAR (14)
- REG_USR_KEY (등록사용자키) — NUMBER (10)
- RECOM_YN (추천여부) — CHAR (1 )
BRD_CATE (게시판분류)
- CATE_SEQ (분류순번) — NUMBER (10) — Primary key — NOT NULL
- CATE_NM (분류명) — NVARCHAR2 (50)
- PARNT_CATE_SEQ (게시판메뉴구분) — NUMBER (10)
- CATE_LVL (부모분류순번) — NUMBER (3)
- BRD_YN (분류레벨) — CHAR (1 )
- BRD_SEQ (게시판여부) — NUMBER (10)
- REG_DTIME (게시판순번) — CHAR (14)
- REG_USR_KEY (조회순서) — NUMBER (10)
- MOD_DTIME (등록일시) — CHAR (14)
- MOD_USR_KEY (등록사용자키) — NUMBER (10)
- BRD_MENU_DIV (수정일시) — VARCHAR2(1)
- HIT_ORDER (수정사용자키) — NUMBER
BRD_CNFG (게시판설정)
- BRD_SEQ (게시판순번) — NUMBER (10) — Primary key — NOT NULL
- BRD_ID (게시판아이디) — VARCHAR2 (30)
- CORP_SEQ (회사순번) — NUMBER (10)
- DEPT_SEQ (부서순번) — NUMBER (10)
- USR_KEY (사용자키) — NUMBER (10)
- WS_SEQ (워크스페이스순번) — NUMBER (10)
- BRD_TYP_CD (게시판타입코드) — VARCHAR2 (2)
- BRD_NM (게시판명) — NVARCHAR2 (50)
- BRD_DSCRT (게시판설명) — NVARCHAR2 (200)
- BSIC_BRD_YN (기본게시판여부) — CHAR (1)
- CMT_USE_YN (댓글사용여부) — CHAR (1)
- APPR_USE_YN (승인사용여부) — CHAR (1)
- RPLY_USE_YN (답글사용여부) — CHAR (1)
- RECOM_USE_YN (추천사용여부) — CHAR (1)
- VER_MGMT_USE_YN (버전관리사용여부) — CHAR (1)
- LOCK_USE_YN (락사용여부) — CHAR (1)
- USE_YN (사용여부) — CHAR (1)
- DEL_YN (삭제여부) — CHAR (1)
- REG_DTIME (등록일시) — CHAR (14)
- REG_USR_KEY (등록사용자키) — NUMBER (10)
- MOD_DTIME (수정일시) — CHAR (14)
- MOD_USR_KEY (수정사용자키) — NUMBER (10)
- ANON_USE_YN (익명사용여부) — CHAR (1)
- ATCL_CATE_CD_DIV (게시물분류코드구분) — VARCHAR2 (5)
- ATCL_STTS_CD_DIV (게시물상태코드구분) — VARCHAR2 (5)
- CNTS_TYP_CD (콘텐츠타입코드) — VARCHAR2 (30)
- ATCL_CATE_CD_DIV_2 (게시물분류코드구분2) — VARCHAR2 (5)
- RESER_POST_USE_YN (예약게시사용여부) — CHAR (1)
- CMNT_BRD_YN (커뮤니티게시판여부) — CHAR (1)
- POST_TERM_CD (게시기간코드) — VARCHAR2 (1)
- POST_TERM (게시기간) — NUMBER (3)
- BRD_WG_USE_YN (게시판위젯사용여부) — CHAR (1)
- NOTI_BRD_YN (공지게시판여부) — CHAR (1)
- UNRECOM_USE_YN (비추천사용여부) — CHAR (1)
- PUSH_USE_YN (푸시사용여부) — CHAR (1)
- MAIL_NOTI_YN (메일공지여부) — CHAR (1)
- SUB_ATCL_TIT_DIV (게시말머리제목구분) — VARCHAR2(5)
BRD_COL_CNFG (게시판컬럼설정)
- COL_ID (컬럼ID) — NVARCHAR2 (30)
- COL_NM (컬럼명) — NVARCHAR2 (50)
- COL_SIZE (컬럼사이즈) — NUMBER (5)
- COL_SORT (컬럼정렬) — VARCHAR2 (1)
- COL_ORDER (컬럼순서) — NUMBER (5)
- COL_TYP (컬럼타입) — VARCHAR2 (1)
- BRD_SEQ (게시판키) — NUMBER (10)
BRD_LIST_USR_CNFG (게시판순번사용자설정)
- BRD_SEQ (게시판순번) — NUMBER (10)
- USR_KEY (사용자키) — NUMBER (10)
BRD_USR_CNFG (게시판사용자설정)
- USR_KEY (사용자키) — NUMBER (10) — Primary key — NOT NULL
- UNSHOW_SHR_BRD (미표시공유게시판) — VARCHAR2 (500)
- REG_DTIME (등록일시) — CHAR (14)
- REG_USR_KEY (등록사용자키) — NUMBER (10)
- MOD_DTIME (수정일시) — CHAR (14)
- MOD_USR_KEY (수정사용자키) — NUMBER (10)