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