Proto
Tables (3)
buyTBL
- userName — VARCHAR(3) — Foreign key → userTBL.userName — NOT NULL
- prodName — VARCHAR(45) — Foreign key → prodTBL.prodName — NOT NULL
- amount — INT — NOT NULL
prodTBL
- prodName — VARCHAR(45) — Primary key — NOT NULL
- price — INT — NOT NULL
- company — VARCHAR(45)
userTBL
- userName — VARCHAR(3) — Primary key — NOT NULL
- birthYear (birtYear) — INT — NOT NULL
- addr — VARCHAR(45) — NOT NULL
- mobile — VARCHAR(12)