연스

테이블 (3)

Untitled (DEPARTMENT)

  • Key (DEPT_NO) — NUMBER — 기본 키 — NOT NULL
  • Field (DEPT_NM) — VARCHAR2(30) — NOT NULL

Untitled (JOBGRADE)

  • Key (JG_NO) — NUMBER — 기본 키 — NOT NULL
  • Field (JG_NM) — VARCHAR2(30) — NOT NULL

회원 (COMPANY)

  • MEM_ID (COMPANY_ID) — VARCHAR2(30) — 기본 키 — NOT NULL
  • MEM_PW (COMPANY_PW) — VARCHAR2(300) — NOT NULL
  • Field2 (COMPANY_NM) — VARCHAR2(300) — NOT NULL
  • Field4 (COMPANY_EMAIL) — VARCHAR2(300) — NOT NULL
  • Field5 (COMPANY_PHONE) — VARCHAR2(300) — NOT NULL
  • Key (DEPT_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
  • Key (JG_NO) — NUMBER — 외래 키 → Untitled.Key — NOT NULL