2025-2- cource

Tables (4)

Member (Untitled)

  • 회원ID (member_id) — bigint — Primary key — NOT NULL
  • 회원로그인ID (member_login_id) — varchar(50)
  • 비밀번호 (member_pw) — varchar(100)
  • 적립금 (member_point) — int
  • Field

Order (Untitled2)

  • 주문ID (Key) — bigint — Primary key — NOT NULL
  • 주문일시 (Field) — datetime
  • 주문총액 (Field2) — int
  • 주문상태 (Field3) — varchar(20)
  • 회원ID (member_id) — bigint — Foreign key → Member.회원ID — NOT NULL

Order_Product (Untitled4)

  • 주문품목ID (Key2) — bigint — Primary key — NOT NULL
  • 주문ID (Key3) — bigint — Foreign key → Order.주문ID — NOT NULL
  • 상품ID (Key4) — bigint — Foreign key → Product.상품ID — NOT NULL

Product (Untitled3)

  • 상품ID (Key) — bigint — Primary key — NOT NULL
  • 재고량 (Field) — int
  • 가격 (Field2) — int
  • 상품이름 (Field3) — varcahr(50)