Ddanahdae

Tables (4)

AUCTION_RESULT_TB (Untitled2)

  • Id — Primary key — NOT NULL — Result PK
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6

AUCTION_TRANSACTION_TB (Untitled)

  • Id — long — Primary key — NOT NULL — Transaction PK
  • productId (product_id) — int — Foreign key → PRODUCT_TB.productId — NOT NULL — product PK
  • sequence — int — NOT NULL — 순서
  • roomId (room_id) — String — NOT NULL — room id
  • bidder — String — NOT NULL — 경매자
  • beforeBalance (bofore_balance) — int — NOT NULL — 낙찰 전 잔액
  • price — int — NOT NULL — 낙찰 가격
  • afterBalance (after_balance) — int — NOT NULL — 낙찰 후 잔액
  • regDate (reg_date) — DateTime — NOT NULL — 등록 날짜

PRODUCT_TB (Untitled4)

  • productId (product_id) — int — Primary key — NOT NULL — product PK
  • name — String — NOT NULL — 이름
  • position — String — NOT NULL — 포지션
  • image — String — 매물 이미지
  • tier — String — 티어
  • tierImage (tier_image) — String — 티어 이미지

ROOM_TB (Untitled3)

  • id — int — Primary key — NOT NULL — room pk
  • uuid — String — 방 id