shoppingmall

Tables (3)

tb_member (CopyOfUntitled)

  • 제품번호 (product_seq) — int(11) — Primary key — NOT NULL
  • 제품명 (product_name) — varchar(100)
  • 제품가격 (product_price) — int(11)
  • 생성일자 (reg_date) — datetime

tb_order (CopyOfCopyOfUntitled)

  • 제품번호 (product_seq) — int(11) — Primary key — NOT NULL
  • 제품번호 (product_seq2) — int(11) — Foreign key → tb_member.제품번호 — NOT NULL
  • 제품번호 (product_seq3) — int(11) — Foreign key → tb_product.제품번호 — NOT NULL
  • 제품명 (product_name) — varchar(100)
  • 제품가격 (product_price) — int(11)
  • 생성일자 (reg_date) — datetime

tb_product (Untitled)

  • 제품번호 (product_seq) — int(11) — Primary key — NOT NULL
  • 제품명 (product_name) — varchar(100)
  • 제품가격 (product_price) — int(11)
  • 생성일자 (reg_date) — datetime