ITJOBGO
ITJOBGO ERD
테이블 (42)
IT소식 (it_news)
- news_sq — NUMBER — 기본 키 — NOT NULL
- news_division — CHAR(100 BYTE) — NOT NULL
- news_title — VARCHAR2(200 BYTE) — NOT NULL
- news_content — CLOB — NOT NULL
- news_ref_site — VARCHAR2(500 BYTE)
- news_date — DATE
- news_read_count — NUMBER
- member_num — NUMBER — 외래 키 → member.member_sq
IT소식 댓글 (itnews_comment)
- it_comment_no — NUMBER — 기본 키 — NOT NULL
- itnews_no — NUMBER — 외래 키 → IT소식.news_sq
- it_comment_content — VARCHAR2(1000 BYTE)
- member_sq — NUMBER — 외래 키 → member.member_sq — NOT NULL
- it_comment_date — VARCHAR2(100 BYTE)
- member_name — VARCHAR2(100 BYTE)
IT소식 첨부파일 (itnews_attachment)
- attachmentno — NUMBER — 기본 키 — NOT NULL
- board_sq — NUMBER — 외래 키 → IT소식.news_sq — NOT NULL
- originalfilename — VARCHAR2(2000 BYTE)
- renamedfilename — VARCHAR2(2000 BYTE)
- uploaddate — DATE
- status — CHAR(10 BYTE) — NOT NULL
member
- member_sq — NUMBER — 기본 키 — NOT NULL
- member_email — VARCHAR2(50 BYTE) — NOT NULL
- member_pwd — VARCHAR2(100 BYTE) — NOT NULL
- member_name — VARCHAR2(20 BYTE) — NOT NULL
- member_phone — VARCHAR2(20 BYTE) — NOT NULL
- member_level — VARCHAR2(2 BYTE)
- member_postcode — VARCHAR2(20 BYTE)
- member_addr — VARCHAR2(50 BYTE)
- member_addr_dtl — VARCHAR2(50 BYTE)
- member_addr_extra — VARCHAR2(50 BYTE)
- member_token — VARCHAR2(1000 BYTE)
- member_position — VARCHAR2(20 BYTE)
member_photo
- member_sq — NUMBER — 외래 키 → member.member_sq
- mem_photo_sq — NUMBER
- originalfilename — VARCHAR2(255 BYTE)
- renamedfilename — VARCHAR2(255 BYTE)
- uploaddate — DATE
qb_attachment
- attachmentno — NUMBER — 기본 키 — NOT NULL
- qboard_no — NUMBER — 외래 키 → qna_board.qboard_no — NOT NULL
- originalfilename — VARCHAR2(4000 BYTE)
- renamedfilename — VARCHAR2(4000 BYTE)
- uploaddate — DATE
- status — CHAR(20 BYTE) — NOT NULL
qb_comment
- qboard_comment_no — NUMBER — 기본 키 — NOT NULL
- qboard_no — NUMBER — 외래 키 → qna_board.qboard_no
- qb_comment_content — VARCHAR2(1000 BYTE)
- member_sq — NUMBER — 외래 키 → member.member_sq — NOT NULL
- qbcomment_date — VARCHAR2(100 BYTE)
- member_name — VARCHAR2(100 BYTE)
qna_board
- qboard_no — NUMBER — 기본 키 — NOT NULL
- qna_category — VARCHAR2(100 BYTE) — NOT NULL
- qna_title — VARCHAR2(80 BYTE) — NOT NULL
- qna_writer — VARCHAR2(40 BYTE)
- qna_content — VARCHAR2(4000 BYTE) — NOT NULL
- qna_answer_yn — VARCHAR2(40 BYTE) — NOT NULL
- qna_date — DATE
- member_num — NUMBER — NOT NULL
- board_count — NUMBER
ref_site
- ref_no — NUMBER — 기본 키 — NOT NULL
- ref_category — CHAR(100 BYTE) — NOT NULL
- ref_title — VARCHAR2(200 BYTE) — NOT NULL
- ref_content — CLOB — NOT NULL
- ref_site_addr — VARCHAR2(500 BYTE)
- ref_date — DATE
- ref_read_count — NUMBER
- member_num — NUMBER — 외래 키 → member.member_sq
- status — VARCHAR2(10 BYTE) — NOT NULL
ref_site_attachment
- attachmentno — NUMBER — 기본 키 — NOT NULL
- ref_no — NUMBER — 외래 키 → ref_site.ref_no — NOT NULL
- originalfilename — VARCHAR2(2000 BYTE)
- renamedfilename — VARCHAR2(2000 BYTE)
- uploaddate — DATE
- status — CHAR(10 BYTE) — NOT NULL
scrap
- job_no — VARCHAR2(20 BYTE) — 기본 키 — NOT NULL
- scrap_sq — NUMBER — NOT NULL
- member_sq — NUMBER — 외래 키 → member.member_sq — NOT NULL
- job_title — VARCHAR2(100 BYTE) — NOT NULL
- company — VARCHAR2(50 BYTE) — NOT NULL
- deadline — VARCHAR2(20 BYTE) — NOT NULL
- apply_method — VARCHAR2(50 BYTE) — NOT NULL
게시판 댓글 (rboard_comment) (CopyOfrboard_attachment)
- rboard_commentno (rboard_attachmentno) — NUMBER — 기본 키 — NOT NULL
- rboard_no — NUMBER — 외래 키 → 이력서 컨설팅 게시판 (rboard).rboard_no — NOT NULL
- rboard_comment_content (original_filename) — VARCHAR2(1000 BYTE) — NOT NULL
- rboard_comment_date (renamed_filename) — DATE — NOT NULL
- member_sq (upload_date) — NUMBER
- member_name (status) — VARCHAR2(20 BYTE)
경력사항(resume_work) (resume_work)
- resume_workno — NUMBER — 기본 키 — NOT NULL
- resume_no — NUMBER — 외래 키 → 이력서(resume).resume_no — NOT NULL
- work_start_date — DATE
- work_finish_date — DATE
- work_name — VARCHAR2(200 BYTE)
- work_level — VARCHAR2(100 BYTE)
- work_state — VARCHAR2(50 BYTE)
- work_detail — VARCHAR2(500 BYTE)
공지사항 (notice)
- notice_sq — NUMBER — 기본 키 — NOT NULL
- notice_division — CHAR(200 BYTE)
- notice_title — VARCHAR2(200 BYTE)
- notice_content — CLOB
- notice_date — DATE
- notice_read_count — NUMBER
- member_num — NUMBER — 외래 키 → member.member_sq
- notice_id — VARCHAR2(80 BYTE)
공지사항 댓글 (notice_comment)
- nt_comment_no — NUMBER — 기본 키 — NOT NULL
- nt_board_no — NUMBER — 외래 키 → 공지사항.notice_sq
- nt_comment_content — VARCHAR2(1000 BYTE)
- member_sq — NUMBER — 외래 키 → member.member_sq — NOT NULL
- nt_comment_date — VARCHAR2(100 BYTE)
- member_name — VARCHAR2(100 BYTE)
공지사항 첨부파일 (notice_attachment)
- attachmentno — NUMBER — 기본 키 — NOT NULL
- notice_sq — NUMBER — 외래 키 → 공지사항.notice_sq
- originalfilename — VARCHAR2(2000 BYTE)
- renamedfilename — VARCHAR2(2000 BYTE)
- uploaddate — DATE
- status — CHAR(10 BYTE)
대외활동(resume_activity) (resume_activity)
- resume_activityno — NUMBER — 기본 키 — NOT NULL
- resume_no — NUMBER — 외래 키 → 이력서(resume).resume_no — NOT NULL
- activity — VARCHAR2(100 BYTE)
- activity_start_date — DATE
- activity_finish_date — DATE
- activity_agency — VARCHAR2(200 BYTE)
- activity_work — VARCHAR2(500 BYTE)
- activity_detail — VARCHAR2(500 BYTE)
모임 인원 체크 테이블 (collab_count)
- collab_sq — NUMBER — 외래 키 → 모임테이블.collab_sq — NOT NULL
- collab_back — NUMBER
- collab_front — NUMBER
- collab_desgin — NUMBER
- back_count — NUMBER
- front_count — NUMBER
- desgin_count — NUMBER
모임이미지 첨부파일 (m_attachment)
- mattachmentno — NUMBER — 기본 키 — NOT NULL
- pboard_sq — NUMBER — 외래 키 → 모임테이블.collab_sq — NOT NULL
- originalfilename — VARCHAR2(255 BYTE) — NOT NULL
- renamedfilename — VARCHAR2(255 BYTE) — NOT NULL
- uploaddate — DATE
- status — VARCHAR2(1 BYTE)
모임테이블 (collab_board)
- collab_sq — NUMBER — 기본 키 — NOT NULL
- collab_title — VARCHAR2(50 BYTE)
- collab_content — VARCHAR2(2000 BYTE)
- collab_simcontent — VARCHAR2(500 BYTE)
- collab_writer — VARCHAR2(20 BYTE)
- collab_email — VARCHAR2(100 BYTE)
- collab_phone — VARCHAR2(100 BYTE)
- collab_upload_date — DATE
- collab_deadline — DATE
- collab_lang — VARCHAR2(500 BYTE)
- collab_back — NUMBER
- collab_front — NUMBER
- collab_desgin — NUMBER
- address — VARCHAR2(500 BYTE)
- rdate — DATE
- member_sq — NUMBER — 외래 키 → member.member_sq
- mkdate — DATE
신청완료 테이블 (application_complted)
- ac_number — NUMBER — 기본 키 — NOT NULL
- member_sq — NUMBER — 외래 키 → member.member_sq
- position — VARCHAR2(50 BYTE)
- complete_date — DATE
- collab_sq — NUMBER
- status — VARCHAR2(1 BYTE)
신청한 목록 (tmp_apply)
- tmp_no — NUMBER — 기본 키 — NOT NULL
- membersq — NUMBER — 외래 키 → member.member_sq
- postion — VARCHAR2(50 BYTE)
- tmp_date — DATE
- collab_sq — NUMBER — 외래 키 → 모임테이블.collab_sq
- writer_no — NUMBER
외국어(resume_language) (resume_language)
- resume_languageno — NUMBER — 기본 키 — NOT NULL
- resume_no — NUMBER — 외래 키 → 이력서(resume).resume_no — NOT NULL
- language_name — VARCHAR2(200 BYTE)
- language_level — VARCHAR2(100 BYTE)
- language_test — VARCHAR2(200 BYTE)
- language_score — VARCHAR2(100 BYTE)
- language_date — DATE
이력서 목록(resumelist) (resumelist)
- resumelist_no — NUMBER — 기본 키 — NOT NULL
- resume_no (resume_no2) — NUMBER — 외래 키 → 이력서(resume).resume_no — NOT NULL
- member_no — DATE — 외래 키 → member.member_sq — NOT NULL
- resumelist_title — VARCHAR2(50 BYTE) — NOT NULL
- resumelist_writer — VARCHAR2(20 BYTE) — NOT NULL
- resumelist_date — DATE
- resumelist_status — VARCHAR2(1 BYTE)
- resumelist_attachment — VARCHAR2(1 BYTE)
- resumelist_count — VARCHAR2(500 BYTE)
이력서 전문가 (consult) (CopyOfrboard2)
- consult_no (rboard_no) — NUMBER — 기본 키 — NOT NULL
- member_sq (rboard_id) — NUMBER — 외래 키 → member.member_sq — NOT NULL
- consult_name (rboard_title) — VARCHAR2(50 BYTE) — NOT NULL
- consult_field (rboard_content) — VARCHAR2(200 BYTE) — NOT NULL
- consult_work (rboard_writer) — VARCHAR2(200 BYTE) — NOT NULL
- consult_attachment (rboard_status) — VARCHAR2(1 BYTE)
- consult_approval (Field) — VARCHAR2(1 BYTE)
- consult_date (Field2) — DATE
이력서 전문가 첨부파일(consult_attachment) (CopyOfCopyOfrboard2)
- consult_attachmentno (rboard_no) — NUMBER — 기본 키 — NOT NULL
- consult_no (rboard_no2) — NUMBER — 외래 키 → 이력서 전문가 (consult).consult_no — NOT NULL
- original_filename (rboard_title) — VARCHAR2(255 BYTE) — NOT NULL
- renamed_filename (rboard_content) — VARCHAR2(255 BYTE) — NOT NULL
- upload_date (rboard_writer) — DATE — NOT NULL
- status (rboard_status) — VARCHAR2(1 BYTE)
이력서 첨부파일(rboard_attachment) (rboard_attachment)
- rboard_attachmentno — NUMBER — 기본 키 — NOT NULL
- rboard_no — NUMBER — 외래 키 → 이력서 컨설팅 게시판 (rboard).rboard_no — NOT NULL
- original_filename — VARCHAR2(255 BYTE) — NOT NULL
- renamed_filename — VARCHAR2(255 BYTE) — NOT NULL
- upload_date — DATE
- status — VARCHAR2(1 BYTE)
이력서 컨설팅 게시판 (rboard) (rboard)
- rboard_no — NUMBER — 기본 키 — NOT NULL
- rboard_id — NUMBER — 외래 키 → member.member_sq — NOT NULL
- rboard_title — VARCHAR2(50 BYTE) — NOT NULL
- rboard_content — VARCHAR2(2000 BYTE) — NOT NULL
- rboard_writer — VARCHAR2(20 BYTE) — NOT NULL
- rboard_date — DATE
- rboard_status — VARCHAR2(1 BYTE)
- rboard_count — VARCHAR2(500 BYTE)
이력서(resume) (resume)
- resume_no — NUMBER — 기본 키 — NOT NULL
- member_no — NUMBER — 외래 키 → member.member_sq — NOT NULL
- rname — VARCHAR2(50 BYTE) — NOT NULL
- eng_name — VARCHAR2(100 BYTE) — NOT NULL
- birth — DATE — NOT NULL
- gender — VARCHAR2(10 BYTE) — NOT NULL
- postcode — NUMBER — NOT NULL
- address — VARCHAR2(200 BYTE)
- address_detail — VARCHAR2(200 BYTE)
- telephone — VARCHAR2(100 BYTE)
- rphone — VARCHAR2(100 BYTE)
- remail — VARCHAR2(100 BYTE)
- rtitle — VARCHAR2(50 BYTE) — NOT NULL
- rdate — DATE
자격증(resume_license) (resume_license)
- resume_licenseno — NUMBER — 기본 키 — NOT NULL
- resume_no — NUMBER — 외래 키 → 이력서(resume).resume_no — NOT NULL
- license_name — VARCHAR2(300 BYTE)
- license_agency — VARCHAR2(300 BYTE)
- license_date — DATE
자유게시판 (community_board)
- board_sq — NUMBER — 기본 키 — NOT NULL
- board_division — CHAR(20 BYTE) — NOT NULL
- board_title — VARCHAR2(200 BYTE)
- board_content — CLOB — NOT NULL
- board_date — DATE
- member_num — NUMBER — 외래 키 → member.member_sq — NOT NULL
- board_writer — VARCHAR2(30 BYTE)
- board_count — NUMBER
- comment_count — NUMBER
자유게시판 댓글 (cb_comment)
- cb_comment_no — NUMBER — 기본 키 — NOT NULL
- cboard_no — NUMBER — 외래 키 → 자유게시판.board_sq
- cb_comment_content — VARCHAR2(1000 BYTE)
- member_sq — NUMBER — 외래 키 → member.member_sq — NOT NULL
- cb_comment_date — VARCHAR2(100 BYTE)
- member_name — VARCHAR2(100 BYTE)
자유게시판 첨부파일 (cb_attachment)
- attachmentno — NUMBER — 기본 키 — NOT NULL
- board_sq — NUMBER — 외래 키 → 자유게시판.board_sq — NOT NULL
- originalfilename — VARCHAR2(2000 BYTE)
- renamedfilename — VARCHAR2(2000 BYTE)
- uploaddate — DATE
- status — CHAR(10 BYTE) — NOT NULL
증명사진(resume_attachment) (resume_attachment)
- resume_attachmentno — NUMBER — 기본 키 — NOT NULL
- resume_no — NUMBER — 외래 키 → 이력서(resume).resume_no — NOT NULL
- original_filename — VARCHAR2(255 BYTE) — NOT NULL
- renamed_filename — VARCHAR2(255 BYTE) — NOT NULL
- upload_date — DATE
- status — VARCHAR2(1 BYTE)
첨부파일 (attachment)
- attachmentno — NUMBER — 기본 키 — NOT NULL
- pboard_no — NUMBER — 외래 키 → 포트폴리오테이블.pboard_no — NOT NULL
- originalfilename — VARCHAR2(255 BYTE) — NOT NULL
- renamedfilename — VARCHAR2(255 BYTE) — NOT NULL
- uploaddate — DATE
- status — VARCHAR2(1 BYTE)
취업정보 일정 (info)
- info_sq — NUMBER — 기본 키 — NOT NULL
- member_num — NUMBER — 외래 키 → member.member_sq — NOT NULL
- info_category — CHAR(200 BYTE) — NOT NULL
- info_title — VARCHAR2(200 BYTE)
- info_date — VARCHAR2(300 BYTE)
- info_time — VARCHAR2(300 BYTE)
- info_content — VARCHAR2(500 BYTE)
- info_count — VARCHAR2(500 BYTE)
취업정보 첨부파일 (info_attachment)
- attachmentno — NUMBER — 기본 키 — NOT NULL
- info_sq — NUMBER — 외래 키 → 취업정보 일정.info_sq — NOT NULL
- originalfilename — VARCHAR2(2000 BYTE)
- renamedfilename — VARCHAR2(2000 BYTE)
- uploaddate — DATE
- status — CHAR(10 BYTE) — NOT NULL
포트폴리오 답글 (pcomment)
- pcomment_no — NUMBER — 기본 키 — NOT NULL
- pboard_no — NUMBER — 외래 키 → 포트폴리오테이블.pboard_no
- pcomment_content — VARCHAR2(500 BYTE)
- member_sq — NUMBER — 외래 키 → member.member_sq
- pcomment_date — DATE
- member_name — VARCHAR2(50 BYTE)
포트폴리오테이블 (pboard)
- pboard_no — NUMBER — 기본 키 — NOT NULL
- pboard_id — NUMBER — 외래 키 → member.member_sq
- pboard_title — VARCHAR2(200 BYTE)
- pboard_content — VARCHAR2(2000 BYTE)
- pboard_writer — VARCHAR2(20 BYTE)
- pboard_date — DATE
- pboard_status — VARCHAR2(1 BYTE)
- pboard_count — NUMBER
- pboard_division — VARCHAR2(100 BYTE)
프로젝트(resume_project) (resume_project)
- resume_projectno — NUMBER — 기본 키 — NOT NULL
- resume_no — NUMBER — 외래 키 → 이력서(resume).resume_no — NOT NULL
- project_part — VARCHAR2(100 BYTE)
- project_start_date — DATE
- project_finish_date — DATE
- project_name — VARCHAR2(200 BYTE)
- project_work — VARCHAR2(300 BYTE)
- project_detail — VARCHAR2(500 BYTE)
학력사항(resume_school) (resume_school)
- resume_schoolno — NUMBER — 기본 키 — NOT NULL
- resume_no — NUMBER — 외래 키 → 이력서(resume).resume_no — NOT NULL
- school1 — VARCHAR2(50 BYTE)
- school_name1 — VARCHAR2(50 BYTE)
- school_start_date1 — DATE
- school_finish_date1 — DATE
- major1 — VARCHAR2(50 BYTE)
- education1 — VARCHAR2(50 BYTE)
- school2 — VARCHAR2(50 BYTE)
- school_name2 — VARCHAR2(50 BYTE)
- school_start_date2 — DATE
- school_finish_date2 — DATE
- major2 — VARCHAR2(50 BYTE)
- education2 — VARCHAR2(50 BYTE)
- Field
해외경험(resume_abroad) (resume_abroad)
- resume_abroadno — NUMBER — 기본 키 — NOT NULL
- resume_no — NUMBER — 외래 키 → 이력서(resume).resume_no — NOT NULL
- abroad — VARCHAR2(100 BYTE)
- abroad_start_date — DATE
- abroad_finish_date — DATE
- abroad_countury — VARCHAR2(200 BYTE)
- abroad_agency — VARCHAR2(200 BYTE)
- abroad_detail — VARCHAR2(500 BYTE)