shoppingmall table
Tables (3)
Order (Untitled)
- id (Key) — field — Primary key — NOT NULL
- product_id (id) — Foreign key → Product.id — NOT NULL
- user_id (id2) — Foreign key → User.id — NOT NULL
- order_date (Field) — date
Product (상품)
- id — field — Primary key — NOT NULL
- namen (ame) — char
- image — image
- description — text
- price — positiveinteger
- available_order (avaliable_order) — boolean
User (사용자)
- id — field — Primary key — NOT NULL
- emaile (email) — Email
- username — char
- gender — smallinteger,choice