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