mamma

Tables (3)

babies (아기)

  • id (고유ID) — Primary key — NOT NULL
  • name (이름)
  • birth_date (생년월일)
  • gender (성별)
  • profile_image_url (프로필 이미지)
  • created_at (생성일)
  • updated_at (수정일)
  • deleted_at (삭제일)

parents (부모)

  • id (고유ID) — Primary key
  • email (이메일)
  • status (상태) — active, withdrawn
  • last_login_at (마지막 로그인 일시)
  • created_at (생성일)
  • updated_at (수정일)
  • deleted_at (탈퇴일)

records (기록)

  • id (고유 ID) — Primary key — NOT NULL
  • type (타입)
  • value (값)
  • baby_id (아기ID) — Foreign key → babies.id — NOT NULL
  • parent_id (부모 ID) — Foreign key → parents.id
  • created_at (생성일)
  • updated_at (수정일)
  • deleted_at (삭제일)