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