onehand_sales

Tables (51)

AiJob

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • provider — TEXT — NOT NULL
  • inputSummary — JSON
  • output — JSON
  • errorMessage — TEXT
  • targetType — TEXT
  • targetId — CHAR(36)
  • startedAt — DATETIME
  • completedAt — DATETIME
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

AuditLog

  • id — CHAR(36) — Primary key — NOT NULL
  • actorUserId — CHAR(36) — Foreign key → User.id
  • action — VARCHAR(50) — NOT NULL
  • targetType — VARCHAR(50) — NOT NULL
  • targetId — CHAR(36)
  • targetUserId — CHAR(36)
  • reason — TEXT
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL

AuthDevice

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • deviceSlot — VARCHAR(50) — NOT NULL
  • deviceIdHash — TEXT — NOT NULL
  • label — TEXT
  • status — VARCHAR(50) — NOT NULL
  • lastSeenAt — DATETIME
  • replacedAt — DATETIME
  • revokedAt — DATETIME
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

AuthSession

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • authDeviceId — CHAR(36) — Foreign key → AuthDevice.id — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • refreshTokenHash — TEXT
  • userAgent — TEXT
  • ipAddressHash — TEXT
  • lastUsedAt — DATETIME
  • expiresAt — DATETIME — NOT NULL
  • revokedAt — DATETIME
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

BrowserPushSubscription

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • endpointHash — VARCHAR(255) — NOT NULL
  • endpointCiphertext — TEXT — NOT NULL
  • p256dhCiphertext — TEXT — NOT NULL
  • authCiphertext — TEXT — NOT NULL
  • contentKeyVersion — TEXT — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • userAgent — TEXT
  • deviceLabel — TEXT
  • lastUsedAt — DATETIME
  • revokedAt — DATETIME
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

BusinessCardScan

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • companyId — CHAR(36) — Foreign key → Company.id
  • contactId — CHAR(36) — Foreign key → Contact.id
  • status — VARCHAR(50) — NOT NULL
  • imageStorageProvider — VARCHAR(50) — NOT NULL
  • imageBucket — TEXT — NOT NULL
  • imageObjectKey — TEXT — NOT NULL
  • imageContentType — TEXT
  • imageSizeBytes — INT
  • extractedCompany — TEXT
  • extractedName — TEXT
  • extractedDepartment — TEXT
  • extractedPosition — TEXT
  • extractedPhone — TEXT
  • extractedEmail — TEXT
  • extractedAddress — TEXT
  • aiOutput — JSON
  • confirmedAt — DATETIME
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

Company

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • location — TEXT
  • industry — TEXT
  • description — TEXT
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

CompanyField

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • field — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

CompanyLog

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • companyId — CHAR(36) — Foreign key → Company.id — NOT NULL
  • logDate — DATETIME — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

CompanyMemoLog

  • id — UUID — Primary key — NOT NULL
  • companyId — UUID — Foreign key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • memoType — TEXT — NOT NULL
  • memo — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

CompanyRegion

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • region — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

CompanyUserPrivateMemoLog

  • id — UUID — Primary key — NOT NULL
  • companyId — UUID — Foreign key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • memoCiphertext — TEXT — NOT NULL
  • memoKeyVersion — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Contact

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • companyId — CHAR(36) — Foreign key → Company.id
  • name — VARCHAR(255) — NOT NULL
  • department — TEXT
  • position — TEXT
  • location — TEXT
  • phone — TEXT
  • email — TEXT
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

ContactDepartment

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • departmentName — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

ContactJobGrade

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • jobGradeName — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

ContactLog

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • contactId — CHAR(36) — Foreign key → Contact.id — NOT NULL
  • logDate — DATETIME — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

ContactMemoLog

  • id — UUID — Primary key — NOT NULL
  • contactId — UUID — Foreign key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • memoType — TEXT — NOT NULL
  • memo — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

ContactUserPrivateMemoLog

  • id — UUID — Primary key — NOT NULL
  • contactId — UUID — Foreign key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • memoCiphertext — TEXT — NOT NULL
  • memoKeyVersion — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Deal

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • companyId — CHAR(36) — Foreign key → Company.id
  • contactId — CHAR(36) — Foreign key → Contact.id
  • title — TEXT — NOT NULL
  • amount — DECIMAL(18,2) — NOT NULL
  • currency — TEXT — NOT NULL
  • stage — VARCHAR(50) — NOT NULL
  • likelihoodStatus — VARCHAR(50) — NOT NULL
  • likelihoodPercent — INT
  • nextActionTitle — TEXT
  • nextActionDueAt — DATETIME
  • nextActionStatus — VARCHAR(50) — NOT NULL
  • expectedCloseDate — DATETIME
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

