ant

Tables (51)

blog_comments

  • comment_no — NUMBER — Primary key — NOT NULL
  • content — VARCHAR2(100) — NOT NULL
  • create_date — VARCHAR2(15)
  • blog_no — NUMBER
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

blog_folder

  • folder_no — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(15)
  • folder_name — VARCHAR2(15)
  • blog_no — NUMBER

blog_follows

  • follow_no — NUMBER — Primary key — NOT NULL
  • follow_status — NUMBER
  • follow_content — VARCHAR2(15)
  • follower — VARCHAR2(15) — NOT NULL
  • following — VARCHAR2(15) — NOT NULL

blog_likes

  • blog_no — NUMBER — Foreign key → blogs.blog_no — NOT NULL
  • member_id — VARCHAR2(15)

blog_tags

  • tag_no — NUMBER — Primary key — NOT NULL
  • tag_name — VARCHAR2(10) — NOT NULL
  • blog_no — NUMBER

blogs

  • blog_no — NUMBER — Primary key — NOT NULL
  • title — VARCHAR2(15) — NOT NULL
  • content — VARCHAR2(1000) — NOT NULL
  • folder_no — NUMBER
  • tag_no — NUMBER
  • thumbnail — VARCHAR2(100)
  • create_date — DATE
  • hits — NUMBER
  • read_status — VARCHAR2(10)
  • comment_set — VARCHAR2(10)
  • bookmark — NUMBER
  • likes — NUMBER
  • member_id — VARCHAR2(15) — NOT NULL

boards

  • board_no — INT — Primary key — NOT NULL
  • title — VARCHAR2(50)
  • content — VARCHAR2(200)
  • reg_date — DATE
  • count — INT
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

bookmark_folder

  • bookmark_no — NUMBER — Primary key — NOT NULL
  • book_name — VARCHAR2(10)
  • blog_no — NUMBER
  • member_id — VARCHAR2(15)

career

  • career_no — NUMBER — Primary key — NOT NULL
  • dept — VARCHAR2(15)
  • company — VARCHAR2(15)
  • position — VARCHAR2(15)
  • job_type — VARCHAR2(15)
  • job_period — VARCHAR2(15)
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

carts

  • cart_no — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(15)
  • lecture_no — NUMBER
  • lecture_title — VARCHAR2(50)

certifications

  • certi_no — NUMBER — Primary key — NOT NULL
  • certi_name — VARCHAR2(15)
  • score — VARCHAR2(15)
  • institution — VARCHAR2(15)
  • acq_date — DATE
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

curriculums

  • curr_no — NUMBER — Primary key — NOT NULL
  • lecture_no — NUMBER
  • lecture_title — VARCHAR2(50)
  • curr_name — VARCHAR2(50)
  • video_src — VARCHAR2(100)

educations

  • edu_no — NUMBER — Primary key — NOT NULL
  • edu_status — VARCHAR2(15)
  • edu_period — VARCHAR2(15)
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

ent_likes

  • ent_like_no — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(15) — NOT NULL
  • ent_no — NUMBER — NOT NULL

ent_reviews

  • ent_review_no — NUMBER — Primary key — NOT NULL
  • ent_no — NUMBER — Foreign key → enterprises.ent_no — NOT NULL
  • category — VARCHAR2(5) — NOT NULL
  • career — VARCHAR2(10) — NOT NULL
  • grade — NUMBER — NOT NULL
  • content — VARCHAR2(200) — NOT NULL
  • advantage — VARCHAR2(200) — NOT NULL
  • disadvantage — VARCHAR2(200) — NOT NULL
  • salary_grade — NUMBER — NOT NULL
  • wlb_grade — NUMBER — NOT NULL
  • atmosphere — NUMBER — NOT NULL
  • potential — NUMBER — NOT NULL
  • about_ceo — VARCHAR2(5) — NOT NULL
  • recommend — VARCHAR2(5) — NOT NULL
  • reg_date — DATE
  • writer — VARCHAR2(15) — NOT NULL

ent_skills

  • ent_skill_no — NUMBER — Primary key — NOT NULL
  • tech — VARCHAR2(20) — NOT NULL
  • ent_no — NUMBER — Foreign key → enterprises.ent_no — NOT NULL

enterprises

  • ent_no — NUMBER — Primary key — NOT NULL
  • name — VARCHAR2(10) — NOT NULL
  • job_type — VARCHAR2(30) — NOT NULL
  • size — VARCHAR2(10) — NOT NULL
  • emp_size — NUMBER
  • est_date — DATE
  • ceo — VARCHAR2(10)
  • sales — NUMBER
  • addr — VARCHAR2(100)
  • url — VARCHAR2(100)
  • introduce — VARCHAR2(2000) — NOT NULL

