Ovcos
Tables (24)
BK_HISTORY
- FEED_NO — NUMBER — NOT NULL
- BK_HIST_ID — VARCHAR2(15) — NOT NULL
- BK_HIST_DATE — DATE
BOOKMARK
- BK_NO — NUMBER — NOT NULL
- BK_ID — VARCHAR2(15) — NOT NULL
- BK_DATE — DATE
- BK_STATUS — CHAR(1) — NOT NULL — CHECK( 'Y', 'N')
CHLG_COMMENT
- CHLG_CMN_NO — NUMBER — NOT NULL — CHLG_CMN_DATE` DATE NOT NUL
- CHLG_CMN_CNT — VARCHAR2(1500) — NOT NULL — 한글 500자 이내
- CHLG_CMN_RPR_NY — CHAR(1) — NOT NULL
- CHLG_CMN_RPR_DATE — DATE
- CHLG_CMN_DEL_NY — CHAR(1) — NOT NULL
- CHLG_CMN_ID — VARCHAR2(20) — NOT NULL
- CHLG_CMN_RPR_ID — VARCHAR2(20)
- MATCH_CHLG_NO — NUMBER — NOT NULL
CMN_HISTORY
- CMN_HIST_MENU — NUMBER — NOT NULL — 피드1/대회2/일반3
- CMN_HIST_NO — NUMBER — NOT NULL
- CMN_HIST_RPR_NY — CHAR(1) — NOT NULL
- CMN_HIST_NEW_NY — CHAR(1) — NOT NULL — 새로 달린 댓글이냐?
- CMN_HIST_NICK_NY — CHAR(1) — NOT NULL — 태그당했니?
- CMN_HIST_DATE — DATE — NOT NULL
CONTEST
- CNTS_NO — NUMBER — NOT NULL
- CNTS_NAME — VARCHAR2(60) — NOT NULL — 20글자 이내 한글
- CNTS_DATE — DATE — NOT NULL
- CNTS_URL — VARCHAR(100) — NOT NULL
- DEL_STATUS — CHAR(1) — NOT NULL — 변경
CONTEST_CHALLENGE
- CNTS_CHLG_NO — NUMBER — NOT NULL
- CNTS_CHLG_TITLE — VARCHAR2(60) — NOT NULL — 20글자 이내 한글
- ENROLL_DATE — DATE — NOT NULL
- CNTS_CHLG_DATE — DATE — NOT NULL
- CNTS_CHLG_MAX — NUMBER — NOT NULL
- RPR_STATUS — CHAR(1) — NOT NULL
- RPR_DATE — DATE
- DEL_STATUS — CHAR(1) — NOT NULL
- PRP_ID — VARCHAR2(20)
- CNTS_NO — NUMBER — NOT NULL
- CNTS_CHLG_ID — VARCHAR2(20) — NOT NULL — 등록자 아이디
CUT
- MEM_ID — VARCHAR(255) — NOT NULL
- CUT_ID — VARCHAR2(20) — NOT NULL
- CUT_STATUS — CHAR(1) — CHECK( 'Y', 'N')
ENTRY_LIST
- CHLG_NO_INLIST — NUMBER — NOT NULL
- CHLG_ENTRY_ID — VARCHAR2(20) — NOT NULL
FEED
- FEED_INDEX — NUMBER — NOT NULL
- FEED_DATE — DATE — NOT NULL
- FEED_TITLE — VARCHAR2(60) — NOT NULL — 수정
- FEED_CNT — VARCHAR2(1500) — NOT NULL — 수정
- FEED_EVAL — NUMBER — NOT NULL — 수정
- FEED_PUBLIC_TYPE — CHAR(20) — NOT NULL — 수정 CHECKED (전체/친구/비공개)
- FEED_PAHT_NY — CHAR(1) — NOT NULL — CHECKED
- FEED_RPR_NY — CHAR(1) — NOT NULL — CHECKED
- FEED_RPR_DATE — DATE
- DISTANCE — NUMBER
- START_LAT — NUMBER
- START_LON — NUMBER
- FEED_DEL_NY — CHAR(1) — NOT NULL — 삭제 요청상태 CHECKED
- MEM_ID — VARCHAR2(20) — NOT NULL
- HIT — NUMBER — NOT NULL — 조회수
- FEED_RPR_ID — VARCHAR2(20)
FEED_COMMENTS
- FEED_CMN_NO — NUMBER — NOT NULL
- FEED_CMN_ID — VARCHAR2(15) — NOT NULL
- FEED_CMN_DATE — DATE — NOT NULL
- FEED_CMN_CNT — VARCHAR2(300) — NOT NULL
- FEED_CMN_RPR — CHAR(1) — NOT NULL
- FEED_CMN_RPR_DATE — DATE
- FEED_CMN_DEL_NY — CHAR(1) — NOT NULL
- FEED_INDEX — NUMBER — NOT NULL
FOLLOW
- MEM_ID — VARCHAR(255) — NOT NULL
- FLW_ID — VARCHAR2(20) — NOT NULL
- FLW_DATE — DATE
- FLW_STATUS — CHAR(1) — CHECK( 'Y', 'N')
FOLLOW_HISTORY
- MEM_ID — VARCHAR2(20) — NOT NULL
- FLW_ED_NY — CHAR(1) — NOT NULL
- FLW_DATE — DATE — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
FOLLOW_REQUEST
- MEM_ID — VARCHAR(255) — NOT NULL
- SEND_ID — VARCHAR(20)
- RESPONSE_ID — VARCHAR(2)
- REQUEST_STATUS — CHAR(1) — CHECK( 'Y', 'N')
GENERAL_HISTORY
- GEN_HIST_MENU — NUMBER — NOT NULL — 피드1/대회2/일반3
- GEN_HIST_NO — NUMBER — NOT NULL — 피드 또는 그룹 고유번호
- GEN_HIST_RPR_NY — CHAR(1) — NOT NULL
- GEN_HIST_DATE — DATE — NOT NULL — 신고들어온시간
GPX_FILES
- GPX_NO — NUMBER — NOT NULL
- FEED_INDEX — NUMBER — NOT NULL
- ORIGIN_NAME — VARCHAR2(255) — NOT NULL
- CHANGE_NAME — VARCHAR2(255) — NOT NULL
- FILE_PATH — VARCHAR2(1000) — NOT NULL
- UPLOAD_DATE — DATE — NOT NULL
- STATUS — CHAR(1) — NOT NULL — Y/N
INQUIRY
- INQ_NO — NUMBER — NOT NULL
- INQ_MENU — NUMBER — NOT NULL — 피드1/탐색2/챌린지3/마이페이지4/기타5
- INQ_TITLE — VARCHAR2(60) — NOT NULL
- INQ_DATE — DATE — NOT NULL
- INQ_CNT — VARCHAR2(300) — NOT NULL
- ANS_CNT — VARCHAR2(300)
- INQ_DEL_NY — CHAR(1) — NOT NULL
- MEM_ID — VARCHAR(255) — NOT NULL — 문의작성자
LOCAL
- LOCAL_NO — NUMBER — NOT NULL
- LOCAL_NAME — VARCHAR2(15) — NOT NULL — 서울/부산/대구/인천/광주/대전/울산/세종/경기/강원/충북/충남/전북/전남/경북/경남/제주
MEMBER
- MEM_ID — VARCHAR(255) — NOT NULL
- MEM_PWD — VARCHAR2(20)
- MEM_NAME — VARCHAR2(15)
- MEM_NICK — VARCHAR2(24)
- MEM_INTRO — VARCHAR2(300)
- MEM_BIRTH — VARCHAR2(10)
- MEM_ADMIN_NY — CHAR(1) — CHECKED
- MEM_STATUS — VARCHAR2(12) — 탈퇴/회원/휴면/일시정지
- MEM_LOC_INFO — VARCHAR(255)
- MEM_PUBLIC_NY — CHAR(1) — CHECKED
- MEM_GOAL_DTN — NUMBER
- MEM_CODE_NY — CHAR(1) — CHECKED
- MEM_RPR_CUM — NUMBER
- MEM_API_TYPE — VARCHAR2(30) — 일반/ 카카오/네이버/구글
- MEM_API_TOKEN — VARCHAR2(50)
- MEM_EML — VARCHAR2(20)
NCHLG_COMMENT
- NCHLG_CMN_NO — NUMBER — NOT NULL — NCHLG_CMN_DATE` DATE NOT NUL
- NCHLG_CMN_CNT — VARCHAR2(1500) — NOT NULL — 한글 500자 이내
- NCHLG_CMN_RPR_NY — CHAR(1) — NOT NULL
- NCHLG_CMN_RPR_DATE — DATE
- NCHLG_CMN_DEL_NY — CHAR(1) — NOT NULL
- NCHLG_CMN_ID — VARCHAR2(20) — NOT NULL
- NCHLG_CMN_RPR_ID — VARCHAR2(20)
- MATCH_NCHLG_NO — NUMBER — NOT NULL
NENTRY_LIST
- NCHLG_NO_INLIST — NUMBER — NOT NULL
- NCHLG_ENTRY_ID — VARCHAR2(20) — NOT NULL
NORMAL_CHALLENGE
- NOR_CHLG_NO — NUMBER — NOT NULL
- NOR_CHLG_TITLE — VARCHAR2(60) — NOT NULL — 20글자 이내 한글
- ENROLL_DATE — DATE — NOT NULL
- NOR_CHLG_DATE — DATE — NOT NULL
- NOR_CHLG_MAX — NUMBER — NOT NULL
- RPR_STATUS — CHAR(1) — NOT NULL
- RPR_DATE — DATE
- DEL_STATUS — CHAR(1) — NOT NULL
- PRP_ID — VARCHAR2(20)
- NOR_CHLG_ID — VARCHAR2(20) — NOT NULL — 등록자 아이디
- NOR_CHLG_LOCAL — NUMBER — NOT NULL — LOCAL_NO
NOTICE
- NTC_NO — NUMBER — NOT NULL
- NTC_TITLE — VARCHAR2(90) — NOT NULL — 30자 이내 한글
- NTC_CNT — VARCHAR2(4000) — NOT NULL
- NTC_DATE — DATE — NOT NULL
- NTC_WRITER — VARCHAR2(20) — NOT NULL
- NTC_COUNT — NUMBER — NOT NULL
- NTC_DEL_NY — CHAR(1) — NOT NULL
UPLOAD
- UPL_ID — VARCHAR2(20) — NOT NULL
- UPL_MENU — NUMBER — NOT NULL — 대회1/챌린지2/프로필3/배경4
- UPL_NO — NUMBER — 3,4의 경우 NULL
- ORIGIN_NAME — VARCHAR2(60) — NOT NULL
- CHANGE_NAME — VARCHAR2(60) — NOT NULL
- VER_STATUS — CHAR(1) — NOT NULL — 부적절한 이미지 컷하기
- DEL_STATUS — CHAR(1) — 삭제여부
WITHDRAWAL
- WTH_NO — NUMBER — NOT NULL
- WTH_ID — VARCHAR2(20) — NOT NULL
- WTH_RSN — VARCHAR2(150) — 한글 50자 이내
- WTH_DATE — DATE — NOT NULL