harbor
Tables (13)
Annual
- annual_id — bigint — Primary key — NOT NULL
- attendence_id — bigint — Foreign key → Attendance.attendence_id — NOT NULL
- annual_count — tinyint(3) — 연차 변동 발생시 +- 값을 담아줄 컬럼
- adjustment_date — date
- adjustment_end_date — date
- adjustment_comment — varchar(255) — NOT NULL
- adjustment_delYn — enum("Y", "N")
- first_sign_id — varchar(20)
- second_sign_id — varchar(20)
- third_sign_id — varchar(20)
- first_approval_date — datetime
- second_approval_date — datetime
- third_approval_date — datetime
Attendance
- attendence_id — bigint(20) — Primary key — NOT NULL
- employee_id — int(8) — Foreign key → Employee.employee_id — NOT NULL
- work_start_time — time — NOT NULL — 근로계약서(유저 정보)에 등록된 출근 시간
- work_end_time — time — 근로계약서(유저 정보)에 등록된 퇴근 시간
- work_policy — code_num — 고정 / 시차 / 휴가, 출장 고정 : 9시~6시 시차 : 8시부터 10시 30 분 단위 휴가: 휴가 출장: 출장
- Field — Date
- createAt — dateTime
- updateAt — dateTime
Commute
- id — bigint — Primary key — NOT NULL
- employee_id — int(8) — Foreign key → Employee.employee_id — NOT NULL
- attendence_time — datetime
- leavework_time — datetime
- attendance_date — datetime
Department
- department_code — code_num
- high_department_code — code_num
Employee
- employee_id — int(8) — Primary key — NOT NULL
- email — varchar(50)
- name — varchar(20)
- team_code — code_num
- annual_remain — double
- department_code — code_num
- position_code — code_num
Employee1
- employee_id — int(8) — Primary key — NOT NULL
- department_code — code_num — Foreign key → Department.department_code
- team_code — code_num
- position_code — code_num — NOT NULL
- duty_code — code_num — NOT NULL — ex) 백엔드 개발, 프론트엔드 개발
- status_code — code_num — 재직자, 퇴사자, 휴직자 필터 처리를 위한 컬럼
- gender_code — code_num — NOT NULL
- profile_image — url
- email — varchar(50) — NOT NULL — 유저별 이메일 주소 (중복 x)
- name — varchar(10) — NOT NULL — 사원 이름
- birth_date — date — NOT NULL — YYYY-mm-DD 형식으로 저장
- careerymd — int(4) — NOT NULL — x년 x개월차 형식으로 표시
- join_date — date — NOT NULL
- update_date — date — NOT NULL — 퇴사 신청한 날짜
- reason_for_resignation — varchar(255) — nullable한 값
- leaving_date — date
- address — varchar(255) — NOT NULL — 거주지
- bank_code — code_num — 하나은행, SC제일은행, 국민은행, 신한은행, 우리은행, 씨티은행, IBK기업은행, 농협, 수협, 한국산업은행, 한국수출입은행, etc...
- phone — varchar(15) — NOT NULL — 전화번호 00000000000 형식으로 저장
- social_security_number — varchar(14) — NOT NULL — 000000-0000000 형식으로 저장
- account_number — varchar(50)
EmployeeCode
- code_num — varchar(10) — Primary key — NOT NULL
- code_name — varchar(10)
PA
- appointment_id — bigint(20) — Primary key — NOT NULL
- employee_id — int(8) — Foreign key → Employee1.employee_id — NOT NULL
- update_duty_code — code_num
- before_department_code — code_num
- after_department_code — code_num
- position_code — code_num
- issue_date — date
- del_yn — enum("y","n")
Salary
- salary_id — bigint(20) — Primary key — NOT NULL
- position_code — varchar — Foreign key → SalaryTable.code_num
- employee_id — varchar(10)
- salary_month_of_year — date
- salary_gross — int(10)
SalaryTable
- code_num — varchar(20)
- position — varchar(10)
- base_salary — int(10)
Schedule
- schedule_id — bigint(20) — Primary key — NOT NULL
- employee_id — int(8) — Foreign key → Employee1.employee_id — NOT NULL
- schedule_start_date — date
- schedule_end_date — date
- schedule_start_time — time
- schedule_end_time — time
- schedule_title — varchar(50)
- schedule_comment — varchar(255)
- schedule_color — varchar(255)
- del_yn — enum("y""N")
- Field — VARCHAR(255)
Untitled15
- notice_id — bigint(20) — Primary key — NOT NULL
- notice_title — varchar(255)
- notice_content — varchar(255)
- notice_date — date
- image_url — url
Untitled6
- email — varchar(50) — Primary key — NOT NULL
- employee_id — varchar(20) — 8자리 랜덤 숫자(중복 x)
- name — varchar(20) — NOT NULL
- password — varchar(20)
- delyn — boolean — 최초 회원가입 후 승인권자에 의해 사원번호가 생성되면 승인여부가 Y로 변경
- birth — date
- role — enum(ADMIN, USER)
- createdAt — dateTime
- updateAt — dateTime