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