优惠券表的表结构 [英] Table Structure for Coupon Table

问题描述

亲爱的朋友们，



我要求在表格中存储唯一代码作为优惠券代码。

我已经有效直到和使用/未使用的类别在同一个表中。

现在数据量巨大，推送新数据或检索数据进行验证，需要时间。



任何人都可以在表结构中提供帮助，我目前使用的是正确与否。



现有表结构

Dear Friends,

I am having a requirement of storing unique code as coupon code in an table.
I have already valid till and used/un-used category in the same table.
Now the data is in huge size and for pushing the new data or retrieving data for verification, it takes time.

Can anyone help in table structure of the same, what I am using currently is correct or not.

Existing Table Structure

Column	Type	Length	
Date	datetime	8	
MOBILE_FROM	varchar	15	- Used from which mobile
SMS	varchar	150	- SMS Syntax to use the coupon
Received_On	datetime	8	- SMS Received on
Category	varchar	20	- Offer Type
Coupon No	varchar	20	
Status	varchar	5	- Used or Not
Product Id	varchar	20	- Used against which product
Valid_Till	datetime	8	
Last_Updated	datetime	8	- latest updated
Mapp_1	varchar	30	- Incharge 1
Mapp_2	varchar	30	- Incharge 2
Mapp_3	varchar	30	- Incharge 3

推荐答案

检查出来：向您的数据库询问该唯一ID [ ^ ]

这篇关于优惠券表的表结构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！