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