연습용

테이블 (5)

books

  • book_id — INT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • author — VARCHAR(255) — NOT NULL
  • publisher — VARCHAR(255)
  • price — DECIMAL(10,2)
  • category_id — INT — NOT NULL

categories

  • category_id — INT — 기본 키 — NOT NULL
  • category_name — VARCHAR(255) — NOT NULL
  • position — INT

departments

  • department_id — INT — 기본 키 — NOT NULL
  • department_name — VARCHAR(255) — NOT NULL

loans

  • loan_id — INT — 기본 키 — NOT NULL
  • loan_date — DATETIME — NOT NULL
  • return_date — DATETIME — NOT NULL
  • student_id — INT — NOT NULL
  • book_id — INT — NOT NULL

students

  • student_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(255)
  • address — VARCHAR(255)
  • phone — VARCHAR(50)
  • department_id — INT — NOT NULL
  • department_id (department_id2) — INT — 외래 키 → departments.department_id — NOT NULL