Queensland-v1027

Tables (10)

board (Untitled10)

  • Key — Primary key — NOT NULL
  • id (Key2) — Foreign key → company.id — NOT NULL

company (Untitled3)

  • id (Key) — Primary key — NOT NULL

contract (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • id (Key222) — Foreign key → worker.id — NOT NULL
  • id (Key3) — Foreign key → worker.id — NOT NULL

farm (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → company.id — NOT NULL
  • id (Key3) — Foreign key → location.id — NOT NULL

location (Untitled6)

  • id (Key) — Primary key — NOT NULL

order (Untitled7)

  • Key — Primary key — NOT NULL
  • id (Key23) — Foreign key → farm.id — NOT NULL
  • id (Key222) — Foreign key → worker.id — NOT NULL
  • id (Key3) — Foreign key → worker.id — NOT NULL

person (Untitled9)

  • id (Key) — Primary key — NOT NULL

staff (Untitled)

  • id (Key) — Primary key — NOT NULL

team (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → company.id — NOT NULL

worker (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → team.id — NOT NULL
  • id (Key22) — Foreign key → team.id — NOT NULL
  • id (Key3) — Foreign key → person.id — NOT NULL