시니어ON

테이블 (15)

Alert (Untitled12)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (alertType)
  • String (title) — VARCHAR(100)
  • String (content) — VARCHAR(500)
  • String (status) — VARCHAR(20)
  • Double (latitude) — DOUBLE
  • Double (longitude) — DOUBLE
  • LocalDateTime (createdAt) — DATETIME
  • Long (seniorId) — BIGINT — 외래 키 → User.Long

AlertSetting (Untitled11)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • Boolean (sosEnabled) — BOOLEAN
  • Boolean (inactivityEnabled) — BOOLEAN
  • Integer (inactivityHours) — INT
  • Boolean (dangerousLinkEnabled) — BOOLEAN
  • Boolean (medicationAlertEnabled) — BOOLEAN
  • Long (seniorId) — BIGINT — 외래 키 → User.Long

AppShortcut (Untitled6)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (appName) — VARCHAR(100)
  • String (appIconUrl) — VARCHAR(500)
  • String (packageName) — VARCHAR(100)
  • Integer (displayOrder) — INT
  • Long (seniorId) — BIGINT — 외래 키 → User.Long

DangerousLinkLog (Untitled15)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (url) — VARCHAR(1000)
  • String (riskLevel) — VARCHAR(20)
  • String (description) — VARCHAR(500)
  • LocalDateTime (detectedAt) — DATETIME
  • Long (seniorId) — BIGINT — 외래 키 → User.Long

FamilyGroup (Untitled2)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (familyCode) — VARCHAR(20)
  • String (groupName) — VARCHAR(50)
  • LocalDateTime (createdAt) — DATETIME
  • Long (ownerId) — BIGINT — 외래 키 → User.Long

FamilyMember (Untitled3)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (familyRole) — VARCAHR(20)
  • Boolean (isCareManager) — Boolean
  • Boolean (isSubscriptionManager) — Boolean
  • LocalDateTime (joinedAt) — DATETIME
  • Long (userId) — BIGINT — 외래 키 → User.Long
  • Long (familyGroupId) — BIGINT — 외래 키 → FamilyGroup.Long — NOT NULL

FamilyPhoto (Untitled4)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (imageUrl) — VARCHAR(500)
  • String (caption) — VARCHAR(255)
  • Boolean (sharedToSenior) — BOOLEAN
  • LocalDateTime (createdAt) — DATETIME
  • Long (uploaderId) — BIGINT — 외래 키 → FamilyGroup.Long — NOT NULL
  • Long (familyGroupId) — BIGINT — 외래 키 → FamilyMember.Long — NOT NULL

HealthGoal (Untitled14)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (goalType) — VARCHAR(20)
  • Integer (targetValue) — INT
  • Integer (currentValue) — INT
  • LocalDate (goalDate) — DATE
  • Long (seniorId) — BIGINT — 외래 키 → User.Long

HomeLayout (Untitled7)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (buttonType) — VARCHAR(30)
  • Integer (xPosition) — INT
  • Integer (yPosition) — INT
  • Integer (size) — INT
  • Long (seniorId) — BIGINT — 외래 키 → User.Long

HospitalSchedule (Untitled13)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (hospitalName) — VARCHAR(100)
  • String (department) — VARCHAR(50)
  • LocalDate (visitDate) — DATE
  • Time (visitTime) — TIME
  • String (memo) — VARCHAR(500)
  • Boolean (alarmEnabled) — BOOLEAN
  • Long (seniorId) — BIGINT — 외래 키 → User.Long

Inquiry (Untitled5)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (title) — VARCHAR(100)
  • String (content) — TEXT
  • String (status) — VARCHAR(20)
  • LocalDateTime (createdAt) — DATETIME
  • Long (userId) — BIGINT — 외래 키 → User.Long

Medication (Untitled8)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • String (name) — VARCHAR(100)
  • String (memo) — VARCHAR(500)
  • LocalDate (startDate) — DATE
  • LocalDate (endDate) — DATE
  • LocalDateTime (createdAt) — DATETIME
  • Long (seniorId) — BIGINT — 외래 키 → User.Long

MedicationLog (Untitled10)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • LocalDate (takenDate) — DATE
  • Time (takenTime) — TIME
  • Boolean (isTaken) — BOOLEAN
  • Long (medicationId) — BIGINT — 외래 키 → Medication.Long — NOT NULL

MedicationSchedule (Untitled9)

  • Long (id) — BIGINT — 기본 키 — NOT NULL
  • Time (takeTime) — TIME
  • String (repeatDays) — VARCHAR(50)
  • Boolean (alarmEnabled) — BOOLEAN
  • Long (medicationId) — BIGINT — 외래 키 → Medication.Long — NOT NULL

User (Untitled)

  • Long (id) — BIGINT — 기본 키
  • String (email) — VARCHAR(255)
  • String (password) — VARCHAR(255)
  • String (name) — VARCHAR(50)
  • String (phone) — VARCHAR(20)
  • String (role) — VARCHAR(20)
  • String (profileImageUrl) — VARCHAR(500)
  • LocalDateTime (createdAt) — DATETIME
  • LocalDateTime (updateAt) — DATETIME