DDL_PRACTICE
Tables (3)
OUR_EMP (CLOUD_EMP)
- Key (EMP_ID) — NUMBER — Primary key — NOT NULL — 사번
- Field (EMP_NAME) — VARCHAR(50 CHAR) — NOT NULL — 이름
- Field2 (PHONE) — CHAR(13 CHAR) — NOT NULL — 휴대폰번호
- Field (HIRE_DATE) — DATE — 입사일
- Key (DEPT_CODE) — NUMBER — Foreign key → Untitled.Key — NOT NULL — 부서번호
Untitled (CLOUD_DEPT)
- Key (DEPT_CODE) — NUMBER — Primary key — NOT NULL — 부서번호
- Field (DEPT_TITLE) — VARCHAR2(50 CHAR) — NOT NULL — 부서명
board (Untitled)
- Key (NO) — number — Primary key — NOT NULL — 글번호
- Field (status) — varchar2