erp

테이블 (22)

board_comments

  • id — BIGINT — 기본 키 — NOT NULL
  • is_anonymous — BOOLEAN — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • post_id — BIGINT — 외래 키 → board_posts.id — NOT NULL
  • user_id — BIGINT — 외래 키 → 회원정보.id — NOT NULL

board_posts

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • is_anonymous — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • views — INT — NOT NULL
  • category — ENUM('NOTICE', 'FREE', 'QNA', 'DOCUMENT') — NOT NULL
  • user_id — BIGINT — 외래 키 → 회원정보.id — NOT NULL

계약 (contracts)

  • id — BIGINT — 기본 키 — NOT NULL
  • contract_date — DATE — NOT NULL
  • details — TEXT — NOT NULL
  • vendor_id — BIGINT — 외래 키 → 공급업체.id — NOT NULL

고객사 (clients)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • contact_info — VARCHAR(255) — NOT NULL

공급업체 (vendors)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • contact_info — VARCHAR(255) — NOT NULL

공지사항 (announcements)

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • posted_by — BIGINT — NOT NULL
  • posted_at — TIMESTAMP

근태 (attendance_records)

  • id — BIGINT — 기본 키 — NOT NULL
  • check_in — TIMESTAMP — NOT NULL
  • check_out — TIMESTAMP
  • employee_id — BIGINT — 외래 키 → 직원정보.id — NOT NULL

급여 (salaries)

  • id — BIGINT — 기본 키 — NOT NULL
  • employee_id — BIGINT — NOT NULL
  • base_salary — DECIMAL(10,2) — NOT NULL
  • bonus — DECIMAL(10,2)
  • tax — DECIMAL(10,2) — NOT NULL
  • net_salary — DECIMAL(10,2) — NOT NULL
  • payment_date — DATE — NOT NULL

문서 (documents)

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • uploaded_by — BIGINT — NOT NULL
  • upload_date — TIMESTAMP

부서 (departments)

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL

업무 (tasks)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • status — ENUM('PENDING', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
  • project_id — BIGINT — 외래 키 → 프로젝트.id — NOT NULL

업무할당 (task_assignments)

  • id — BIGINT — 기본 키 — NOT NULL
  • assigned_date — DATE — NOT NULL
  • status — ENUM('PENDING', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
  • employee_id — BIGINT — 외래 키 → 직원정보.id — NOT NULL
  • task_id — BIGINT — 외래 키 → 업무.id — NOT NULL

직원교육 (employee_training)

  • id — BIGINT — 기본 키 — NOT NULL
  • training_name — VARCHAR(255) — NOT NULL
  • training_date — DATE — NOT NULL
  • status — ENUM('COMPLETED', 'ONGOING', 'PLANNED') — NOT NULL
  • employee_id — BIGINT — 외래 키 → 직원정보.id — NOT NULL

직원이력 (employee_history)

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • employee_id — BIGINT — 외래 키 → 직원정보.id — NOT NULL
  • department_id — BIGINT — 외래 키 → 부서.id — NOT NULL
  • position_id — BIGINT — 외래 키 → 직책.id — NOT NULL

직원정보 (employees)

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE')
  • hire_date — DATE — NOT NULL
  • resign_date — DATE
  • user_id — BIGINT — 외래 키 → 회원정보.id — NOT NULL
  • department_id — BIGINT — 외래 키 → 부서.id — NOT NULL
  • position_id — BIGINT — 외래 키 → 직책.id — NOT NULL

직원평가 (employee_performance)

  • id — BIGINT — 기본 키 — NOT NULL
  • evaluation_date — DATE — NOT NULL
  • score — INT — NOT NULL
  • remarks — TEXT
  • employee_id — BIGINT — 외래 키 → 직원정보.id — NOT NULL

직책 (positions)

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • level — INT — NOT NULL

청구서 (invoices)

  • id — BIGINT — 기본 키 — NOT NULL
  • issue_date — DATE — NOT NULL
  • due_date — DATE — NOT NULL
  • total_amount — DECIMAL(15,2) — NOT NULL
  • status — ENUM('PENDING', 'PAID', 'OVERDUE')
  • client_id — BIGINT — 외래 키 → 고객사.id — NOT NULL

프로젝트 (projects)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • budget — DECIMAL(15,2) — NOT NULL

프로젝트 팀원 (project_members)

  • id — BIGINT — 기본 키 — NOT NULL
  • role — VARCHAR(100) — NOT NULL
  • project_id — BIGINT — 외래 키 → 프로젝트.id — NOT NULL
  • employee_id — BIGINT — 외래 키 → 직원정보.id — NOT NULL

회원정보 (users)

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • role — ENUM('ADMIN', 'EMPLOYEE', 'HR', 'ACCOUNTANT') — NOT NULL
  • created_at — TIMESTAMP

휴가 (leave_requests)

  • id — BIGINT — 기본 키 — NOT NULL
  • leave_type — ENUM('ANNUAL', 'SICK', 'UNPAID', 'OTHER') — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — ENUM('PENDING', 'APPROVED', 'REJECTED')
  • employee_id — BIGINT — 외래 키 → 직원정보.id — NOT NULL