Grou_B

Tables (6)

Category (카테고리)

  • id — uint256 — Primary key — NOT NULL
  • name (이름) — bytes

GroupBuying (공구)

  • id — uint256 — Primary key — NOT NULL
  • manufacturing_id (제작사 id) — uint256 — Foreign key → Manufacturing.id — NOT NULL
  • id (카테고리id) — uint256 — Foreign key → Category.id — NOT NULL
  • name (이름) — bytes
  • address (주소) — address
  • details (상세 정보) — bytes
  • count (발행량) — uint256
  • Duedate (마감일) — uint256
  • price (가격) — uint256

Manufacturing (제작사)

  • id — uint256 — Primary key — NOT NULL
  • name (이름) — bytes
  • address (지갑 주소) — address

Participation (참여)

  • id — uint256 — Primary key — NOT NULL
  • user_id (유저id) — uint256 — Foreign key → User.id — NOT NULL
  • groupbuying_id (공구id) — uint256 — Foreign key → GroupBuying.id — NOT NULL
  • id (id2) — uint256 — Foreign key → GroupBuying.id — NOT NULL

Registration (등록)

  • id — uint256 — Primary key — NOT NULL
  • Groupbuying_id (공구id) — uint256 — Foreign key → GroupBuying.id — NOT NULL
  • use_id (유저id) — uint256 — Foreign key → User.id — NOT NULL
  • id (id2) — uint256 — Foreign key → GroupBuying.id — NOT NULL

User (유저)

  • id — uint256 — Primary key — NOT NULL
  • name (이름) — bytes
  • address (지갑주소) — address
  • delivery_address (배송주소) — bytes