CW ERD

Tables (33)

V2Matching (v2_matching)

  • id — bigserial — Primary key — NOT NULL
  • v2_company_id — int4 — Foreign key → v2_company.id
  • v2_company_manager_id — int4 — Foreign key → v2_company_manager.id
  • id (v2_matching_resume_id) — int4 — Foreign key → v2_matching_resume.id
  • position_name — varchar(255)
  • recruit_start_date — timestamp
  • recruit_end_date — timestamp
  • is_recruiting_agreement — bool
  • pay_period — varchar(255)
  • pay — varchar(255)
  • work_experience — varchar(255)
  • core_competencies1 — varchar(255)
  • core_competencies2 — varchar(255)
  • hiring_headcount — int4
  • recruit_detail — text
  • address1 — varchar(255)
  • address2 — varchar(255)
  • matching_status — int4
  • created_at — timestamp
  • updated_at — timestamp
  • recruit_type — varchar
  • end_at — timestamp
  • Field (apply_count) — int4

V2MatchingResumeInterview (v2_matching_resume_interview)

  • v2_matching_resume_interview_id — bigserial — Primary key — NOT NULL
  • v2_matching_resume_id — int4 — Foreign key → v2_matching_resume.id
  • interview_date — timestamp
  • is_selected — bool
  • interview_type — int4
  • interview_address1 — varchar(255)
  • interview_address2 — varchar(255)
  • interview_url — varchar(255)
  • interview_status — int8
  • created_at — timestamp
  • updated_at — timestamp

V2User (v2_user)

  • 아이디 (v2_user_id) — bigserial — Primary key — NOT NULL
  • simple_resume_id — int4 — Foreign key → simple_resume.id
  • id (v2_ai_personality_id) — int4 — Foreign key → v2_ai_personality.id
  • 소셜로그인 아이디 (social_id) — varchar(255)
  • 소셜로그인 구분자 (social_provider) — varchar(255)
  • 로그인 상태값 (status) — int4
  • 이메일 (email) — varchar(255)
  • 생년월일 (birth) — date
  • job_status — varchar(255)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • id_photo_url — varchar(255)
  • name — varchar(255)
  • phone — varchar(255)
  • gender — varchar(5)
  • address1 — varchar(255)
  • address2 — varchar(255)
  • current_job_status — varchar(255)
  • is_agree_privacy — bool
  • is_agree_marketing — bool
  • is_admin — bool
  • v2_ai_personality_name — varchar

account

  • id — bigserial — Primary key — NOT NULL
  • id (account_provider_id) — int8 — Foreign key → account_provider.id
  • id (account_status_id) — int8 — Foreign key → account_status.id
  • id (account_type_id) — int8 — Foreign key → account_type.id
  • last_login — timestamptz
  • account_name — varchar(128)
  • password — varchar(128)
  • created_time — timestamptz
  • deleted_time — timestamptz
  • is_active — bool — NOT NULL
  • is_staff — bool — NOT NULL

account_profile

  • id — bigserial — Primary key — NOT NULL
  • id (account_id) — int8 — Foreign key → account.id
  • name — varchar(64)
  • email — varchar(128)
  • birth — date
  • phone — varchar(64)
  • gender — bool
  • updated_time — timestamptz
  • address1 — varchar(128)
  • address2 — varchar(128)
  • job_status — varchar(32)

account_provider

  • id — bigserial — Primary key — NOT NULL
  • name — varchar(32)

account_status

  • id — bigserial — Primary key — NOT NULL
  • name — varchar(32)

account_type

  • id — bigserial — Primary key — NOT NULL
  • name — varchar(32)

addy_ai_personality_result

  • id — bigserial — Primary key — NOT NULL
  • addy_result_id — int4
  • title — varchar(200)
  • pc_img_url — varchar(512)
  • mobile_img_url — varchar(512)
  • result_img_url — varchar(512)

addy_ai_personality_type

  • id — bigserial — Primary key — NOT NULL
  • name — varchar(64)
  • group_name — varchar(10)
  • content_id — int4
  • hidden_code — varchar(64)
  • priority — int4

c_employee_scale

  • id — int8 — Primary key — NOT NULL
  • scale_min — int4
  • scale_max — int4
  • name — varchar(32)

c_industrial

  • id — bigserial — Primary key — NOT NULL
  • name — varchar(32)

resume_area

  • id — serial4 — Primary key — NOT NULL
  • area_code — varchar(64) — NOT NULL
  • area_name1 — varchar(64) — NOT NULL
  • area_name2 — varchar(64) — NOT NULL

resume_skill_category1

  • id — serial4 — Primary key — NOT NULL
  • category1_name — varchar(64) — NOT NULL
  • category1_type — varchar(64) — NOT NULL
  • category1_status — int4 — NOT NULL
  • category1_order_by — int4 — NOT NULL
  • is_show — int4 — NOT NULL

resume_skill_category2

  • id — serial4 — Primary key — NOT NULL
  • id (resume_skill_category1_id) — int4 — Foreign key → resume_skill_category1.id — NOT NULL
  • category2_name — varchar(512) — NOT NULL
  • category2_type — varchar(64) — NOT NULL
  • category2_status — int4 — NOT NULL
  • category2_order_by — int4 — NOT NULL
  • is_show — int4 — NOT NULL

resume_skill_category3

  • id — serial4 — Primary key — NOT NULL
  • id (resume_skill_category2_id) — int4 — Foreign key → resume_skill_category2.id — NOT NULL
  • category3_name — varchar(512) — NOT NULL
  • category3_type — varchar(64) — NOT NULL
  • category3_status — int4 — NOT NULL
  • category3_order_by — int4 — NOT NULL
  • is_show — int4 — NOT NULL

