CREATE TABLE RewardCoupon
(
    [ID] AUTOINCREMENT,
    [OrderID] INTEGER,
    [PaymentDate] DATETIME,
    [CouponCode] TEXT,
    [CouponType] TEXT,
   [MemberNumber] TEXT
);

CREATE TABLE table_name
 (field1 type [(size)] [NOT NULL] [index1]
 [, field2 type [(size)] [NOT NULL] [index2]
 [, ...][, CONSTRAINT constraint1 [, ...]])