aaa

Tables (3)

market (마켓)

  • marketId — number — Primary key — NOT NULL
  • userId (userId2) — numbert — Foreign key → user.userId — NOT NULL
  • productId — number
  • marketName — string
  • phone — string
  • country — string
  • userId — number

product (상품)

  • productId — number — Primary key — NOT NULL
  • marketId (marketId2) — number — Foreign key → market.marketId — NOT NULL
  • userId (userId2) — numbert — Foreign key → market.userId — NOT NULL
  • marketId — number
  • productName — string
  • price — number
  • deliveryPrice — number
  • content — string

user (유저)

  • userId — numbert — Primary key — NOT NULL
  • marketId — number
  • email — string
  • password (pawssord) — string
  • role — enum