dismiss

Tables (7)

cart (장바구니)

  • cart_id (Key) — int — Primary key — NOT NULL
  • total_price (Field) — int
  • customer_id (Key2) — int — Foreign key → customer.customer_id — NOT NULL

cart_item (장바구니상품)

  • cart_id (Key) — int — Foreign key → cart.cart_id — NOT NULL
  • item_id (Key2) — int — Foreign key → item.item_id — NOT NULL

customer (고객)

  • customer_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(255)
  • address (Field2) — varchar(255)
  • tel (Field3) — varchar(255)
  • coupon_count (Field4) — int

item (상품)

  • item_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(255)
  • type (Field2) — varchar(255)
  • price (Field3) — int
  • score (Field4) — float
  • amount (Field5) — int

order_item (주문상품)

  • item_id (Key) — int — Foreign key → item.item_id — NOT NULL
  • order_id (Key2) — int — Foreign key → orders.order_id — NOT NULL

orders (주문)

  • order_id (Key) — int — Primary key — NOT NULL
  • deliverycondition (Field) — int
  • pucharse_date (Field2) — DATE
  • customer_id (Key2) — int — Foreign key → customer.customer_id — NOT NULL

review (리뷰)

  • customer_id (Key) — int — Foreign key → customer.customer_id — NOT NULL
  • item_id (Key2) — int — Foreign key → item.item_id — NOT NULL
  • score (Field) — int
  • comments (Field2) — varchar(255)