diggit_database
Tables (8)
Announcement
- Id — INTEGER — Primary key — NOT NULL
- Title — VARCHAR(100) — NOT NULL
- Content — TEXT — NOT NULL
- CreatedAt — DATETIME
Bid
- Id — INTEGER — Primary key — NOT NULL
- Amount — FLOAT — NOT NULL
- ItemId — INTEGER — Foreign key → Item.Id — NOT NULL
- UserId — INTEGER — Foreign key → User.Id — NOT NULL
- BidTime — DATETIME
Bookmark
- Id — INTEGER — Primary key — NOT NULL
- UserId — INTEGER — Foreign key → User.Id — NOT NULL
- ItemId — INTEGER — Foreign key → Item.Id — NOT NULL
Comment
- Id — INTEGER — Primary key — NOT NULL
- UserId — INTEGER — Foreign key → User.Id — NOT NULL
- ItemId — INTEGER — Foreign key → Item.Id — NOT NULL
- Content — TEXT — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- Target — INTEGER — Foreign key → Comment.Id
Item
- Id — INTEGER — Primary key — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Description — VARCHAR(500)
- UserId — INTEGER — Foreign key → User.Id — NOT NULL
- EndTime — DATETIME — NOT NULL
- CurrentBid — FLOAT
- BuyNowPrice — FLOAT — NOT NULL
- BidderId — INTEGER — Foreign key → User.Id
- CategoryClass — INTEGER — NOT NULL — 0 : 커스텀 1 : 스위치 2 : 기성품 3 : 키캡 4 : 아티산
ItemImage
- Id — INTEGER — Primary key — NOT NULL
- ItemId — INTEGER — Foreign key → Item.Id — NOT NULL
- ImagePath — VARCHAR(100) — NOT NULL
User
- Id — INTEGER — Primary key — NOT NULL
- PhoneNumber — VARCHAR(15)
- IsBanned — BOOLEAN — NOT NULL
- Username — VARCHAR(150)
- KakaoId — VARCHAR(150)
UserReport
- Id — INTEGER — Primary key — NOT NULL
- ReporterId — INTEGER — Foreign key → User.Id — NOT NULL
- ReportedUserId — INTEGER — Foreign key → User.Id — NOT NULL
- Reason — TEXT — NOT NULL
- ReportedAt — DATETIME — NOT NULL