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 (단가)