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)