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