ChadDa

Tables (4)

Untitled (posts)

  • Key (sid) — bigint — Primary key — NOT NULL
  • Key (sid_profile) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Key (location_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (post_id) — varchar
  • Field (cts) — datetime
  • Field (post_type) — tinyint
  • Field (description) — mediumtext
  • Field (number_likes) — int
  • Field (number_comments) — int
  • Key (profile_id) — bigint — Foreign key → Untitled2.Key — NOT NULL

Untitled (locations)

  • Key (sid) — int — Primary key — NOT NULL
  • Field (location_id) — int
  • Field2 (name) — varchar
  • Field3 (street) — varchar
  • Field4 (zip) — varchar
  • Field5 (city) — mediumtext
  • Field (region) — varchar
  • Field2 (cd) — varchar
  • Field3 (phone) — varchar
  • Field4 (aj_exact_city_match) — varchar
  • Field5 (aj_exact_country_match) — varchar
  • Field6 (blurb) — varchar
  • Field7 (dir_city_id) — varchar
  • Field8 (dir_city_name) — varchar
  • Field9 (dir_city_slug) — varchar
  • Field10 (dir_country_id) — varchar
  • Field11 (dir_country_name) — varchar
  • Field12 (lat) — double
  • Field13 (lng) — double
  • Field14 (primary_alias_on_fb) — varchar
  • Field15 (slug) — varchar
  • Field16 (website) — longtext
  • Field17 (cts) — varchar

Untitled (👁 search_posts)

  • Key (sid) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (sid_profile) — bigint — Foreign key → Untitled2.Key — NOT NULL
  • Key (location_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (profile_name) — varchar — Foreign key → Untitled2.Key — NOT NULL
  • Key (name) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Key (cts) — datetime — Foreign key → Untitled.Key — NOT NULL
  • Key (post_type) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (description) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Key (number_likes) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (number_comments) — int — Foreign key → Untitled.Key — NOT NULL

Untitled2 (users)

  • Key (sid) — bigint — Primary key — NOT NULL
  • Field (profile_id) — bigint
  • Field (profile_name) — varchar
  • Field (firstname_lastname) — varchar
  • Field (description) — varchar
  • Field2 (following) — int
  • Field3 (followers) — int
  • Field4 (n_posts) — int
  • Field5 (url) — varchar
  • Field6 (cts) — datetime
  • Field7 (business_account_tf) — tinyint
  • Field8 (password) — varchar