DX_Project

Tables (16)

AI_ANALYSIS_RESULTS

  • analysis_id — bigint — Primary key — NOT NULL
  • diary_id — bigint — Foreign key → DIARY_LOGS.diary_id
  • detected_emotion — varchar(50)
  • analyzed_at — timestamp

APPLIANCE_SETTINGS

  • setting_id — bigint — Primary key — NOT NULL
  • analysis_id — bigint — Foreign key → AI_ANALYSIS_RESULTS.analysis_id
  • appliance_name — varchar(100)
  • control_command — varchar(255)
  • execution_status — varchar(50)
  • user_id — bigint

COMMUNITY_COMMENTS

  • comment_id — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → COMMUNITY_POSTS.post_id
  • user_id — bigint — Foreign key → USERS.user_id
  • content — text — NOT NULL
  • created_at — timestamp

COMMUNITY_POSTS

  • post_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.user_id
  • pregnancy_period — varchar(50)
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp

COMMUNITY_POST_LIKES

  • like_id — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → COMMUNITY_POSTS.post_id — NOT NULL
  • user_id — bigint — Foreign key → USERS.user_id — NOT NULL
  • created_at — datetime

DIARY_LOGS

  • diary_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.user_id
  • temperature_ambient — decimal(4,2)
  • humidity_ambient — decimal(4,2)
  • weather_ambient — varchar(50)
  • selected_emotion — varchar(50)
  • stress_level — int
  • diary_content — text
  • small_talk_topic_id — bigint — Foreign key → SMALL_TALK_TOPICS.topic_id
  • recorded_at — timestamp
  • image_path — varchar(255)

DIARY_SYMPTOMS

  • diary_symptom_id — bigint — Primary key — NOT NULL
  • diary_id — bigint — Foreign key → DIARY_LOGS.diary_id
  • symptom_name — varchar(100)

GUARDIAN_MISSIONS

  • mission_id — bigint — Primary key — NOT NULL
  • analysis_id — bigint — Foreign key → AI_ANALYSIS_RESULTS.analysis_id
  • user_id — bigint — Foreign key → USERS.user_id
  • mission_content — text
  • execution_status — varchar(50)
  • created_at — timestamp
  • status_check_id — bigint
  • mission_title — varchar(200) — NOT NULL
  • mission_reason — text
  • mission_type — varchar(50) — NOT NULL
  • completed_at — datetime

PREGNANCY_STATUS_CHECKS

  • status_check_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.user_id — NOT NULL
  • symptoms — text
  • emotions — text
  • created_at — datetime

SHARED_CALENDAR_EVENTS

  • event_id — bigint — Primary key — NOT NULL
  • connection_code — varchar(100)
  • event_type — varchar(50)
  • title — varchar(200)
  • content — text
  • event_date — date
  • created_at — timestamp

SMALL_TALK_ANSWERS

  • answer_id — bigint — Primary key — NOT NULL
  • topic_id — bigint — Foreign key → SMALL_TALK_TOPICS.topic_id
  • user_id — bigint — Foreign key → USERS.user_id
  • connection_code — varchar(100)
  • answer_content — text
  • match_status — varchar(50)
  • created_at — timestamp

SMALL_TALK_TOPICS

  • topic_id — bigint — Primary key — NOT NULL
  • question_text — varchar(255) — NOT NULL
  • created_at — timestamp

TRUSTED_PREGNANCY_INFO

  • info_id — bigint — Primary key — NOT NULL
  • title — varchar(200)
  • content — text
  • source — varchar(100)
  • pregnancy_period — varchar(50)

USERS

  • user_id — bigint — Primary key — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(50)
  • role — varchar(20)
  • pregnancy_start_date — date
  • baby_nickname — varchar(50)
  • connection_code — varchar(100)
  • parent_user_id — bigint — Foreign key → USERS.user_id
  • created_at — timestamp

USER_CARE_PREFERENCES

  • preference_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → USERS.user_id — NOT NULL
  • preferred_mission_type — varchar(50) — NOT NULL
  • notification_enabled — tinyint(1) — NOT NULL
  • mission_time — varchar(20)
  • care_style — varchar(50) — NOT NULL
  • avoid_mission_keywords — text
  • updated_at — datetime

WEEKLY_AI_RECOMMENDATIONS

  • recommendation_id — bigint — Primary key — NOT NULL
  • pregnancy_week — int
  • recommendation_type — varchar(50)
  • title — varchar(200)
  • content — text