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