api.ownedmaker.com
Tables (10)
Address (住所)
- id (ID) — Int — Primary key — NOT NULL
- jobId (求人ID) — INT — Foreign key → Job.id
- firmId (企業ID) — INT — Foreign key → Firm.id
- branchId (店舗ID) — INT — Foreign key → Branch.firmId
- uuid (UUID) — String — NOT NULL
- createdAt (作成日) — DateTime — NOT NULL
- updatedAt (更新日) — DateTime — NOT NULL
- prefectureType (都道府県) — Enum — NOT NULL
- city (市区町村) — String — NOT NULL
- zipcode (郵便番号) — String — NOT NULL
- building (住所詳細) — String
- station (最寄駅) — String
- access (アクセス) — String
- isMain (削除可能) — Boolean — NOT NULL
Branch (店舗)
- id (ID) — INT — Primary key — NOT NULL
- firmId (企業ID) — INT — Foreign key → Firm.id — NOT NULL
- uuid (UUID) — String — NOT NULL
- createdAt (作成日) — DateTime — NOT NULL
- updatedAt (更新日) — DateTime — NOT NULL
- name (店舗名) — Name — NOT NULL
Firm (企業(支店))
- id (ID) — INT — Primary key — NOT NULL
- uuid (UUID) — String — NOT NULL
- createdAt (作成日) — DateTime — NOT NULL
- updatedAt (更新日) — DateTime — NOT NULL
- Field
- firmId (支店ID) — INT — Foreign key → Firm.id
Job (求人)
- id (ID) — INT — Primary key — NOT NULL
- firmId (企業ID) — INT — Foreign key → Firm.id — NOT NULL
- branchId (店舗ID) — INT — Foreign key → Branch.firmId
- uuid (UUID) — STRING — NOT NULL
- createdAt (作成日) — DateTime — NOT NULL
- updatedAt (更新日) — DateTime — NOT NULL
- statusType (public/private/draft) — StatusType — NOT NULL — DBのルールはFEの検証で守る
- title (求人名) — String — NOT NULL
- workType (業種) — WorkType — NOT NULL
- jobType (職種) — JobType — NOT NULL
- employmentType (雇用形態) — EmploymentType — NOT NULL
- description (仕事内容) — String — NOT NULL
- time (勤務時間) — String — NOT NULL
- flow (仕事の流れ) — String
- holidayTypes (休日内容) — HolidayType[]
- welfareTypes (福利厚生内容) — WelfareType[]
- genderRatio (男女の割合) — Int
- workerMessage (先輩からのメッセージ) — String
JobImage (求人の画像)
- id (Key) — Primary key — NOT NULL
- jobId (求人ID) — INT — Foreign key → Job.id — NOT NULL
- uuid (Field) — NOT NULL
- createdAt (Field2) — NOT NULL
- updatedAt (Field3) — NOT NULL
- url (URL) — String — NOT NULL
- description (画像の説明) — String — NOT NULL
Name (名前)
- id (ID) — Int — Primary key — NOT NULL
- firmId (企業ID) — INT — Foreign key → Firm.id
- branchId (店舗ID) — INT — Foreign key → Branch.firmId
- uuid (UUID) — String — NOT NULL
- createdAt (Field) — DateTime — NOT NULL
- updatedAt (Field2) — DateTime — NOT NULL
- writing (書き) — String — NOT NULL
- reading (読み) — String — NOT NULL
Pay (賃金・交通費)
- id (ID) — Int — Primary key — NOT NULL
- salaryId (給料ID) — Int — Foreign key → Salary.id
- travelId (交通費ID) — Int — Foreign key → Travel.salaryId
- uuid (UUID) — String — NOT NULL
- createdAt (作成日) — DateTime — NOT NULL
- updatedAt (更新日) — DateTime — NOT NULL
- min (最低額) — Int — NOT NULL
- max (最高額) — Int — NOT NULL
- description (備考) — String
Salary (給料)
- id (ID) — Int — Primary key — NOT NULL
- jobId (求人ID) — INT — Foreign key → Job.id — NOT NULL
- uuid (UUID) — String — NOT NULL
- createdAt (作成日) — DateTime — NOT NULL
- updatedAt (更新日) — DateTime — NOT NULL
- salaryType (給与形態) — SalayType — NOT NULL
- shiftIncomeExample (シフト・収入例) — String
Travel (交通費)
- id (ID) — Int — Primary key — NOT NULL
- salaryId (給料ID) — Int — Foreign key → Salary.id — NOT NULL
- uuid (UUID) — String — NOT NULL
- createdAt (作成日) — DateTime — NOT NULL
- updatedAt (更新日) — DateTime — NOT NULL
- travelType (交通費形態) — TravelType — NOT NULL
Trial (試用・研修)
- id (ID) — Int — Primary key — NOT NULL
- jobId (求人ID) — INT — Foreign key → Job.id — NOT NULL
- description (使用/研修に関する情報) — String — NOT NULL