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)