ERD_MARK

Tables (3)

Alarm (알람)

  • alarmId — BIGINT — Primary key — NOT NULL
  • message — VARCHAR(100)
  • receivePlayerId — VARCHER(36)
  • sendPlayerId — VARCHAR(36)
  • sendDate — TIMESTAMP
  • sendYN — BOOLEAN

Auction (경매)

  • auctionId — INT — Primary key — NOT NULL
  • auctionName — VARCHAR(100)
  • playerId — VARCHAR(36) — NOT NULL
  • startPrice — BIGINT
  • bidPrice — BIGINT
  • nowPrice — BIGINT
  • buyPlayerId — VARCHAR(36)
  • categoryId — INT
  • startDate — TIMESTAMP
  • endDate — TIMESTAMP

AuctionCategory (경매분야)

  • categoryId — INT — Primary key — NOT NULL
  • categoryName (catogoryName) — VARCHER(30)