charlie-game
Tables (7)
Chicken (Untitled5)
- chickenId (Key) — long — Primary key — NOT NULL
- produceItem (Key2) — long — Foreign key → Item.ItemId — NOT NULL
- chickenName (Field) — String
- maxEggCapacity (Field2) — int
- eggProduceSpeedSec (Field4) — int
- randomDrawProbability (Field3) — int
Item (Untitled)
- ItemId (Key) — long — Primary key — NOT NULL
- Name (Field) — String
- itemType (아이템 타입) — String
- description (Field2) — String
- price (Field3)
- basePrice (Field4)
ItemPriceHistory (아이템 가격 변동 기록)
- ItemPriceHistoryId (PK) — long — Primary key — NOT NULL
- ItemId (FK) — long — Foreign key → Item.ItemId — NOT NULL
- createAt (생성 시간) — LocalDateTime
- updateAt (변경시간) — LocalDateTime
- newPrice (변경된 가격) — int
- oldPrice (이전 가격) — int
User (Member)
- userId (Key) — long — Primary key — NOT NULL
- id (유저 id) — String
- password (Field) — String
- username (Field3) — String
- kakaoId (Field2) — String
- joinDate (가입일) — LocalDateTime
- lastAccessDate (최근접속일) — LocalDateTime
UserChicken (Untitled4)
- chickenId — long — Primary key — NOT NULL
- userId — long — Foreign key → User.userId — NOT NULL
- chickenId (Key) — long — Foreign key → Chicken.chickenId — NOT NULL
- lastProduceTime — LocalDateTime
- currentEgg (Field) — int
- maxCapacity (Field2) — int
UserGameInfo (Untitled2)
- userGameInfoId (Key) — long — Primary key — NOT NULL
- userId (유저 FK) — long — Foreign key → User.userId — NOT NULL
- maxChicken (최대 닭 마리수) — int
- chickenCount (닭 마리수) — int
- maxItem (최대 아이템 수) — int
- money (화페 잔액) — int
- eggCount (보유 달걀 수) — int
Useritem (Untitled3)
- userItemId (Key) — Primary key — NOT NULL
- userId (Key2) — long — Foreign key → User.userId — NOT NULL
- ItemId (Key3) — long — Foreign key → Item.ItemId — NOT NULL
- quantity (Field) — int