DDOITJUN
Tables (32)
ACHIEVEMENT
- ACHIEVEMENT_NO — NUMBER
- TITLE — VARCHAR2(100 BYTE)
- ICON_PATH — VARCHAR2(200 BYTE)
- DESCRIPTION — VARCHAR2(500 BYTE)
- CREATED_DATE — DATE
ACHIEVEMENT_COMPLETION
- COMPLETION_NO — NUMBER
- MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO
- ACHIEVEMENT_NO — NUMBER — Foreign key → ACHIEVEMENT.ACHIEVEMENT_NO
- COMPLETION_DATE — DATE
- IS_COMPLETED — CHAR(1 BYTE)
ACHIEVEMENT_CONDITION
- CONDITION_NO — NUMBER
- ACHIEVEMENT_NO — NUMBER — Foreign key → ACHIEVEMENT.ACHIEVEMENT_NO
- CONDITION_TYPE — VARCHAR2(50 BYTE) — 조건유형
- TARGET_COUNT — NUMBER — 조건
- CREATED_DATE — DATE
ATTACHED_FILE
- FILE_NO — NUMBER
- FILE_TYPE — VARCHAR2(50 BYTE)
- ORIGINAL_FILENAME — VARCHAR2(200 BYTE) — 원래
- SAVED_FILENAME — VARCHAR2(200 BYTE) — 경로에
- FILE_SIZE — NUMBER
- PROFILE_NO — NUMBER
- POST_NO — NUMBER
- REPLY_NO — NUMBER
- COMMENT_NO — NUMBER
- UPLOAD_DATE — DATE
- MODIFIED_DATE — DATE
- FILE_PATH — VARCHAR2(200 BYTE) — 저장된
BOARD
- BOARD_NO — NUMBER
- BOARD_NAME — VARCHAR2(100 BYTE)
- BOARD_TYPE — VARCHAR2(50 BYTE)
- BOARD_STATUS — VARCHAR2(1 BYTE)
- CREATED_DATE — DATE — 생성일
- ADMIN_MEMBER_NO — NUMBER — 관리자번호
- PARENT_BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — 부모게시판번
- BOARD_CONTENT — VARCHAR2(2000 BYTE)
CALENDAR
- CALENDAR_NO — NUMBER
- CALENDAR_TITLE — VARCHAR2(200 BYTE)
- CALENDAR_MEMO — VARCHAR2(500 BYTE)
- CALENDAR_START — VARCHAR2(200 BYTE)
- CALENDAR_END — VARCHAR2(200 BYTE)
- CALENDAR_BACKGROUNDCOLOR — VARCHAR2(20 BYTE)
CERTIFICATION
- CERTIFICATION_NO — NUMBER — 자격증일정번호
- CERTIFICATION_NAME — VARCHAR2(200 BYTE) — 자격증이름
- INSTITUTION — VARCHAR2(200 BYTE) — 시행기관
- REGISTRATION_START_DATE — VARCHAR2(200 BYTE) — 접수시작일자
- REGISTRATION_END_DATE — VARCHAR2(200 BYTE) — 접수마감일자
- CREATED_AT — DATE — 자격증일정생성일
- CALENDARBACKGROUNDCOLOR — VARCHAR2(200 BYTE) — 달력색상
CHAT_MESSAGE
- MESSAGE_NO — NUMBER
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEM_NO
- CONTENT — VARCHAR2(4000 BYTE)
- CREATED_DATE — DATE
CLASSROOM
- CLASSROOM_NO — NUMBER
- CLASSROOM_NAME — VARCHAR2(50 BYTE)
- AVAILABLE_YN — CHAR(1 BYTE)
COMMENTS
- COMMENT_NO — NUMBER
- POST_NO — NUMBER — Foreign key → POST.POST_NO
- MEM_NO — NUMBER
- CONTENT — VARCHAR2(4000 BYTE)
- CREATED_DATE — DATE
- STATUS — CHAR(1 BYTE)
- REPLY_NO — NUMBER — Foreign key → REPLY.REPLY_NO
DBG_ACCEPTED
- POST_NO — NUMBER — Foreign key → POST.POST_NO
- ACCEPTED_REPLY_NO — NUMBER — Foreign key → REPLY.REPLY_NO
GIFT_PRODUCT
- GIFT_NO — NUMBER — 선물
- GIFT_MESSAGE — VARCHAR2(200 BYTE) — 선물과
- GIFT_DATE — DATE — 선물
INSTRUCTOR
- INSTRUCTOR_NO — NUMBER
- INSTRUCTOR_NAME — VARCHAR2(50 BYTE)
LECTURE_DETAIL
- DETAIL_NO — NUMBER
- TIMETABLE_NO — NUMBER
- COURSE_NAME — VARCHAR2(4000 BYTE) — 강의명
- DESCRIPTION — CLOB
- REG_DATE — DATE
- UPDATE_DATE — DATE
LECTURE_MEMO
- MEMO_NO — NUMBER
- TIMETABLE_NO — NUMBER
- MEMBER_NO — NUMBER
- MEMO_CONTENT — CLOB
- REG_DATE — DATE
- UPDATE_DATE — DATE
MEMBER
- MEM_NO — NUMBER
- MEM_NAME — VARCHAR2(100 BYTE)
- MEM_ID — VARCHAR2(100 BYTE)
- MEM_PASSWORD — VARCHAR2(100 BYTE)
- MEM_NICKNAME — VARCHAR2(100 BYTE)
- MEM_EMAIL — VARCHAR2(100 BYTE)
- MEM_PHONE — VARCHAR2(50 BYTE)
- COURSE_NAME — VARCHAR2(100 BYTE)
- POINTS — NUMBER
- MEM_TYPE — NUMBER
- MEM_JOIN_DATE — DATE
- COMPLETION_STATUS — VARCHAR2(1 BYTE)
- COURSE_SDATE — DATE
- COURSE_EDATE — DATE
- MEM_STATUS — VARCHAR2(1 BYTE)
ORDER_ITEM
- ORDER_NO — NUMBER — 구매
- ORDER_DATE — DATE — 상품
- MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — 구매한
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT.PRODUCT_NO — 구매한
- FINAL_PRICE — NUMBER — 최종결제금액
- USEYN — VARCHAR2(1 BYTE) — 사용여부
- ORDER_STATUS — VARCHAR2(1 BYTE) — 결제상태
OWNED_PRODUCT
- OWNED_NO — VARCHAR2(20 BYTE) — 보유
- PURCHASE_DATE — DATE — 상품
- USE_YN — CHAR(1 BYTE) — 상품
PLANNER
- PLANNER_NO — NUMBER — 플래너번호
- MEMBER_NO — NUMBER — Foreign key → MEMBER.MEM_NO — 플래너
- CREATED_DATE — DATE — 플래너
- TOTAL_STUDY_TIME — NUMBER — 누적
PLANNER_PLAN
- PLPLAN_NO — NUMBER — 학습
- PLANNER_NO — NUMBER — Foreign key → PLANNER.PLANNER_NO — 플래너번호
- SUBJECT_NO — NUMBER — Foreign key → STUDY_SUBJECT.SUBJECT_NO — 과목번호
- PLPLAN_DATE — DATE — 학습
- TARGET_STUDY_TIME — NUMBER — 목표
PLAN_DETAIL
- DETAIL_NO — NUMBER
- PLAN_NO — NUMBER
- PLAN_CONTENT — VARCHAR2(4000 BYTE)
- ACHIEVEMENT_STATUS — VARCHAR2(1 BYTE)
POINT_HISTORY
- POINT_HISTORY_NO — NUMBER — 포인트
- POINT_AMOUNT — NUMBER — 변동
- POINT_TYPE — CHAR(1 BYTE) — 포인트
- POINT_CONTENT — VARCHAR2(200 BYTE) — 포인트
- EXPIRE_DATE — DATE — 포인트
- CREATED_DATE — DATE — 포인트
POST
- POST_NO — NUMBER — 게시글번호
- BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — 게시판번호
- MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO
- POST_NAME — VARCHAR2(200 BYTE) — 게시글이름
- CONTENT — CLOB
- VIEW_COUNT — NUMBER — 조회수
- CREATED_DATE — DATE — 생성일
- EXPIRY_DATE — DATE — 만료일
- RECOMMEND — NUMBER
- MODIFIED_DATE — DATE — 수정일
- POST_STATUS — VARCHAR2(1 BYTE) — 상태(사용여부)
PRODUCT
- PRODUCT_NO — NUMBER — 상품
- PRODUCT_NAME — VARCHAR2(100 BYTE) — 상품
- PRODUCT_TYPE — NUMBER — 상품
- PRICE — NUMBER — 상품
- DESCRIPTION — VARCHAR2(4000 BYTE) — 상품
- PRODUCT_IMAGE — VARCHAR2(200 BYTE) — 상품
- PROD_STATUS — VARCHAR2(1 BYTE) — 상품
- REG_DATE — DATE — 상품
- UPDATE_DATE — DATE — 상품
PROFILE
- PROFILE_NO — NUMBER
- MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO
- INTRODUCTION — VARCHAR2(1000 BYTE)
- IMAGE — VARCHAR2(200 BYTE) — 프로필이미지
- ONLINE_STATUS — VARCHAR2(1 BYTE)
- ACHIEVEMENT_YN — VARCHAR2(1 BYTE)
- ACHIEVEMENT_CONDITION — VARCHAR2(200 BYTE)
- BACKGROUND_IMAGE — VARCHAR2(200 BYTE) — 배경이미지
- ICON_IMAGE — VARCHAR2(200 BYTE) — 아이콘이미지경로
RECOMMEND
- MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO
- POST_NO — NUMBER — Foreign key → POST.POST_NO
- RECOMMEND_DATE — DATE
REPLY
- POST_NO — NUMBER — Foreign key → POST.POST_NO — 상위
- BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — 게시판번호
- MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO — 작성자
- CONTENT — CLOB — 답글
- CREATED_DATE — DATE — 작성일
- MODIFIED_DATE — DATE — 수정일
- POST_STATUS — VARCHAR2(1 BYTE) — 상태
- REPLY_NO — NUMBER — 답글
- RECOMMEND — NUMBER — 추천
STUDY_SUBJECT
- SUBJECT_NO — NUMBER — 학습과목
- SUBJECT_TITLE — VARCHAR2(100 BYTE) — 학습과목명
- SUBJECT_DESCRIPTION — VARCHAR2(1000 BYTE) — 과목상세설명
- REG_DATE — DATE — 과목
- STATUS — VARCHAR2(1 BYTE) — 과목활성화상태
- SUBJECT_COLOR — VARCHAR2(100 BYTE) — 과목색상
STUDY_TIME_LOG
- LOG_NO — NUMBER — 학습
- STUDY_DATE — DATE — 학습
- STUDY_HOURS — NUMBER — 실제
- MEMO — VARCHAR2(1000 BYTE) — 학습
TAG_POST
- TAG_POST_NO — NUMBER
- REG_DATE — DATE
TIMETABLE
- TIMETABLE_NO — NUMBER — 시간표번호
- COURSE_NAME — VARCHAR2(200 BYTE) — 교육과정명
- LECTURE_NAME — VARCHAR2(200 BYTE) — 강의명
- INSTRUCTOR_NO — VARCHAR2(200 BYTE) — 강사번호
- CLASSROOM_NO — VARCHAR2(200 BYTE) — 강의실번호
- START_TIME — VARCHAR2(200 BYTE) — 수업시작시간
- END_TIME — VARCHAR2(200 BYTE) — 수업종료시간
- REG_DATE — DATE — 등록일
- UPDATE_DATE — DATE — 수정일
- TIMETABLECOLOR — VARCHAR2(200 BYTE) — 시간표색상
WISH
- MEM_NO — NUMBER — Foreign key → MEMBER.MEM_NO
- PRODUCT_NO — NUMBER — Foreign key → PRODUCT.PRODUCT_NO