seniorJob

Tables (20)

BusinessPlanA

  • seq — number(10) — Primary key — NOT NULL
  • business_a — varchar2(4000)
  • business_b — varchar2(4000)
  • business_c — varchar2(4000)
  • ID — varchar2(20) — Foreign key → USERS.ID
  • collection — varchar2(4000)
  • title — varchar2(100)
  • mentor_id — varchar2(100)
  • writedate — date

BusinessPlanB

  • seq — number(10) — Foreign key → BusinessPlanA.seq — NOT NULL
  • prod_a — varchar2(4000)
  • prod_b — varchar2(4000)
  • prod_c — varchar2(4000)
  • bhidden — varchar2(25)
  • ID — varchar(20)

BusinessPlanC

  • seq — number(10) — Foreign key → BusinessPlanA.seq — NOT NULL
  • market_a — varchar2(4000)
  • market_b — varchar2(4000)
  • market_c — varchar2(4000)
  • market_d — varchar2(4000)
  • mhidden — varchar2(25)
  • ID — varchar2(20)

BusinessPlanD

  • seq — number(10) — Foreign key → BusinessPlanA.seq — NOT NULL
  • selling_a — varchar2(4000)
  • selling_b — varchar2(4000)
  • selling_c — varchar2(4000)
  • shidden — varchar2(25)
  • ID — varchar2(20)

Following

  • MENTOR_ID — VARCHAR2(20) — Foreign key → Mentor.MENTOR_ID — NOT NULL
  • ID — varchar2(20) — Foreign key → USERS.ID

Inquire

  • seq — number — Primary key — NOT NULL
  • category_a — varchar2(20)
  • category_b — varchar2(20)
  • w_date — date
  • click — number
  • content — clob
  • i_file — varchar2(100)
  • status — varchar2(20)
  • ID — varchar2(20) — Foreign key → USERS.ID
  • title — varchar2(100)

Inquiry_Answer

  • i_seq — number — Primary key — NOT NULL
  • seq — number — Foreign key → Inquire.seq — NOT NULL
  • title — varchar2(20)
  • content — clob
  • w_date — date
  • ID — varchar2(20) — Foreign key → USERS.ID
  • seq_ord — number

Mentor

  • MENTOR_ID — VARCHAR2(20) — Primary key — NOT NULL
  • MENTORING_KIND — VARCHAR2(50)
  • MENTOR_INTRODUCE — VARCHAR2(500)
  • MENTOR_CAREER — VARCHAR2(500)
  • MENTOR_PHOTO — VARCHAR2(50)
  • MENTOR_LICENSE — VARCHAR2(300)
  • MENTOR_CAREER_CERTIFICATE — VARCHAR2(300)
  • MENTOR_SCHOOL_NAME — VARCHAR2(20)
  • MENTOR_COMPANY_NAME — VARCHAR2(20)
  • MENTOR_DEPARTMENT_NAME — VARCHAR2(20)
  • MENTOR_JOB_ID — VARCHAR2(20)
  • MENTOR_DUTY — VARCHAR2(20)
  • ID — varchar2(20) — Foreign key → USERS.ID
  • MENTORING_AGE — VARCHAR2(10)
  • MENTORING_LOCATION — VARCHAR2(30)
  • MENTOR_CONFIRM_STATUS — VARCHAR2(20)
  • MENTOR_DATE — DATE
  • MENTOR_F_NUM — NUMBER

Mentoring

  • MENTORING_NUMBER — NUMBER — Primary key — NOT NULL
  • MENTORING_NAME — VARCHAR2(100)
  • MENTORING_LIMIT — NUMBER
  • MENTORING_INTRODUCE — VARCHAR2(1000)
  • MENTORING_PHOTO — VARCHAR2(50)
  • MENTORING_PRICE — NUMBER
  • MENTORING_DATA — VARCHAR2(100)
  • MENTOR_ID — VARCHAR2(20) — Foreign key → Mentor.MENTOR_ID — NOT NULL
  • MENTORING_END_DATE — DATE
  • MENTORING_BEGIN_DATE — DATE
  • MENTORING_CLICK — NUMBER
  • MENTORING_OPEN_DATE — DATE
  • MENTORING_KIND — VARCHAR2(20)
  • MENTORING_CONTENT — VARCHAR2(1000)

