dice_edition

Tables (7)

comment (Untitled5)

  • comment_id (Key) — int — Primary key — NOT NULL
  • feed_id (pk) — int — Foreign key → feeds.feed_id — NOT NULL
  • username (Key2) — vachar — Foreign key → users.username — NOT NULL
  • feed_id (Field) — int
  • username (Field2) — varchar
  • content (Field3) — varchar
  • created_at (Field4) — datetime
  • updated_at (Field5)

feed_like (Untitled6)

  • feed_id (Key) — int — Primary key — NOT NULL
  • username (Key2) — varchar — Primary key — NOT NULL
  • username (Key4) — vachar — Foreign key → users.username — NOT NULL
  • feed_id (pk) — int — Foreign key → feeds.feed_id — NOT NULL
  • created_at (Field)

feeds (Untitled)

  • feed_id (pk) — int — Primary key — NOT NULL
  • content (Field)
  • username (Field2) — varchar
  • created_at (Field3) — datetime
  • updated_at (Field4)
  • username (Key) — vachar — Foreign key → users.username — NOT NULL

items (Untitled2)

  • item_id (pk) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • image (Field2) — varchar
  • is_active (Field3) — tinyint
  • price (Field4) — int

store (Untitled4)

  • item_id (Key) — int — Primary key — NOT NULL
  • range (Field) — int
  • item_id (pk) — int — Foreign key → items.item_id — NOT NULL

user_inventory (Untitled3)

  • username (pk) — varchar — Primary key — NOT NULL
  • username (Key) — vachar — Foreign key → users.username — NOT NULL
  • item_id (Field) — int
  • created_at (Field2)
  • item_id (pk2) — int — Foreign key → items.item_id — NOT NULL

users

  • username (Key) — vachar — Primary key — NOT NULL
  • auth_key (Field) — varchar
  • nick_name (unique) — varchar
  • email (Field3) — varchar
  • lv (Field4) — tinyint
  • exp (Field5) — int
  • coin (Field6) — int
  • profile_image (Field7) — varchar
  • signup_comment (Field8) — varchar
  • created_at (Field9) — datetime
  • last_login_at (Field10) — datetime
  • is_active_item (Field11) — int
  • is_superuser (Field12) — tinyint
  • is_staf (Field13) — tinyint
  • is_active (Field14) — tinyint