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