학사관리시스템

테이블 (11)

Student (Students)

  • Key (student_id) — INT — 기본 키 — NOT NULL
  • Field (student_name) — VARCHAR(10) — NOT NULL
  • Field (student_mobile) — INT
  • Field (student_email) — VARCHAR(50)
  • Field (student_address) — VARCHAR(50)
  • Field2 (guardian) — VARCHAR(20)
  • Field (birthplace) — VARCHAR(50)
  • Field (gender) — VARCHAR(10) — NOT NULL
  • Key (professor_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Major)

  • Key (major_id) — INT — 기본 키 — NOT NULL
  • Field (major_name) — VARCHAR(20) — NOT NULL
  • Field (major_outline) — TEXT

Untitled (Student_Major)

  • Key (student_id) — INT — 외래 키 → Student.Key — NOT NULL
  • Key (major_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Department(학과))

  • Key (department_id) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (establish_year) — INT — NOT NULL
  • Key (major_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (room_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (building_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Building)

  • Key (building_id) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (building_name) — VARCHAR(30)

Untitled (Room)

  • Key (room_id) — INT — 기본 키 — NOT NULL
  • Key (building_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Professor)

  • Key (professor_id) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (professor_name) — VARCHAR(20) — NOT NULL
  • Field (professor_mobile) — INT
  • Field (professor_email) — VARCHAR(50)
  • Field (gender) — VARCHAR(10) — NOT NULL
  • Key (room_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (building_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (major_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Lecture)

  • Key (lecture_id) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field (lecture_name) — VARCHAR(20) — NOT NULL
  • Key (subject_id) — INT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Subject)

  • Key (subject_id) — INT — 기본 키 — NOT NULL
  • Field (subject_name) — VARCHAR(20)

Untitled (Opening_Lecture)

  • Key (lecture_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (professor_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (lecture_outline) — TEXT
  • Key (room_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (building_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Student_Lecture)

  • Key (student_id) — INT — 외래 키 → Student.Key — NOT NULL
  • Key (lecture_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (professor_id) — VARCHAR(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (year) — DATE — NOT NULL
  • Field (credit) — VARCHAR(10)