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