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