BLUE
Tables (4)
cart (Untitled3)
- cartSeq (Key) — int — Primary key — NOT NULL — AUTO_INCREMENT
- userId (Key2) — varchar(45 — Foreign key → user.userId — NOT NULL
- itemSeq (Key3) — int — Foreign key → item.itemSeq — NOT NULL — AUTO_INCREMENT
item (Untitled2)
- itemSeq (Key) — int — Primary key — NOT NULL — AUTO_INCREMENT
- itemName (Field2) — varchar(45)
- itemImg (Field3) — varchar(45)
- itemPrice (Field4) — varchar(45)
- itemInfo (Field5) — varchar(500)
- itemRole (Field6) — int — DEFAULT 0
order (Untitled4)
- orderSeq (Key) — int — Primary key — NOT NULL — AUTO_INCREMENT
- userId (Key2) — varchar(45 — Foreign key → user.userId — NOT NULL
- itemSeq (Key3) — int — Foreign key → item.itemSeq — NOT NULL — AUTO_INCREMENT
- totalPrice (Field3) — varchar(45)
- addr (Field4) — varchar(255)
- orderStatus (Field5) — int
user (Untitled)
- userId (Key) — varchar(45 — Primary key — NOT NULL
- userPw (Field2) — varchar(45)
- userName (Field3) — varchar(45)
- userEmail (Field4) — varchar(45)
- userTel (Field5) — varchar(45)
- addr (Field6) — varchar(45)
- detailAddr (Field7) — varchar(45)
- postNum (Field8) — varchar(45)