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