me-dly

Tables (4)

Alarm (Untitled3)

  • alarm_id (Key) — Primary key — NOT NULL
  • morning (Field)
  • launch (Field2)
  • dinner (Field3)
  • morningAte (Field4)
  • launchAte (Field5)
  • remainingDay (Field6)
  • member_id (Key2) — Foreign key → Member.member_id — NOT NULL

Enroll (Untitled2)

  • enroll_id (Key3) — Primary key — NOT NULL
  • alarm_id (Key) — Foreign key → Alarm.alarm_id — NOT NULL
  • pill_id (Key2) — Foreign key → Pill.pill_id — NOT NULL

Member (Untitled)

  • member_id (Key) — Primary key — NOT NULL
  • loginId (Field)
  • password (Field2)
  • userName (Field3)
  • phoneNumber (Field4)
  • role (Field5)

Pill (Untitled4)

  • pill_id (Key) — Primary key — NOT NULL
  • name (Field)
  • color (Field2)
  • shape (Field3)
  • texture (Field4)
  • storeImgName (Field5)