software project

Tables (4)

Disease_List (Untitled3)

  • Disease_id (Key) — int — Primary key — NOT NULL
  • Name (Field) — varchar(30)
  • description (Field2) — varchar(50) — NOT NULL

Medicine_List (Untitled4)

  • Medicine_ID (Key) — int — Primary key — NOT NULL
  • Prescription_ID (Key2) — int — Foreign key → User_Prescription.Prescription_ID — NOT NULL
  • Medicine_name (Field) — varchar(30)
  • Medicine_type (Field2) — varchar(5)
  • Num_doses (Field3) — int
  • Max_dosage (Field4) — int

Member (Physical Name)

  • User_ID (Key) — int — Primary key — NOT NULL
  • Password (Field2) — int
  • Gender (Field3) — char
  • Birth_date (Field9) — date
  • Height (Field4) — double
  • Weight (Field5) — double
  • Med_User_Num_doses (Field) — int
  • Med_User_dosage (Field6) — int
  • Med_Total_quanitty (Field7) — int
  • Med_Remaining_quantity (Field8) — int
  • Cur_date (Field10) — date
  • Cur_status (Field11) — date — check로 할당 예정
  • Cur_lastcheck (Field13) — date
  • Inter_interest (Field12) — int

User_Prescription (Untitled)

  • Prescription_ID (Key) — int — Primary key — NOT NULL
  • User_ID (Key2) — int — Foreign key → Member.User_ID — NOT NULL
  • Disease_id (Key3) — int — Foreign key → Disease_List.Disease_id — NOT NULL
  • Prescribed_data (Field) — date
  • Medication_period (Field2) — int