order system

Tables (4)

appointment (CopyOfUntitled3)

  • Key — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → doctors.Key — NOT NULL
  • Key (Key3) — INT — Foreign key → patient.Key — NOT NULL
  • Field3 — DATETIME
  • Field4 — VARCHAR
  • Field5 — CHAR

department (Untitled)

  • Key — INT — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2 — VARCHAR

doctors (CopyOfUntitled)

  • Key — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → department.Key — NOT NULL
  • Field2 — VARCHAR
  • Field3 — VARCHAR
  • Field4 — CHAR

patient (CopyOfUntitled2)

  • Key — INT — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2 — DATE
  • Field3 — CHAR
  • Field4 — VARCHAR
  • Field5 — CHAR