tim

Tables (5)

Untitled (t_studentList)

  • Key (ID) — Primary key — NOT NULL
  • Field (Name)

Untitled (Subject)

    Untitled (Professor)

      customer

      • cid — number(3) — Primary key — NOT NULL
      • cname — varchar2(30)
      • mobile — varchar2(15)
      • address — number(100)
      • accum_pur_amt — number(10,1)
      • level_code (lcode) — char(1) — Foreign key → customer_level.level_code — NOT NULL

      customer_level

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