ShopMallDeliver
Tables (4)
Goods (Untitled3)
- 판매자id (SallerID) — int — Primary key — NOT NULL
- 상품명 (Goods_name) — varchar(200) — NOT NULL
- 상품코드 (Goods_code) — varchar(100) — NOT NULL
Order (Untitled4)
- 주문번호 (Order_ID) — int — Primary key — NOT NULL
- CustomID (customer_id) — int — NOT NULL
- 상품코드 (Goods_code) — varchar(100) — NOT NULL
- 판매자id (SalerID) — int — NOT NULL
- 판매가격 (Sales_Price) — int — NOT NULL
- 배송상태 (del_status) — varchar(200) — NOT NULL
- 주문일자 (Order_date) — varchar(100) — NOT NULL
- 배송시작일 (Field)
Saler (Untitled2)
- 판매자 (SalerID) — int — Primary key — NOT NULL
- 판매자명 (Name) — varchar(30) — NOT NULL
- 주소 (OfficeAddress) — varchar(200) — NOT NULL
- 전화번호 (PhoneNumber) — varchar(50) — NOT NULL
- 결재계좌 (AccountNo) — varchar(100) — NOT NULL
- Mobile (PhoneNo) — varchar(100) — NOT NULL
Untitled
- CustomID (customer_id) — int — Primary key — NOT NULL
- CustomName (Custom_Name) — vadrchar(30) — NOT NULL
- PhoneNo (Custom_phoneNo) — varchar(30) — NOT NULL