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