madang DB

Tables (3)

book (Untitled)

  • bookid (Key) — int — Primary key — NOT NULL
  • bookname (Field) — varchar(20)
  • publisher (Field2) — varchar(20)
  • price (Field4) — int

customer (Untitled2)

  • custid (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • address (Field2) — varchar(20)
  • phone (Field3) — varchar(20)

order (Untitled3)

  • orderid (Key) — int — Primary key — NOT NULL
  • custid (Key3) — int — Foreign key → customer.custid — NOT NULL
  • saleprice (Field3) — int
  • orderdate (Field4) — date
  • bookid (Key2) — int — Foreign key → book.bookid — NOT NULL