returnwork

Tables (8)

Accident Info (accident_info)

  • Id (id) — bigint — Primary key — NOT NULL
  • Department (department) — varchar(255)
  • Type (type) — varchar(255)
  • Injury Location (injury_location) — varchar(255)
  • Injury Severity (injury_severity) — varchar(255)
  • UserId (user_id) — varchar(255) — Foreign key → User.Id — NOT NULL
  • Detail (detail) — varchar(255)

Job (job)

  • Id (id) — bigint — Primary key — NOT NULL
  • Name (name) — varchar(255)
  • Code (code) — varchar(255)

Region (region)

  • Id (id) — bigint — Primary key — NOT NULL
  • Name (name) — varchar(255)

Resume (resume)

  • Id (id) — bigint — Primary key — NOT NULL
  • Question (question) — varchar(255)
  • UserId (user_id) — varchar(255) — Foreign key → User.Id — NOT NULL
  • Limit (limit) — Integer
  • JobId (job_id) — bigint — Foreign key → Job.Id — NOT NULL
  • Body (body) — text
  • AiFeedback (ai_feedback) — text
  • Note (note) — text

Survey (survey)

  • Id (id) — bigint — Primary key — NOT NULL
  • Date (date) — date
  • A1 (a1) — Integer
  • A2 (a2) — Integer
  • A3 (a3) — Integer
  • A4 (a4) — Integer
  • A5 (a5) — Integer
  • A6 (a6) — Integer
  • A7 (a7) — Integer
  • A8 (a8) — Integer
  • A9 (a9) — Integer
  • A10 (a10) — Integer
  • UserId (user_id) — varchar(255) — Foreign key → User.Id — NOT NULL

Survey Job (survey_job)

  • Id (id) — bigint — Primary key — NOT NULL
  • JobId (job_id) — bigint — Foreign key → Job.Id — NOT NULL
  • Reason (reason) — text
  • SurveyId (survey_id) — bigint — Foreign key → Survey.Id — NOT NULL

Training (training)

  • Id (id) — bigint — Primary key — NOT NULL
  • SurveyJobId (survey_job_id) — bigint — Foreign key → Survey Job.Id — NOT NULL
  • Name (name) — varchar(255)
  • Institution (institution) — varchar(255)
  • StartAt (start_at) — date
  • EndAt (end_at) — date
  • Time (time) — Integer
  • Fee (fee) — varchar(255)
  • RegionId (region_id) — bigint — Foreign key → Region.Id — NOT NULL
  • AddressSpec (address_spec) — varchar(255)

User (user)

  • Id (id) — varchar(255) — Primary key — NOT NULL
  • Name (name) — varchar(255)
  • Email (email) — varchar(255)
  • Password (password) — varchar(255)
  • Serial Id (serial_id) — varchar(255)
  • Role (role) — varchar(255)
  • Provider (provider) — varchar(255)
  • Birthday (birthday) — date
  • Career (career) — text
  • RegionId (region_id) — bigint — Foreign key → Region.Id — NOT NULL