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