SFC
Tables (8)
category (Untitled2)
- category_no (Key) — Primary key — NOT NULL
- earring (Field)
- necklace (Field2)
- ring (Field3)
- all (Field6)
earing_info (Untitled6)
- earing_no (Key) — Primary key — NOT NULL
- product_no (Key2) — Foreign key → productinfo.product_no — NOT NULL
- category_no (Key22) — Foreign key → productinfo.category_no — NOT NULL
member (Untitled)
- member_no (Key) — Primary key — NOT NULL
- member_id (Field)
- member_pw (Field2)
- member_gender (Field3)
- member_birth (Field4)
- member_phone (Field5)
- member_email (Field6)
- member_joindate (Field7)
- member_address (Field8)
mypage (Untitled4)
- memer_no (Key) — Primary key — NOT NULL
necklace_info (Untitled8)
- necklace_info (Key) — Primary key — NOT NULL
- product_no (Key2) — Foreign key → productinfo.product_no — NOT NULL
- category_no (Key22) — Foreign key → productinfo.category_no — NOT NULL
productinfo (Untitled3)
- product_no (Key) — Primary key — NOT NULL
- category_no (Key2) — Foreign key → category.category_no — NOT NULL
- product_name (Field)
- product_image (Field2)
- product_price (Field3)
- product_saleprice (Field4)
- product_writedate (Field5)
- Field6
ring_info (Untitled7)
- ring_no (Key) — Primary key — NOT NULL
- product_no (Key2) — Foreign key → productinfo.product_no — NOT NULL
- category_no (Key22) — Foreign key → productinfo.category_no — NOT NULL
- ring_size (Field)
wishlist (Untitled5)
- wishlist_no (Key) — Primary key — NOT NULL
- Field