연습

테이블 (8)

Course

  • CourseID — INT
  • CourseName — VARCHAR(100) — NOT NULL
  • Credit — INT — NOT NULL
  • ProfessorID — INT

Customer

  • CustomerID — INT
  • FirstName — VARCHAR(50) — NOT NULL
  • LastName — VARCHAR(50) — NOT NULL
  • Email — VARCHAR(100)
  • Phone — VARCHAR(15)
  • Country — VARCHAR(50)

Enrollment

  • EnrollmentID — INT
  • StudentID — INT — NOT NULL
  • CourseID — INT — NOT NULL
  • Grade — CHAR(1)

Order

  • OrderID — INT
  • CustomerID — INT — NOT NULL
  • OrderDate — DATETIME
  • TotalAmount — DECIMAL(10, 2) — NOT NULL

OrderItem

  • OrderItemID — INT
  • OrderID — INT — NOT NULL
  • ProductID — INT — NOT NULL
  • Quantity — INT
  • UnitPrice — DECIMAL(10, 2) — NOT NULL

Product

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

Professor

  • ProfessorID — INT
  • Name — VARCHAR(100) — NOT NULL
  • Department — VARCHAR(100) — NOT NULL

Student

  • StudentID — INT
  • Name — VARCHAR(100) — NOT NULL
  • Grade — INT — NOT NULL