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