BookMall

Tables (10)

Cart (Untitled6)

  • cart_id (Key3) — Primary key — NOT NULL
  • member_id (Key) — Foreign key → MEMBER.member_id — NOT NULL
  • product_id (Key2) — Foreign key → Product.id — NOT NULL
  • pub_id (Key22) — Foreign key → Product.pub_id — NOT NULL
  • categroy_id (Key32) — Foreign key → Product.categroy_id — NOT NULL
  • cnt (Field)

Coupon (Untitled2)

  • coupon_id (Key) — Primary key — NOT NULL
  • name (Field2)
  • exp (Field3)

Coupon_member (Untitled7)

  • member_id (Key) — Foreign key → MEMBER.member_id — NOT NULL
  • coupon_id (Key2) — Foreign key → Coupon.coupon_id — NOT NULL
  • date (Field)
  • used (Field2)

MEMBER

  • member_id — VARCHAR(50) — Primary key — NOT NULL
  • email (emai) — VARCHAR(100)
  • pw — VARCHAR(100)
  • name — VARCHAR(30)
  • phone — char(20)
  • gender — CHAR(10)
  • birth — DATE
  • date — DATE
  • point — int
  • login_platform — VARCHAR(30)
  • addr — VARCHAR(100)
  • adminCK — INT

Order (Untitled9)

  • order_id (Key) — Primary key — NOT NULL
  • product_id (Key2) — Foreign key → Product.id — NOT NULL
  • member_id (Key4) — Foreign key → MEMBER.member_id — NOT NULL
  • cart_id (Key3) — Foreign key → Cart.cart_id — NOT NULL
  • date (Field)
  • cnt (Field2)
  • price (Field3)

Payment (Untitled10)

  • pay_num (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
  • pay_method (Field2)
  • total_price (Field3)
  • monthly (Field)

Product (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • pub_id (Key2) — Foreign key → Pub.pub_id — NOT NULL
  • categroy_id (Key3) — Foreign key → category.categroy_id — NOT NULL
  • name (Field)
  • sell_cnt (Field2)
  • date (Field4)
  • price (Field6)
  • like (Field7)
  • desc (Field8)
  • quantity (Field9)

Pub (Untitled4)

  • pub_id (Key) — Primary key — NOT NULL
  • pub_title (Field3)
  • pub_dsc (Field)

Purchase_history (Untitled5)

  • member_id (Key) — Foreign key → MEMBER.member_id — NOT NULL
  • order_id (Key2) — Foreign key → Order.order_id — NOT NULL
  • date (Field)

category (Untitled8)

  • categroy_id (Key) — Primary key — NOT NULL
  • name (Field)
  • dsc (Field2)