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