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