Yayınlar ( broadcast )

Column NameColumn TypeNullablePrimary
idint(11) / No CharsetNO
tagvarchar(200) / No CharsetNO
locate_cityvarchar(200) / No CharsetNO
locate_statevarchar(200) / No CharsetNO
user_idint(11) / No CharsetNO
texttext / No CharsetYES
created_attimestamp / No CharsetNO
bgclassvarchar(10) / No CharsetYES
imagestext / No CharsetYES

Configurations

Relations = user_id to => . nick_name with users . userID

Kategoriler ( categories )

Column NameColumn TypeNullablePrimary
idint(11) / No CharsetNO
namevarchar(300) / No CharsetNO

Configurations

comments

Column NameColumn TypeNullablePrimary
idint(11) / No CharsetNO
user_idint(11) / No CharsetNO
broadcast_idint(11) / No CharsetNO
texttext / No CharsetNO
timestimestamp / No CharsetNO

Configurations

Tanımlı Taglar ( default_tags )

Column NameColumn TypeNullablePrimary
idint(11) / No CharsetNO
category_idint(11) / No CharsetNO
namevarchar(300) / No CharsetNO

Configurations

Relations = category_id to => . name with categories . id

Bölgeler ( locate )

Column NameColumn TypeNullablePrimary
idint(11) / No CharsetNO
locate_cityvarchar(300) / No CharsetNO
locate_statevarchar(300) / No CharsetNO

Configurations

Taglar ( tags )

Column NameColumn TypeNullablePrimary
idint(11) / No CharsetNO
user_idint(11) / No CharsetNO
tagvarchar(300) / No CharsetNO
created_attimestamp / No CharsetNO

Configurations

Relations = user_id to => . nick_name with users . userID

App. Kullanıcı ( users )

Column NameColumn TypeNullablePrimary
userIDint(11) / No CharsetNO
nick_namevarchar(200) / No CharsetNO
emailvarchar(200) / No CharsetNO
passwordtext / No CharsetNO
user_locateint(11) / No CharsetNO
create_attimestamp / No CharsetNO
fcm_idtext / No CharsetYES
prof_imagestext / No CharsetYES

Configurations

Relations = user_locate to => . locate_state with locate . id

Yönetici ( users_admin )

Column NameColumn TypeNullablePrimary
uidint(11) unsigned / No CharsetNO
user_namevarchar(100) / No CharsetNO
emailvarchar(100) / No CharsetNO
passwordvarchar(100) / No CharsetNO
user_typesvarchar(50) / No CharsetYES
created_attimestamp / No CharsetNO

Configurations

Yön. Grubu ( users_admin_permissions )

Column NameColumn TypeNullablePrimary
idint(11) unsigned / No CharsetNO
namevarchar(100) / No CharsetNO
access_tablestext / No CharsetYES
created_attimestamp / No CharsetNO

Configurations