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)