ERD_프리미엄리뷰
테이블 (13)
companies
- id — int — 기본 키 — NOT NULL
- 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 (prac)
- id — int — 기본 키 — NOT NULL
- answer_id — int — 외래 키 → premium_review_answers.id — NOT NULL
- content — text
- review_status_id — int
- rejection_reason — text
- user_id — int
- created_at — datetime
- updated_at — datetime
premium_review_answer_sets (pras)
- id — int — 기본 키 — NOT NULL
- company_id — int — 외래 키 → companies.id — NOT NULL
- questionnaire_id — int — 외래 키 → survey_questionnaires.id — NOT NULL
- user_id — int
- review_status_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 (pra)
- id — int — 기본 키 — NOT NULL
- answer_set_id — int — 외래 키 → premium_review_answer_sets.id — NOT NULL
- question_id — int — 외래 키 → survey_questions.id — NOT NULL
- id (id2) — int — 외래 키 → premium_review_answer_sets.questionnaire_id — NOT NULL
- review_status_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 — 기본 키 — NOT NULL
- answer_id — int — 외래 키 → premium_review_answers.id — NOT NULL
- id (id2) — int — 외래 키 → premium_review_answers.question_id — NOT NULL
- id (id22) — int — 외래 키 → premium_review_answers.id — NOT NULL
- reject_reason_id — int
- reject_reason_text — text
- review_status_id — int
- created_at — datetime
- updated_at — datetime
premium_review_question_supplements (prqs)
- id — 기본 키 — NOT NULL
- question_id — int — 외래 키 → survey_questions.id — NOT NULL
- sample — tinyint(1)
- created_at — datetime
- updated_at — datetime
survey_campaign_questionnaires (scq)
- id — int — 기본 키 — NOT NULL
- campaign_id — int — 외래 키 → survey_campaigns.id — NOT NULL
- questionnaire_id — int — 외래 키 → survey_questionnaires.id — NOT NULL
- active — tinyint(1)
- weight — int
- created_at — datetime
- updated_at — datetime
survey_campaigns (sc)
- id (Key) — int — 기본 키 — NOT NULL
- company_id — int — 외래 키 → companies.id — NOT NULL
- 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)
- Field
survey_choices
- id — 기본 키 — NOT NULL
- text — varchar(255)
- comment — varchar(255) — archar(255) nul
- other — tinyint(1)
- created_at — datetime
- updated_at — datetime
- value — varchar(255)
- choice_type — int
survey_question_choices (sqc)
- id — 기본 키 — NOT NULL
- question_id — int — 외래 키 → survey_questions.id — NOT NULL
- choice_id — 외래 키 → survey_choices.id — NOT NULL
- active — tinyint(1)
- weight — int
- created_at — datetime
- updated_at — datetime
survey_questionnaire_questions (sqq)
- id — int — 기본 키 — NOT NULL
- questionnaire_id — int — 외래 키 → survey_questionnaires.id — NOT NULL
- question_id — int — 외래 키 → survey_questions.id — NOT NULL
- 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 (sq)
- id — int — 기본 키 — NOT NULL
- 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 (sq2)
- id — int — 기본 키 — NOT NULL
- 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