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