simple_resume

  • id — serial4 — Primary key — NOT NULL
  • job_status — varchar
  • portfolio_url — varchar
  • main_position_id — int8
  • sub_position_id — int8

simple_resume_area

  • id — serial4 — Primary key — NOT NULL
  • simple_resume_id — int8 — Foreign key → simple_resume.id
  • area_code — varchar
  • area_name — varchar
  • area_name2 — varchar

simple_resume_category1

  • id — serial4 — Primary key — NOT NULL
  • simple_resume_id — int8 — Foreign key → simple_resume.id
  • category1_id — int8
  • category1_name — varchar(255)
  • category_type — varchar(255)
  • category1_text — varchar

simple_resume_category2

  • id — serial4 — Primary key — NOT NULL
  • simple_resume_category1_id — int8 — Foreign key → simple_resume_category1.id
  • category2_id — int8
  • category2_name — varchar(255)
  • category2_text — varchar(255)
  • category_type — varchar(255)

simple_resume_category3

  • id — serial4 — Primary key — NOT NULL
  • simple_resume_category2_id — int8 — Foreign key → simple_resume_category2.id
  • category3_id — int8
  • category3_name — varchar(255)
  • category3_text — varchar(255)
  • category_type — varchar(255)

v2_ai_personality

  • id — serial4 — Primary key — NOT NULL
  • id (personality_result_id) — int8 — Foreign key → addy_ai_personality_result.id
  • created_at — timestamp
  • updated_at — timestamp

v2_company

  • id — serial4 — Primary key — NOT NULL
  • company_logo_url — varchar(255)
  • company_name — varchar(255)
  • company_business_number — varchar(255)
  • company_address1 — varchar(255)
  • company_address2 — varchar(255)
  • company_email — varchar(255)
  • company_phone — varchar(255)
  • company_homepage — varchar(255)
  • company_type — varchar(255)
  • company_sectors — varchar(255)
  • company_employee_count — int4
  • company_ceo_name — varchar(255)
  • company_established_date — date
  • company_annual_sales — varchar
  • company_status — int4
  • company_description — varchar(255)
  • company_description_detail — text

v2_company_image

  • id — serial4 — Primary key — NOT NULL
  • v2_company_id — int4 — Foreign key → v2_company.id
  • company_image_url — varchar(255)
  • company_image_status — int4

v2_company_manager

  • id — serial4 — Primary key — NOT NULL
  • v2_company_id — int4 — Foreign key → v2_company.id
  • manager_name — varchar(255)
  • manager_email — varchar(255)
  • manager_phone — varchar(255)
  • manager_position — varchar(255)
  • manager_department — varchar(255)
  • manager_name_card_url — varchar(255)
  • is_agree_privacy — bool
  • is_agree_marketing — bool
  • manager_status — int4
  • social_id — varchar(255)

v2_matching_list

  • id — serial4 — Primary key — NOT NULL
  • v2_matching_id — int4 — Foreign key → V2Matching.id
  • v2_user_id — int4 — Foreign key → V2User.아이디
  • id (v2_matching_resume) — int4 — Foreign key → v2_matching_resume.id
  • matching_user_type — int4
  • user_matching_date — timestamp
  • created_at — timestamp
  • updated_at — timestamp
  • matching_list_status — int4
  • Field (user_request_date) — timestamp
  • Field2 (user_matching_cancle_date) — timestamp

v2_matching_memo_history

  • id — serial4 — Primary key — NOT NULL
  • v2_matching_id — int4 — Foreign key → V2Matching.id
  • content — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp

v2_matching_resume

  • id — serial4 — Primary key — NOT NULL
  • v2_user_id — int8 — Foreign key → V2User.아이디
  • v2_matching_id — int8 — Foreign key → V2Matching.id
  • portfolio_url — varchar
  • status — int4

v2_matching_resume_area

  • id — serial4 — Primary key — NOT NULL
  • v2_matching_resume_id — int4 — Foreign key → v2_matching_resume.id
  • area_code — varchar
  • area_name — varchar
  • area_name2 — varchar

v2_matching_resume_category1

  • id — serial4 — Primary key — NOT NULL
  • v2_matching_resume_id — int8 — Foreign key → v2_matching_resume.id
  • category1_id — int8
  • category1_name — varchar
  • category_type — varchar
  • category1_text — varchar

v2_matching_resume_category2

  • id — serial4 — Primary key — NOT NULL
  • v2_matching_resume_category1_id — int8 — Foreign key → v2_matching_resume_category1.id
  • category2_id — int8
  • category2_name — varchar
  • category2_text — varchar
  • category_type — varchar

v2_matching_resume_category3

  • id — serial4 — Primary key — NOT NULL
  • v2_matching_resume_category2_id — int8 — Foreign key → v2_matching_resume_category2.id
  • category3_id — int8
  • category3_name — varchar
  • category3_text — varchar
  • category_type — varchar

v2_payment_product

  • id — serial4 — Primary key — NOT NULL
  • product_type_name — varchar(10)
  • product_view_name — varchar(255)
  • max_matching_count — int4
  • max_matching_user_count — int4
  • max_talent_pool_count — int4
  • max_sub_manager_count — int4
  • product_payment_type — int4
  • product_month — int4
  • product_price — int4
  • product_discount_price — int4
  • product_real_payment_price — int4
  • product_status — int4
  • created_at — timestamp
  • updated_at — timestamp