dd
Tables (30)
AuthDevice
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- deviceSlot — "AuthDeviceSlot" — NOT NULL
- deviceIdHash — TEXT — NOT NULL
- label — TEXT
- status — "AuthDeviceStatus" — NOT NULL
- lastSeenAt — TIMESTAMP(3)
- replacedAt — TIMESTAMP(3)
- revokedAt — TIMESTAMP(3)
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
AuthSession
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- authDeviceId — UUID — Foreign key → AuthDevice.id — NOT NULL
- status — "AuthSessionStatus" — NOT NULL
- refreshTokenHash — TEXT
- userAgent — TEXT
- ipAddressHash — TEXT
- lastUsedAt — TIMESTAMP(3)
- expiresAt — TIMESTAMP(3) — NOT NULL
- revokedAt — TIMESTAMP(3)
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
Company
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- companyName — TEXT — NOT NULL
- companyFieldId — UUID — Foreign key → CompanyField.id — NOT NULL
- companyRegionId — UUID — Foreign key → CompanyRegion.id — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
CompanyField
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- field — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
CompanyMemoLog
- id — UUID — Primary key — NOT NULL
- companyId — UUID — Foreign key → Company.id — NOT NULL
- userId — UUID — Foreign key → User.id — 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 → User.id — NOT NULL
- region — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
CompanyUserPrivateMemoLog
- id — UUID — Primary key — NOT NULL
- companyId — UUID — Foreign key → Company.id — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- memoCiphertext — TEXT — NOT NULL
- memoKeyVersion — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
Contact
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- companyId — UUID — Foreign key → Company.id — NOT NULL
- username — TEXT — NOT NULL
- mobile — TEXT — NOT NULL
- email — TEXT — NOT NULL
- contactJobGradeId — UUID — Foreign key → ContactJobGrade.id — NOT NULL
- contactDepartmentId — UUID — Foreign key → ContactDepartment.id — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
ContactDepartment
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- departmentName — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
ContactJobGrade
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- jobGradeName — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
ContactMemoLog
- id — UUID — Primary key — NOT NULL
- contactId — UUID — Foreign key → Contact.id — NOT NULL
- userId — UUID — Foreign key → User.id — 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 → Contact.id — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- memoCiphertext — TEXT — NOT NULL
- memoKeyVersion — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
Deal
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- dealName — TEXT — NOT NULL
- dealCost — INTEGER — NOT NULL
- companyId — UUID — Foreign key → Company.id — NOT NULL
- contactId — UUID — Foreign key → Contact.id — NOT NULL
- dealStatus — TEXT — NOT NULL
- expectedEndDate — DATE — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
DealFollowingActionLog
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- dealId — UUID — Foreign key → Deal.id — 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 → User.id — NOT NULL
- dealId — UUID — Foreign key → Deal.id — 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 → User.id — NOT NULL
- dealId — UUID — Foreign key → Deal.id — NOT NULL
- productId — UUID — Foreign key → Product.id — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
MeetingNote
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- sourceType — "MeetingNoteSourceType" — NOT NULL
- meetingAt — TIMESTAMPTZ(3) — NOT NULL
- timeZone — TEXT — NOT NULL
- details — TEXT — NOT NULL
- nextPlan — TEXT
- requiredAction — TEXT
- rawText — TEXT
- createdAt — TIMESTAMPTZ(3) — NOT NULL
- updatedAt — TIMESTAMPTZ(3) — NOT NULL
MeetingNoteCompany
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- meetingNoteId — UUID — Foreign key → MeetingNote.id — NOT NULL
- companyId — UUID — Foreign key → Company.id
- companyNameSnapshot — TEXT — NOT NULL
- companyFieldSnapshot — TEXT
- companyRegionSnapshot — TEXT
- createdAt — TIMESTAMPTZ(3) — NOT NULL
MeetingNoteContact
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- meetingNoteId — UUID — Foreign key → MeetingNote.id — NOT NULL
- contactId — UUID — Foreign key → Contact.id
- companyId — UUID — Foreign key → Company.id
- 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 → User.id — NOT NULL
- meetingNoteId — UUID — Foreign key → MeetingNote.id — NOT NULL
- dealId — UUID — Foreign key → Deal.id — 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 → User.id — NOT NULL
- meetingNoteId — UUID — Foreign key → MeetingNote.id — NOT NULL
- productId — UUID — Foreign key → Product.id
- productNameSnapshot — TEXT — NOT NULL
- productPriceSnapshot — INTEGER
- productCategorySnapshot — TEXT
- productStatusSnapshot — TEXT
- createdAt — TIMESTAMPTZ(3) — NOT NULL
Product
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- productName — TEXT — NOT NULL
- productPrice — INTEGER — NOT NULL
- productCategoryId — UUID — Foreign key → ProductCategory.id — NOT NULL
- productStatusId — UUID — Foreign key → ProductStatus.id — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
ProductCategory
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- categoryName — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
ProductMemoLog
- id — UUID — Primary key — NOT NULL
- productId — UUID — Foreign key → Product.id — NOT NULL
- userId — UUID — Foreign key → User.id — 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 → User.id — NOT NULL
- statusName — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
ProductUserPrivateMemoLog
- id — UUID — Primary key — NOT NULL
- productId — UUID — Foreign key → Product.id — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- memoCiphertext — TEXT — NOT NULL
- memoKeyVersion — TEXT — NOT NULL
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
Schedule
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- scheduleTitle — TEXT — NOT NULL
- startAt — TIMESTAMPTZ(3) — NOT NULL
- endAt — TIMESTAMPTZ(3) — NOT NULL
- timeZone — TEXT — NOT NULL
- location — TEXT
- memo — TEXT
- createdAt — TIMESTAMPTZ(3) — NOT NULL
- updatedAt — TIMESTAMPTZ(3) — NOT NULL
ScheduleDeal
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- scheduleId — UUID — Foreign key → Schedule.id — NOT NULL
- dealId — UUID — Foreign key → Deal.id — NOT NULL
- createdAt — TIMESTAMPTZ(3) — NOT NULL
User
- id — UUID — Primary key — NOT NULL
- email — TEXT
- displayName — TEXT
- role — "UserRole" — NOT NULL
- status — "UserStatus" — NOT NULL
- timeZone — TEXT — NOT NULL
- lastLoginAt — TIMESTAMP(3)
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL
- deletedAt — TIMESTAMP(3)
UserOAuthAccount
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key → User.id — NOT NULL
- provider — "OAuthProvider" — NOT NULL
- providerUserId — TEXT — NOT NULL
- providerEmail — TEXT
- accessTokenHash — TEXT
- refreshTokenHash — TEXT
- tokenExpiresAt — TIMESTAMP(3)
- createdAt — TIMESTAMP(3) — NOT NULL
- updatedAt — TIMESTAMP(3) — NOT NULL