육아상담소

테이블 (4)

map_content_parenting_keyword

  • id — BIGINT
  • content_id — BIGINT — NOT NULL
  • content_type — VARCHAR(255) — NOT NULL
  • home_card_type — VARCHAR(255) — NOT NULL
  • keyword — VARCHAR(255) — NOT NULL
  • created_by — VARCHAR(255)
  • created_at — TIMESTAMP
  • modified_by — VARCHAR(255)
  • modified_at — TIMESTAMP

parenting_counseling

  • id — BIGINT
  • counseling_code — VARCHAR(255) — NOT NULL
  • parenting_counseling_origin_id — BIGINT — 외래 키 → parenting_counseling_origin.id — NOT NULL
  • parenting_counseling_user_info_id — BIGINT — 외래 키 → parenting_counseling_user_info.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • detail — TEXT — NOT NULL
  • is_selected — BOOLEAN — NOT NULL
  • applied_at — TIMESTAMP — NOT NULL
  • is_answered — BOOLEAN — NOT NULL
  • answered_at — TIMESTAMP
  • answer_thumbnail_url — VARCHAR(255)
  • answer_video_url — VARCHAR(255)
  • answer_video_seconds — INT
  • related_parenting_keyword_list — JSONB — NOT NULL
  • related_content_list — JSONB — NOT NULL
  • programming_status — VARCHAR(255) — NOT NULL
  • display_start_at — TIMESTAMP
  • display_end_at — TIMESTAMP
  • status — VARCHAR(255) — NOT NULL
  • created_by — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_by — VARCHAR(255) — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL
  • is_keyword_created — boolean — NOT NULL
  • generated_keyword_list — JSONB — NOT NULL

parenting_counseling_origin

  • id — BIGINT
  • parenting_counseling_id — BIGINT — NOT NULL
  • origin_title — VARCHAR(255) — NOT NULL
  • origin_detail — TEXT — NOT NULL
  • created_by — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_by — VARCHAR(255) — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL

parenting_counseling_user_info

  • id — BIGINT
  • parenting_counseling_id — BIGINT — NOT NULL
  • user_id — VARCHAR(255) — NOT NULL
  • profile_id — VARCHAR(255) — NOT NULL
  • profile_name — VARCHAR(255) — NOT NULL
  • child_birth_year — INT — NOT NULL
  • child_age_type — VARCHAR(255) — NOT NULL
  • child_gender — VARCHAR(255) — NOT NULL
  • has_pattern_info — BOOLEAN — NOT NULL
  • child_pattern_type — VARCHAR(255)
  • parent_pattern_type — VARCHAR(255)
  • combination_pattern_type — VARCHAR(255)
  • created_by — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_by — VARCHAR(255) — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL