practice

Tables (11)

Untitled (연극)

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

Untitled (출연진 급여)

  • Key (출연자번호) — Primary key — NOT NULL
  • Field (급여)
  • Key (출연진) — NOT NULL
  • Key (연극번호) — Foreign key → Untitled.Key — NOT NULL

Untitled (게시판)

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

Untitled (회원)

  • Key (회원번호) — Primary key — NOT NULL
  • Field (회원명)
  • Field (전화번호)
  • Field2 (등급)
  • Field (적립퍼센트)

Untitled (게시판별댓글)

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

Untitled (강사)

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

Untitled (과목)

  • Key (과목명) — Primary key — NOT NULL
  • Field (과목설명)
  • Field2 (과목카테고리)

Untitled (강의)

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

Untitled (고객)

  • Key (고객전화번호) — Primary key — NOT NULL
  • Field (주문주소)

Untitled (주문)

  • Key (주문번호) — Primary key — NOT NULL
  • Key (메뉴명) — Foreign key → Untitled.Key — NOT NULL
  • Field (수량)
  • Key (고객전화번호) — Foreign key → Untitled.Key — NOT NULL

Untitled (메뉴)

  • Key (메뉴명) — Primary key — NOT NULL
  • Field (메뉴가격)