daily_1_자유1_Database설계 및 SQL작성
테이블 (5)
Book (book)
- ISBN (isbn) — INT — 기본 키 — NOT NULL
- Title (title) — VARCHAR(2000)
- Buy Date (but_date) — DATE
- Due Date (due_date) — DATE — NOT NULL
- Return Date (return_date) — DATE — NOT NULL
- Borrower (borrower) — INT — 외래 키 → Student.ID — NOT NULL
Manager (manager)
- ID (id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(255)
- Phone (phone) — VARCHAR(255)
- Responsible Region (responsible_region) — VARCHAR(200)
- Responsible Class (responsible_class) — int
- Responsible Team (responsible_team) — VARCHAR(100)
Project (project)
- Project ID (project_id) — INT — 기본 키 — NOT NULL
- Project Type (project_type) — VARCHAR(100)
- Project Title (project_title) — VARCHAR(255)
Project Members (project_members)
- Project ID (project_id) — INT — 외래 키 → Project.Project ID — NOT NULL
- ID (id2) — INT — 외래 키 → Student.ID — NOT NULL
Student (student)
- ID (id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(255)
- Phone (phone) — VARCHAR(255)
- Region (region) — VARCHAR(200)
- Borrow Book Count (borrow_book_cnt) — int
- Responsible Manager (responsible_manager) — INT — 외래 키 → Manager.ID