Database Structure

Jump to bottom

krzd edited this page Apr 26, 2013 · 19 revisions

countries

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
code	varchar(3)	NO		NULL

languages

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
country_id	bigint(20) unsigned	YES		NULL
code	varchar(3)	NO		NULL

media

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
type	varchar(255)	NO		NULL

posts

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
time	timestamp	NO		CURRENT_TIMESTAMP
venue_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL
lat	decimal(8,6)	YES		NULL
lon	decimal(9,6)	YES		NULL
caption	varchar(100)	YES		NULL
image	varchar(255)	NO		NULL

post_likes

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
post_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL

post_reports

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
post_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL

post_shares

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
time	timestamp	NO		CURRENT_TIMESTAMP
media_id	bigint(20) unsigned	NO		NULL
post_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL

post_views

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
time	timestamp	NO		CURRENT_TIMESTAMP
post_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL

promotions

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
title	varchar(255)	NO		NULL
description	text	NO		NULL
passcode	varchar(255)	NO		NULL
venue_id	bigint(20) unsigned	NO		NULL
start	timestamp	YES		NULL
end	timestamp	YES		NULL
limit	int(11)	YES		NULL
creator	bigint(20) unsigned	NO		NULL

promotion_redemptions

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
promotion_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL

promotion_views

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
time	timestamp	NO		CURRENT_TIMESTAMP
promotion_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL

users

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
facebook_token	varchar(255)	YES		NULL
twitter_token	varchar(255)	YES		NULL
facebook	varchar(50)	YES		NULL
twitter	varchar(140)	YES		NULL
forename	varchar(255)	NO		NULL
surname	varchar(255)	NO		NULL
age	tinyint(3) unsigned	YES		NULL
birth_day	tinyint(2) unsigned	YES		NULL
birth_month	tinyint(2) unsigned	YES		NULL
birth_year	year(4)	YES		NULL
gender	enum('m','f','o')	YES		NULL
image	varchar(255)	YES		NULL
staff	timestamp	YES		NULL
manager	tinyint(1)	NO		0
venue_id	bigint(20) unsigned	YES		NULL
promotion_perm	tinyint(1)	NO		0
employee	tinyint(1)	NO		0
joined	timestamp	NO		CURRENT_TIMESTAMP
country_id	bigint(20)	YES		NULL
language_id	bigint(20)	YES		NULL

user_searches

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
time	timestamp	NO		CURRENT_TIMESTAMP
user_id	bigint(20) unsigned	NO		NULL
term	varchar(255)	NO		NULL

venues

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
name	varchar(255)	NO		NULL
address	text	NO		NULL
country_id	bigint(20) unsigned	NO		NULL
phone	varchar(255)	NO		NULL
email	varchar(254)	NO		NULL
email_verified	tinyint(1)	NO		0
category_id	bigint(20) unsigned	NO		NULL
tooltip	varchar(60)	YES		NULL
tonight	text	YES		NULL
website	varchar(255)	NO		NULL
facebook	varchar(50)	YES		NULL
twitter	varchar(140)	YES		NULL
facebook_token	varchar(255)	YES		NULL
twitter_token	varchar(255)	YES		NULL
lat	decimal(8,6)	NO		NULL
lon	decimal(9,6)	NO		NULL
timezone	tinyint(2)	NO		NULL
image	varchar(255)	YES		NULL
official	tinyint(1)	NO		0
verified	tinyint(1)	NO		0
customer_spend	decimal(10,2)	NO		0.00
authenticated	timestamp	YES		NULL

venue_categories

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
type	varchar(255)	NO		NULL

venue_favourites

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
venue_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL

venue_loads

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
time	timestamp	NO		CURRENT_TIMESTAMP
venue_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL

venue_rsvps

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
time	timestamp	NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP
venue_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL
maybe	tinyint(1)	NO		0
going	tinyint(1)	NO		0
checked_in	tinyint(1)	NO		0

venue_shares

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
time	timestamp	NO		CURRENT_TIMESTAMP
media_id	bigint(20) unsigned	NO		NULL
venue_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL

venue_views

Field	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
time	timestamp	NO		CURRENT_TIMESTAMP
venue_id	bigint(20) unsigned	NO		NULL
user_id	bigint(20) unsigned	NO		NULL