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