Mentoring_Reviews

  • seq — number — Primary key — NOT NULL
  • category_a — varchar2(20)
  • category_b — varchar2(20)
  • w_date — date
  • click — number
  • content — clob
  • r_file — varchar2(100)
  • ID — varchar2(20) — Foreign key → USERS.ID
  • MENTORING_NUMBER — NUMBER — Foreign key → Mentoring.MENTORING_NUMBER — NOT NULL
  • title — varchar2(100)

Resume

  • resume_no — number — Primary key — NOT NULL
  • resume_name — varchar2(10)
  • resume_birth — number
  • resume_email — varchar2(50)
  • resume_phone — varchar2(25)
  • resume_address — varchar2(100)
  • resume_school — varchar2(30)
  • resume_area — varchar2(20)
  • resume_start — date
  • resume_end — date
  • ID — varchar2(20) — Foreign key → USERS.ID
  • collection — varchar2(4000)
  • image — varchar2(100)
  • resume_title — varchar2(100)
  • resume_major — varchar2(100)

Schedule

  • seq — number(10) — Primary key — NOT NULL
  • schedule_name — varchar2(50)
  • schedule_con — varchar2(1000)
  • schedule_start — Date
  • schedule_end — Date
  • state — varchar2(20)
  • menteeId — varchar2(20) — Foreign key → USERS.ID
  • mentorId — varchar2(20) — Foreign key → USERS.ID
  • schedule_start_TIME — varchar2(20)
  • schedule_end_TIME — varchar2(20)

Service_Center

  • seq — number — Primary key — NOT NULL
  • category_a — varchar2(20)
  • category_b — varchar2(20)
  • w_date — date
  • click — number
  • content — clob
  • s_file — varchar2(100)
  • ID — varchar2(20) — Foreign key → USERS.ID
  • title — varchar2(100)

Shopping

  • shopping_no — number — Primary key — NOT NULL
  • ID — varchar2(20) — Foreign key → USERS.ID
  • MENTORING_NUMBER — NUMBER — Foreign key → Mentoring.MENTORING_NUMBER — NOT NULL
  • men_start — date
  • met_end — date
  • s_date — date
  • s_state — varchar2(20)
  • men_price — NUMBER

USERS

  • ID — varchar2(20)
  • password — varchar2(60)
  • address — varchar2(100) — (도로명)주소를 담는다(ex: 서울 강남구 가로수길 5)
  • phonenum — varchar2(20)
  • email — varchar2(40)
  • birth — varchar2(20)
  • auth — varchar2(20)
  • name — varchar2(20)
  • log_date — date
  • distinction — varchar2(50) — user와 kakao 사용자를 구별한다 소셜닉네임을 담음
  • postcode — varchar2(50) — 우편번호를 담는다(ex:06035)
  • detailaddress — varchar2(50) — 상세주소를 담는다(ex: 아파트의 경우 동,호수)
  • extraaddress — varchar2(50) — (주소)참고항목을 담는다(ex: 신사동)
  • accesstoken — varchar2(50)

cart

  • cart_no — number — Primary key — NOT NULL
  • mentoring_name — varchar2(100)
  • cart_start — date
  • cart_end — date
  • cart_price — number
  • ID — varchar2(20) — Foreign key → USERS.ID
  • mentor_id — varchar2(20)

certificate

  • certi_no — number — Primary key — NOT NULL
  • resume_no — number — Foreign key → Resume.resume_no — NOT NULL
  • certi_kinds — varchar2(50)
  • certi_name — varchar2(50)
  • certi_place — varchar2(50)
  • accept — varchar2(10)
  • certi_date — date

portfolio

  • port_no — number — Primary key — NOT NULL
  • resume_no — number — Foreign key → Resume.resume_no — NOT NULL
  • portfolio — varchar2(100)

self_info

  • self_no — number — Primary key — NOT NULL
  • resume_no — number — Foreign key → Resume.resume_no — NOT NULL
  • self_name — varchar2(100)
  • self_content — varchar2(4000)

usercerti

  • NO — NUMBER
  • CERTI_NAME — VARCHAR2(500)
  • CERTI_PLACE — VARCHAR2(500)
  • CERTI_NO — VARCHAR2(500)
  • CERTI_DATE — VARCHAR2(500)
  • CARRER_CERTI — VARCHAR2(500)
  • ID — varchar2(20) — Foreign key → USERS.ID