JHTA-CODEPEOPLE

Tables (25)

Copy Of Untitled2 (instructor)

  • Key (instructor_no) — number — Primary key — NOT NULL
  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Field (instructor_summary) — varchar2 — NOT NULL
  • Field2 (instructor_description) — varchar2 — NOT NULL

Untitled (cart)

  • Key (cart_no) — number — Primary key — NOT NULL
  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Key (paid_lecture_no) — number(5) — Foreign key → paid_lecture.Key — NOT NULL
  • Field (create_date) — date — NOT NULL

Untitled (test_table)

  • Key — number — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

Untitled (free_lecture_grade)

  • Key (lecture_grade_no) — number(5) — Primary key — NOT NULL
  • Key (free_lecture_no) — number(5) — Foreign key → Untitled.Key — NOT NULL
  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Field (grade_coment) — varchar2 — NOT NULL
  • Field (grade_point) — number — NOT NULL
  • Field (grade_create_date) — date — NOT NULL

Untitled (paid_lecture_review)

  • Key (review_no) — number — Primary key — NOT NULL
  • user_no — number(5) — Foreign key → Untitled.user_no — NOT NULL
  • Key (paid_lecture_no) — number(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (comment) — varchar2
  • Field (create_date) — date — NOT NULL
  • Field (grade) — number — NOT NULL

Untitled (buy_lecture)

  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Key (paid_lecture_no) — number(5) — Foreign key → paid_lecture.Key — NOT NULL

Untitled (free_lecture_ schedule)

  • Key (lecture_schedule_no) — number(5) — Primary key — NOT NULL
  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Key (lecture_section_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (schedule_name) — varchar2 — NOT NULL
  • Field (schedule_start_date) — date — NOT NULL
  • Field2 (schedule_last_date) — date — NOT NULL

Untitled (free_lecture_coment_reply)

  • Key (coment_reply_no) — number(5) — Primary key — NOT NULL
  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Key (lecture_coment_no) — number(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (reply_contents) — varchar2 — NOT NULL
  • Field (reply_create_date) — date — NOT NULL

Untitled (free_lecture_coment)

  • Key (lecture_coment_no) — number(5) — Primary key — NOT NULL
  • Key (lecture_section_no) — number — Foreign key → Untitled.Key — NOT NULL
  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Field (coment_contents) — varchar2 — NOT NULL
  • Field2 (coment_like) — number — NOT NULL
  • Field (coment_create_date) — date — NOT NULL

Untitled (paid_lecture_question_reply)

  • Key (reply_no) — number — Primary key — NOT NULL
  • Key (question_no) — number — Foreign key → Untitled.Key — NOT NULL
  • user_no (writer_no) — number(5) — Foreign key → user.user_no — NOT NULL
  • user_no — number(5) — Foreign key → Untitled.user_no — NOT NULL
  • Field (reply_content) — varchar2 — NOT NULL

Untitled (lecture_history)

  • Key (no) — number — Primary key — NOT NULL
  • Key (paid_lecture_detail_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Key (instructor_no) — number — Foreign key → Untitled.Key — NOT NULL
  • user_no — number(5) — Foreign key → Untitled.user_no — NOT NULL
  • Field (pass) — char — NOT NULL

Untitled (paid_lecture_question)

  • Key (question_no) — number — Primary key — NOT NULL
  • Key (detail_no) — number — Foreign key → Untitled.Key — NOT NULL
  • user_no (buy_lecture_user_no) — number(5) — Foreign key → Untitled.user_no — NOT NULL
  • Field (title) — varchar2 — NOT NULL
  • Field (content) — varchar2 — NOT NULL
  • Field (create_date) — varchar2 — NOT NULL

Untitled (note)

  • Key (note_no) — number — Primary key — NOT NULL
  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Key (paid_lecture_detail_no) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar2 — NOT NULL
  • Field (content) — varcahr2

Untitled (paid_lecture_detail)

  • Key (detail_no) — number — Primary key — NOT NULL
  • Key (paid_lecture_no) — number(5) — Foreign key → paid_lecture.Key — NOT NULL
  • Key (instructor_no) — number — Foreign key → paid_lecture.Key — NOT NULL
  • Field (filepath) — varchar2 — NOT NULL
  • Field (section_no) — number — NOT NULL
  • Field (section_name) — varchar2 — NOT NULL
  • Field (lesson_no) — number — NOT NULL
  • Field (lesson_name) — varchar2 — NOT NULL
  • Field (lesson_length) — number — NOT NULL

Untitled (user_log)

  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Field (log_account) — varchar2(50)
  • Field2 (log_ip) — varchar2(20)
  • Field (log_create_date) — date — NOT NULL

Untitled (free_lecture_section)

  • Key (lecture_section_no) — number — Primary key — NOT NULL
  • Key (free_lecture_no) — number(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (section_title) — varchar2(999) — NOT NULL
  • Field (section_contents) — varchar2(3000) — NOT NULL
  • Field (section_count) — number(5) — NOT NULL
  • Field (section_views) — number — NOT NULL
  • Field2 (section_create_date) — date — NOT NULL

Untitled (free_lecture)

  • Key (free_lecture_no) — number(5) — Primary key — NOT NULL
  • Field2 (lecture_image) — varchar2(3000) — NOT NULL
  • Field (lecture_title) — varchar2(100) — NOT NULL
  • Field (lecture_contents) — varchar2(3000) — NOT NULL
  • Field2 (lecture_main_image) — varchar2(3000) — NOT NULL
  • Field (lecture_time) — number(999) — NOT NULL
  • Field (lecture_level) — varchar2(3000) — NOT NULL
  • Field (lecture_summary) — varchar2(3000) — NOT NULL

paid_lecture

  • Key (paid_lecture_no) — number(5) — Primary key — NOT NULL
  • Key (instructor_no) — number — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Field (lang) — varchar2 — NOT NULL
  • Field2 (title) — varchar2 — NOT NULL
  • Field3 (level) — varchar2 — NOT NULL
  • Field4 (specialized) — varchar2 — NOT NULL
  • Field (summary) — varchar2
  • Field2 (description) — varchar2
  • Field (price) — number — NOT NULL
  • Field (thumnail_path) — varchar2
  • Field (create_date) — date — NOT NULL
  • Field (likes) — number
  • Field (view_count) — number
  • Field (approve_status) — varchar2(1) — NOT NULL

user

  • user_no — number(5) — Primary key — NOT NULL
  • user_id — varchrar2 — NOT NULL
  • user_password — varchar2 — NOT NULL
  • user_email — varchar2 — NOT NULL
  • user_name — varchar2 — NOT NULL
  • 경험치 (user_exp) — number(8) — NOT NULL
  • Field6 (user_create_date) — date — NOT NULL

user_avatar

  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • user_thumbnail (avatar_image) — varchar2(100) — 널일경우 기본 사진
  • user_background (avatar_bg) — varchar2(100) — 배경사진
  • Field (avatar_nick)

user_follow

  • follower_no (follower) — number(5) — Foreign key → user_avatar.user_no — NOT NULL
  • following_no (following) — number(5) — Foreign key → user_avatar.user_no — NOT NULL
  • Field (follow_create_date) — date — NOT NULL

광고 (advertising_bar)

  • Key (ad_no) — number — Primary key — NOT NULL
  • Field (ad_name) — varchar2(200) — NOT NULL
  • Field (ad_img_path) — varchar2(500) — NOT NULL
  • Field (ad_type) — varchar2(20) — NOT NULL
  • Field (ad_status) — varchar2(1) — NOT NULL
  • Field (create_date) — date — NOT NULL

등록한 뱃지 (badge)

  • Key (badge_no) — Primary key — NOT NULL
  • Field (badge_name)
  • Field (badge_icon)
  • Field (badge_exp)

얻은뱃지 (user_badge)

  • user_no — number(5) — Foreign key → user.user_no — NOT NULL
  • Key (badge_no) — Foreign key → 등록한 뱃지.Key — NOT NULL
  • Field (user_badge_create_date)

채팅 (user_chat)

  • 보낸유저 (send_user) — number(5) — Foreign key → user.user_no — NOT NULL
  • 받는유저 (recv_user) — number(5) — Foreign key → user.user_no — NOT NULL
  • 내용 (chat_msg) — varchar2(500) — NOT NULL
  • 생성일 (chat_create_date) — date — NOT NULL