RdsDiagram
attribute_groups
id: INTEGER
name: VARCHAR(255)
label: VARCHAR(255)
required: INTEGER
value_type: VARCHAR(255)
view_type: VARCHAR(255)
attributes
id: INTEGER
attribute_group_id: INTEGER
order: INTEGER
value_init: INTEGER
value_decimal: DECIMAL(12,4)
value_varchar: VARCHAR(255)
value_text: VARCHAR(255)
value_date: DATE
label: VARCHAR(255)
profile_id: INTEGER
profiles
id: INTEGER
name: VARCHAR(255)
email: VARCHAR(255)
password: VARCHAR(255)
last_login: DATE
imported: INTEGER
profile_type_id: INTEGER
path: VARCHAR(255)
created_at: DATE
import_source_id: INTEGER
attribute_values
id: INTEGER
attribute_id: INTEGER
profile_id: INTEGER
attribute_group_id: INTEGER
profile_attribute_groups
id: INTEGER
profile_id: INTEGER
attribute_group_id: INTEGER
order: INTEGER
profile_locations
id: INTEGER
profile_id: INTEGER
country_id: INTEGER
state_id: INTEGER
city_id: INTEGER
geolite2_city_locations
id: INTEGER
geoname_id: INTEGER
locale_code: VARCHAR(50)
country_iso_code: VARCHAR(2)
country_name: VARCHAR(255)
city_name: VARCHAR(255)
geolite2_country_locations
id: INTEGER
geoname_id: INTEGER
locale_code: VARCHAR(50)
continent_name: VARCHAR(255)
country_iso_code: VARCHAR(2)
country_name: VARCHAR(255)
locations
id: INTEGER
parent_id: INTEGER
name: VARCHAR(100)
path: VARCHAR(255)
order: INTEGER
profile_types
id: INTEGER
name: INTEGER
photos
id: INTEGER
profile_id: INTEGER
main: INTEGER
name: VARCHAR(150)
thumb_path: VARCHAR(255)
order: INTEGER
full_path: VARCHAR(255)
original_path: VARCHAR(255)
import_sources
id: INTEGER
name: VARCHAR(100)
url: VARCHAR(255)
imported: INTEGER
string_source_id: VARCHAR(255)
source_id: INTEGER
ratings
id: INTEGER
profile_id: INTEGER
rating: SMALLINT
votes: INTEGER