InnoChecck
Tables (4)
Company (Untitled2)
- 회사ID (company_id) — NOT NULL — Primary key — NOT NULL
- 회사명 (company_name)
- 회사주소 (address) — NOT NULL
- Field
Department (Untitled3)
- 부서번호 (dep_id) — NOT NULL — Primary key — NOT NULL
- 부서명 (dep_name) — NOT NULL
Department_Mapping (Untitled4)
- 회원ID (user_id) — Foreign key → User.사원ID — NOT NULL
- 부서번호 (dep_id) — NOT NULL — Foreign key → Department.부서번호 — NOT NULL
- Field
User (Untitled)
- 사원ID (emp_id) — Primary key — NOT NULL
- 이름 (empname) — NOT NULL
- 비밀번호 (password) — NOT NULL
- 휴대폰번호 (phone) — NOT NULL
- 이메일 (email) — NOT NULL
- 권한 (role) — NOT NULL
- 생성일 (createdDate)
- 상태 (status) — NOT NULL
- 직급 (rank)
- 회사 (company_name)