db

Tables (7)

dice (주사위 숫자 로그)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Key (user_id) — TEXT — Foreign key → user.Key — NOT NULL
  • Field (dice_number) — INTEGER
  • Field2 (created_at) — INTEGER

item (아이템 목록)

  • Key (item_id) — INTEGER — Primary key — NOT NULL
  • Field (name) — TEXT
  • Field2 (price) — INTEGER
  • Field3 (max_level) — INTEGER

item_level (아이템 레벨 관계)

  • Key (level) — INTEGER — Primary key — NOT NULL
  • Key (item_id) — INTEGER — Foreign key → item.Key — NOT NULL
  • Field (upgrade_chance) — INTEGER
  • Field2 (sell_price) — INTEGER
  • Field3 (upgrade_price) — INTEGER

own_item (유저 아이템 보유 관계)

  • Key (user_id) — TEXT — Foreign key → user.Key — NOT NULL
  • Key (level) — INTEGER — Foreign key → item_level.Key — NOT NULL
  • Key (item_id) — INTEGER — Foreign key → item_level.Key — NOT NULL

role (직위)

  • Key (role_id) — INTEGER — Primary key — NOT NULL
  • Field (name) — TEXT
  • Field2 (price) — INTEGER
  • Field (plus_chance) — INTEGER

style (칭호)

  • Key (style_id) — INTEGER — Primary key — NOT NULL
  • Field (name) — TEXT
  • Field2 (price) — INTEGER

user (유저정보)

  • Key (user_id) — TEXT — Primary key — NOT NULL
  • Key (style_id) — INTEGER — Foreign key → style.Key — NOT NULL
  • Key (role_id) — INTEGER — Foreign key → role.Key — NOT NULL
  • Field (name) — TEXT
  • Field2 (point) — INTEGER
  • Field4 (is_admin) — INTEGER
  • Field6 (channel_id) — INTEGER