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