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