ㅛㅓ
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