d

Tables (4)

camera

  • camera_id — Primary key — NOT NULL
  • station_id — Foreign key → station.station_id — NOT NULL

employee

  • employee_id — Primary key — NOT NULL
  • camera_id — Foreign key → camera.camera_id — NOT NULL
  • station_id — Foreign key → camera.station_id — NOT NULL
  • work_id — Foreign key → station_work.work_id — NOT NULL

station

  • station_id — Primary key — NOT NULL

station_work

  • work_id — Primary key — NOT NULL