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)