testtest
Tables (10)
BookCategory
- id — INT
- name — VARCHAR(100)
- description — VARCHAR(255)
ConditionType
- id — INT
- name — VARCHAR(100)
- description — VARCHAR(255)
Coupon
- id — INT
- name — VARCHAR(100)
- discountAmount — DECIMAL(10, 2)
- discountRate — DECIMAL(5, 2)
- issueDate — DATE
- expiryDate — DATE
- type — VARCHAR(50)
CouponCategory
- couponId — INT
- categoryId — INT
CouponCondition
- id — INT
- couponId — INT
- conditionTypeId — INT
- conditionValue — VARCHAR(100)
- categoryId — INT
CouponRecipient
- id — INT
- couponId — INT
- userId — INT
- issueDate — DATE
CouponRule
- id — INT
- couponId — INT
- ruleType — VARCHAR(50)
- description — VARCHAR(255)
- categoryId — INT
CouponUsage
- id — INT
- couponRecipientId — INT
- usedDate — DATE
Event
- id — INT
- eventType — VARCHAR(100)
- eventDate — DATE
User
- id — INT
- name — VARCHAR(100)
- email — VARCHAR(100)
- membershipLevel — VARCHAR(50)
- birthday — DATE