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