1

Tables (5)

Untitled (Book)

  • Key (IBSN) — char(50) — Primary key — NOT NULL
  • Field (B-name) — char(30)
  • Field (B-writerid) — int
  • Field (B-publishid) — int
  • Field (B-price) — float
  • Field (Num-total) — int
  • Field (Num-remain) — int
  • Field2 (Condition) — char(5)
  • Field (Class-no) — char(5) — Foreign key → Untitled.Field
  • Field (ID) — char(30) — Foreign key → publishID.Field

Untitled (belongto)

  • Field (writeid) — char(30)
  • Key (IBSN) — char(50) — Foreign key → Untitled.Key — NOT NULL
  • Field (Id) — char(30) — Foreign key → Untitled.Field

Untitled (Classfy)

  • Field (Class-no) — char(5) — Primary key
  • Field (B-class) — char(30)

Untitled (Write)

  • Field (Id) — char(30) — Primary key
  • Field (SSN) — char(30)
  • Field (Name) — char(30)
  • Field (Adress) — char(50)

publishID

  • Field (ID) — char(30) — Primary key
  • Field (NAME) — char(30)
  • Field (Address) — char(50)