수강신청
테이블 (5)
Course (Untitled2)
- Key (course_id) — Long — 기본 키 — NOT NULL
- Key (major_id) — Long — 외래 키 → Major.Key — NOT NULL
- Field (course_name) — varchar(255)
Major (Untitled)
- Key (major_id) — Long — 기본 키 — NOT NULL
- Field (major_name) — varchar(255)
User (Untitled3)
- Key (user_id) — Long — 기본 키 — NOT NULL
- Key (major_id) — Long — 외래 키 → Major.Key — NOT NULL
- Field (email) — varchar(255)
- Field (login_id) — varchar(255)
- Field2 (password) — varchar(255)
- Field (phone_number) — varchar(255)
- Field2 (role) — varchar(255)
- Field3 (username) — varchar(255)
- Field (created_date) — DateTime
- Field2 (modified_date) — DateTime
classes (Untitled4)
- Key (class_id) — Long — 기본 키 — NOT NULL
- Key (course_id) — Long — 외래 키 → Course.Key — NOT NULL
- Field (class_number) — Integer
- Field2 (cur_student_num) — Integer
- Field3 (max_student_num) — Integer
- Field4 (professor_name) — varchar(255)
take_class (Untitled5)
- Key (take_id) — Long — 기본 키 — NOT NULL
- Key (class_id) — Long — 외래 키 → classes.Key — NOT NULL
- Key (user_id) — Long — 외래 키 → User.Key — NOT NULL