aa
Tables (3)
buytbl
- num — INT — Primary key — NOT NULL
- userID — char(8) — Foreign key → usertbl.userID — NOT NULL
- id — INT — Foreign key → producttbl.id — NOT NULL
producttbl
- id — INT — Primary key — NOT NULL
- name — VARCHAR(20)
- price — INT
usertbl
- userID — char(8) — Primary key — NOT NULL
- name — varchar(10)
- addr — char(2)