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