지식공유
테이블 (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)