imall

Tables (5)

bag (장바구니)

  • userId (FK) — Not Null — Foreign key → userac.userId — NOT NULL
  • goods_Num (Key) — Not Null — Foreign key → goods.goods_Num — NOT NULL
  • saveFileName (Field)
  • originalFileName (Field2)
  • created (Field3)
  • title (Field4)
  • price (Field5)

board (게시판)

  • Num (PK) — Not Null — Primary key — NOT NULL
  • userId (PK2) — Not Null — Foreign key → userac.userId — NOT NULL
  • userName (Field) — Not Null
  • subject (Field2)
  • content (Field3)
  • hitCount (Field4)
  • created (Field5)

goods (상품)

  • goods_Num (Key) — Not Null — Primary key — NOT NULL
  • title (Field) — Not Null
  • content (Field2) — Not Null
  • saveFileName (Field3)
  • originalFileName (Field4)
  • cate (Field5)
  • price (Field6)

orders (주문내역)

  • userId (FK) — Not Null — Foreign key → bag.userId — NOT NULL
  • goods_Num (Key) — Not Null — Foreign key → bag.goods_Num — NOT NULL
  • days (Field)
  • ordeq (Field2)
  • title (Field3)

userac (계정)

  • userId (PK) — Not Null — Primary key — NOT NULL
  • userPwd (Field) — Not Null
  • userName (Field2) — Not Null
  • userBirth (Field3) — Not Null
  • userTel (Field4) — Not Null
  • userAddr (Field5) — Not Null