DealActivity

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • dealId — CHAR(36) — Foreign key → Deal.id — NOT NULL
  • typeId — CHAR(36) — Foreign key → DealActivityType.id — NOT NULL
  • activityDate — DATETIME — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT
  • isAutoGenerated — BOOLEAN — NOT NULL
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

DealActivityType

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id
  • name — TEXT — NOT NULL
  • isSystem — BOOLEAN — NOT NULL
  • createdAt — DATETIME — NOT NULL

DealFollowingActionLog

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • dealId — UUID — Foreign key — NOT NULL
  • followingAction — TEXT — NOT NULL
  • checkComplete — BOOLEAN — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

DealMemoLog

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • dealId — UUID — Foreign key — NOT NULL
  • memoType — TEXT — NOT NULL
  • memo — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

DealProduct

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • dealId — UUID — Foreign key — NOT NULL
  • productId — UUID — Foreign key — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

ExportJob

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • targetType — VARCHAR(50) — NOT NULL
  • format — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • includeSensitiveData — BOOLEAN — NOT NULL
  • sensitiveWarningAccepted — BOOLEAN — NOT NULL
  • fileName — TEXT
  • fileStorageProvider — VARCHAR(50)
  • fileBucket — TEXT
  • fileObjectKey — TEXT
  • fileContentType — TEXT
  • fileSizeBytes — INT
  • filter — JSON
  • resultSummary — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • completedAt — DATETIME
  • expiresAt — DATETIME

ExternalCalendarConnection

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • providerAccountId — TEXT
  • accessTokenHash — TEXT
  • refreshTokenHash — TEXT
  • tokenExpiresAt — DATETIME
  • status — VARCHAR(50) — NOT NULL
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

ImportJob

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • targetType — VARCHAR(50) — NOT NULL
  • fileName — TEXT — NOT NULL
  • fileStorageProvider — VARCHAR(50)
  • fileBucket — TEXT
  • fileObjectKey — TEXT
  • fileContentType — TEXT
  • fileSizeBytes — INT
  • status — VARCHAR(50) — NOT NULL
  • aiMapping — JSON
  • userMapping — JSON
  • resultSummary — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • completedAt — DATETIME

ImportJobRow

  • id — CHAR(36) — Primary key — NOT NULL
  • importJobId — CHAR(36) — Foreign key → ImportJob.id — NOT NULL
  • rowNumber — INT — NOT NULL
  • rawData — JSON — NOT NULL
  • mappedData — JSON
  • status — VARCHAR(50) — NOT NULL
  • errorMessage — TEXT
  • targetId — CHAR(36)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

MeetingNote

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • dealId — CHAR(36) — Foreign key → Deal.id
  • companyId — CHAR(36) — Foreign key → Company.id
  • contactId — CHAR(36) — Foreign key → Contact.id
  • meetingDate — DATETIME
  • companyName — TEXT
  • contactName — TEXT
  • department — TEXT
  • productName — TEXT
  • stageText — TEXT
  • details — TEXT
  • nextPlan — TEXT
  • requiredAction — TEXT
  • rawTextCiphertext — TEXT — NOT NULL
  • rawTextKeyVersion — TEXT — NOT NULL
  • aiOutput — JSON
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

MeetingNoteCompany

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • meetingNoteId — UUID — Foreign key — NOT NULL
  • companyId — UUID — Foreign key
  • companyNameSnapshot — TEXT — NOT NULL
  • companyFieldSnapshot — TEXT
  • companyRegionSnapshot — TEXT
  • createdAt — TIMESTAMPTZ(3) — NOT NULL

MeetingNoteContact

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • meetingNoteId — UUID — Foreign key — NOT NULL
  • contactId — UUID — Foreign key
  • companyId — UUID — Foreign key
  • contactUsernameSnapshot — TEXT — NOT NULL
  • contactEmailSnapshot — TEXT
  • contactMobileSnapshot — TEXT
  • contactCompanyNameSnapshot — TEXT
  • contactDepartmentSnapshot — TEXT
  • contactJobGradeSnapshot — TEXT
  • createdAt — TIMESTAMPTZ(3) — NOT NULL

MeetingNoteDeal

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • meetingNoteId — UUID — Foreign key — NOT NULL
  • dealId — UUID — Foreign key — NOT NULL
  • dealNameSnapshot — TEXT — NOT NULL
  • dealStatusSnapshot — TEXT — NOT NULL
  • dealCostSnapshot — INTEGER — NOT NULL
  • dealExpectedEndDateSnapshot — DATE — NOT NULL
  • createdAt — TIMESTAMPTZ(3) — NOT NULL

MeetingNoteProduct

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • meetingNoteId — UUID — Foreign key — NOT NULL
  • productId — UUID — Foreign key
  • productNameSnapshot — TEXT — NOT NULL
  • productPriceSnapshot — INTEGER
  • productCategorySnapshot — TEXT
  • productStatusSnapshot — TEXT
  • createdAt — TIMESTAMPTZ(3) — NOT NULL

