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