CustomerBookingChanged

Tables (4)

CustomerBooking (Untitled3)

  • CustomerBookingId (Id) — Int — Primary key — NOT NULL
  • Field

CustomerBookingNotification (customerBookingChanged)

  • CustomerBookingChangedId (Id) — Int — Primary key — NOT NULL
  • 변경한 사람 (ChangedBy) — Int — Foreign key → Staff.StaffId — NOT NULL
  • CustomerBookingId — Int — Foreign key → CustomerBooking.CustomerBookingId — NOT NULL
  • 읽음표시 (IsRead) — boolean
  • 생성 날짜 (CreatedAt) — DateTime

CustomerBookingNotificationItem (customerBookingNotificationItem)

  • CustomerBookingChangedId (Id) — Int — Foreign key → CustomerBookingNotification.CustomerBookingChangedId — NOT NULL
  • 변경된 필드 (ChangedField) — String
  • 변경된 필드 타입 (ChangedFieldType) — String
  • 변경된String (ChangedString) — String
  • 변경된DateTime (ChangedDateTime) — DateTime
  • 변경된Boolean (ChangedBoolean) — Boolean
  • 변경된Int (ChangedInt) — Int
  • 이전의String (PreviousString) — String
  • 이전의DateTime (PreviousDateTime) — DateTime
  • 이전의Boolean (PreviousBoolean) — Boolean
  • 이전의Int (PreviousInt) — Int

Staff (Untitled2)

  • StaffId (Id) — Int — Primary key — NOT NULL
  • Field