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