Database 설계 및 SQL 작성

테이블 (5)

Book (교보재)

  • student_id (Key) — IntegerField — 외래 키 → Student.student_id — NOT NULL
  • pro_id (Key2) — IntegerField — 외래 키 → Student.pro_id — NOT NULL
  • lender (Field4) — CharField
  • title (Field) — CharField
  • day_of_purchase (Field2) — DateField
  • rental_date (Field3) — DateField
  • return_date (Field5) — DateField

Pro (Untitled)

  • pro_id (Key) — IntegerField — 기본 키 — NOT NULL
  • name (Field) — CharField
  • phone_number (Field2) — PhoneNumberField

Project (Untitled3)

  • project_id (Key) — 기본 키 — NOT NULL
  • turn (Field) — IntegerField
  • title (Field2) — CharField

Student (Untitled2)

  • student_id (Key) — IntegerField — 기본 키 — NOT NULL
  • pro_id (Key2) — IntegerField — 외래 키 → Pro.pro_id — NOT NULL
  • name (Field) — CharField
  • phone_number (Field2) — PhoneNumberField
  • Campus (Field3) — CharField

Untitled4

  • student_id (Key) — IntegerField — 외래 키 → Student.student_id — NOT NULL
  • pro_id (Key2) — IntegerField — 외래 키 → Student.pro_id — NOT NULL
  • project_id (Key3) — 외래 키 → Project.project_id — NOT NULL
  • student_id (Field)
  • project_id (Field2)