Job이로운생활

테이블 (9)

경력 (Career)

  • Article_ID (article_id) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id2) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id2) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id22) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id3) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id23) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id22) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id2222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Career_Name (career_name) — VARCHAR(20)
  • Career_Start_Term (career_start_term) — VARCHAR(20)
  • Career_End_Term (career_end_term) — VARCHAR(20)
  • Career_Retirement_Reason (career_retirement_reason) — VARCHAR(20)
  • Career_Department (career_department) — VARCHAR(20)
  • Career_Rank (career_rank) — VARCHAR(20)
  • Career_Duty (career_duty) — VARCHAR(20)
  • Career_Statement (career_statement) — TEXT

공고 (Recruitment)

  • User_ID (user_id) — INT — 외래 키 → 사용자.User_ID — NOT NULL
  • Article_ID (article_id) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id2) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id22) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id2) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id3) — INT — 외래 키 → 사용자.Article_ID — NOT NULL
  • User_ID (user_id23) — INT — 외래 키 → 사용자.User_ID — NOT NULL
  • User_ID (user_id223) — INT — 외래 키 → 사용자.User_ID — NOT NULL
  • Article_ID (article_id22) — INT — 외래 키 → 사용자.Article_ID — NOT NULL
  • User_ID (user_id2222) — INT — 외래 키 → 사용자.User_ID — NOT NULL
  • Recruitment_Image (recruitment_image) — IMAGE
  • Recruitment_Division (recruitment_division) — VARCHAR(20)
  • Recruitment_Title (recruitment_title) — VARCHAR(20)
  • Recruitment_Startdate (recruitment_startdate) — VARCHAR(20)
  • Recruitment_Deadline (recruitment_deadline) — VARCHAR(20)
  • Recruitment_Applicants (Field6)
  • Recruitment_Created_At (recruitment_created_at) — DATETIME
  • Recruitment_Updated_At (recruitment_updated_at) — DATETIME

사용자 (User)

  • User_ID (user_id) — INT — 기본 키 — NOT NULL
  • Article_ID (article_id) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id2) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id22) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id2) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_Flag (user_flag) — INT
  • Wallet_Addr (wallet_addr) — VARCHAR(20)
  • User_It (user_it) — INT
  • User_Electric (user_electric) — INT
  • User_Semiconductor (user_semiconductor) — INT
  • User_Design (user_design) — INT
  • User_Eng (user_eng) — INT
  • User_username (user_user_name) — VARCHAR(20)
  • User_Email (user_email) — VARCHAR(20)

어학 (Language)

  • Article_ID (article_id) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id2) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id2) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id22) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id3) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id23) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id22) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id2222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Language_Classification (language_classification) — VARCHAR(20)
  • Language_Name (language_name) — VARCHAR(20)
  • Language_Score (language_score) — VARCHAR(20)
  • Language_Date (language_date) — VARCHAR(20)

이력서 (Article)

  • Article_ID (article_id) — INT — 기본 키 — NOT NULL
  • User_ID (user_id) — INT — 외래 키 → 사용자.User_ID — NOT NULL
  • User_ID (user_id2) — INT — 외래 키 → 공고.User_ID — NOT NULL
  • Article_ID (article_id2) — INT — 외래 키 → 공고.Article_ID — NOT NULL
  • User_ID (user_id22) — INT — 외래 키 → 공고.User_ID — NOT NULL
  • Article_ID (article_id3) — INT — 외래 키 → 사용자.Article_ID — NOT NULL
  • User_ID (user_id23) — INT — 외래 키 → 사용자.User_ID — NOT NULL
  • User_ID (user_id222) — INT — 외래 키 → 사용자.User_ID — NOT NULL
  • Article_ID (article_id22) — INT — 외래 키 → 사용자.Article_ID — NOT NULL
  • User_ID (user_id2222) — INT — 외래 키 → 사용자.User_ID — NOT NULL
  • Article_Image (article_image) — IMAGE
  • Article_Name (article_name) — VARCHAR(20)
  • Article_Date_Of_Birth (article_date_of_birth) — VARCHAR(20)
  • Article_Email (article_email) — VARCHAR(20)
  • Article_Phone_Number (article_phone_number) — VARCHAR(20)
  • Article_Military_Classification (article_military_classification) — VARCHAR(20)
  • Article_Military_Branch (article_military_branch) — VARCHAR(20)
  • Article_Military_Rank (article_military_rank) — VARCHAR(20)
  • Article_Military_Completed (article_military_completed) — VARCHAR(20)
  • Article_Military_Completed_Reason (article_military_completed_reason) — VARCHAR(20)
  • Article_Military_Start (article_military_start) — VARCHAR(20)
  • Article_Military_End (article_military_end) — VARCHAR(20)
  • Article_Highschool_Name (article_highschool_name) — VARCHAR(20)
  • Article_Highschool_Classification (article_highschool_classification) — VARCHAR(20)
  • Article_Highschool_Location (article_highschool_location) — VARCHAR(20)
  • Article_Highschool_Entrance_Year (article_highschool_entrance_year) — VARCHAR(20)
  • Article_Highschool_Graduation_Year (article_highschool_graduation_year) — VARCHAR(20)
  • Article_College_Name (article_college_name) — VARCHAR(20)
  • Article_College_Classification (article_college_classificationc) — VARCHAR(20)
  • Article_College_Location (article_college_location) — VARCHAR(20)
  • Article_College_Entrance_Year (article_college_entrance_year) — VARCHAR(20)
  • Article_College_Graduation_Year (article_college_graduation_year) — VARCHAR(20)
  • Article_College_Major (article_college_major) — VARCHAR(20)
  • Article_College_Minor (article_college_minor) — VARCHAR(20)
  • Article_College_Grade (article_college_grade) — FLOAT
  • Article_College_Total (article_college_total) — FLOAT
  • Article_Master_Name (article_master_name) — VARCHAR(20)
  • Article_Master_Classification (article_master_classification) — VARCHAR(20)
  • Article_Master_Location (article_master_location) — VARCHAR(20)
  • Article_Master_Entrance_Year (article_master_entrance_year) — VARCHAR(20)
  • Article_Master_Graduation_Year (article_master_graduation_year) — VARCHAR(20)
  • Article_Master_Major (article_master_major) — VARCHAR(20)
  • Article_Master_Minor (article_master_minor) — VARCHAR(20)
  • Article_Master_Grade (article_master_grade) — FLOAT
  • Article_Master_Total (article_master_total) — FLOAT
  • Article_Doctor_Name (article_doctor_name) — VARCHAR(20)
  • Article_Doctor_Classification (article_doctor_classification) — VARCHAR(20)
  • Article_Doctor_Location (article_doctor_location) — VARCHAR(20)
  • Article_Doctor_Entrance_Year (article_doctor_entrance_year) — VARCHAR(20)
  • Article_Doctor_Graduation_Year (article_doctor_graduation_year) — VARCHAR(20)
  • Article_Doctor_Major (article_doctor_major) — VARCHAR(20)
  • Article_Doctor_Minor (article_doctor_minor) — VARCHAR(20)
  • Article_Doctor_Grade (article_doctor_grade) — FLOAT
  • Article_Doctor_Total (article_doctor_total) — FLOAT
  • Article_Veterans_Classification (article_veterans_classification) — VARCHAR(20)
  • Article_Veterans_Number (article_veterans_number) — VARCHAR(20)
  • Article_Obstacle_Classification (article_obstacle_classification) — VARCHAR(20)
  • Article_Obstacle_Grade (article_obstacle_grade) — VARCHAR(20)
  • Article_Buyer (article_buyer) — User
  • Article_Created_At (article_created_at) — DATETIME
  • … +1

