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)