SWAIdatamodeling

Tables (6)

COUPON (Untitled5)

  • Coupon_ID (Field) — char — NOT NULL
  • Coupon_Code (Field2) — char(10) — NOT NULL
  • Discount_Type (Field3) — char
  • Discount_Value (Field4) — int
  • Minimum_Payment_Amount (Field5) — int
  • Expiration_Date (Field6) — int
  • Issuance_Limit (Field7) — int
  • Applicable_Plan_ID (Field8) — char

CREDIT_USAGE_LOG (Untitled6)

  • Log_ID (Field) — char — NOT NULL
  • Customer_ID (Field2) — char — NOT NULL
  • Usage_Date (Field3) — int
  • Used_Credit_Amount (Field4) — int

Customer (Untitled)

  • Cus_ID (Field) — char(14) — NOT NULL
  • Login_ID (Field2) — char — NOT NULL
  • Password (Field3) — int — NOT NULL
  • Name (Field4) — char — NOT NULL
  • E-mail (Field5) — char — NOT NULL
  • Join Date (Field6) — int
  • Last_Login_Time (Field7) — int
  • Pro_Coupon_User (Field8) — int
  • Basic_Coupon_User (Field9) — int

PAYMENT (Untitled4)

  • Payment_ID (Field) — char — NOT NULL
  • Subscription_History_ID (Field2) — char — NOT NULL
  • Coupon_ID (Field3) — char — NOT NULL
  • Payment_Datetime (Field4) — int
  • Payment_Amount (Field5) — int
  • Payment_Method (Field6) — int
  • Payment_Status (Field7) — int

SUBSCRIPTION_HISTORY (Untitled3)

  • Subscription_History_ID (Field) — char — NOT NULL
  • Customer_ID (Field2) — char — NOT NULL
  • Plan_ID (Field3) — char
  • Start_Date (Field4) — int
  • End_Date (Field5) — int
  • Subscription_Status (Field6) — char

SUBSCRIPTION_PLAN (Untitled2)

  • Plan_ID (Field) — char — NOT NULL
  • Plan_Name (Field2) — char — NOT NULL
  • Month_Price (Field3) — int
  • Sale Percent (Field4) — int
  • Feature_Description (Field5) — char
  • General_Credit_Limit (Field6) — int