hanbitMart
테이블 (5)
게시글
- Key (post_num) — 기본 키 — NOT NULL
- Field (post_name)
- Field (post_content)
- Field (post_date)
- Key (user_id) — 외래 키 → 회원.Key — NOT NULL
상품
- Key (product_id) — 기본 키 — NOT NULL
- Field (product_name)
- Field (product_quantity)
- Field (product_price)
- Key (mnfc_name) — 외래 키 → 제조업체.Key — NOT NULL
- Field (mnfc_quantity)
- Field (mnfc_date)
제조업체
- Key (mnfc_name) — 기본 키 — NOT NULL
- Field (mnfc_num)
- Field (mnfc_location)
- Field (mnfc_manager)
주문
- Field (order_num)
- Field (order_quantity)
- Field (order_address)
- Field (order_date)
- Key (user_id) — 외래 키 → 회원.Key — NOT NULL
- Key (product_id) — 외래 키 → 상품.Key — NOT NULL
회원
- Key (user_id) — 기본 키 — NOT NULL
- Field (user_pw)
- Field (user_name)
- Field (user_age)
- Field (user_job)
- Field (user_grade)
- Field (user_milage)