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