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