MentorMan

Tables (23)

answer

  • Key (answer_seq) — NUMBER — Primary key — NOT NULL
  • Key (member_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • Key (mentor_seq) — NUMBER — Foreign key → mentor.Key — NOT NULL
  • Key (question_seq) — NUMBER — Foreign key → question.Key — NOT NULL
  • answer_content — CLOB — NOT NULL
  • answer_logtime — DATE

essayboard

  • Key (essayboard_seq) — NUMBER — Primary key — NOT NULL
  • Key (member_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • Key (job_code) — VARCHAR2(20) — Foreign key → job.Key — NOT NULL
  • essayboard_title — VARCHAR2(1000) — NOT NULL
  • essayboard_content — CLOB — NOT NULL
  • essayboard_hit — NUMBER
  • essayboard_scrap — NUMBER
  • essayboard_scrapFlag — NUMBER
  • essayboard_logtime — NUMBER

essayboardScrap

  • Key (essayboardScrap_es_seq) — NUMBER — Foreign key → essayboard.Key — NOT NULL
  • Key (essayboardScrap_mem_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • essatboardScrap_logtime — DATE

faq

  • Key (faq_seq) — NUMBER — Primary key — NOT NULL
  • Key (catalog_code) — VARCHAR2(100) — Foreign key → faq_catalog.Key — NOT NULL
  • faq_title — VARCHAR2(1000) — NOT NULL
  • faq_content — CLOB — NOT NULL

faq_catalog

  • Key (catalog_code) — VARCHAR2(100) — Primary key — NOT NULL
  • catalog_type — VARCHAR2(100)

guide

  • guide_content — VARCHAR2(1000)
  • logtime — DATE

job

  • Key (job_code) — VARCHAR2(20) — Primary key — NOT NULL
  • job_type — VARCHAR2(100) — NOT NULL

meeting_order

  • order_id — VARCHAR2(100)
  • order_date — DATE
  • order_price — NUMBER
  • order_flag — NUMBER
  • mentee_email — VARCHAR2(100)
  • mentee_name — VARCHAR2(50)
  • mentee_tel — VARCHAR2(50)
  • meetingboard_seq — NUMBER
  • participation_seq — NUMBER

meeting_participation

  • Key (participation_seq) — NUMBER — Primary key — NOT NULL
  • Key (meetingboard_seq) — NUMBER — Foreign key → meetingboard.Key — NOT NULL
  • Key (mentor_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • Key (mentee_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • mentor_name — VARCHAR2(50)
  • mentee_name — VARCHAR2(50)
  • participation_address — VARCHAR2(50)
  • participation_question — VARCHAR2(2000)
  • participation_state — NUMBER

meeting_review

  • Key (review_seq) — number — Primary key — NOT NULL
  • Key (meetingboard_seq) — NUMBER — Foreign key → meetingboard.Key — NOT NULL
  • Key (member_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • review_content — VARCHAR2(2000)
  • review_flag — NUMBER
  • review_date — DATE

meetingboard

  • Key (meetingboard_seq) — NUMBER — Primary key — NOT NULL
  • Key (mentor_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • Key (job_code) — VARCHAR2(20) — Foreign key → job.Key — NOT NULL
  • meetingboard_title — VARCHAR2(500)
  • meetingboard_subtitle — VARCHAR2(1000)
  • meetingboard_content — CLOB
  • meetingboard_day — VARCHAR2(50)
  • meetingboard_starthour — VARCHAR2(30)
  • meetingboard_endhour — VARCHAR2(30)
  • meetingboard_address — VARCHAR2(50)
  • meetingboard_buildingname — VARCHAR2(50)
  • meetingboard_address_x — VARCHAR2(50)
  • meetingboard_address_y — VARCHAR2(50)
  • meetingboard_count — NUMBER
  • meetingboard_host — VARCHAR2(50)
  • meetingboard_price — NUMBER
  • meetingboard_state — NUMBER

menteeboard

  • Key (menteeboard_seq) — NUMBER — Primary key — NOT NULL
  • Key (menteeboard_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • Key (job_code) — VARCHAR2(20) — Foreign key → job.Key — NOT NULL
  • menteeboard_title — VARCHAR2(255) — NOT NULL
  • menteeboard_content — CLOB — NOT NULL
  • menteeboard_good — NUMBER
  • menteeboard_ref — NUMBER — NOT NULL
  • menteeboard_lev — NUMBER — NOT NULL
  • menteeboard_step — NUMBER — NOT NULL
  • menteeboard_pseq — NUMBER — NOT NULL
  • menteeboard_reply — NUMBER — NOT NULL
  • menteeboard_hit — NUMBER
  • menteeboard_logtime — DATE

menteeboardLike

  • Key (menteeboardLike_mb_seq) — NUMBER — Foreign key → menteeboard.Key — NOT NULL
  • Key (menteeboardLike_mb_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • menteeboardLike_logtime — DATE

menteeboardReply

  • Key (menteeboardReply_seq) — NUMBER — Primary key — NOT NULL
  • Key (menteeboardReply_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • Key (menteeboardReply_mb_seq) — NUMBER — Foreign key → menteeboard.Key — NOT NULL
  • menteeboardReply_content — VARCHAR2(1000) — NOT NULL
  • menteeboardReply_ref — NUMBER — NOT NULL
  • menteeboardReply_lev — NUMBER — NOT NULL
  • menteeboardReply_step — NUMBER — NOT NULL
  • menteeboardReply_pseq — NUMBER — NOT NULL
  • menteeboardReply_logtime — DATE
  • Field (menteeboardReply_flag) — NUMBER

menteeemployee_profile (mentee_employee)

  • Key (menteeemployee_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • menteeemployee_school — VARCHAR2(1000)
  • menteeemployee_career — VARCHAR2(4000) — NOT NULL
  • menteeemployee_year — NUMBER — NOT NULL
  • menteeemployee_final — VARCHAR2(100) — NOT NULL
  • menteeemployee_etc — VARCHAR2(2000)

menteestudent_profile (mentee_student)

  • Key (menteestudent_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • menteestudent_school — VARCHAR2(1000)
  • menteestudent_major — VARCHAR2(500) — NOT NULL
  • menteestudent_state — VARCHAR2(100) — NOT NULL
  • menteestudent_grade — VARCHAR2(100)
  • menteestudent_spec — VARCHAR2(2000) — NOT NULL
  • menteestudent_etc — VARCHAR2(2000)

mentor

  • Key (mentor_seq) — NUMBER — Primary key — NOT NULL
  • Key (mentor_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • Key (job_code) — VARCHAR2(20) — Foreign key → job.Key — NOT NULL
  • mentor_company — VARCHAR2(100) — NOT NULL
  • mentor_department — VARCHAR2(100) — NOT NULL
  • mentor_position — VARCHAR2(100) — NOT NULL
  • mentor_school — VARCHAR2(100)
  • mentor_career — VARCHAR2(4000) — NOT NULL
  • mentoring_code — VARCHAR2(4000) — NOT NULL
  • mentor_represent — VARCHAR2(1000) — NOT NULL
  • mentor_info — CLOB — NOT NULL
  • mentor_etc — VARCHAR2(2000)
  • mentor_selectNaming — VARCHAR2(200) — NOT NULL
  • mentor_businesscard — VARCHAR2(2000) — NOT NULL
  • mentor_badge — NUMBER
  • mentor_flag — NUMBER
  • mentor_logtime — DATE

mentorFollow (mentor_follow)

  • Key (follower_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • Key (followed_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • mentorFollow_logtime — DATE

mentoring

  • Key (mentoring_code) — VARCHAR2(20) — Primary key — NOT NULL
  • mentoring_type — VARCHAR2(30) — NOT NULL

mentors_member (member)

  • Key (member_email) — VARCHAR2(100) — Primary key — NOT NULL
  • member_name — VARCHAR2(50) — NOT NULL
  • member_nickname — VARCHAR2(50) — NOT NULL
  • member_pwd — VARCHAR2(100) — NOT NULL
  • member_profile — VARCHAR2(200)
  • member_flag — NUMBER
  • member_seq — NUMBER
  • logtime — DATE
  • MEMBERAUTHKEY (memberauthkey) — VARCHAR2(100)
  • MEMBERAUTHSTATUS (memberauthstatus) — NUMBER

myAlarm

  • Key (myAlarm_seq) — NUMBER — Primary key — NOT NULL
  • Key (myAlarm_receiverEmail) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • myAlarm_callerNickname — VARCHAR2(40) — NOT NULL
  • myAlarm_title — VARCHAR2(150) — NOT NULL
  • myAlarm_content — VARCHAR2(2000) — NOT NULL
  • myAlarm_subscribeFlag — NUMBER — NOT NULL
  • myAlarm_logtime — DATE

noticeboard

  • Key (noticeboard_seq) — NUMBER — Primary key — NOT NULL
  • noticeboard_adminEmail — VARCHAR2(200) — NOT NULL
  • noticeboard_title — VARCHAR2(2000) — NOT NULL
  • noticeboard_content — CLOB — NOT NULL
  • noticeboard_hit — NUMBER
  • noticeboard_logtime — DATE

question

  • Key (question_seq) — NUMBER — Primary key — NOT NULL
  • Key (member_email) — VARCHAR2(100) — Foreign key → mentors_member.Key — NOT NULL
  • Key (mentor_seq) — NUMVER — Foreign key → mentor.Key — NOT NULL
  • question_title — CLOB — NOT NULL
  • question_content — CLOB — NOT NULL
  • question_flag — NUMBER
  • question_logtime — DATE