project_2
Tables (7)
campus (지역)
- id — int — Primary key — NOT NULL
- name — varchar(10)
class (반)
- id — int — Primary key — NOT NULL
- pro_id — int — Foreign key → operating_pro.id — NOT NULL
- campus_id — int — Foreign key → campus.id — NOT NULL
- number — int
operating_pro (운영프로)
- id — int — Primary key — NOT NULL
- campus_id — int — Foreign key → campus.id — NOT NULL
- phone_number — varchar(20)
- name — varchar(10)
project (프로젝트)
- id — int — Primary key — NOT NULL
- pro_id — int — Foreign key → operating_pro.id — NOT NULL
- kind — varchar(5)
- title — varchar(45)
project_member (팀인원)
- student_id — int — Foreign key → students.id — NOT NULL
- project_id — int — Foreign key → project.id — NOT NULL
students (교육생)
- id — int — Primary key — NOT NULL
- campus_id — int — Foreign key → campus.id — NOT NULL
- class_id — int — Foreign key → class.id — NOT NULL
- name — varchar(10)
- phone_number — varchar(20)
textbook (교보재)
- id — int — Primary key — NOT NULL
- student_id — int — Foreign key → students.id — NOT NULL
- title — varchar(45)
- purchase_dt — date
- rental_dt — date
- return_dt — date
- is_return — boolean