자문사(근태+임금)
테이블 (15)
advice_requests
- id — bigint(20) — 기본 키 — NOT NULL
- company_id — bigint(20) — 외래 키 → companies.id — NOT NULL
- title — varchar(255) — NOT NULL
- status — int(11) — NOT NULL
- request_date — datetime
- created_at — timestamp
- updated_at — timestamp
allowances
- id — bigint(20) — 기본 키 — NOT NULL
- employee_id — bigint(20) — 외래 키 → employees.id — NOT NULL
- wage_id — bigint(20) — 외래 키 → wages.id — NOT NULL
- status — int(11) — NOT NULL
- normal_wage — decimal(15,0)
- normal — decimal(15,0)
- fixed_allowance_1 — decimal(15,0)
- fixed_allowance_2 — decimal(15,0)
- fixed_allowance_3 — decimal(15,0)
- fixed_extension_allowance — decimal(15,0)
- overtime_allowance — decimal(15,0)
- holiday_allowance — decimal(15,0)
- nighttime_allowance — decimal(15,0)
- holiday_extension_allowance — decimal(15,0)
- weekly_vacation_pay — decimal(15,0)
- annual_allowance — decimal(15,0)
- non_taxable_overtime_work_allowance — decimal(15,0)
- meals — decimal(15,0)
- vehicle_subsidy — decimal(15,0)
- incentive — decimal(15,0)
- bonus — decimal(15,0)
- other_1 — decimal(15,0)
- other_2 — decimal(15,0)
- settlement — decimal(15,0)
- absence_deduction — decimal(15,0)
- total_salary — decimal(15,0)
- income_tax — decimal(15,0)
- resident_tax — decimal(15,0)
- national_pension — decimal(15,0)
- health_insurance — decimal(15,0)
- long_term_care_insurance_for_the_elderly — decimal(15,0)
- employment_insurance — decimal(15,0)
- health_insurance_support_settlement — decimal(15,0)
- employment_insurance_support_settlement — decimal(15,0)
- income_tax_year_end_settlement — decimal(15,0)
- other_withholding_tax — decimal(15,0)
- other_settlement — decimal(15,0)
- deduction_system — decimal(15,0)
- actual_payment — decimal(15,0)
- retirement_pension_contribution — decimal(15,0)
- specifics_for_the_month — varchar(255)
- created_at — timestamp
- updated_at — timestamp
- pay_stub — varchar(255)
attendances
- id — bigint(20) — 기본 키 — NOT NULL
- employee_id — bigint(20) — 외래 키 → employees.id — NOT NULL
- status — int(11) — NOT NULL
- memo — varchar(255)
- day — int(11) — NOT NULL
- month — int(11) — NOT NULL
- year — int(11) — NOT NULL
- is_temporary — tinyint(1)
- created_at — timestamp
- updated_at — timestamp
- startup — int(11)
- closing — int(11)
- recess — int(11)
companies
- id — bigint(20) — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
employees
- id — bigint(20) — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
- resident_registration_number — varchar(255) — NOT NULL
- division — int(11) — NOT NULL
- entered_date — datetime — NOT NULL
- labor_contract_end_date — datetime
- created_at — timestamp
- updated_at — timestamp
- distribution — int(11) — NOT NULL
- company_id — bigint(20) — 외래 키 → companies.id — NOT NULL
failed_jobs
- id — bigint(20) — 기본 키 — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
migrations
- id — int(10) — 기본 키 — NOT NULL
- migration — varchar(255) — NOT NULL
- batch — int(11) — NOT NULL
oauth_access_tokens
- id — varchar(100) — 기본 키 — NOT NULL
- user_id — bigint(20)
- client_id — bigint(20) — NOT NULL
- name — varchar(255)
- scopes — text
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- expires_at — datetime
oauth_auth_codes
- id — varchar(100) — 기본 키 — NOT NULL
- user_id — bigint(20) — NOT NULL
- client_id — bigint(20) — NOT NULL
- scopes — text
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
oauth_clients
- id — bigint(20) — 기본 키 — NOT NULL
- user_id — bigint(20)
- name — varchar(255) — NOT NULL
- secret — varchar(100)
- redirect — text — NOT NULL
- personal_access_client — tinyint(1) — NOT NULL
- password_client — tinyint(1) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_personal_access_clients
- id — bigint(20) — 기본 키 — NOT NULL
- client_id — bigint(20) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
oauth_refresh_tokens
- id — varchar(100) — 기본 키 — NOT NULL
- access_token_id — varchar(100) — NOT NULL
- revoked — tinyint(1) — NOT NULL
- expires_at — datetime
password_resets
- email — varchar(255) — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
users
- id — bigint(20) — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- email_verified_at — timestamp
- password — varchar(255) — NOT NULL
- remember_token — varchar(100)
- created_at — timestamp
- updated_at — timestamp
- isAdvisorCompany — tinyint(1) — NOT NULL
- isLaborCorporation — tinyint(1) — NOT NULL
- isManager — tinyint(1) — NOT NULL
wages
- id — bigint(20) — 기본 키 — NOT NULL
- year — int(11) — NOT NULL
- month — int(11) — NOT NULL
- status — int(11) — NOT NULL
- request_date — datetime
- process_date — datetime
- reason — varchar(255)
- created_at — timestamp
- updated_at — timestamp
- company_id — bigint(20) — 외래 키 → companies.id
- upload_file — varchar(255)