학사관리시스템
테이블 (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)