GIMS employeeManage

Tables (4)

department (부서)

  • department_id (부서Id) — bigint — Primary key — NOT NULL
  • department_code (부서코드) — varchar(50) — NOT NULL
  • department_alias (부서약어) — varchar(50) — NOT NULL
  • department_name (부서명) — varchar(50) — NOT NULL
  • sort_order (부서정렬순서) — integer

employee (사원)

  • employee_id (사원Id) — bigint — Primary key — NOT NULL
  • employee_login_id (사원로그인Id) — varchar(50) — NOT NULL
  • employee_number (사원번호) — varchar(6) — NOT NULL
  • employee_name (사원이름) — varchar(50) — NOT NULL
  • employee_password (사원비밀번호) — varchar(50) — NOT NULL
  • status (상태) — varchar(20) — NOT NULL
  • deleted (삭제여부) — TINYINT(1) — NOT NULL
  • login_count (로그인횟수) — integer
  • password_changed_date (비밀번호변경일) — dateTime(6) — NOT NULL
  • create_name (생성자) — varchar(50) — NOT NULL
  • last_modified_name (수정자) — varchar(50) — NOT NULL
  • create_no (생성자사원번호) — varchar(6) — NOT NULL
  • last_modified_no (수정자사원번호) — varchar(6) — NOT NULL
  • created_date (생성일) — dateTime(6) — NOT NULL
  • last_modified_date (수정일) — dateTime(6) — NOT NULL

employee_departments_position (사원_부서_직급)

  • employee_departments_position_id (사원부서직급Id) — bigint — Primary key — NOT NULL
  • department_id (부서Id) — bigint — Foreign key → department.department_id — NOT NULL
  • employee_id (사원Id) — bigint — Foreign key → employee.employee_id — NOT NULL
  • position_id (직급Id) — bigint — Foreign key → postition.position_id — NOT NULL
  • created_date (생성일) — dateTime(6) — NOT NULL
  • last_modified_date (수정일) — dateTime(6) — NOT NULL

postition (직급)

  • position_id (직급Id) — bigint — Primary key — NOT NULL
  • position_name (직급명) — varchar(30) — NOT NULL