helper
Tables (12)
Admin (Untitled4)
- adminId (Key) — String — Primary key — NOT NULL
- id (Field) — String
- pw (Field2) — String
- storeId (Field3) — String
- Field4
Position (Untitled2)
- positionId (Key) — Primary key — NOT NULL
- positionName (Field)
- storeId (Field2)
- storeId (Key2) — Int — Foreign key → store.storeId — NOT NULL
Position (업무)
- positionId (Key) — String — Primary key — NOT NULL
- positionName (Field) — String
- tasks (Field2) — List<Task>
- storeId (Key2) — String — Foreign key → Store.storeId — NOT NULL
Routine (출퇴근 기록지)
- routineId (Key) — String — Primary key — NOT NULL
- userRoutines (Field) — List<UserRoutines>
- createdAt (Field2) — String(LocalDateTime)
- deletedAt (Field3) — String(LocalDateTime)
- storeId (Key2) — String — Foreign key → Store.storeId — NOT NULL
- userId (Key3) — String — Foreign key → Users.userId — NOT NULL
Store (Untitled3)
- storeId (Key) — String — Primary key — NOT NULL
- name (Field) — String
- location (Field2) — String
- latitude (Field3) — String
- longitude (Field4) — String
- positions (Field5) — List<Positions>
- adminId (Key2) — String — Foreign key → Admin.adminId — NOT NULL
Task (할 일들)
- taskId (Key) — String — Primary key — NOT NULL
- title (Field) — String
- isPhotoRequired (Field2) — String
- positionId (Key2) — String — Foreign key → Position.positionId — NOT NULL
UserTask (할일 상태)
- userRoutineId (Key) — String — Primary key — NOT NULL
- task (Field) — Task
- isDone (Field2) — Boolean
- fileUrl (Field3) — String
- routineId (Key2) — String — Foreign key → Routine.routineId — NOT NULL
- taskId (Key3) — String — Foreign key → Task.taskId — NOT NULL
Users (유저)
- userId (Key) — Int — Primary key — NOT NULL
- role (Field) — Role(User/Admin)
- name (Field2) — String
- createdAt (Field3) — LocalDateTime
- Field4
Users (알바님)
- userId (Key) — String — Primary key — NOT NULL
- userName (Field) — String
- phoneNumber (Field2) — String
- isDeleted (Field3) — Boolean
- storeId (Key2) — String — Foreign key → Store.storeId — NOT NULL
routine (할 일)
- routineId (Key) — Int — Primary key — NOT NULL
- isPhotoRequired (사진 필수 여부) — Boolean
- task (할 일) — String
- createdAt (Field6) — LocalDateTime
- deletedAt (Field5) — LocalDateTime
- start_time (Field2)
- end_time (Field3)
- storeId (Key2) — Int — Foreign key → store.storeId — NOT NULL
- positionId (Key3) — Foreign key → Position.positionId — NOT NULL
store (사장님(가게))
- storeId (Key2) — Int — Primary key — NOT NULL
- userId (Key) — Int — Foreign key → Users.userId — NOT NULL
- name (Field) — String
- opeenTime (Field2) — LocalDateTime
- closeTime (Field3) — LocalDateTime
- location (Field4) — String
- latitude (Field5) — String
- longtitude (Field6) — String
userRoutine+routine (Untitled)
- storeId (Key) — Primary key — NOT NULL
- userId (Key2) — Primary key — NOT NULL
- positonId (Field)
- positonName (Field2)
- routineId (Field3)
- task (Field4)
- isphotoRequired (Field5)
- isDone (Field6)
- photo (Field7)
- userName (Field8)
- routineId (Key3) — Int — Foreign key → routine.routineId — NOT NULL
- userId (Key4) — Int — Foreign key → Users.userId — NOT NULL