shoppingMall

Tables (14)

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex (adContract)

  • Key (adContractId) — integer — Foreign key → Copy Of Copy Of adTypeIndex.Key — NOT NULL
  • Key (userId) — integer — Foreign key → Copy Of Copy Of adTypeIndex.Key — NOT NULL
  • Field (pointPayable) — boolean
  • Field (term) — text
  • Field (startDate) — text
  • Field (endDate) — text
  • Field (paymentType) — integer
  • Field (contractRequestDate) — text

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex2 (policy)

  • Key (pointExchangeable) — boolean — Primary key — NOT NULL
  • Field (pointRewardable) — boolean
  • Field (bbsRewardable) — boolean
  • Field (reviewRewardable) — boolean
  • Field (logInRewardable) — boolean
  • Field (reviewRewardPoint) — integer
  • Field (reviewRewardTimesPerDay) — integer
  • Field (bbsRewardTimesPerDay) — integer
  • Field (bbsRewordPoint) — integer
  • Field (logInRewardTimesPerDay) — integer
  • Field (logInRewardPoint) — integer
  • Field (numberOfHighlightArticles) — integer
  • Field (highlightAdSaleAvailable) — boolean
  • Field (highlightPromotionDaysforNewClient) — integer

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex (user)

  • Key (userId) — integer — Primary key — NOT NULL
  • Field (account) — text
  • Field (password) — text
  • Field (alias) — text
  • Field (authority) — integer
  • Field (activityLocation) — text
  • Field (email) — text
  • Field (point) — integer
  • Field (joinDate) — text
  • Field (lastLoginDate) — text

Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex (fileList)

  • Key (fileListId) — integer — Primary key — NOT NULL
  • Field (filePath) — text
  • Field (extention) — text
  • Field (fileName) — text
  • Field (cdt) — text

Copy Of Copy Of Copy Of Copy Of adTypeIndex (message)

  • Key (messageId) — integer — Primary key — NOT NULL
  • Key (senderId) — integer — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex.Key — NOT NULL
  • Key (receiverId) — integer — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex.Key — NOT NULL
  • Field (title) — text
  • Field (content) — text
  • Field (cdt) — text

Copy Of Copy Of Copy Of adTypeIndex (article)

  • Key (articleId) — integer — Primary key — NOT NULL
  • Key (userId) — integer — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex.Key — NOT NULL
  • Key (boardId) — integer — Foreign key → Copy Of Copy Of Copy Of adTypeIndex2.Key — NOT NULL
  • Field (ownerId) — integer
  • Field (boardTypeId) — boolean
  • Field (title) — text
  • Field (recommends) — integer
  • Field (reads) — integer
  • Field (content) — text
  • Field (udt) — text
  • Field (cdt) — text
  • Key (fileListId) — integer — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex.Key — NOT NULL

Copy Of Copy Of Copy Of adTypeIndex2 (board)

  • Key (boardId) — integer — Primary key — NOT NULL
  • Key (adContractId) — integer — Foreign key → Copy Of Copy Of adTypeIndex.Key — NOT NULL
  • Field (boardTypeId) — integer
  • Field (boardTypeName) — text
  • Field (writeAuth) — integer
  • Field (updateAuth) — integer
  • Field (readAuth) — integer
  • Field (udt) — text
  • Field (cdt) — text

Copy Of Copy Of Copy Of adTypeIndex22 (authorityIndex)

  • Key (id) — integer — Primary key — NOT NULL
  • Field (userTypeName) — text
  • Field (level) — integer

Copy Of Copy Of adTypeIndex (ad)

  • Key (adContractId) — integer — Primary key — NOT NULL
  • Key (userId) — integer — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex.Key — NOT NULL
  • Field (isHighlight) — boolean
  • Field (adTypeId) — integer
  • Field (adTypeName) — text
  • Field (adLocationId) — integer
  • Field (adLocationName) — text
  • Field (adLocationDetail) — text
  • Field (reviewBoardId) — integer
  • Field (address) — text
  • Field (startTime) — text
  • Field (endTime) — text
  • Field (tel) — text
  • Field (title) — text
  • Field (content) — text
  • Field (status) — integer
  • Field (udt) — text
  • Field (cdt) — text
  • Key (imageFileListId) — integer — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex.Key — NOT NULL
  • Key (thumbnailFileId) — integer — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of adTypeIndex.Key — NOT NULL

Copy Of Copy Of adTypeIndex2 (boardTypeIndex)

  • Key (boardTypeId) — integer — Primary key — NOT NULL
  • Field (boardTypeName) — text

Copy Of adTypeIndex (adStatusIndex)

  • Key (status) — integer — Primary key — NOT NULL
  • Field (desc) — text

Copy Of adTypeIndex2 (adLocationIndex)

  • Key (adLocationId) — integer — Primary key — NOT NULL
  • Field (adLocationName) — text

Copy Of adTypeIndex3 (paymentTypeIndex)

  • Key (id) — integer — Primary key — NOT NULL
  • Field (paymentType) — text

adTypeIndex

  • Key (adTypeId) — integer — Primary key — NOT NULL
  • Field (adTypeName) — text