hackathon

Tables (18)

Dailylog (Untitled18)

  • Key — Primary key — NOT NULL
  • 날짜 (logDate) — LocalDate
  • 아침답 (morningAnswer) — String
  • 저녁답 (eveningAnswer) — String
  • 걸음수 (stepCount) — Integer
  • 수면상태 (sleepStatus) — String
  • 복약기록 (medicationLogs) — String
  • 요약 (summaryText) — String
  • 아침답여부 (morningAnswered) — boolean
  • 저녁완성수 (eveningCompletedCount) — int
  • 저녁전체수 (eveningTotolCount) — int
  • Pk (pk) — Integer — Foreign key → USER.Pk — NOT NULL

EVENING_ANSWER (Untitled15)

  • Key — Primary key — NOT NULL
  • 텍스트값 (textValue) — TEXT
  • 선택값 (choiceValue) — String
  • 입력타입 (inputType) — String
  • 답장시간 (answeredAT) — LocalDateTime
  • Key (Key2) — Foreign key → EVENING_QUESTION.Key — NOT NULL
  • Pk (pk) — Integer — Foreign key → USER.Pk — NOT NULL

EVENING_QUESTION (Untitled14)

  • Key — Primary key — NOT NULL
  • 질문날짜 (questionDate) — LocalDate
  • 타입 (metricType) — String
  • 내용 (content) — String
  • 답장타입 (answerType) — String
  • 선택지 (choices) — json
  • Pk (pk2) — Integer — Foreign key → USER.Pk — NOT NULL
  • Key (Key2) — Foreign key → QUESTIONTEMPLATE.Key — NOT NULL

Family (Untitled2)

  • Pk — Integer — Primary key — NOT NULL
  • 초대자 (createdBy) — Long

HEALTH_PROFILE (Untitled3)

  • PK — Interger — Primary key — NOT NULL
  • 생년월일 (Birth_date) — LocalDate
  • 성별 (Gender) — Varchar
  • 웰니스 관심사 (WellnessInterests) — Varchar
  • 질병 (Disease)
  • Pk (pk) — Integer — Foreign key → USER.Pk — NOT NULL

HEALTH_RECORD (Untitled10)

  • id — Long — Primary key — NOT NULL
  • 기록날짜 (recordDate) — LocalDate
  • 타입 (metricType) — String
  • 값 (numericValue)
  • 텍스트값 (textValue) — String
  • 원천 (source) — String
  • Pk (pk) — Integer — Foreign key → USER.Pk — NOT NULL

Letter (Untitled9)

  • PJ (Pk) — Integer — Primary key — NOT NULL
  • 발신자 (fromUserId) — Long
  • 내용 (content) — Text
  • 타입 (inputType) — String
  • 오디오url (audioUrl) — String
  • 읽은시간 (readAt) — LocalDateTime
  • 수신자 (toUserId) — Long

MEAL (Untitled7)

  • PK — Integer — Primary key — NOT NULL
  • 기록날짜 (recordDate) — LocalDate
  • 타입 (mealType) — varchar
  • 식사여부 (eaten) — boolean

MEAL (Untitled8)

  • PK — Integer — Primary key — NOT NULL
  • 기록날짜R (RecordDate) — LocalDateTime
  • 시간 (mealType) — varchar
  • 식사여부 (eaten) — boolean
  • Pk (pk) — Integer — Foreign key → USER.Pk — NOT NULL

MEDICATION (Untitled4)

  • Pk (PK) — Integer — Primary key — NOT NULL
  • 이름 (name) — String
  • 활성화 (isActive) — Boolean
  • Pk (pk) — Integer — Foreign key → USER.Pk — NOT NULL

MEDICATION_LOG (Untitled6)

  • PK — Integer — Primary key — NOT NULL
  • 날짜 (recordDate) — LocalDate
  • 복용시간 (checkedAt) — LocalDateTime
  • 소급여부 (isRetroactive) — boolean
  • 약복용여부 (status) — varchar
  • Pk (pk) — Integer — Foreign key → USER.Pk — NOT NULL
  • Pk — Integer — Foreign key → MEDICATION_SCHEDULE.Pk — NOT NULL

MEDICATION_SCHEDULE (Untitled5)

  • Pk — Integer — Primary key — NOT NULL
  • Field4
  • 약시간 (scheduledTime) — LocalTime
  • 주기 (sceduledDay) — varchar
  • 여부 (isEnabled) — boolean
  • Pk (PK) — Integer — Foreign key → MEDICATION.Pk — NOT NULL

MORNING_ANSWER (Untitled13)

  • Id — integer — Primary key — NOT NULL
  • 텍스트값 (textValue) — TEXT
  • 입력타입 (inputType) — String
  • 답장시간 (answeredAt) — LocalDateTime
  • Id (ID) — integer — Foreign key → MORNING_QUESTION.Id — NOT NULL
  • Pk (pk) — Integer — Foreign key → USER.Pk — NOT NULL

MORNING_QUESTION (Untitled11)

  • Id (ID) — integer — Primary key — NOT NULL
  • 질문날짜 (questionDate) — LocalDate
  • 내용 (content) — String
  • Pk — Integer — Foreign key → Family.Pk — NOT NULL

QUESTIONTEMPLATE (Untitled16)

  • Key — Primary key — NOT NULL
  • 타입 (metricType) — String
  • 내용 (content) — String
  • 질문타입 (answerType) — String
  • 선택지 (Choice) — json
  • 질병 (targetDisease) — String
  • 활성화 (isActive) — boolean

USER (Untitled)

  • Pk (pk) — Integer — Primary key — NOT NULL
  • 이메일 (Emal) — String
  • 이름 (Name) — String
  • 온보딩 완료 (OnboardingCompleted) — boolean
  • 초대코드 (Invitecode) — String
  • 역할 (UserRole) — Varchar
  • Pk — Integer — Foreign key → Family.Pk — NOT NULL

Untitled12

    WeeklyReport (Untitled17)

    • Key — Primary key — NOT NULL
    • 시작날짜 (weekStartDate) — LocalDate
    • 끝날짜 (weekEndDate) — LocalDate
    • 요약 (aiSummary) — text
    • 메트릭요약 (metricSummary) — json
    • isBaselineSufficient — boolean
    • Pk (pk) — Integer — Foreign key → USER.Pk — NOT NULL