학원테이블
테이블 (5)
classlist (강의목록)
- classlist_name (VARCHAR2(20)) — PK — 기본 키 — NOT NULL
- classlist_id (NUMBER(7)) — PK — 기본 키 — NOT NULL
- teacher_id (NUMBER(7)2) — PK — 외래 키 → teacher.teacher_id — NOT NULL
- classlist_time (VARCHAR2(15))
- classlist_teacher (VARCHAR2(5)) — FK
student (수강생테이블)
- student_id (NUMBER(7)) — PK — 기본 키 — NOT NULL
- classlist_name (VARCHAR2(20)2) — PK — 외래 키 → classlist.classlist_name — NOT NULL
- classlist_id (NUMBER(7)2) — PK — 외래 키 → classlist.classlist_id — NOT NULL
- teacher_id (NUMBER(7)22) — PK — 외래 키 → classlist.teacher_id — NOT NULL
- student_pass (VARCHAR2(15))
- student_name (VARCHAR2(20))
- student_regno1 (CHAR(6))
- student_regno2 (CHAR(7))
- student_bir (DATE)
- student_zip (CHAR(8))
- student_add1 (VARCHAR2(100))
- student_add2 (VARCHAR2(80))
- student_hometel (VARCHAR2(14))
- student_comtel (VARCHAR2(16))
- student_hp (VARCHAR2(17))
- student_mail (VARCHAR2(40))
- student_job (VARCHAR2(41))
- student_like (VARCHAR2(42))
- student_classlist (VARCHAR2(43)) — FK
- student_reg (VARCHAR2(10))
support1 (일반실업자)
- support1_id (NUMBER(7)) — PK — 기본 키 — NOT NULL
- student_id (NUMBER(7)2) — PK — 외래 키 → student.student_id — NOT NULL
- classlist_name (VARCHAR2(20)2) — PK — 외래 키 → student.classlist_name — NOT NULL
- classlist_id (NUMBER(7)22) — PK — 외래 키 → student.classlist_id — NOT NULL
- teacher_id (NUMBER(7)222) — PK — 외래 키 → student.teacher_id — NOT NULL
- support1_list (VARCHAR(20)) — FK
support2 (재직자과정)
- support2_id (NUMBER(7)) — PK — 기본 키 — NOT NULL
- student_id (NUMBER(7)2) — PK — 외래 키 → student.student_id — NOT NULL
- classlist_name (VARCHAR2(20)2) — PK — 외래 키 → student.classlist_name — NOT NULL
- classlist_id (NUMBER(7)22) — PK — 외래 키 → student.classlist_id — NOT NULL
- teacher_id (NUMBER(7)222) — PK — 외래 키 → student.teacher_id — NOT NULL
- support2_list (VARCHAR(20)) — FK
teacher (강사테이블)
- teacher_id (NUMBER(7)) — PK — 기본 키 — NOT NULL
- teacher_name (VARCHAR2(5))