111

Tables (15)

CLASS (Untitled3)

  • CL_CODE (Key) — Primary key — NOT NULL
  • SD_NO (Key3) — Foreign key → STUDENT.SD_NO — NOT NULL
  • CL_NAME (Field)
  • CL_PRICE (Field2)
  • CL_DATE (Field3)
  • TC_NO (Key2) — Foreign key → TEACHER.TC_NO — NOT NULL

STUDENT (Untitled2)

  • SD_NO (Key) — Primary key — NOT NULL
  • SD_NAME (Field)
  • SD_TEL (Field2)

TEACHER (Untitled)

  • TC_NO (Key) — Primary key — NOT NULL
  • TC_NAME (Field)
  • TC_TEL (Field2)

Untitled4 (연극출연자별급여)

  • Key (연극번호) — Primary key — NOT NULL
  • Field (연극제목)
  • Field2 (감독)
  • Field (연극내용)
  • Field2 (극장)
  • Field3 (출연진)
  • Field (급여)

Untitled4 (연극)

  • Key (연극번호) — Primary key — NOT NULL
  • Field (제목)
  • Field (감독)
  • Field (극장)
  • Field (연극내용)

Untitled4 (출연진)

  • Key (연극번호) — Foreign key → Untitled4.Key — NOT NULL
  • Key (배우번호) — Foreign key → Untitled4.Key — NOT NULL
  • Field (급여)

Untitled4 (회원)

  • Key (회원번호) — Primary key — NOT NULL
  • Field (회원명)
  • Field (전화번호)
  • Key (등급) — Foreign key → Untitled4.Key — NOT NULL

Untitled4 (게시판별댓글)

  • Key (게시판번호) — Primary key — NOT NULL
  • Field (제목)
  • Field (내용)
  • Field (댓글내용)
  • Field (게시판작성자)
  • Field2 (댓글작성자)

Untitled4 (게시판)

  • Key (게시판번호) — Primary key — NOT NULL
  • Field (제목)
  • Field (내용)
  • Key (게시판 작성자) — Foreign key → Untitled4.Key — NOT NULL

Untitled4 (댓글)

  • Key (댓글번호) — Primary key — NOT NULL
  • Field (댓글내용)
  • Key (게시판번호) — Foreign key → Untitled4.Key — NOT NULL
  • Key (댓글작성자) — Foreign key → Untitled4.Key — NOT NULL

Untitled4 (강사)

  • Key (강사코드) — Primary key — NOT NULL
  • Field (이름)
  • Field (이메일)
  • Field (전화번호)

Untitled4 (온라인강의)

  • Key (개강일) — Primary key — NOT NULL
  • Key (강사코드) — Foreign key → Untitled4.Key — NOT NULL
  • Field (과목명) — Foreign key → Untitled4.Field
  • Field (강의료)

Untitled4 (과목)

  • Field (과목명) — Primary key
  • Field (과목설명)
  • Field (과목카테고리)

Untitled4 (배우)

  • Key (배우번호) — Primary key — NOT NULL
  • Field (배우이름)

Untitled4 (등급)

  • Key (등급) — Primary key — NOT NULL
  • Field (적립퍼센트)