work

Tables (3)

user (Untitled2)

  • user_id (id) — Long — Primary key — NOT NULL
  • username (name) — String
  • userEmail (email) — String
  • userPassword (password) — String
  • userPhone (phone)

work (Untitled)

  • id — Long — Primary key — NOT NULL
  • user_id (id2) — Long — Foreign key → user.user_id — NOT NULL
  • scheduledStart (시작) — LocalDateTime
  • scheduledEnd (종료) — LocalDateTime

workLog (Untitled3)

  • workLog_id (id) — Long — Primary key — NOT NULL
  • user_id (id2) — Long — Foreign key → user.user_id — NOT NULL
  • checkIn (checkInTime) — LocalDateTime
  • checkOut (checkOutTime) — LocalDateTime