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