사내 근태
테이블 (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