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