dbtest

Tables (3)

Untitled (customer_level)

  • Key (level_code) — 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)
  • Field (accum_pur_amount) — number(10,1)
  • Key (lcode) — char(1) — Foreign key → Untitled.Key — NOT NULL

Untitled (t_studentList)

  • Key (id) — Primary key — NOT NULL
  • Field