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