qnd

Tables (21)

agreements (Untitled17)

  • id (agreement) — Primary key — NOT NULL
  • id (contract) — Foreign key → contracts.id — NOT NULL

bank_accounts (Untitled12)

  • bnk_acc_id (Key) — Primary key — NOT NULL
  • emp_id (int) — Foreign key → employee.emp_id — NOT NULL
  • tm_id (team) — Foreign key → employee.tm_id — NOT NULL

check_details (Untitled21)

  • id (check) — Foreign key → checks.id — NOT NULL

checks (Untitled15)

  • id (check) — Primary key — NOT NULL
  • id (contract) — Foreign key → contracts.id — NOT NULL

company (Untitled2)

  • id (company) — Primary key — NOT NULL

contracts (Untitled7)

  • id (contract) — Primary key — NOT NULL

emp_evals (Untitled16)

  • emp_eval_id (Key) — Primary key — NOT NULL
  • emp_id (int) — Foreign key → employee.emp_id — NOT NULL
  • tm_id (team) — Foreign key → employee.tm_id — NOT NULL

employee (Untitled)

  • emp_id (int) — Primary key — NOT NULL
  • tm_id (team) — Foreign key → team.tm_id — NOT NULL

farm (Untitled5)

  • frm_id (Key) — Primary key — NOT NULL
  • loc_id (Key2) — Foreign key → locations.loc_id — NOT NULL
  • id (contract) — Foreign key → locations.id — NOT NULL

guides (Untitled19)

  • id (Key) — Primary key — NOT NULL
  • id (contract) — Foreign key → contracts.id — NOT NULL

job (Untitled6)

  • dpch_id (dispatch) — Primary key — NOT NULL
  • frm_id (Key) — Foreign key → farm.frm_id — NOT NULL
  • emp_id (int) — Foreign key → employee.emp_id — NOT NULL
  • loc_id (Key2) — Foreign key → farm.loc_id — NOT NULL
  • id (contract) — Foreign key → farm.id — NOT NULL

locations (Untitled11)

  • loc_id (Key) — Primary key — NOT NULL
  • id (contract) — Foreign key → contracts.id — NOT NULL

manager (Untitled3)

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

medical (Untitled10)

  • emp_id (int) — Foreign key → employee.emp_id — NOT NULL
  • tm_id (team) — Foreign key → employee.tm_id — NOT NULL

pay_slip (Untitled13)

  • psy_id (Key) — Primary key — NOT NULL

payment (Untitled8)

  • pay_id (payment) — Primary key — NOT NULL
  • cmp_id (company) — Foreign key → company.id — NOT NULL
  • emp_id (int) — Foreign key → employee.emp_id — NOT NULL
  • psy_id (Key) — Foreign key → pay_slip.psy_id — NOT NULL

policies (Untitled14)

  • id (policy) — Primary key — NOT NULL
  • id (contract) — Foreign key → contracts.id — NOT NULL

policy_details (Untitled20)

  • id (policy_detail) — Primary key — NOT NULL
  • id (policy) — Foreign key → policies.id — NOT NULL

schedules (Untitled18)

  • id (schedule) — Primary key — NOT NULL
  • id (contract) — Foreign key → contracts.id — NOT NULL

signs (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • id (employee) — Foreign key → employee.emp_id — NOT NULL
  • id (contract) — Foreign key → contracts.id — NOT NULL
  • id (company) — Foreign key → company.id — NOT NULL
  • frm_id (Key2) — Foreign key → farm.frm_id — NOT NULL
  • loc_id (Key22) — Foreign key → farm.loc_id — NOT NULL
  • id (contract2) — Foreign key → farm.id — NOT NULL

team (Untitled4)

  • tm_id (team) — Primary key — NOT NULL
  • stf_id (staff) — Foreign key → manager.id — NOT NULL