김희정

테이블 (8)

Comment

  • CommentID — INT — 기본 키
  • PostID (PostID2) — INT — 외래 키 → Post.PostID
  • PostID — INT — NOT NULL
  • ParentCommentID — INT
  • Content — TEXT — NOT NULL
  • AuthorID — INT — NOT NULL
  • CreatedAt — DATETIME — NOT NULL

Member

  • MemberID — INT — 기본 키
  • Name — VARCHAR(100) — NOT NULL
  • PhoneNumber — VARCHAR(15)
  • Email — VARCHAR(255)
  • Address — VARCHAR(255)

OrderDetail

  • OrderDetailID — INT — 기본 키
  • OrderID — INT — NOT NULL
  • ProductID — INT — NOT NULL
  • Quantity — INT — NOT NULL

OrderHeader

  • OrderID — INT — 기본 키
  • MemberID — INT — NOT NULL
  • OrderDate — DATE — NOT NULL
  • ShippingAddress — VARCHAR(255) — NOT NULL
  • MemberID (MemberID2) — INT — 외래 키 → Member.MemberID

Post

  • PostID — INT — 기본 키
  • Title — VARCHAR(255) — NOT NULL
  • Content — TEXT
  • AuthorID — INT — NOT NULL
  • CreatedAt — DATETIME — NOT NULL
  • MemberID — INT — 외래 키 → Member.MemberID

Product

  • ProductID — INT — 기본 키
  • ProductName — VARCHAR(100) — NOT NULL
  • Stock — INT — NOT NULL
  • UnitPrice — DECIMAL(10, 2) — NOT NULL
  • OrderDetailID — INT — 외래 키 → OrderDetail.OrderDetailID
  • ProductSupplyID — INT — 외래 키 → ProductSupply.ProductSupplyID
  • OrderID — INT — 외래 키 → OrderHeader.OrderID

ProductSupply

  • ProductSupplyID — INT — 기본 키
  • SupplierID — INT — NOT NULL
  • ProductID — INT — NOT NULL
  • SupplyDate — DATE — NOT NULL
  • Quantity — INT — NOT NULL

Supplier

  • SupplierID — INT — 기본 키
  • SupplierName — VARCHAR(100) — NOT NULL
  • PhoneNumber — VARCHAR(15)
  • ContactName — VARCHAR(100)
  • Address — VARCHAR(255)
  • ProductSupplyID — INT — 외래 키 → ProductSupply.ProductSupplyID