[sql] TABLE

Viewer

  1. +-------------+       +-------------+       +-------------+       +-------------+
  2. |   Client    |       |   Booking   |       |   Lesson    |       |   Staff     |
  3. +-------------+       +-------------+       +-------------+       +-------------+
  4. | Client_ID   |-------| Booking_ID  |-------| Lesson_ID   |       | Staff_ID    |
  5. | Name        |       | Client_ID   |       | Name        |       | Name        |
  6. | Contact     |       | Lesson/     |       | Description |       | Contact     |
  7. | Details     |       | Event_ID    |       +-------------+       +-------------+
  8. +-------------+       | Date        |
  9.                       | TIME        |
  10.                       +-------------+
  11.                              |
  12.                              |
  13.                              |
  14.                              V
  15.                       +-------------+
  16.                       | Availability|
  17.                       +-------------+
  18.                       | Staff_ID    |
  19.                       | DATE        |
  20.                       | TIME        |
  21.                       +-------------+
  22.                              |
  23.                              |
  24.                              |
  25.                              V
  26.                       +-------------+
  27.                       |  Schedule   |
  28.                       +-------------+
  29.                       | Staff_ID    |
  30.                       | Booking_ID  |
  31.                       +-------------+
  32.  

Editor

You can edit this paste and save as new:


File Description
  • TABLE
  • Paste Code
  • 18 Apr-2024
  • 1.43 Kb
You can Share it: