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