ㄹㅇㅁ
Tables (5)
BOOKS
- Registration_Number — CHAR(10) — Primary key — NOT NULL
- B_Name — VARCHAR(100) — NOT NULL
- Author — VARCHAR(100) — NOT NULL
- Publisher — VARCHAR(100) — NOT NULL
- P_Year — CHAR(4) — NOT NULL
- Category_key — NVARCHAR(20) — NOT NULL
- Location — NVARCHAR(20) — NOT NULL
- CURRENCY — NVARCHAR(20) — NOT NULL
- PRICE — DECIMAL(10,2) — NOT NULL
- ISBN — CHAR(13) — NOT NULL
- Status — ENUM('B','R') — NOT NULL
DEPARTMENT
- Dept_ID — INT — Primary key — NOT NULL
- Dept_NAME — VARCHAR(100) — NOT NULL
FACULTY
- Faculty_ID — CHAR(9) — Primary key — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Fname — VARCHAR(100) — NOT NULL
- Fclass — ENUM('Professor','Staff','TA') — NOT NULL
- Gender — ENUM('Male','Female') — NOT NULL
- Dept_ID — INT — NOT NULL
- Date_of_Birth — CHAR(10) — NOT NULL
- Email_Address — VARCHAR(100) — NOT NULL
- Phone_number — CHAR(13) — NOT NULL
STUDENT
- Student_ID — CHAR(9) — Primary key — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Fname — VARCHAR(100) — NOT NULL
- Gender — ENUM('Male','Female') — NOT NULL
- Date_of_Birth — CHAR(10) — NOT NULL
- Email_Address — VARCHAR(100) — NOT NULL
- Phone_number — CHAR(13) — NOT NULL
- Dept_ID — INT — Foreign key → DEPARTMENT.Dept_ID — NOT NULL
S_RENT
- Time — DATETIME — NOT NULL
- Type — ENUM('B','R') — NOT NULL
- Student_ID — CHAR(9) — Foreign key → STUDENT.Student_ID — NOT NULL
- Registration_Number — CHAR(10) — Foreign key → BOOKS.Registration_Number — NOT NULL