자격증 (Certificate)

  • Article_ID (article_id) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id2) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id2) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id22) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id3) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id23) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id22) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id2222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Certificate_Name (certificate_name) — VARCHAR(20)
  • Certificate_Publisher (certificate_publisher) — VARCHAR(20)
  • Certificate_Date (certificate_date) — VARCHAR(20)
  • Field

자기소개서 (SelfIntroduction)

  • Article_ID (article_id) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id2) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id2) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id22) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id3) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id23) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • User_ID (user_id222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • Article_ID (article_id22) — INT — 외래 키 → 이력서.Article_ID — NOT NULL
  • User_ID (user_id2222) — INT — 외래 키 → 이력서.User_ID — NOT NULL
  • SelfIntroduction_Content (selfintroduction_content) — TEXT

자기소개서항목 (Introduction)

  • User_ID (user_id) — INT — 외래 키 → 공고.User_ID — NOT NULL
  • Article_ID (article_id) — INT — 외래 키 → 공고.Article_ID — NOT NULL
  • User_ID (user_id2) — INT — 외래 키 → 공고.User_ID — NOT NULL
  • User_ID (user_id22) — INT — 외래 키 → 공고.User_ID — NOT NULL
  • Article_ID (article_id2) — INT — 외래 키 → 공고.Article_ID — NOT NULL
  • User_ID (user_id222) — INT — 외래 키 → 공고.User_ID — NOT NULL
  • Article_ID (article_id3) — INT — 외래 키 → 공고.Article_ID — NOT NULL
  • User_ID (user_id23) — INT — 외래 키 → 공고.User_ID — NOT NULL
  • User_ID (user_id223) — INT — 외래 키 → 공고.User_ID — NOT NULL
  • Article_ID (article_id22) — INT — 외래 키 → 공고.Article_ID — NOT NULL
  • User_ID (user_id2222) — INT — 외래 키 → 공고.User_ID — NOT NULL
  • Introduction_Title (introduction_title) — VARCHAR(20)
  • Introduction_Number (introduction_number) — VARCHAR(20)

트랜잭션 (Transaction)

  • Transaction_Tx_Hash (transaction_tx_hash) — VARCHAR(20)
  • Transaction__Blockhash (transaction_blockhash) — VARCHAR(20)
  • Transaction_Blcoknumber (transaction_blocknumber) — INT
  • Transaction_From_Addr (transaction_from_addr) — VARCHAR(20)
  • Transaction_To_Addr (transaction_to_addr) — VARCHAR(20)
  • Transaction_From_Pk (transaction_from_pk) — INT
  • Transaction_To_Pk (transaction_to_pk) — INT
  • Transaction_Gas (transaciont_gas) — INT
  • Transaction_Gasprice (transaciont_gasprice) — INT
  • Transaction_Nonce (transaciont_nonce) — INT
  • Transaction_R (transaciont_r) — VARCHAR(20)
  • Transaction_S (transaciont_s) — VARCHAR(20)
  • Transaction_V (transaciont_v) — VARCHAR(20)
  • Transaction_Value (transaciont_value) — INT
  • Transaction_Created_At (transaciont_created_at) — DATETIME
  • Transaction_Updated_At (transaciont_updated_at) — DATETIME