Notification

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • channel — VARCHAR(50) — NOT NULL
  • targetType — TEXT
  • targetId — CHAR(36)
  • title — TEXT — NOT NULL
  • content — TEXT
  • scheduledAt — DATETIME — NOT NULL
  • sentAt — DATETIME
  • readAt — DATETIME
  • status — VARCHAR(50) — NOT NULL
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

PersonalMemo

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • targetType — VARCHAR(50) — NOT NULL
  • targetId — CHAR(36) — NOT NULL
  • memoDate — DATETIME — NOT NULL
  • title — TEXT
  • contentCiphertext — TEXT — NOT NULL
  • contentKeyVersion — TEXT — NOT NULL
  • isSensitive — BOOLEAN — NOT NULL
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

Product

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • name — TEXT — NOT NULL
  • category — TEXT
  • description — TEXT
  • unitPrice — DECIMAL(18,2)
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

ProductCategory

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • categoryName — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

ProductConnection

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • productId — CHAR(36) — Foreign key → Product.id — NOT NULL
  • targetType — VARCHAR(50) — NOT NULL
  • targetId — CHAR(36) — NOT NULL
  • connectionType — VARCHAR(50) — NOT NULL
  • note — TEXT
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

ProductLog

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • productId — CHAR(36) — Foreign key → Product.id — NOT NULL
  • logDate — DATETIME — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

ProductMemoLog

  • id — UUID — Primary key — NOT NULL
  • productId — UUID — Foreign key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • memoType — TEXT — NOT NULL
  • memo — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

ProductStatus

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • statusName — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

ProductUserPrivateMemoLog

  • id — UUID — Primary key — NOT NULL
  • productId — UUID — Foreign key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • memoCiphertext — TEXT — NOT NULL
  • memoKeyVersion — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

Schedule

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • companyId — CHAR(36) — Foreign key → Company.id
  • contactId — CHAR(36) — Foreign key → Contact.id
  • dealId — CHAR(36) — Foreign key → Deal.id
  • title — TEXT — NOT NULL
  • startAt — DATETIME — NOT NULL
  • endAt — DATETIME — NOT NULL
  • allDay — BOOLEAN — NOT NULL
  • location — TEXT
  • memo — TEXT
  • source — VARCHAR(50) — NOT NULL
  • externalCalendarId — TEXT
  • externalEventId — TEXT
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

ScheduleDeal

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — Foreign key — NOT NULL
  • scheduleId — UUID — Foreign key — NOT NULL
  • dealId — UUID — Foreign key — NOT NULL
  • createdAt — TIMESTAMPTZ(3) — NOT NULL

ScheduleReminder

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • scheduleId — CHAR(36) — Foreign key → Schedule.id — NOT NULL
  • channel — VARCHAR(50) — NOT NULL
  • remindAt — DATETIME — NOT NULL
  • sentAt — DATETIME
  • status — VARCHAR(50) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

Tag

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • name — TEXT — NOT NULL
  • color — TEXT
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

TagAssignment

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • tagId — CHAR(36) — Foreign key → Tag.id — NOT NULL
  • targetType — VARCHAR(50) — NOT NULL
  • targetId — CHAR(36) — NOT NULL
  • createdAt — DATETIME — NOT NULL

TagLog

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • tagId — CHAR(36) — NOT NULL
  • assignmentId — CHAR(36)
  • action — VARCHAR(50) — NOT NULL
  • tagNameSnapshot — TEXT — NOT NULL
  • tagColorSnapshot — TEXT
  • targetType — VARCHAR(50)
  • targetId — CHAR(36)
  • targetTitleSnapshot — TEXT
  • metadata — JSON
  • occurredAt — DATETIME — NOT NULL
  • createdAt — DATETIME — NOT NULL

User

  • id — CHAR(36) — Primary key — NOT NULL
  • email — TEXT
  • displayName — TEXT
  • role — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • lastLoginAt — DATETIME
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • permanentDeleteAt — DATETIME

UserOAuthAccount

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • providerUserId — VARCHAR(255) — NOT NULL
  • providerEmail — TEXT
  • accessTokenHash — TEXT
  • refreshTokenHash — TEXT
  • tokenExpiresAt — DATETIME
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

UserSetting

  • id — CHAR(36) — Primary key — NOT NULL
  • userId — CHAR(36) — Foreign key → User.id — NOT NULL
  • defaultScheduleReminderMinutes — INT — NOT NULL
  • defaultNextActionReminderMinutes — INT — NOT NULL
  • emailNotificationEnabled — BOOLEAN — NOT NULL
  • browserPushEnabled — BOOLEAN — NOT NULL
  • sensitiveSaveWarningEnabled — BOOLEAN — NOT NULL
  • metadata — JSON
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL