AVON
Tables (6)
Coupon
- 쿠폰 코드 (Coupon Code) — NUMBER — Primary key — NOT NULL
- Field (Valid Entry) — NOT NULL
- Field (Start Date) — TIMESTAMP — NOT NULL
- Field (End Date) — TIMESTAMP
- Field
- Field2
Customer
Item
Offer
- 쿠폰 코드 (Coupon Code) — int — Primary key — NOT NULL
- Field (Valid Entry) — NOT NULL
- Field (Start Date) — DATE
- Field (End Date) — DATE
- Field
Order
Rep Coupon
- 쿠폰 코드 (Coupon Code) — int — Primary key — NOT NULL
- Field (Valid Entry) — NOT NULL
- Field (Start Date) — TIMESTAMP — NOT NULL
- Field (End Date) — TIMESTAMP
- Field