연습
테이블 (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