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