asdasd

Tables (30)

AuthDevice

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — 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 — NOT NULL
  • authDeviceId — UUID — 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 — NOT NULL
  • companyName — TEXT — NOT NULL
  • companyFieldId — UUID — NOT NULL
  • companyRegionId — UUID — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

CompanyField

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

CompanyMemoLog

  • id — UUID — Primary key — NOT NULL
  • companyId — UUID — NOT NULL
  • userId — UUID — 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 — NOT NULL
  • region — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

CompanyUserPrivateMemoLog

  • id — UUID — Primary key — NOT NULL
  • companyId — UUID — NOT NULL
  • userId — UUID — 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 — NOT NULL
  • companyId — UUID — NOT NULL
  • username — TEXT — NOT NULL
  • mobile — TEXT — NOT NULL
  • email — TEXT — NOT NULL
  • contactJobGradeId — UUID — NOT NULL
  • contactDepartmentId — UUID — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

ContactDepartment

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

ContactJobGrade

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

ContactMemoLog

  • id — UUID — Primary key — NOT NULL
  • contactId — UUID — NOT NULL
  • userId — UUID — 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 — NOT NULL
  • userId — UUID — 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 — NOT NULL
  • dealName — TEXT — NOT NULL
  • dealCost — INTEGER — NOT NULL
  • companyId — UUID — NOT NULL
  • contactId — UUID — 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 — NOT NULL
  • dealId — UUID — 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 — NOT NULL
  • dealId — UUID — 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 — NOT NULL
  • dealId — UUID — NOT NULL
  • productId — UUID — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

MeetingNote

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — 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 — NOT NULL
  • meetingNoteId — UUID — NOT NULL
  • companyId — UUID
  • companyNameSnapshot — TEXT — NOT NULL
  • companyFieldSnapshot — TEXT
  • companyRegionSnapshot — TEXT
  • createdAt — TIMESTAMPTZ(3) — NOT NULL

MeetingNoteContact

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — NOT NULL
  • meetingNoteId — UUID — NOT NULL
  • contactId — UUID
  • companyId — UUID
  • 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 — NOT NULL
  • meetingNoteId — UUID — NOT NULL
  • dealId — UUID — 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 — NOT NULL
  • meetingNoteId — UUID — NOT NULL
  • productId — UUID
  • productNameSnapshot — TEXT — NOT NULL
  • productPriceSnapshot — INTEGER
  • productCategorySnapshot — TEXT
  • productStatusSnapshot — TEXT
  • createdAt — TIMESTAMPTZ(3) — NOT NULL

Product

  • id — UUID — Primary key — NOT NULL
  • userId — UUID — NOT NULL
  • productName — TEXT — NOT NULL
  • productPrice — INTEGER — NOT NULL
  • productCategoryId — UUID — NOT NULL
  • productStatusId — UUID — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL
  • updatedAt — TIMESTAMP(3) — NOT NULL

ProductCategory

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

ProductMemoLog

  • id — UUID — Primary key — NOT NULL
  • productId — UUID — NOT NULL
  • userId — UUID — 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 — NOT NULL
  • statusName — TEXT — NOT NULL
  • createdAt — TIMESTAMP(3) — NOT NULL

ProductUserPrivateMemoLog

  • id — UUID — Primary key — NOT NULL
  • productId — UUID — NOT NULL
  • userId — UUID — 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 — 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 — NOT NULL
  • scheduleId — UUID — NOT NULL
  • dealId — UUID — 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 — 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