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)