shoppingmall
Tables (3)
Employee (Untitled3)
- id (Key) — varchar(20) — Primary key — NOT NULL
- pwd (Field) — varchar(20)
- name (Field2) — varchar(20)
- email (Field3) — varchar(40)
- phonev (Field4) — varchar(20)
Product (Untitled2)
- prodnum (Key) — number(5) — Primary key — NOT NULL
- name (Field) — varchar(20)
- price (Field2) — INT
- content (Field3) — varchar(1000)
- UserNumber (Field4) — varchar(20) — Foreign key → User.UserNumber
User (Untitled)
- UserNumber (Field) — varchar(20) — Primary key
- pwd (Field2) — varchar(20)
- name (Field3) — varchar(20)
- email (Field4) — varchar(40)
- address (Field5) — varchar(100)
- phone (Field6) — varchar(20)