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