camagru
Tables (4)
Album (Untitled4)
- id (Key) — int(11) — Primary key — NOT NULL
- user_id (Key2) — int(11) — Foreign key → User.id — NOT NULL
- image (Field) — varchar(255) — NOT NULL
Comment (Untitled3)
- id (Key) — int(11) — Primary key — NOT NULL
- content_id (Key3) — int(11) — Foreign key → Content.id — NOT NULL
- user_id (Key4) — int(11) — Foreign key → User.id — NOT NULL
- text (Key2) — varchar(255) — NOT NULL
- created_at (Field) — datetime — NOT NULL
- updated_at (Field2) — datetime — NOT NULL
Content (Untitled)
- id (Key) — int(11) — Primary key — NOT NULL
- user_id (Key2) — int(11) — Foreign key → User.id — NOT NULL
- image (Field6) — varchar(255) — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- text (Field2) — varchar(255) — NOT NULL
- like_count (Field4) — int(11) — NOT NULL
- comment_count (Field5) — int(11) — NOT NULL
- created_at (Field3) — datetime — NOT NULL
User (Untitled2)
- id (Key) — int(11) — Primary key — NOT NULL
- username (Field) — varchar(50) — NOT NULL
- email (Field2) — varchar(50) — NOT NULL
- password (Field3) — varchar(255) — NOT NULL
- need_verification (Field4) — varchar(255)
- created_at (Field6) — datetime — NOT NULL
- updated_at (Field7) — datetime — NOT NULL
- modify_token (Field5) — varchar(255)