test

Tables (17)

Employee (사원)

  • emp_id (사원번호) — BIGINT — Primary key — NOT NULL — 사원번호
  • emp_name (사원명) — VARCHAR(255) — 사원명
  • key2 (부서번호) — Foreign key → Untitled.dept_id — NOT NULL — 부서번호
  • Key (관리자사원번호) — BIGINT — Foreign key → Employee.emp_id — NOT NULL — 사원번호

Untitled (학생정보)

  • Key (학생코드) — Primary key — NOT NULL
  • Field (이름)
  • Field (전화번호)

Untitled (연극정보)

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

Untitled (재료정보)

  • Key (재료번호) — Primary key — NOT NULL
  • Field (재료명)
  • Field (재료단가)

Untitled (요리정보)

  • Key (요리번호) — Primary key — NOT NULL
  • Field (요리명)
  • Field (소요시간)
  • Field (요리방법)

Untitled (요리재료내역)

  • Key (요리번호) — Foreign key → Untitled.Key — NOT NULL
  • Key (재료번호) — Foreign key → Untitled.Key — NOT NULL
  • Field (재료수량)

Untitled (출연진정보)

  • Key (이름코드) — Primary key — NOT NULL
  • Field (이름)

Untitled (연극출연자별급여)

  • Key (연극번호) — Foreign key → Untitled.Key — NOT NULL
  • Key (이름코드) — Foreign key → Untitled.Key — NOT NULL
  • Field (급여)

Untitled (수업)

  • 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 (이름)
  • Field (전화번호)

Untitled (과정)

  • Key (과정코드) — Primary key — NOT NULL
  • Field (과정명)
  • Field (수강료)
  • Field (기간)
  • Key (강사코드) — Foreign key → Untitled.Key — NOT NULL

Untitled (학과장)

  • Key (학과장번호) — Primary key — NOT NULL
  • Field (이름)
  • Field2 (전공)
  • Field3 (주소)
  • Field4 (전화번호)
  • Key (학과코드2) — Foreign key → Untitled.Key — NOT NULL

Untitled (학과)

  • Key (학과코드) — Primary key — NOT NULL
  • Field (학과명)
  • Field2 (정원)
  • Field3 (교수인원)

Untitled (장바구니)

  • Key (고객번호) — Foreign key → Untitled.Key — NOT NULL
  • Key (상품번호) — Foreign key → Untitled2.Key — NOT NULL

Untitled (부서)

  • dept_id (부서번호) — BIGINT — Primary key — NOT NULL — 부서번호
  • dept_namee (부서명) — VARCHAR(255) — NOT NULL — 부서명

Untitled2 (상품)

  • Key (상품번호) — Primary key — NOT NULL
  • Field (상품명)
  • Field (수량)
  • Field (단가)