Database Structure
krzd edited this page Apr 26, 2013
·
19 revisions
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
code | varchar(3) | NO | NULL |
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 |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
type | varchar(255) | NO | NULL |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | ||
varchar(50) | YES | NULL | |||
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 |
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 |
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 | ||
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 | ||
varchar(50) | YES | NULL | |||
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 |
Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
type | varchar(255) | NO | NULL |
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 |
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 |
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 |
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 |
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 |