| Variable | Description | Type |
|---|---|---|
post_id |
Post ID | Integer |
post_title |
Post Title | Text Input |
post_content |
Post Content | Froala Text Editor |
post_category |
Post Category | Dropdown Select |
post_filename |
Post URL | System Generated |
post_image |
Post Image URL | System Generated |
post_price |
Price of Item | Numerical |
post_date |
Date Post Created | Timestamp |
post_tags |
Post Keywords | Text Input |
post_status |
Publish Status | Yes / No |
post_live_date |
Date Post Created | Timestamp |
user_id |
ID of Member | Integer |
post_expire_date |
End / Expire Date | Timestamp |
post_start_date |
Start / Publish Date | Timestamp |
lat |
Latitude Location | Numerical |
lon |
Longitude Location | Numerical |
post_location |
Post Location | Textarea |
country_sn |
Country Location | Text Input |
state_sn |
State Location | Text Input |
| Variable | Description | Type |
|---|---|---|
post_id |
Post ID | Integer |
user_id |
ID of Member | Integer |
group_name |
Post Title | Text Input |
group_desc |
Post Body | Froala |
group_location |
Post Location | Textarea |
group_date |
Date Created | Timestamp |
group_filename |
Post URL | System Generated |
group_status |
Publish Status | Timestamp |
group_category |
Post Category | Dropdown Select |
lat |
Latitude Location | Numerical |
lon |
Longitude Location | Numerical |
post_tags |
Post Keywords | Text Input |
property_status |
Status of Property Posts | Numerical |
property_type |
Type of Property Posts | Numerical |
property_price |
Price for Property Posts | Numerical |
property_beds |
Number of Beds | Numerical |
property_baths |
Number of Baths | Numerical |
property_sqr_foot |
Square Footage | Numerical |
post_location |
Post Location | Textarea |
country_sn |
Country Location | Text Input |
state_sn |
State Location | Text Input |
data_posts table 📝 users_portfolio_groups table 📷 data_type = 20 (most posts) 📊 data_type = 9 🎬 data_type = 4 📸 post_title group_name post_content group_desc post_category group_category