erd
Tables (10)
Board
- board_id — INT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- emp_idx — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- view_count — INT
- is_deleted — BOOLEAN
- f_name — VARCHAR(255)
- importance — ENUM('중요','일반') — NOT NULL
Comment
- comment_id — INT
- board_id — INT — NOT NULL
- emp_idx — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- is_deleted — BOOLEAN
Permission
- emp_idx — VARCHAR(50)
- can_access_employee — INT
- can_access_worktype — INT
- can_access_personnel — INT
- can_access_salary — INT
- can_access_vacation — INT
PersonnelChange
- change_id — INT
- emp_idx — VARCHAR(50)
- change_type — ENUM('사내', '전출') — NOT NULL
- change_date — DATE
- prev_dept_id — VARCHAR(10)
- new_dept_id — VARCHAR(10)
- Employment_type — ENUM('정규직','계약직','아르바르이트')NOT — NOT NULL
Salary
- salary_id — INT
- emp_idx — VARCHAR(50)
- pay_grade — INT
- base_salary — INT
- bonus — int
- payment_date — DATE
Vacation
- vacation_id — INT
- emp_idx — VARCHAR(50)
- vacation_type — ENUM('연차','공가')NOT — NOT NULL
- start_date — DATE
- end_date — DATE
- vacation_day — INT
- coment — TEXT
- status — ENUM('승인', '대기', '반려')
calender
- calender_idx — INT
- emp_idx — VARCHAR(50)
- title — VARCHAR(100)
- comment — TEXT — EX
employee
- emp_idx — VARCHAR(50)
- user_idx — int — NOT NULL
- emp_id — VARCHAR(50)
- emp_password — VARCHAR(100) — NOT NULL
- dept_name — ENUM('직원', '대기','관리자','슈퍼관리자') — NOT NULL
- position — VARCHAR(50)
- pay_grade — INT
- hire_date — DATE
- resignation_date — DATE
- attitude_type — ENUM('출장', '재택', '회사') — NOT NULL
- quitter — ENUM('입사','퇴사','퇴사대기') — NOT NULL
user
- user_idx — int
- emp_email — VARCHAR(255)UNIQUE — NOT NULL
- emp_name — VARCHAR(50) — NOT NULL
- emp_password — VARCHAR(100) — NOT NULL
- home — VARCHAR(200) — NOT NULL
- detail_home — VARCHAR(200)
- phone_number — VARCHAR(50) — NOT NULL
worktype
- worktype_id — INT
- emp_idx — VARCHAR(50)
- worktype — ENUM('조퇴','지각','정상출근')
- start_date — DATE
- end_date — DATE
- demerit — INT
- job — TEXT