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