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)