jaeyeonShop

Tables (7)

Board (board)

  • Key — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → User.Key — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(45)
  • Field3 — INT

Cart (cart)

  • Key — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → User.Key — NOT NULL
  • Key (Key3) — INT — Foreign key → Product.Key — NOT NULL
  • Key (Key4) — INT — Foreign key → ProductOrder.Key — NOT NULL
  • Field4 — INT

Comment (Untitled)

  • Key — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → User.Key — NOT NULL
  • Field — INT
  • Field3 — INT
  • Field2 — VARCHAR(255)

Product (product)

  • Key — INT — Primary key — NOT NULL
  • Field — VARCHAR(45)
  • Field2 — INT
  • Field3 — VARCHAR(45)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(45)
  • Field7 — INT
  • Field8 — INT
  • Field9 — INT

ProductImg (product_img)

  • Key — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → Product.Key — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — BIGINT

ProductOrder (product_order)

  • Key — INT — Primary key — NOT NULL
  • Key (Key2) — INT — Foreign key → User.Key — NOT NULL
  • Field — VARCHAR(45)
  • Field2 — INT
  • Field3 — INT

User (user)

  • Key — int — Primary key — NOT NULL
  • Field — VARCHAR(45)
  • Field2 — VARCHAR(45)
  • Field3 — VARCHAR(45)
  • Field4 — VARCHAR(45)
  • Field5 — VARCHAR(45)
  • Field6 — VARCHAR(45)
  • Field7 — VARCHAR(45)