Hello world
Tables (25)
ActionGuides (행동추천)
- action_id (행동아이디) — BIGINT — Primary key — NOT NULL
- text (행동가이드) — VARCHAR
- rec_id (묶음아이디) — BIGINT — Foreign key → Recommendations.rec_id — NOT NULL
- order_no (노출순서) — INTEGER
CalendarEvents (캘린더이벤트)
- event_id (이벤트아이디) — BIGINT — Primary key — NOT NULL
- title (제목) — VARCHAR
- start_at (시작시간) — TimeStamp
- end_at (종료시간) — TimeStamp
- memo (메모) — VARCHAR
- created_at (생성일자) — TimeStamp
- updated_at (수정일자) — TimeStamp
- order_no (정렬순서) — INTEGER
- is_remind (알림 수신 여부) — BOOLEAN
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
Caricatures (캐리커처 이미지)
- id — BIGINT — Primary key
- caricature_url (캐리커처 이미지 경로) — TEXT
- diary_photo_id (일기 이미지 아이디) — BIGINT — Foreign key → DiaryPhotos.diary_photo_id
ChecklistItems (리스트아이템)
- item_id (아이템아이디) — BIGINT — Primary key — NOT NULL
- text (텍스트) — VARCHAR
- list_id (체크리스트아이디) — BIGINT — Foreign key → Checklists.list_id — NOT NULL
- checked (체크유무) — BOOLEAN
- order_no (정렬순서) — INTEGER
Checklists (체크리스트)
- list_id (체크리스트아이디) — BIGINT — Primary key — NOT NULL
- basis_type (체크리스트타입) — ENUM
- basis_id (이벤트/주차아이디) — BIGINT
- title (제목) — VARCHAR
- created_at (생성일자) — TimeStamp
- updated_at (수정일자) — TimeStamp
- prep_id (출산대비아이디\) — BIGINT — Foreign key → PrepContents.prep_id — NOT NULL
ContractionSessions (진통)
- id — BIGINT — Primary key
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
- start_time (시작 시간) — TimeStamp
- end_time (종료 시간) — TimeStamp
- interval (이전 진통 종료 ~ 이번 진통 간격) — INT
- alert_sent (위험 감지) — BOOLEAN
- duration (진통 기간) — INT
Couple (커플공유)
- couple_id (커플아이디) — BIGINT — Primary key — NOT NULL
- user_id_a (엄마id) — BIGINT — Foreign key → Menbers.user_id
- user_id_b (아빠id) — BIGINT — Foreign key → Menbers.user_id
- pregnancy_week (임신주차) — INT
- due_date (출산예정일) — TimeStamp
- created_at (생성시각) — TimeStamp
- updated_at (수정시각) — TimeStamp
- menstrual_date (마지막 생리일) — BOOLEAN
- is_childbirth (출산경험여부) — BOOLEAN
Diary (일기)
- diary_id (일기 아이디) — BIGINT — Primary key
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
- diary_title (일기 제목) — VARCHAR
- diary_content (일기 내용) — VARCHAR
- created_at (작성 날짜) — TimeStamp
- updated_at (수정시간) — TimeStamp
- author_id (작성자) — BIGINT — Foreign key → Menbers.user_id
- author_role (역할) — VARCHAR
DiaryPhotos (일기 이미지)
- diary_photo_id (일기 이미지 아이디) — BIGINT — Primary key
- diary_id (일기 아이디) — BIGINT — Foreign key → Diary.diary_id
- image_url (이미지 경로) — Text
- is_ultrasound (초음파 여부) — BOOLEAN
DietPlans (식단추천)
- diet_id (식단아이디) — BIGINT — Primary key — NOT NULL
- meal_type (식사타입) — ENUM
- rec_id (묶음아이디) — BIGINT — Foreign key → Recommendations.rec_id — NOT NULL
- title (메뉴명) — VARCHAR
- img_url (이미지) — VARCHAR
- external_link (레시피링크) — VARCHAR
- order_no (노출순서) — INTEGER
FetalGrowth (태아 발육 측정 결과)
- id — BIGINT — Primary key
- head_size (머리 둘레 측정값) — Float
- leg_size (대퇴골 길이) — Float
- waist_size (복부 둘레) — Float
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
FetalMovements (태동)
- id (Field) — BIGINT — Primary key
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
- recorded_at (기록 시간) — TimeStamp
- notes (메모) — VARCHAR
HealthData (갤럭시워치 데이터)
- health_id (헬스케어 아이디) — BIGINT — Primary key — NOT NULL
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
- date (날짜) — TimeStamp
- stress (스트레스) — INT
- sleep_hours (수면 시간) — INT
- heartrate (심박수) — INT
- steps (걸음수) — INT
- is_danger (위험 확인) — BOOLEAN
InviteCode (초대코드)
- invite_id (초대코드아이디) — BIGINT — Primary key
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
- inviteCode (초대코드) — INT
- expired_date (만료기간) — TimeStamp
LocationRecommendations (나들이 장소 추천)
- id — BIGINT — Primary key
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
- recommended_at (추천 시간) — TimeStamp
- place_name (장소 이름) — VARCHAR
- place_description (장소 설명) — VARCHAR
- location_lat (장소 위도) — Float
- loaction_lng (장소 경도) — Float
- external_url (장소 url) — VARCHAR
- is_clicked (클릭 확인) — BOOLEAN
MaternalHealth (산모 건강)
- id — BIGINT
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
- record_date (기록 날짜) — TimeStamp
- weight (체중) — Float
- max_blood_pressure (혈압수축기) — INT
- min_blood_pressure (혈압이완기) — INT
- blood_sugar (혈당) — INT
Menbers (유저)
- user_id (id) — BIGINT — Primary key
- google_email (이메일) — VARCHAR
- nickname (닉네임) — VARCHAR
- gender (성별) — VARCHAR
- image_URL (프로필 사진) — Text
- age (나이) — INT
- created_at (생성시각) — TimeStamp
- updated_at (수정시각) — TimeStamp
MusicRecommendations (음악 추천)
- id (음악 아이디) — BIGINT — Primary key
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
- playlist_url (유투브,Sptify 링크) — VARCHAR
- reason (추천 이유(스트레스, 불면)) — VARCHAR
- recommended_at (추천 시간) — TimeStamp
- is_clicked (클릭 확인) — BOOLEAN
Notification (알람내역)
- alarm_id (알람아이디) — BIGINT — Primary key — NOT NULL
- alarm_type (알림유형) — ENUM
- user_id (알림수신자) — BIGINT — Foreign key → Menbers.user_id
- alarm_title (알림제목) — VARCHAR
- alarm_msg (알림내용) — VARCHAR
- created_at (생성날짜) — TimeStamp
PregnancyWeeks (주차별)
- week_id (주차아이디) — BIGINT — Primary key — NOT NULL
- week_no (임신주차(1-40)) — INTEGER
- tips (주차별추천요약) — VARCHAR
- created_at (생성시각) — TimeStamp
- updated_at (수정시각) — TimeStamp
PrepContents (출산대비)
- prep_id (출산대비아이디\) — BIGINT — Primary key — NOT NULL
- content_type (컨텐츠타입) — ENUM
- rec_id (묶음아이디) — BIGINT — Foreign key → Recommendations.rec_id — NOT NULL
- title (제목) — VARCHAR
- contents (설명) — VARCHAR
- external_link (외부링크) — VARCHAR
- order_no (노출순서) — INTEGER
Recommendations (추천묶음)
- rec_id (묶음아이디) — BIGINT — Primary key — NOT NULL
- type (추천타입) — ENUM
- week_id (주차아이디) — BIGINT — Foreign key → PregnancyWeeks.week_id — NOT NULL
- title (추천제목) — VARCHAR
- summary (간단설명) — VARCHAR
- created_at (생성일자) — TimeStamp
- updated_at (수정일자) — TimeStamp
Strech (스트레칭추천)
- strech_id (스트레칭아이디) — BIGINT — Primary key — NOT NULL
- external_id (영상Url) — VARCHAR
- rec_id (묶음아이디) — BIGINT — Foreign key → Recommendations.rec_id — NOT NULL
- title (영상제목) — VARCHAR
- tumbnail_url (썸네일이미지) — VARCHAR
TodoItems (todo가이드)
- todo_id (투두아이디) — BIGINT — Primary key — NOT NULL
- text (할일) — VARCHAR
- rec_id (묶음아이디) — BIGINT — Foreign key → Recommendations.rec_id — NOT NULL
- order_no (순서) — INTEGER
VideoRecommendations (영상 추천)
- id — BIGINT — Primary key
- couple_id (커플아이디) — BIGINT — Foreign key → Couple.couple_id — NOT NULL
- recommended_at (추천 시간) — TimeStamp
- video_title (영상 제목) — VARCHAR
- video_url (영상 url) — VARCHAR
- is_clicked (클릭 확인) — BOOLEAN