Proto
Tables (3)
buyTBL
- Field
- userName (CHAR(3))
- prodName (VARCHAR(45))
- amount (INT)
prodTBL
- prodName (Key) — Primary key — NOT NULL
- price (INT)
- Field
userTBL
- userName (Key) — Primary key — NOT NULL
- birthYear (INT) — NOT NULL
- addr (VARCHAR(45))
- mobile (VARCHAR(12))