ResumeRefiner-old

Tables (11)

credit_history

  • id — BIGINT
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • delta — INTEGER — NOT NULL
  • member_id — BIGINT — NOT NULL
  • reason — VARCHAR(30) — NOT NULL
  • ref_id — BIGINT
  • ref_type — VARCHAR(30)
  • REVIEW_CONSUME::character — varying
  • ADMIN_ADJUST::character — varying
  • REVIEW::character — varying
  • ADMIN::character — varying

media_file

  • id — BIGINT
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • owner_id — BIGINT — NOT NULL
  • owner_type — VARCHAR(20) — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • url — VARCHAR(512) — NOT NULL
  • RESUME::character — varying

member

  • id — BIGINT
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • credits — INTEGER — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • handle — VARCHAR(32) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255)
  • profile_image_id — BIGINT
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255)
  • role — VARCHAR(20) — NOT NULL
  • GOOGLE::character — varying
  • ADMIN::character — varying

payment

  • id — BIGINT
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • amount — INTEGER — NOT NULL
  • approved_at — TIMESTAMP(6)
  • currency — VARCHAR(10) — NOT NULL
  • member_id — BIGINT — NOT NULL
  • pg_provider — VARCHAR(30) — NOT NULL
  • pg_transaction_id — VARCHAR(100) — NOT NULL
  • product_code — VARCHAR(50) — NOT NULL
  • requested_at — TIMESTAMP(6) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • KAKAO::character — varying
  • NICE::character — varying
  • PAYPAL::character — varying
  • APPROVED::character — varying
  • CANCELLED::character — varying
  • FAILED::character — varying

resume

  • id — BIGINT
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • language_code — VARCHAR(10) — NOT NULL
  • member_id — BIGINT — NOT NULL
  • photo_image_id — BIGINT
  • slug — VARCHAR(64) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • military_branch — VARCHAR(30)
  • military_notes — VARCHAR(500)
  • military_period — VARCHAR(50)
  • military_rank — VARCHAR(50)
  • military_status — VARCHAR(30) — NOT NULL
  • email — VARCHAR(255)
  • profile_location — VARCHAR(255)
  • profile_name — VARCHAR(100) — NOT NULL
  • profile_phone — VARCHAR(30)
  • EN::character — varying
  • NAVY::character — varying
  • AIR_FORCE::character — varying
  • MARINE::character — varying
  • SOCIAL_SERVICE::character — varying
  • OTHER::character — varying
  • NOT_SERVED::character — varying
  • SERVING::character — varying
  • SERVED::character — varying
  • EXEMPT::character — varying

resume_custom_section

  • resume_id — BIGINT — Primary key — NOT NULL
  • display_order — INTEGER — Primary key — NOT NULL
  • content — VARCHAR(8000) — NOT NULL
  • subject — VARCHAR(100) — NOT NULL
  • section_type — VARCHAR(30)
  • PROJECT::character — varying
  • CERTIFICATION::character — varying
  • AWARD::character — varying
  • ACTIVITY::character — varying
  • MILITARY_NOTE::character — varying
  • OTHER::character — varying

resume_education

  • resume_id — BIGINT — Primary key — NOT NULL
  • display_order — INTEGER — Primary key — NOT NULL
  • degree — VARCHAR(30)
  • description — VARCHAR(2000)
  • major — VARCHAR(255)
  • period — VARCHAR(50)
  • school_name — VARCHAR(255) — NOT NULL
  • ASSOCIATE::character — varying
  • BACHELOR::character — varying
  • MASTER::character — varying
  • DOCTOR::character — varying
  • OTHER::character — varying

resume_experience

  • resume_id — BIGINT — Primary key — NOT NULL
  • display_order — INTEGER — Primary key — NOT NULL
  • company — VARCHAR(255) — NOT NULL
  • description — VARCHAR(4000)
  • period — VARCHAR(50) — NOT NULL
  • role — VARCHAR(255) — NOT NULL

review

  • id — BIGINT
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • improved_text — TEXT — NOT NULL
  • model — VARCHAR(50) — NOT NULL
  • resume_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • score_clarity — SMALLINT
  • score_structure — SMALLINT
  • score_tone — SMALLINT
  • summary — TEXT — NOT NULL
  • tone — VARCHAR(20) — NOT NULL
  • NEUTRAL::character — varying
  • PROFESSIONAL::character — varying

review_sentence_feedback

  • id — BIGINT
  • created_at — TIMESTAMP(6) — NOT NULL
  • updated_at — TIMESTAMP(6) — NOT NULL
  • clarity_score — SMALLINT
  • logic_score — SMALLINT
  • original_text — TEXT — NOT NULL
  • rewritten_text — TEXT — NOT NULL
  • sentence_index — INTEGER — NOT NULL
  • suggestion — TEXT — NOT NULL
  • tone_score — SMALLINT
  • review_id — BIGINT — NOT NULL

review_sentence_issue

  • sentence_feedback_id — BIGINT — NOT NULL
  • issue_text — TEXT — NOT NULL