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