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