test

Tables (4)

product (주문)

  • order_id (주문아이디) — Primary key — NOT NULL
  • user_id (사용자id2) — Foreign key → user.user_id — NOT NULL
  • created_at (주문시간)
  • total_price (Field)

product (상품)

  • product_id (상품아이디) — Primary key — NOT NULL
  • price (Field)

product_num (주문내역)

  • order_id (주문아이디) — Foreign key → product.order_id — NOT NULL
  • count (상품갯수)
  • product_id (사품아이디)

user (사용자)

  • user_id (사용자id) — Primary key — NOT NULL
  • email (Field)
  • nickname (닉네임)