밥먹자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