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