dbtest

Tables (6)

Untitled (사원)

  • Key (사원번호) — Primary key — NOT NULL
  • Key (부서번호2) — Foreign key → Untitled.Key — NOT NULL
  • Field (사원명)
  • Field2 (담당업무)
  • Field3 (매니저)
  • Field4 (입사일자)
  • Field (급여)
  • Field2 (보너스)
  • Field3 (부서번호)

Untitled (부서)

  • Key (부서번호) — Primary key — NOT NULL
  • Field (부서명)
  • Field2 (부서위치)

Untitled (회원등급)

  • Key (등급코드) — Primary key — NOT NULL
  • Field (등급명)
  • Field2 (할인율)

Untitled (고객)

  • Key (회원번호) — Primary key — NOT NULL
  • Key (등급코드) — Foreign key → Untitled.Key — NOT NULL
  • Field (이름)
  • Field2 (연락처)
  • Field3 (주소)
  • Field4 (누적구매금액)
  • Field5 (회원등급)

Untitled (customer_level)

  • Key (level) — char(1) — Primary key — NOT NULL
  • Field (level_name) — varchar2(20)
  • Field2 (discount_rate) — number(3,2)

Untitled (customer)

  • Key (cid) — number(3) — Primary key — NOT NULL
  • Field (cname) — varchar2(30)
  • Field2 (mobile) — varchar2(15)
  • Field3 (address) — varchar2(100)
  • Field4 (accum_pur_amt) — number(10,1)
  • Field5 (clevel(FK)) — char(1)
  • Key (lcode) — char(1) — Foreign key → Untitled.Key — NOT NULL