모의해킹 프로젝트
테이블 (15)
approval_attachments
- id — BIGINT
- document_id — BIGINT — 외래 키 → approval_documents.id — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- storage_path — VARCHAR(500) — NOT NULL
approval_documents
- id — BIGINT
- owner_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- approval_type — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- current_approver_user_id — BIGINT — 외래 키 → users.id
- requested_at — DATETIME — NOT NULL
- decided_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
approval_lines
- id — BIGINT
- document_id — BIGINT — 외래 키 → approval_documents.id — NOT NULL
- step_order — INT — NOT NULL
- approver_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- acted_at — DATETIME
certificate_requests
- id — BIGINT
- requester_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- target_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- certificate_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- requested_at — DATETIME — NOT NULL
certificates
- id — BIGINT
- owner_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- certificate_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- storage_path — VARCHAR(500) — NOT NULL
- issued_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
departments
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- manager_user_id — BIGINT
- internal_code — VARCHAR(50)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
document_permissions
- id — BIGINT
- document_id — BIGINT — 외래 키 → documents.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id
- department_id — BIGINT — 외래 키 → departments.id
- permission_type — VARCHAR(30) — NOT NULL
documents
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- content — TEXT
- file_name — VARCHAR(255)
- storage_path — VARCHAR(500)
- owner_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- department_id — BIGINT — 외래 키 → departments.id — NOT NULL
- access_level — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
leave_requests
- id — BIGINT
- approval_document_id — BIGINT — 외래 키 → approval_documents.id — NOT NULL
- leave_type — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
login_audit
- id — BIGINT
- user_id — BIGINT — 외래 키 → users.id
- username_input — VARCHAR(100) — NOT NULL
- ip_address — VARCHAR(50) — NOT NULL
- user_agent — VARCHAR(255) — NOT NULL
- success — BOOLEAN — NOT NULL
- failure_reason — VARCHAR(100)
- session_id_before — VARCHAR(255)
- session_id_after — VARCHAR(255)
- attempted_at — DATETIME — NOT NULL
meeting_room_requests
- id — BIGINT
- approval_document_id — BIGINT — 외래 키 → approval_documents.id — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
- reservation_date — DATE — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
notice_attachments
- id — BIGINT
- notice_id — BIGINT — 외래 키 → notices.id — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- storage_path — VARCHAR(500) — NOT NULL
- mime_type — VARCHAR(100)
notices
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- summary — TEXT
- content — TEXT — NOT NULL
- category — VARCHAR(30) — NOT NULL
- visibility_scope — VARCHAR(30) — NOT NULL
- pinned — BOOLEAN — NOT NULL
- author_id — BIGINT — 외래 키 → users.id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
payslips
- id — BIGINT
- owner_user_id — BIGINT — 외래 키 → users.id — NOT NULL
- pay_period — VARCHAR(7) — NOT NULL
- gross_pay — DECIMAL(15, 2) — NOT NULL
- net_pay — DECIMAL(15, 2) — NOT NULL
- salary_account_last4 — VARCHAR(4)
- file_name — VARCHAR(255)
- storage_path — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT
- password_hash — VARCHAR(255) — NOT NULL
- employee_number — VARCHAR(50) — NOT NULL
- display_name — VARCHAR(100) — NOT NULL
- email — VARCHAR(150) — NOT NULL
- phone_number — VARCHAR(50) — NOT NULL
- role — VARCHAR(30) — NOT NULL
- department_id — BIGINT — 외래 키 → departments.id — NOT NULL
- job_title — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- salary_grade — VARCHAR(50)
- hr_note — TEXT
- last_login_at — DATETIME
- last_login_ip — VARCHAR(50)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL