test

Tables (5)

Untitled (손넴)

  • Key (손님번호) — Number — Primary key — NOT NULL
  • Field (ㅅㄴ이름)

Untitled (상품)

  • Key (상품번호) — Primary key — NOT NULL
  • Field (ㅅㅍ이름)

Untitled (주문)

  • Key (주문번호) — Primary key — NOT NULL
  • Key (손님번호) — Number — Foreign key → Untitled.Key — NOT NULL
  • Key (상품번호) — Foreign key → Untitled.Key — NOT NULL

Untitled2 (EMP)

  • Key — number — Primary key — NOT NULL
  • Key (dept_id) — Number — Foreign key → hello.Key — NOT NULL
  • Field — Varchar2

hello (DEPT)

  • Key (dept_id) — Number — Primary key — NOT NULL
  • Field (dept_name) — Varchar2
  • Field (dept_addr) — Varchar2