ERD_프리미엄리뷰

테이블 (10)

companies

  • id — int
  • name — varchar(255)
  • slug_suffix — varchar(255)
  • business_number — varchar(255)
  • survey_code — varchar(255)
  • logo — varchar(255)
  • slogan — varchar(255)
  • founded — date
  • business_type_korean — varchar(255)
  • industry_id — int
  • headquarter_city_id — int
  • website — varchar(255)
  • introduction — text
  • review_status_id — int
  • rating_status_id — int
  • created_at — datetime
  • updated_at — datetime
  • culture — text
  • mission — text
  • vision — text
  • company_type_id — int
  • korean_address — varchar(255) — NOT NULL
  • geocoding_id — int
  • premium — int
  • broad — varchar(255)
  • preferred — int
  • site_address — varchar(255)
  • input_by_type — varchar(255)
  • input_by_id — int
  • postal_code — varchar(255)
  • telephone_number — varchar(255)
  • main_product — varchar(255)
  • salary_min_cache — decimal(10, 2) — NOT NULL
  • salary_avg_cache — decimal(10, 2) — NOT NULL
  • external_salary_avg_cache — decimal(10, 2)
  • salary_max_cache — decimal(10, 2) — NOT NULL
  • review_avg_cache — decimal(10, 2) — NOT NULL
  • approved_reviews_cache — int — NOT NULL
  • approved_salaries_cache — int — NOT NULL
  • approved_interviews_cache — int — NOT NULL
  • review_advancement_cache — decimal(5, 2) — NOT NULL
  • review_compensation_cache — decimal(5, 2) — NOT NULL
  • review_worklife_cache — decimal(5, 2) — NOT NULL
  • review_culture_cache — decimal(5, 2) — NOT NULL
  • review_management_cache — decimal(5, 2) — NOT NULL
  • interview_overall_cache — decimal(5, 2) — NOT NULL
  • interview_difficulty_cache — decimal(5, 2) — NOT NULL
  • basic_validated — tinyint(1)
  • review_recommend_to_friend_cache — decimal(5, 2) — NOT NULL
  • review_ceo_support_rating_cache — decimal(5, 2) — NOT NULL
  • review_next_year_rating_cache — decimal(5, 2) — NOT NULL
  • co_registration_number — varchar(255)
  • next_data_mapping_at — datetime
  • industry_level2_id — int
  • cached_omit_from_rankings — tinyint(1)
  • vault_club_handle — varchar(255)
  • approved_benefits_cache — int — NOT NULL
  • review_by_survey_avg_cache — decimal(10, 2)
  • review_advancement_by_survey_cache — decimal(5, 2)
  • review_compensation_by_survey_cache — decimal(5, 2)
  • … +8

premium_review_answer_comments

  • id — int
  • answer_id — int
  • content — text
  • review_status_id — int
  • rejection_reason — text
  • user_id — int
  • created_at — datetime
  • updated_at — datetime

premium_review_answer_sets

  • id — int
  • company_id — int
  • user_id — int
  • review_status_id — int
  • questionnaire_id — int
  • current_question — int
  • completed — tinyint(1)
  • weight — int
  • link_token — varchar(255)
  • user_link_hash — varchar(255)
  • jp_link_hash — varchar(255)
  • occupation_id — int
  • occupation_level2_id — int
  • years_of_experience — int
  • last_year_at_employer — int
  • currently_employed — tinyint(1)
  • draft_at — datetime
  • pending_at — datetime
  • approved_at — datetime
  • rejected_at — datetime
  • created_at — datetime
  • updated_at — datetime

premium_review_answers

  • id — int
  • answer_set_id — int
  • review_status_id — int
  • question_id — int
  • choice_id — int
  • text — text
  • created_at — datetime
  • updated_at — datetime
  • helpful_count — int
  • not_helpful_count — int

premium_review_histories

  • id — int
  • answer_id — int
  • reject_reason_id — int
  • reject_reason_text — text
  • review_status_id — int
  • created_at — datetime
  • updated_at — datetime

survey_campaign_questionnaires

  • id — int
  • campaign_id — int
  • questionnaire_id — int
  • active — tinyint(1)
  • weight — int
  • created_at — datetime
  • updated_at — datetime

survey_campaigns

  • id — int
  • company_id — int
  • name — varchar(255)
  • starts_at — datetime
  • expires_at — datetime
  • mail_template — varchar(255)
  • created_at — datetime
  • updated_at — datetime
  • push_type — varchar(255)
  • title — varchar(255)
  • cover_page_body — text
  • cover_page — tinyint(1)
  • message — varchar(255)
  • reminder_message — varchar(255)
  • auto_save — tinyint(1)
  • redirect_url — varchar(255)
  • completed_title — varchar(255)
  • completed_subtitle — varchar(255)
  • cover_page_header — text
  • cover_page_footer — text
  • cover_page_start — varchar(255)
  • report — varchar(255)

survey_questionnaire_questions

  • id — int
  • questionnaire_id — int
  • question_id — int
  • active — tinyint(1)
  • weight — int
  • optional — tinyint(1)
  • min_choice — int
  • max_choice — int
  • max_length — int
  • created_at — datetime
  • updated_at — datetime
  • supplemental — tinyint(1)
  • min_length — int
  • method — varchar(255)
  • placeholder — varchar(255)

survey_questionnaires

  • id — int
  • category_id — int
  • name — varchar(255)
  • description — text
  • created_at — datetime
  • updated_at — datetime
  • title — varchar(255)
  • constant — varchar(255)
  • number — tinyint(1)

survey_questions

  • id — int
  • category_id — int
  • text — varchar(255)
  • comment — varchar(255) — archar(255) nul
  • question_type — int
  • active — tinyint(1)
  • created_at — datetime
  • updated_at — datetime
  • service_type — int