모의해킹 프로젝트

테이블 (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