DB_week12

Tables (4)

Untitled (사원)

  • Key (사원번호) — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Key3 — Primary key — NOT NULL
  • Field
  • Field2

Untitled (customer_level)

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

Untitled (customer)

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

Untitled

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3