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