BST2

Tables (6)

Diagnostic Info (diagnostic_info)

  • Diagnostic Id (diagnostic _id) — INT(11) — Primary key — NOT NULL
  • Doctor id (doctor_id) — INT(11) — Foreign key → Doctor Info.Doctor id — NOT NULL
  • Patient Id (patient_id) — INT(11) — Foreign key → Patient Info.Patient Id — NOT NULL
  • Diagnostic Date (diagnostic_date) — CHAR(8)
  • Category (category) — VARCHAR(255)

Doctor Info (doctor_info)

  • Doctor id (doctor_id) — INT(11) — Primary key — NOT NULL
  • Password (password) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Major (major) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Call (call) — VARCHAR(20)

Exercise Result (exercise_result)

  • Result Id (result_id) — INT(11) — Primary key — NOT NULL
  • Patient Id (patient_id) — INT(11) — Foreign key → Patient Info.Patient Id — NOT NULL
  • Exercise Date (exercise_date) — CHAR(8)
  • Result1 (result1) — VARCHAR(255)
  • Result2 (result2) — VARCHAR(255)

Log Info (log_info)

  • Log Id (log_id) — INT(11) — Primary key — NOT NULL
  • Date (date) — CHAR(8)
  • Type (type) — VARCHAR(10)
  • Content (content) — VARCHAR(255)

NFC Info (nfc_info)

  • Nfc id (nfc_id) — INT(11) — Primary key — NOT NULL
  • Number (number) — INT(3)
  • Doctor id (doctor_id) — INT(11) — Foreign key → Doctor Info.Doctor id — NOT NULL
  • Patient Id (patient_id) — INT(11) — Foreign key → Patient Info.Patient Id — NOT NULL

Patient Info (patient_info)

  • Patient Id (patient_id) — INT(11) — Primary key — NOT NULL
  • Password (password) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Birthday (birthday) — CHAR(8)
  • Gender (gender) — CHAR(1)
  • Phone (phone) — VARCHAR(20)
  • Doctor id (doctor_id) — INT(11) — Foreign key → Doctor Info.Doctor id — NOT NULL