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)