medicine
Tables (3)
Search (Untitled2)
- User_ID (Key) — Foreign key → customer_ID.User_ID — NOT NULL
- Pharmacy_ID (Key2) — Foreign key → pharmacy_table.Pharmacy_ID — NOT NULL
customer_ID (Untitled)
- User_ID (Key) — Primary key — NOT NULL
- User_PW (Field)
- User_Nickname (Field2)
- User_Position (Field3)
pharmacy_table (Untitled3)
- Pharmacy_ID (Key) — Primary key — NOT NULL
- Pharmacy_PW (Field)
- Pharmacy_address (Field2)
- Pharmacy_Name (Field3)