123
Tables (4)
appointments
- id — BIGINT
- patient_id — BIGINT — NOT NULL
- doctor_id — BIGINT — NOT NULL
- appointment_date — DATETIME — NOT NULL
- department — VARCHAR(100)
- created_at — DATETIME — NOT NULL
patients
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- birth_date — DATE — NOT NULL
- gender — ENUM('M', 'F', 'Other') — NOT NULL
- phone — VARCHAR(20)
- address — VARCHAR(255)
- created_at — DATETIME — NOT NULL
staff
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- position — VARCHAR(100)
- department — VARCHAR(100)
- phone — VARCHAR(20)
- created_at — DATETIME — NOT NULL
visits
- id — BIGINT
- appointment_id — BIGINT — NOT NULL
- patient_id — BIGINT — NOT NULL
- doctor_id — BIGINT — NOT NULL
- diagnosis — TEXT
- visit_datetime — DATETIME — NOT NULL
- fee — DECIMAL(10,2) — NOT NULL
- created_at — DATETIME — NOT NULL