지식공유

테이블 (7)

내 정보 히스토리 (CopyOf1.3)

  • HISTORY_SEQ (Key) — VARCHAR(10) — 기본 키 — NOT NULL
  • USERID (Field13) — VARCHAR(10)
  • STATUS (Field14) — CHAR
  • TOTAL_PTS (Field1) — NUMBER
  • REMAIN_PTS (Field2) — NUMBER
  • TOTAL_MILES (Field3) — NUMBER
  • REMAIN_MILES (Field4) — NUMBER
  • REWARDS_CNT (Field5) — NUMBER
  • TOTAL_REWARDS (Field6) — NUMBER
  • VACATION_CNT (Field7) — NUMBER
  • TOTAL_VACATION_REWARDS (Field8) — NUMBER
  • SH_POST_CNT (Field9) — NUMBER
  • SH_COMMENT_CNT (Field10) — NUMBER
  • IN_POST_CNT (Field11) — NUMBER
  • IN_COMMENT_CNT (Field12) — NUMBER

임시 저장 테이블 (Untitled)

  • USERID (Key) — 기본 키 — NOT NULL
  • TYPE (Field4) — CHAR
  • DATA (Field) — TEXT

조회수 중복 체크 (CopyOfUntitled2)

  • VIEW_SEQ (Key) — 기본 키 — NOT NULL
  • USERID (Field2)
  • BOARD_SEQ (Field)
  • STATUS (Field4)

지식 글 댓글 목록 (.)

  • COMMENT_SEQ (Key3) — NUMBER — 기본 키 — NOT NULL
  • USERID (Field1) — VARCHAR(10)
  • BOARD_SEQ (Field7) — NUMBER
  • COMMENT_SEQ (Field8) — NUMBER
  • COMMENT_CONTENT (Field5) — VARCHAR(10)
  • COMMENT_ADOPT_STATUS (Field4) — CHAR — dd
  • COMMENT_DEPTH (Field9) — NUMBER

지식 글 목록 (./)

  • BOARD_SEQ (Key3) — NUMBER — 기본 키 — NOT NULL
  • BOARD_TYPE (Key4) — CHAR — 기본 키 — NOT NULL
  • USERID (Field) — VARCHAR(10)
  • BOARD_TITLE (Field5) — VARCHAR(10)
  • BOARD_CONTENT (Field9) — TEXT
  • BOARD_COMMENT_CNT (Field3) — NUMBER
  • BOARD_FAV_CNT (Field8) — NUMBER
  • BOARD_KIND (Field2) — VARCHAR(10)
  • BOARD_ADOPT_STATUS (Field4) — CHAR
  • BOARD_VIEW (Field10) — NUMBER
  • BOARD_POINT (Field11)

지식 정보 내 상태 (1.3)

  • USERID (Key) — VARCHAR(10) — 기본 키 — NOT NULL
  • TOTAL_PTS (Field1) — NUMBER
  • REMAIN_PTS (Field2) — NUMBER
  • TOTAL_MILES (Field3) — NUMBER
  • REMAIN_MILES (Field4) — NUMBER
  • REWARDS_CNT (Field5) — NUMBER
  • TOTAL_REWARDS (Field6) — NUMBER
  • VACATION_CNT (Field7) — NUMBER
  • TOTAL_VACATION_REWARDS (Field8) — NUMBER
  • SH_POST_CNT (Field9) — NUMBER
  • SH_COMMENT_CNT (Field10) — NUMBER
  • IN_POST_CNT (Field11) — NUMBER
  • IN_COMMENT_CNT (Field12) — NUMBER
  • REGDT (Field15) — VARCHAR
  • REGEMPNO (Field13) — VARCHAR
  • REGIP (Field14) — VARCHAR
  • MODDT (Field16) — VARCHAR
  • MODEMPNO (Field17) — VARCHAR
  • MODIP (Field18) — VARCHAR

지식 정보 좋아요 (Untitled2)

  • LIKE_SEQ (Key) — 기본 키 — NOT NULL
  • USERID (Field2)
  • BOARD_SEQ (Field)
  • STATUS (Field4)