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