imlab

Tables (7)

Country Code (국가 코드)

  • Key (id) — Primary key — NOT NULL
  • Field (code)
  • Field (dcode)
  • Field (name)

Coupon (쿠폰)

  • Key (id) — Primary key — NOT NULL
  • Key (coupon_type_id) — Foreign key → Coupon Type.Key — NOT NULL
  • Field (code)
  • Field (is_used)
  • Field (created_at)
  • Field (dueDate)
  • Field (discount)

Coupon Type (쿠폰 타입)

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field (discount_type) — enum
  • Field (discount_value)
  • Field (discount_at) — enum

Delivery (배송)

  • Key (id) — Primary key — NOT NULL
  • Key (order_id) — Foreign key → Order.Key — NOT NULL
  • Field (state) — enum

Delivery Cost (배송 비용)

  • Key (id) — Primary key — NOT NULL
  • Key (country_code_id) — Foreign key → Country Code.Key — NOT NULL
  • Field (quantity)
  • Field (cost)

Order (주문)

  • Key (id) — Primary key — NOT NULL
  • Key (country_code_id) — Foreign key → Country Code.Key — NOT NULL
  • Key (user_id) — Foreign key → User.Key — NOT NULL
  • Key (coupon_id) — Foreign key → Coupon.Key — NOT NULL
  • Field (pay_state)
  • Field (quantity)
  • Field (buyr_zipx)
  • Field (vccode)
  • Field (price)
  • Field (total_price)
  • Field (created_at)
  • Field (updated_at)

User (사용자)

  • Key (id) — Primary key — NOT NULL
  • Field (name)