chuno

Tables (5)

friends

  • from_user_key — int — Foreign key → users.user_key — NOT NULL
  • to_user_key — int — Foreign key → users.user_key — NOT NULL

items

  • item_key — varchar(100) — Primary key — NOT NULL
  • name — varchar(30) — NOT NULL
  • price — int — NOT NULL

profile_img (Untitled)

  • user_key — int — Foreign key → users.user_key — NOT NULL
  • path — varchar(100) — NOT NULL
  • save_name — varchar(100) — NOT NULL

users

  • user_key — int — Primary key — NOT NULL
  • email — varchar(30) — NOT NULL
  • nickname — varchar(10) — NOT NULL
  • level — int — NOT NULL
  • paper_count — int — NOT NULL
  • runner_play_count — int — NOT NULL
  • runner_win_count — int — NOT NULL
  • chaser_play_count — int — NOT NULL
  • chaser_win_count — int — NOT NULL
  • exp — int — NOT NULL
  • is_manager — boolean — NOT NULL
  • money — int — NOT NULL
  • reg_dt — datetime — NOT NULL

users_items

  • inventory_key — int — Primary key — NOT NULL
  • user_key — int — Foreign key → users.user_key — NOT NULL
  • item_key — varchar(100) — Foreign key → items.item_key — NOT NULL