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