ssafy

Tables (5)

device (Untitled2)

  • PK (device_id) — INT — Primary key — NOT NULL
  • FK (student_id) — INT — Foreign key → student.PK — NOT NULL
  • 제목 (title) — VARCHAR
  • 구입년월일 (purchase_date) — DATE
  • 대여일 (rental_date) — DATE
  • 반납일 (return_date) — DATE

mgr_pro (Untitled)

  • PK (mgr_id) — INT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR
  • 전화번호 (phone) — VARCHAR
  • 담당지역 (region) — VARCHAR
  • 담당반 (class) — VARCHAR
  • 팀 (team) — VARCHAR

project (Untitled4)

  • PK (project_id) — INT — Primary key — NOT NULL
  • 순번 (sequence) — VARCHAR
  • 제목 (title) — VARCHAR

project_student (Untitled5)

  • PK (project_student_id) — INT — Primary key — NOT NULL
  • FK (student_id) — INT — Foreign key → student.FK — NOT NULL
  • FK (project_id) — INT — Foreign key → project.PK — NOT NULL

student (Untitled3)

  • PK (student_id) — INT — Primary key — NOT NULL
  • FK (mgr_id) — INT — Foreign key → mgr_pro.PK — NOT NULL
  • 이름 (name) — VARCHAR
  • 전화번호 (phone) — VARCHAR
  • 캠퍼스 지역 (region) — VARCHAR
  • Field