시니어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