자문사(근태+임금)

테이블 (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)