Database Schema - micahbello/christian_singles GitHub Wiki

users

column name	data type	details
created_at	datetime	not null
updated_at	datetime	not null
id	integer	not null, primary key
username	string	not null, unique
password_digest	string	not null
session_token	string	not null, unique
age	interger	not null
zip_code	integer	not null
occupation	string
religion	string
first_name	string	not null
last_name	string	not null
gender	string	not null
birth_date	date
description	text
city	string
state	string
last_online	date	not null
height	integer
want_kids	string
have_kids	string
marital_status	string
relocate	string
attendance	string
education	string
place_as_child	string
ethnicity	string
language	string
pets	string
smoke	string
drink	string
hobbies	string
first_date	string
sex_seek	string
religion_seek	string
relationship_seek	string
education_seek	string
attendance_seek	string
have_kids_seek	string
want_kids_seek	string
relocate_seek	string
marital_status_seek	string
language_seek	string
ethnicity_seek	string
display_name	string
smoke_seek	string
drink_seek	string
distance_seek	integer
min_height_seek	integer
max_height_seek	integer
min_age_seek	integer
max_age_seek	integer
online	boolean	not null
image_file_name	string
image_file_name	string
image_content_type	string
image_file_size	integer
image_updated_at	datetime