Crews
Generated schema file.
Columns
| Name | Type | References | |
| Id [KEY] | String | ||
| UserId | String | ||
| BizEstablishmentId | String | ||
| EmpCode | String | ||
| EmploymentTypeId | String | ||
| EmploymentTypeName | String | ||
| EmploymentTypePresetType | String | ||
| EmploymentTypeCreatedAt | Datetime | ||
| EmploymentTypeUpdatedAt | Datetime | ||
| EmpStatus | String | ||
| LastName | String | ||
| FirstName | String | ||
| LastNameYomi | String | ||
| FirstNameYomi | String | ||
| BusinessLastName | String | ||
| BusinessFirstName | String | ||
| BusinessLastNameYomi | String | ||
| BusinessFirstNameYomi | String | ||
| BirthAt | Date | ||
| Gender | String | ||
| IdentityCardImage1FileName | String | ||
| IdentityCardImage1Url | String | ||
| IdentityCardImage2FileName | String | ||
| IdentityCardImage2Url | String | ||
| TelNumber | String | ||
| AddressId | String | ||
| AddressCountryNumber | String | ||
| AddressZipCode | String | ||
| AddressPref | String | ||
| AddressCity | String | ||
| AddressStreet | String | ||
| AddressBuilding | String | ||
| AddressLiteralYomi | String | ||
| AddressImageFileName | String | ||
| AddressImageUrl | String | ||
| AddressHeadOfFamily | String | ||
| AddressRelationName | String | ||
| String | |||
| ProfileImages | String | ||
| EmergencyRelationName | String | ||
| EmergencyLastName | String | ||
| EmergencyFirstName | String | ||
| EmergencyLastNameYomi | String | ||
| EmergencyFirstNameYomi | String | ||
| EmergencyTelNumber | String | ||
| EmergencyAddressId | String | ||
| EmergencyAddressCountryNumber | String | ||
| EmergencyAddressZipCode | String | ||
| EmergencyAddressPref | String | ||
| EmergencyAddressCity | String | ||
| EmergencyAddressStreet | String | ||
| EmergencyAddressBuilding | String | ||
| EmergencyAddressLiteralYomi | String | ||
| ResidentCardAddressId | String | ||
| ResidentCardAddressCountryNumber | String | ||
| ResidentCardAddressZipCode | String | ||
| ResidentCardAddressPref | String | ||
| ResidentCardAddressCity | String | ||
| ResidentCardAddressStreet | String | ||
| ResidentCardAddressBuilding | String | ||
| ResidentCardAddressLiteralYomi | String | ||
| ResidentCardAddressHeadOfFamily | String | ||
| ResidentCardAddressRelationName | String | ||
| Position | String | ||
| PositionId1 | String | ||
| PositionName1 | String | ||
| PositionRank1 | String | ||
| PositionCode1 | String | ||
| PositionCreatedAt1 | Date | ||
| PositionId2 | String | ||
| PositionName2 | String | ||
| PositionRank2 | String | ||
| PositionCode2 | String | ||
| PositionCreatedAt2 | Date | ||
| PositionId3 | String | ||
| PositionName3 | String | ||
| PositionRank3 | String | ||
| PositionCode3 | String | ||
| PositionCreatedAt3 | Date | ||
| Occupation | String | ||
| EnteredAt | Date | ||
| ResignedAt | Date | ||
| ResignedReason | String | ||
| Resume1FileName | String | ||
| Resume1Url | String | ||
| Resume2FileName | String | ||
| Resume2Url | String | ||
| EmpInsInsuredPersonNumber | String | ||
| EmpInsQualifiedAt | Date | ||
| EmpInsDisqualifiedAt | Date | ||
| SocInsInsuredPersonNumber | Integer | ||
| HelInsInsuredPersonNumber | Integer | ||
| BasicPensionNumber | String | ||
| SocInsQualifiedAt | Date | ||
| SocInsDisqualifiedAt | Date | ||
| HavingSpouse | Boolean | ||
| SpouseYearlyIncome | Integer | ||
| MonthlyIncomeCurrency | Integer | ||
| MonthlyIncomeGoods | Integer | ||
| PaymentPeriodId | String | ||
| PaymentPeriodName | String | ||
| PaymentPeriodPeriodType | String | ||
| PaymentPeriodCreatedAt | Datetime | ||
| PaymentPeriodUpdatedAt | Datetime | ||
| MonthlyStandardIncomeUpdatedAt | Date | ||
| MonthlyStandardIncomeHel | Integer | ||
| MonthlyStandardIncomePns | Integer | ||
| NearestStationAndLine | String | ||
| Commutation1Expenses | Integer | ||
| Commutation1Period | String | ||
| Commutation1SingleFare | Integer | ||
| Commutation2Expenses | Integer | ||
| Commutation2Period | String | ||
| Commutation2SingleFare | Integer | ||
| ForeignResidentLastName | String | ||
| ForeignResidentFirstName | String | ||
| ForeignResidentMiddleName | String | ||
| ForeignResidentCardNumber | String | ||
| ForeignResidentCardImage1FileName | String | ||
| ForeignResidentCardImage1Url | String | ||
| ForeignResidentCardImage2FileName | String | ||
| ForeignResidentCardImage2Url | String | ||
| NationalityCode | String | ||
| ResidentEndAt | Date | ||
| HavingExActivityPermission | String | ||
| OtherBeWorkableType | String | ||
| BankAccounts | String | ||
| Departments | String | ||
| ContractType | String | ||
| ContractStartOn | Date | ||
| ContractEndOn | Date | ||
| ContractRenewalType | String | ||
| HandicappedType | String | ||
| HandicappedImageFileName | String | ||
| HandicappedImageUrl | String | ||
| WorkingStudentIncome | Integer | ||
| SchoolName | String | ||
| StudentCardImageFileName | String | ||
| StudentCardImageUrl | String | ||
| EnrolledAt | Date | ||
| WorkingStudentFlag | Boolean | ||
| EmploymentIncomeFlag | Boolean | ||
| BusinessIncomeFlag | Boolean | ||
| DevidendIncomeFlag | Boolean | ||
| EstateIncomeFlag | Boolean | ||
| WidowType | String | ||
| WidowReasonType | String | ||
| WidowMemo | String | ||
| CustomFields | String | ||
| CreatedAt | Datetime | ||
| UpdatedAt | Datetime | ||
| Query | String |