refluencerApp

Tables (14)

Untitled (AUTH)

  • Key (authId) — Primary key — NOT NULL
  • Field (createAt)
  • Field (updateAt)
  • Field (email)
  • Field (password)
  • Field2 (name)
  • Field (authCodeToken)
  • Field2 (authCode)
  • Field (authCodeVerify)

Untitled (MEMBER)

  • Key (memberId) — Primary key — NOT NULL
  • Field (createAt)
  • Field2 (updateAt)
  • Field (name)
  • Field2 (email)
  • Field3 (password)
  • Field4 (authCodeVerify)
  • Field (deleteFlag)
  • Field (usingAppVersion)
  • Field2 (deviceType)
  • Field3 (nickName)
  • Field (devicePushToken)
  • Field (onesignalPushToken)
  • Field (ci)
  • Field2 (kyc)
  • Field (age)
  • Field (gender)
  • Field (point)
  • Field (di)
  • Field (birthDate)
  • Field (phone)

Untitled (MALLINFOS)

  • Key (mallinfosId) — Primary key — NOT NULL
  • Field (createAt)
  • Field2 (updateAt)
  • Field (platform)
  • Field2 (mallId)
  • Field (redirectUrl)
  • Field (clientId)
  • Field (clientSecretKey)
  • Field (accessToken)
  • Field (expiresAt)
  • Field (refreshToken)
  • Field2 (refreshTokenExpiresAt)
  • Field (use)

Untitled (SHORTS)

  • Key (shortId) — BIGINT — Primary key — NOT NULL
  • Field (createAt) — DATETIME
  • Field2 (updateAt)
  • Field3 (originalFileName)
  • Field (assetId)
  • Field2 (playbackId)
  • Field3 (uploadId)
  • Field (uploadUrl)
  • Field (playbackUrl)
  • Field (thumbnailUrl)
  • Key (memberId) — Foreign key → Untitled.Key — NOT NULL
  • Key (productsId) — Foreign key → Untitled.Key — NOT NULL
  • Field (description)
  • Field (viewCount)
  • Field2 (shareCount)
  • Field3 (likeCount)

Untitled (APICONFIG)

  • Key (apiConfigId) — Primary key — NOT NULL
  • Field (createAt)
  • Field2 (updateAt)
  • Field (moduleName)
  • Field2 (targetAppVersion)
  • Field3 (apiUrl)
  • Field (apiKey)

Untitled (CAMPAIGN)

  • Key (campaignId) — Primary key — NOT NULL
  • Field (createAt)
  • Field2 (updateAt)
  • Field (use)
  • Key (memberId) — Foreign key → Untitled.Key — NOT NULL
  • Key (productsId) — Foreign key → Untitled.Key — NOT NULL
  • Key (shortlinksId) — Foreign key → Untitled.Key — NOT NULL

Untitled (NOTIFICATIONS)

  • Key (notificationsId) — Primary key — NOT NULL
  • Field (createAt)
  • Field2 (updateAt)
  • Field (pushType)
  • Field2 (message)
  • Key (memberId) — Foreign key → Untitled.Key — NOT NULL
  • Key (productsId) — Foreign key → Untitled.Key — NOT NULL
  • Key (campaignId) — Foreign key → Untitled.Key — NOT NULL

Untitled (SHORTLINKS)

  • Key (shortlinksId) — Primary key — NOT NULL
  • Field (createAt)
  • Field2 (updateAt)
  • Field (originalUrl)
  • Field2 (shortUrl)
  • Key (campaignId) — Foreign key → Untitled.Key — NOT NULL
  • Key (memberId) — Foreign key → Untitled.Key — NOT NULL

Untitled (PRODUCTS)

  • Key (productsId) — Primary key — NOT NULL
  • Field (platform)
  • Field (mallId)
  • Field (shopNo)
  • Field (productNo)
  • Field (productCode)
  • Field (productName)
  • Field (price)
  • Field (display)
  • Field (selling)
  • Field (simpleDescription)
  • Field (summaryDescription)
  • Field (listImage)
  • Field (smallImage)
  • Field (detailImage)
  • Field (additionalImages)
  • Field (rewardRatio)
  • Field (hits)
  • Field (link)
  • Field (use)
  • Field (createdAt)
  • Field (updatedAt)
  • Key (shopsId) — Foreign key → Untitled.Key — NOT NULL

Untitled (SHOPS)

  • Key (shopsId) — Primary key — NOT NULL
  • Field (platform)
  • Field (mallId)
  • Field (shopNo)
  • Field (use)
  • Field (createdAt)
  • Field (updatedAt)
  • Key (mallinfosId) — Foreign key → Untitled.Key — NOT NULL
  • Field (shopLogoImage)
  • Field (shopMainImage)
  • Field (shopName)
  • Field (businessCountryCode)
  • Field (languageCode)
  • Field2 (languageName)
  • Field3 (currencyCode)
  • Field4 (currencyName)
  • Field (baseDomain)
  • Field2 (primaryDomain)
  • Field3 (active)
  • Field (default)

Untitled (APPCONFIG)

  • Key (appConfigId) — Primary key — NOT NULL
  • Field (versionInfo)
  • Field (versionName)
  • Field (createAt)
  • Field (updateAt)

Untitled (PERMISSION)

  • Key (permissionId) — Primary key — NOT NULL
  • Field (name)
  • Field (status)
  • Field (createAt)
  • Field (updateAt)
  • Key (memberId) — Foreign key → Untitled.Key — NOT NULL

Untitled (LOGINTYPE)

  • Key (loginTypeId) — Primary key — NOT NULL
  • Field (type)
  • Field (email)
  • Field (ci)
  • Field (createAt)
  • Field (updateAt)
  • Key (memberId) — Foreign key → Untitled.Key — NOT NULL

Untitled (TOU)

  • Key (touId) — Primary key — NOT NULL
  • Field (touName)
  • Field (touStatus)
  • Field (createAt)
  • Field (updateAt)
  • Key (memberId) — Foreign key → Untitled.Key — NOT NULL