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