inquiry

  • inquiry_no — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(15)
  • content — VARCHAR2(500)
  • reg_date — DATE
  • answer — VARCHAR2(500)
  • status — VARCHAR2(10)

interview_question

  • int_question_no — NUMBER — Primary key — NOT NULL
  • question — VARCHAR2(30) — NOT NULL
  • int_review_no — NUMBER — NOT NULL

interview_reviews

  • int_review_no — NUMBER — Primary key — NOT NULL
  • ent_no — NUMBER — NOT NULL
  • difficulty — NUMBER — NOT NULL
  • content — VARCHAR2(200) — NOT NULL
  • atmosphere — VARCHAR2(5) — NOT NULL
  • result — VARCHAR2(5) — NOT NULL
  • reg_date — DATE — NOT NULL
  • writer — VARCHAR2(15) — NOT NULL

introduction

  • intro_no — NUMBER — Primary key — NOT NULL
  • introduction — VARCHAR2(1000)
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

languages

  • lan_no — NUMBER — Primary key — NOT NULL
  • language — VARCHAR2(15)
  • level — VARCHAR2(15)
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

lecture_answer

  • answer_no — CHAR(18) — Primary key — NOT NULL
  • qna_no — NUMBER
  • content — VARCHAR2(2000)
  • writer — VARCHAR2(15)
  • reg_date — DATE

lecture_qna

  • qna_no — NUMBER — Primary key — NOT NULL
  • curr_no — NUMBER
  • curr_name — VARCHAR2(50)
  • title — VARCHAR2(100)
  • content — VARCHAR2(2000)
  • writer — VARCHAR2(15)
  • reg_date — DATE
  • status — VARCHAR2(10)
  • lecture_name — VARCHAR2(50)

lecture_reqs

  • req_no — CHAR(18) — Primary key — NOT NULL
  • member_id — CHAR(18)
  • lecture_no — NUMBER
  • status — CHAR(18)
  • curr_no — CHAR(18)

lecture_review

  • review_no — NUMBER — Primary key — NOT NULL
  • lecture_no — NUMBER
  • content — VARCHAR2(2000)
  • rate — NUMBER
  • writer — VARCHAR2(50)
  • reg_date — DATE

lecture_skills

  • skill_no — NUMBER — Primary key — NOT NULL
  • name — VARCHAR2(10)
  • lecture_no — NUMBER

lectures

  • lecture_no — NUMBER — Primary key — NOT NULL
  • title — VARCHAR2(50) — NOT NULL
  • professor — VARCHAR2(10) — NOT NULL
  • introduce — VARCHAR2(1000) — NOT NULL
  • reg_date — DATE
  • category — VARCHAR2(20)
  • price — NUMBER — NOT NULL
  • rate — NUMBER
  • student — NUMBER
  • difficulty — VARCHAR2(5)

master_req

  • req_no — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(15)
  • content — VARCHAR2(500)
  • file — VARCHAR2(100)
  • status — VARCHAR2(5)

members

  • memeber_id — VARCHAR2(15) — Primary key — NOT NULL
  • password — VARCHAR2(16) — NOT NULL
  • NAVER — VARCHAR2(30)
  • KAKAO — VARCHAR2(30)
  • GOOGLE — VARCHAR2(30)
  • email — VARCHAR2(25)
  • phone — VARCHAR2(15)
  • grade — VARCHAR2(15)
  • profile — VARCHAR2(100)
  • status — VARCHAR2(15)
  • name — VARCHAR2(15)
  • address — VARCHAR2(30)
  • address_d — VARCHAR2(30)
  • company_no — NUMBER
  • company_name — VARCHAR2(30)

mentorCons

  • mentorCons_no — INT — Primary key — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • yn — INT
  • member_id — VARCHAR2(15)
  • mentor_no — INT

mentorPays

  • pay_no — INT — Primary key — NOT NULL
  • kind — VARCHAR2(20)
  • bank — VARCHAR2(20)
  • pay_date — DATE
  • approval — INT
  • mentorCons_no — INT
  • total — INT
  • date_count — INT

mentorReps

  • mentorRep_no — INT — Primary key — NOT NULL
  • member_id — VARCHAR2(15) — NOT NULL
  • content — VARCHAR2(200)
  • reg_date — DATE
  • score — INT
  • mentor_no — INT

