test
Tables (4)
member
- userid (VARCHAR(16)) — NOT NULL — Primary key — NOT NULL
- username (VARCHAR(20)) — NOT NULL — NOT NULL
- grade (ENUM('A', 'B', 'C')) — NOT NULL
orderdetail
- Key — Primary key — NOT NULL
- orderid (INT) — NOT NULL — Foreign key → orders.orderid — NOT NULL
- Field
- Field2
orders
- orderid (INT) — NOT NULL — Primary key — NOT NULL
- orderdate (TIMESTAMP) — NOT NULL
product
- Key — Primary key — NOT NULL
- Field
- Field2