학원테이블

테이블 (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))