commute

Tables (5)

Department (부서)

  • id (DepartmentId) — Integer — Primary key — NOT NULL
  • name — String

DepartmentRank (부서 계급)

  • id (rankId) — Integer — Primary key — NOT NULL
  • role (계급) — String
  • memberId — Integer — Foreign key → Member.id — NOT NULL
  • departmentId — Integer — Foreign key → Department.id — NOT NULL

Member (유저)

  • id (memberId) — Integer — Primary key — NOT NULL
  • identityString (아이디) — Stirng
  • password (패스워드) — String
  • email (이메일) — String
  • phone (전화번호) — Stirng
  • refreshToken (리프레시토큰) — String

TimeSheet (출퇴근 기록)

  • id (TimeSheetId) — Integer — Primary key — NOT NULL
  • commuteTime (출근시간) — String
  • memberId — Integer — Foreign key → Member.id — NOT NULL
  • DepartmentId — Integer — Foreign key → Department.id — NOT NULL
  • endTime (퇴근시간) — LocalTime
  • date (출퇴근 날짜) — LocalDate

device (스마트택배 디바이스)

  • id (deviceId) — Integer — Primary key — NOT NULL
  • token — String
  • memberId — Integer — Foreign key → Member.id — NOT NULL