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