ㄴㄴㄴ

Tables (8)

Comment

  • CommentID — INT
  • QuestionID — INT
  • MemberID — INT
  • Content — TEXT — NOT NULL
  • CreationDate — DATETIME — NOT NULL

Manufacturer

  • ManufacturerID — INT
  • ManufacturerName — VARCHAR(100) — NOT NULL
  • Phone — VARCHAR(15)
  • ContactPerson — VARCHAR(100)
  • Address — VARCHAR(255)

Member

  • MemberID — INT
  • Name — VARCHAR(100) — NOT NULL
  • Phone — VARCHAR(15)
  • Email — VARCHAR(100)
  • Address — VARCHAR(255)

Order

  • OrderID — INT
  • MemberID — INT
  • DeliveryAddress — VARCHAR(255)
  • OrderDate — DATE — NOT NULL

OrderDetail

  • OrderDetailID — INT
  • OrderID — INT
  • ProductID — INT
  • Quantity — INT — NOT NULL

Product

  • ProductID — INT
  • ProductName — VARCHAR(100) — NOT NULL
  • Stock — INT — NOT NULL
  • UnitPrice — DECIMAL(10, 2) — NOT NULL

ProductManufacturer

  • ProductID — INT
  • ManufacturerID — INT

Question

  • QuestionID — INT
  • Title — VARCHAR(255) — NOT NULL
  • MemberID — INT
  • CreationDate — DATETIME — NOT NULL