shopping

Tables (5)

buyList (Untitled3)

  • buyListNum (주문번호) — int — Primary key — NOT NULL
  • boughtDate (주문일) — date
  • amount (수량) — int
  • totalMoney (결제액) — int
  • productCode (제품코드) — int — Foreign key → product.productCode — NOT NULL
  • id (아이디) — varchar(13) — Foreign key → user.id — NOT NULL

cateegory (CopyOfCopyOfUntitled)

  • categoryCode (분류코드) — int — Primary key — NOT NULL
  • categoryName (분류명) — varchar(50)

product (CopyOfUntitled)

  • productCode (제품코드) — int — Primary key — NOT NULL
  • productName (제품명) — varchar(50)
  • productContent (제품내용) — varchar(100)
  • categoryCode (분류코드) — int — Foreign key → cateegory.categoryCode — NOT NULL

user (Untitled)

  • id (아이디) — varchar(13) — Primary key — NOT NULL
  • pw (비밀번호) — varchar(15)
  • email (이메일) — varchar(30)
  • telnum (전화번호) — int
  • isAdmin (어드민) — boolean
  • loginTry (로그인실패횟수) — int

userIdentify (Untitled2)

  • idNum (인증번호) — int — Primary key — NOT NULL
  • idCode (인증코드) — int
  • expirationDate (만료기간) — datetime
  • id (아이디) — varchar(13) — Foreign key → user.id — NOT NULL