사내 근태

테이블 (7)

attendances

  • id — bigint(20) — 기본 키 — NOT NULL — 인덱스
  • user_id — int(11) — 외래 키 → users.id — NOT NULL
  • name — varchar(255) — NOT NULL — 이름
  • record_date — varchar(255) — NOT NULL — 날짜
  • record_time — varchar(255) — NOT NULL — 시간
  • created_at — timestamp
  • updated_at — timestamp

failed_jobs

  • id — bigint(20) — 기본 키 — NOT NULL
  • uuid — varchar(255) — 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

password_resets

  • email — varchar(255) — 기본 키 — NOT NULL
  • token — varchar(255) — NOT NULL
  • created_at — timestamp

personal_access_tokens

  • id — bigint(20) — 기본 키 — NOT NULL
  • tokenable_type — varchar(255) — NOT NULL
  • tokenable_id — bigint(20) — NOT NULL
  • name — varchar(255) — NOT NULL
  • token — varchar(64) — NOT NULL
  • abilities — text
  • last_used_at — timestamp
  • expires_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

sessions

  • id — varchar(255) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 → users.id — NOT NULL
  • ip_address — varchar(45)
  • user_agent — text
  • payload — longtext — NOT NULL
  • last_activity — int(11) — NOT NULL

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
  • two_factor_secret — text
  • two_factor_recovery_codes — text
  • two_factor_confirmed_at — timestamp
  • remember_token — varchar(100)
  • current_team_id — bigint(20)
  • profile_photo_path — varchar(2048)
  • created_at — timestamp
  • updated_at — timestamp
  • google_id — varchar(255)
  • provider — varchar(255) — NOT NULL