육아상담소
테이블 (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