밥먹자2

테이블 (6)

attendance_photos

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • action_type — VARCHAR(20) — NOT NULL
  • face_match_score — DECIMAL(5,2)
  • ai_verify_result — VARCHAR(20)
  • captured_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

attendance_records

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • work_date — DATE — NOT NULL
  • check_in_time — DATETIME
  • check_out_time — DATETIME
  • check_in_gps_log_id — BIGINT — 외래 키 → gps_logs.id
  • check_out_gps_log_id — BIGINT — 외래 키 → gps_logs.id
  • check_in_photo_id — BIGINT — 외래 키 → attendance_photos.id
  • check_out_photo_id — BIGINT — 외래 키 → attendance_photos.id
  • status — VARCHAR(20) — NOT NULL
  • memo — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

gps_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • work_location_id — BIGINT — 외래 키 → work_locations.id
  • latitude — DECIMAL(10,7) — NOT NULL
  • longitude — DECIMAL(10,7) — NOT NULL
  • accuracy — DECIMAL(8,2)
  • verified_yn — TINYINT(1) — NOT NULL
  • verified_at — DATETIME
  • action_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notices

  • id — BIGINT — 기본 키 — NOT NULL
  • writer_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • is_important — TINYINT(1) — NOT NULL
  • is_visible — TINYINT(1) — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • employee_no — VARCHAR(30) — NOT NULL
  • phone — VARCHAR(20)
  • department — VARCHAR(50)
  • position — VARCHAR(50)
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

work_locations

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • latitude — DECIMAL(10,7) — NOT NULL
  • longitude — DECIMAL(10,7) — NOT NULL
  • allowed_radius_m — INT — NOT NULL
  • active_yn — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL