BlockChain

Tables (3)

Buyer (구매자계정)

  • id (Key) — Int — Primary key — NOT NULL
  • nickName (닉네임) — varchar
  • password (비밀번호) — Int

Contract (거래내역)

  • id (거래ID) — Int — Primary key
  • BuyerId (구매자Id) — Int — Foreign key → Buyer.id — NOT NULL
  • SellerId (판매자Id) — Int — Foreign key → Seller.id — NOT NULL
  • Content (물품) — varchar
  • Amount (가격) — varchar

Seller (판매자계정)

  • id (Key) — Int — Primary key — NOT NULL
  • nickName (닉네임) — Int
  • password (비밀번호) — Int