ㅛㅓ

Tables (5)

Product (상품관련)

  • 상품코드 (Product_code) — not null — Primary key
  • 상품이름 (Product_name) — not null
  • 상품수량 (Product_amount) — not null
  • 상품가격 (Product_price) — not null
  • 상품브랜드 (Product_brand) — not null
  • 상품인기순위 (Product_best) — null
  • 파일 (file1) — null
  • 파일이름 (filename) — null

Untitled (주문)

  • Field (order_idx) — not null — Primary key
  • 회원아이디 (order_id) — not null — Foreign key → member.회원아이디
  • Field (order_cart) — not null — Foreign key → Untitled2.Field
  • 상품코드 (order_code) — not null — Foreign key → Product.상품코드
  • Field (order_name) — not null
  • Field (order_phone) — not null
  • Field (order_product) — not null
  • Field (order_sum) — not null
  • Field (order_addr1) — null
  • Field (order_addr2) — null
  • Field (order_addr3) — null
  • Field (delivery_state) — defalut 'payment'

Untitled (관리자)

  • Field (memberid) — not null — Primary key
  • Field (memberpw) — not null
  • Field (membername) — not null

Untitled2 (장바구니)

  • Field (cart_id) — not null — Primary key
  • 회원아이디 (memberid2) — not null — Foreign key → member.회원아이디
  • 상품코드 (Product_code) — not null — Foreign key → Product.상품코드
  • Field (amount) — null

member (회원)

  • 회원아이디 (memberid) — not null — Primary key
  • 회원비밀번호 (memberpw) — not null
  • 회원이름 (membername) — not null
  • 회원이메일 (memberemail) — not null
  • 회원번호 (midx) — notnull