Some key table structures for group buying in the most soil: Some key table structures for group buying in the most soil
Coupon card
Id: coupon ID
Code Identifier
Partner_id merchant ID
Team_id product ID
Order_id order ID
Credit coupon amount
Has consume been used?
Ip address used
Begin_time validity period start time
End_time end time of validity period
Category Table category id: id
Category: zone
Classification Group: czone
Category name: name
English name of Category: ename
The first word of the category name: letter
Sort: sort_order
Display homepage: display order table order id: id
Pay_id: payment ID, that is, order number
Buy_id: ID of the member to be purchased
Service: payment method
Member ID: user_id
Administrator id: admin_id to determine whether the administrator is required
Project ID: team_id
City ID: city_id
Coupon ID: card_id
Payment status: state
Quantity: quantity
Real name: realname
Mobile phone number: mobile
Zip code: zipcode
Shipping address: address
Choose express?
Express No.: express_id
Express delivery ticket code: express_no
Product price: price
Paid amount: money
Total order price: origin
Points acquisition: credit
Coupon amount used: card
Item property: condbuy
Purchase remarks: remark
Order Time: create_time
Payment Time: pay_time
Comment: comment_content
Comment: comment_display
Comment level: comment_grade
Comment Time: comment_time
Merchant ID: partner_id
SMS notification: sms_express Best Database coupon form coupon ID: id
Member ID: user_id
Merchant ID: partner_id
Project ID: team_id
Order ID: order_id
Type: type
Points: credit
Coupon password: secret
Used?: consume
Ip address when using discount coupons: ip
Whether the sms is successfully sent: sms
Coupon expiration Time: expire_time
SMS sending Time: sms_time
Order of purchase under this item: buy_id the lowest database merchant information partner table merchant ID: id
Merchant username: username
Merchant password: password
Merchant name: title
Merchant Product Category: group_id
Merchant website address: homepage
Merchant City id: city_id
Merchant Bank Account name: bank_name
Merchant Bank account: bank_no
Merchant username: bank_user
Merchant location: location
Merchant contact: contact
Merchant image: image
Merchant Image 1: image1
Merchant Image 2: image2
Merchant phone Number: phone
Contact address: address
Other merchant information: other
Merchant mobile number: mobile
Business Presentation: open
Merchant Member id: user_id
Merchant creation Time: create_time
Display homepage: display
Comment_good
Comment_none
Comment_bad: logger_admin log No.: id operation administrator ID: user_id operation administrator Email: user_email operation type: type operation description: operation-related data: relate_data operation Time: create_on user table structure Member id: id
Member email: email
Member Name: username
Real member name: realname
Member password: password
Member Title: avatar
Gender
Mobile phone number: mobile
Contact QQ: qq
Account balance: money
Account points: score
Zip code: zipcode
Contact address: address
City ID: city_id
Verify by email: enable
Administrator or not: manager
Email Verification Key: secret
Key seed for password modification: recode
Ip address at login: ip address
Last logon Time: login_time
Registration time: create_time the most popular database friendship chain table friendlink friendship connection ID: id friendship link title: title friendship link address: url friendship link logo: logo sorting: sort_order whether to display the home page: display invite invitation id: id ID: user_id processing invited administrator: admin_id IP: user_ip when the invitation is registered, the invitee ID: other_user_id Project ID: team_id whether to pay: pay: credit purchase time: buy_time write record time: create_time most soil database problem feedback table feedback message No.: id City id: city_id message User id: user_id message type: category Title: title contact email: contact message content: conent message time: create_time most soil database question and answer ask table Question ID: id question User UID: user_id group purchase Project id: team_id question City id: city_id question type: type question content: content reply content: comment Question Time: create_time most Earth points redeem commodity database goods table points commodity id: id points commodity Title: titie points required for redemption points: score point product image: image point product creation time: time sorting field: sort_order convertible quantity: consume display: display most soil database mail subscription table subscribe subscription ID: id subscription mail: the city ID of the email subscription: city_id key for subscription: secret mobile phone number subscription table smssubscribe subscription No.: mobile phone number subscribed by id: mobile City ID: city_id mobile phone subscription key: secret status: enable subscription Time: create_time