mentors

  • mentor_no — INT — Primary key — NOT NULL
  • title — VARCHAR2(50)
  • content — VARCHAR2(200)
  • category — VARCHAR2(20)
  • open — INT
  • reg_date — DATE
  • count — INT
  • price — VARCHAR2(20)
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

messages

  • no — NUMBER — Primary key — NOT NULL
  • send_id — VARCHAR2(15)
  • recv_id — VARCHAR2(15)
  • content — VARCHAR2(300)
  • sent_date — DATE
  • read_date — DATE
  • read_unread — VARCHAR2(15)

my_lectures

  • my_lecture_no — NUMBER — Primary key — NOT NULL
  • lecture_no — NUMBER
  • lecture_name — VARCHAR2(50)
  • latest_lecture — NUMBER
  • time — VARCHAR2(20)

notification

  • noti_no — NUMBER — Primary key — NOT NULL
  • noti_code — VARCHAR2(5)
  • member_id — VARCHAR2(15)
  • post_no — NUMBER
  • post_code — VARCHAR2(5)

payments

  • payment_no — NUMBER — Primary key — NOT NULL
  • member_id — NUMBER
  • lecture_no — NUMBER
  • lecture_name — VARCHAR2(50)
  • payment_date — DATE

projectCons

  • projectCons_no — INT — Primary key — NOT NULL
  • yn — INT
  • member_id — VARCHAR2(15)
  • project_id — VARCHAR2(20)

projectReps

  • projectRep_no — INT — Primary key — NOT NULL
  • member_id — VARCHAR2(15) — NOT NULL
  • content — VARCHAR2(200)
  • reg_date — DATE
  • project_id — VARCHAR2(20)

projects

  • project_id — VARCHAR2(20) — Primary key — NOT NULL
  • project_no — INT
  • content — VARCHAR2(200)
  • category — VARCHAR2(20)
  • open — INT
  • human — INT
  • how — VARCHAR2(20)
  • start_date — DATE
  • end_date — DATE
  • reg_date — DATE
  • count — INT
  • project_blog — VARCHAR2(20)
  • img — VARCHAR2(100)
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

qnaReps

  • qnaRep_no — INT — Primary key — NOT NULL
  • member_id — VARCHAR2(15) — NOT NULL
  • content — VARCHAR2(200)
  • reg_date — DATE
  • choice — INT
  • qna_no — INT

qna_like

  • like_no — NUMBER — Primary key — NOT NULL
  • qna_no — NUMBER
  • member_id — VARCHAR2(15)

qnas

  • qna_no — INT — Primary key — NOT NULL
  • title — VARCHAR2(50)
  • content — VARCHAR2(200)
  • reg_date — DATE
  • count — INT
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL

recruit

  • recruit_no — NUMBER — Primary key — NOT NULL
  • ent_no — NUMBER — NOT NULL
  • titile — VARCHAR2(20) — NOT NULL
  • end_date — DATE
  • job_type — VARCHAR2(20)
  • career — VARCHAR2(20)
  • emp_type — VARCHAR2(20)
  • salary — VARCHAR2(20)
  • skill — VARCHAR2(100)
  • introduce — VARCHAR2(1000)
  • job_datail — VARCHAR2(1000)
  • advantage — VARCHAR2(1000)
  • etc — VARCHAR2(1000)
  • contact — VARCHAR2(200)
  • reg_date — DATE

recruit_history

  • history_no — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(15) — NOT NULL
  • recruit_no — NUMBER — NOT NULL
  • status — VARCHAR2(5) — NOT NULL

recruit_likes

  • recruit_like_no — NUMBER — Primary key — NOT NULL
  • recruit_no — NUMBER — NOT NULL
  • member_id — VARCHAR2(15) — NOT NULL

rep

  • rep_no — INT — Primary key — NOT NULL
  • member_id — VARCHAR2(15) — NOT NULL
  • content — VARCHAR2(200)
  • reg_date — DATE
  • board_no — INT

reports

  • report_no — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(15)
  • content — VARCHAR2(1000)
  • post_no — NUMBER
  • post_code — VARCHAR2(5)
  • result — VARCHAR2(5)

studyReps

  • studyRep_no — INT — Primary key — NOT NULL
  • member_id — VARCHAR2(15)
  • content — VARCHAR2(200)
  • reg_date — DATE
  • study_no — INT

studys

  • study_no — INT — Primary key — NOT NULL
  • title — VARCHAR2(50)
  • content — VARCHAR2(200)
  • category — VARCHAR2(20)
  • open — INT
  • reg_date — DATE
  • count — INT
  • memeber_id — VARCHAR2(15) — Foreign key → members.memeber_id — NOT NULL