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