Medly
Tables (4)
ALARM_ITEM
- alarmItemId — long — Primary key — NOT NULL
- alarmListId — long — Foreign key → ALARM_LIST.alarmListId — NOT NULL
- medicineId — long — Foreign key → Medicine.medicineId — NOT NULL
- alertTime
- Field
ALARM_LIST
- alarmListId — long — Primary key — NOT NULL
- userId — long — Foreign key → USER.userId — NOT NULL
Medicine
- medicineId — long — Primary key — NOT NULL
- medicineName
- medicineColor
- medicineImage
- medicineShape (medicineShpae)
- medicineDosageForm
USER
- userId — long — Primary key — NOT NULL
- parentId — long
- loginId — VARCHAR(60)
- loginPw — VARCHAR(64)
- phoneNum