joinusworld_erd

Tables (67)

accounts_corpuser N

  • userprofile_ptr_id — int(11) — Primary key — NOT NULL

accounts_donationinfo

  • id — int(11) — Primary key — auto_increment
  • first_name — varchar(50)
  • last_name — varchar(50)
  • amount — varchar(50)
  • currency — varchar(5)
  • email — varchar(50)
  • date — datetime — NOT NULL
  • address — varchar(250)
  • type — varchar(20)
  • status — varchar(20)
  • transactionid — varchar(20)

accounts_professionaluser N

  • userprofile_ptr_id — int(11) — Primary key — NOT NULL
  • organization — varchar(50)
  • field — varchar(10)

accounts_userlogging N

  • id — int(11) — Primary key — NOT NULL — auto_increment
  • user_id — int(11) — Primary key — NOT NULL — Foreign Key
  • connected_ip — char(15)
  • connected_ref — longtext
  • connected_user_agent — longtext
  • connected_time — datetime

accounts_usermailauth

  • id — int(11) — Primary key — NOT NULL — auto_increment
  • user_id — int(11) — Primary key — NOT NULL — FK
  • activate_code — varchar(255)
  • activate_key_expire — datetime — NOT NULL
  • reset_code — varchar(255)
  • reset_key_expire — datetime — NOT NULL

accounts_userprofile

  • id — int(11) — Primary key — NOT NULL — PK
  • user_id — int(11) — Primary key — NOT NULL — FK
  • user_name — varchar(45) — NOT NULL
  • status — smallint(6) — NOT NULL
  • photo — varchar(45) — NOT NULL
  • public_gender — tinyint(1)
  • public_email — tinyint(1)
  • public_nationality — tinyint(1)
  • public_location — tinyint(1)
  • job — varchar(45) — NOT NULL
  • public_job — tinyint(1)
  • home_page — varchar(45) — NOT NULL
  • public_home_page — tinyint(1)
  • public_introduce — tinyint(1)
  • is_deleted — tinyint(1)
  • register_date — datetime — NOT NULL
  • confirm_email — varchar(75)
  • nickname — varchar(50)
  • main_code — varchar(10)
  • available_codes — varchar(20)
  • user_state — varchar(10) — NOT NULL
  • gender — varchar(10)
  • birth — datetime — NOT NULL
  • nationality — varchar(8) — NOT NULL
  • location — varchar(255) — NOT NULL
  • contact — varchar(255) — NOT NULL
  • public_contact — tinyint(1) — NOT NULL
  • sns — longtext
  • timezone — varchar(63)
  • site — varchar(200)
  • introduce — longtext
  • process — tinyint(1)
  • public_birth — tinyint(1) — NOT NULL
  • last_login — datetime
  • last_modified — datetime
  • view_number — int(11) — NOT NULL

accounts_userprofile_facebook

  • id — int(11) — Primary key — NOT NULL — PK
  • user_id — int(11) — Primary key — NOT NULL — fk
  • accessToken — varchar(250) — NOT NULL
  • expiresIn — int(11) — NOT NULL
  • userID — varchar(200) — NOT NULL

accounts_userprofile_google

  • id — int(11) — Primary key — NOT NULL — PK
  • user_id — int(11) — Primary key — NOT NULL — fk
  • accessToken — varchar(250) — NOT NULL
  • expiresIn — int(11) — NOT NULL
  • userID — varchar(200) — NOT NULL

accounts_userprofile_kakaotalk

  • id — int(11) — Primary key — NOT NULL — PK
  • user_id — int(11) — Primary key — NOT NULL — fk
  • accessToken — varchar(250) — NOT NULL
  • expiresIn — int(11) — NOT NULL
  • userID — varchar(200) — NOT NULL

accounts_userprofile_linkedin N

  • id — int(11) — Primary key — NOT NULL — PK
  • user_id — int(11) — Primary key — NOT NULL — fk
  • accessToken — varchar(250) — NOT NULL
  • expiresIn — int(11) — NOT NULL
  • userID — varchar(200) — NOT NULL

accounts_userprofile_naver

  • id — int(11) — Primary key — NOT NULL — PK
  • user_id — int(11) — Primary key — NOT NULL — fk
  • accessToken — varchar(250) — NOT NULL
  • expiresIn — int(11) — NOT NULL
  • userID — varchar(200) — NOT NULL

accounts_volunteeruser N

  • userprofile_ptr_id — int(11) — Primary key — NOT NULL — pk
  • volunteer_language — varchar(10)
  • language_level — varchar(5)

auth_group N

  • id — int(11) — Primary key — NOT NULL — pk
  • name — varchar(80)

auth_group_permissions N

  • id — int(11) — Primary key — NOT NULL — pk
  • group_id — int(11) — Primary key — NOT NULL — fk
  • permission_id — int(11) — Primary key — NOT NULL — fk

auth_permission NS

  • id — int(11) — Primary key — NOT NULL — pk
  • content_type_id — int(11) — Primary key — NOT NULL — fk
  • name — varchar(50)
  • codename — varchar(100)

auth_user NS

  • id — int(11) — Primary key — NOT NULL — pk
  • username — varchar(30)
  • first_name — varchar(30)
  • last_name — varchar(30)
  • email — varchar(75)
  • password — varchar(128)
  • is_staff — tinyint(1)
  • is_active — tinyint(1)
  • is_superuser — tinyint(1)
  • last_login — datetime
  • date_joined — datetime

auth_user_groups N

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • group_id — int(11) — Primary key — NOT NULL — fk

auth_user_user_permissions N

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • permission_id — int(11) — Primary key — NOT NULL — fk

django_admin_log N

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • content_type_id — int(11) — Primary key — fk
  • action_time — datetime
  • object_id — longtext — NOT NULL
  • object_repr — varchar(200)
  • action_flag — smallint(5)
  • change_message — longtext

django_content_type

  • id — int(11) — Primary key — NOT NULL — pk
  • app_label — varchar(100) — Primary key — NOT NULL
  • name — varchar(100)
  • model — varchar(100)

django_session N

  • session_key — varchar(40) — Primary key — NOT NULL — pk
  • expire_date — datetime — Primary key — NOT NULL — fk
  • session_data — longtext

django_site N

  • id — int(11) — Primary key — NOT NULL — pk
  • domain — varchar(100)
  • name — varchar(50)

joinus_activity

  • id — int(11) — Primary key — pk
  • user_id — int(11) — Primary key — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • answer_id — int(11) — Primary key — NOT NULL — fk
  • comment_id — int(11) — Primary key — NOT NULL — fk
  • post_id — int(11) — Primary key — NOT NULL — fk
  • reply_id — int(11) — Primary key — NOT NULL — fk
  • category — smallint(6)
  • board_type — smallint(6)
  • vote_point — double
  • bookmark_type — smallint(6) — NOT NULL
  • block_type — smallint(6)
  • spam_type — smallint(6)
  • date_time — datetime — NOT NULL
  • affected_user_id — int(11) — NOT NULL
  • comment_type — smallint(6)
  • guestbook_id — int(11)
  • guestbook_comment_id — int(11)

joinus_answer

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • admin_status — smallint(6)
  • content — longtext
  • search_content — longtext
  • is_accepted — tinyint(1)
  • modified_date — datetime
  • created_date — datetime
  • up_vote — int(11)
  • down_vote — int(11)

joinus_answer_search

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL
  • search_content — longtext — Primary key — NOT NULL — fk
  • admin_status — smallint(6)
  • content — longtext
  • is_accepted — tinyint(1)
  • modified_date — datetime
  • created_date — datetime
  • up_vote — int(11)
  • down_vote — int(11)

joinus_answer_source

  • id — int(11) — Primary key — NOT NULL
  • answer_id — int(11) — Primary key — NOT NULL — fk
  • content — longtext

joinus_articlefileupload N

  • id — int(11) — Primary key — NOT NULL — pk
  • file_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • post_id — int(11) — Primary key — NOT NULL

joinus_bookmark

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • post_id — int(11) — Primary key — NOT NULL — fk
  • activity_id — int(11) — Primary key — NOT NULL — uk
  • bookmark_type — longtext
  • date — datetime

joinus_cache_mainpage_datalist

  • id — int(11) — Primary key — NOT NULL
  • board_type — varchar(30)
  • author — varchar(250)
  • keyword — varchar(250)
  • languages — varchar(100)
  • sort_order — smallint(11)
  • within_time — smallint(11)
  • article_category — smallint(11)
  • page — int(11)
  • result_total_pages — int(11)
  • result_total_records — int(11)
  • result_rows — longtext
  • created_date — datetime

joinus_cache_mainpage_thumbnail

  • id — int(11) — Primary key — NOT NULL
  • board_type — varchar(30)
  • languages — varchar(100)
  • article_category — smallint(11)
  • type — smallint(11)
  • result_content — mediumtext
  • created_date — datetime

joinus_category

  • id — int(11) — Primary key — NOT NULL — pk
  • category_id — int(11) — Primary key — NOT NULL — fk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • date_time — datetime

joinus_code

  • id — int(11) — Primary key — NOT NULL — pk
  • code_type — smallint(6)
  • code_type_name — varchar(45)
  • code_value — varchar(45)
  • code_name — varchar(45)

joinus_comment

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Primary key — NOT NULL — fk
  • answer_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • reply_id — int(11) — Primary key — NOT NULL — fk
  • admin_status — smallint(6)
  • freetalk_id — int(11)
  • content — longtext
  • search_content — longtext
  • comment_type — smallint(6)
  • modified_date — datetime
  • created_date — datetime
  • referer_id — varchar(1000)

joinus_comment_search

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Primary key — NOT NULL — fk
  • answer_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • reply_id — int(11) — Primary key — NOT NULL — fk
  • search_content — longtext — Primary key — NOT NULL
  • admin_status — smallint(6)
  • freetalk_id — int(11)
  • content — longtext
  • comment_type — smallint(6)
  • modified_date — datetime
  • created_date — datetime
  • referer_id — varchar(1000)

joinus_event_attendee

  • id — int(11) — Primary key — NOT NULL — pk
  • post_id — int(11) — Primary key — NOT NULL
  • user_id — varchar(10) — Primary key — NOT NULL
  • created — datetime

joinus_fileupload

  • id — int(11) — Primary key — NOT NULL
  • file_name — longtext
  • file_path — longtext

joinus_freetalk

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11)
  • content — mediumtext
  • is_private — tinyint(1)
  • is_deleted — tinyint(1)
  • is_blocked — tinyint(1)
  • created_date — datetime
  • last_modified — datetime

joinus_guestbook

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • from_user_id — int(11) — Primary key — NOT NULL — fk
  • content — longtext
  • anonymous — tinyint(1)
  • modified_date — datetime
  • created_date — datetime
  • admin_status — smallint(6)
  • is_announcement — tinyint(1)
  • is_public — tinyint(1)

joinus_guestbook_comment

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • guestbook_id — int(11) — Primary key — NOT NULL — fk
  • content — longtext
  • modified_date — datetime
  • created_date — datetime
  • admin_status — smallint(6)
  • referer_id — varchar(1000)

joinus_ma_session

  • id — int(11) — Primary key — NOT NULL — PK
  • user_id — int(11)
  • session_key — varchar(40)
  • session_data — longtext
  • expired_date — datetime

joinus_notification

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — pk
  • from_user_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • answer_id — int(11) — Primary key — NOT NULL — fk
  • comment_id — int(11) — Primary key — NOT NULL — fk
  • post_id — int(11) — Primary key — NOT NULL — fk
  • reply_id — int(11) — Primary key — NOT NULL — fk
  • activity_id — int(11) — Primary key — NOT NULL — fk
  • category — smallint(6)
  • board — smallint(6)
  • article — longtext
  • date_time — datetime
  • checked — tinyint(1)
  • guestbook_id — int(11)
  • guestbook_comment_id — int(11)

joinus_notification_to_all_user;

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11)
  • category — smallint(6)
  • board — smallint(6)
  • article_id — int(11)
  • language — varchar(10)

joinus_notification_unread

  • id — int(11) — Primary key — NOT NULL
  • notification_id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Primary key — NOT NULL

joinus_post

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Primary key — NOT NULL
  • admin_status — smallint(6)
  • board_type — smallint(6)
  • title — longtext
  • content — longtext
  • search_content — longtext
  • post_type — smallint(6)
  • file_uploaded — tinyint(1)
  • is_announcement — tinyint(1)
  • view_number — int(11)
  • shared_number — int(11)
  • modified_date — datetime
  • created_date — datetime
  • language — varchar(10)
  • thumbnail — varchar(2048)
  • is_event — tinyint(1)
  • event_options — mediumtext
  • up_vote — int(11)

joinus_post_search

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Primary key — NOT NULL
  • search_content — longtext — Primary key — NOT NULL
  • admin_status — smallint(6)
  • board_type — smallint(6)
  • title — longtext
  • content — longtext
  • post_type — smallint(6)
  • file_uploaded — tinyint(1)
  • is_announcement — tinyint(1)
  • view_number — int(11)
  • shared_number — int(11)
  • modified_date — datetime
  • created_date — datetime
  • language — varchar(10)
  • thumbnail — varchar(2048)
  • is_event — tinyint(1)
  • event_options — mediumtext
  • up_vote — int(11)

joinus_post_source

  • id — int(11) — Primary key — NOT NULL
  • post_id — int(11)
  • content — longtext

joinus_postquestiontag

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • post_id — int(11) — Primary key — NOT NULL — fk
  • tag — longtext
  • date_time — datetime

joinus_question

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • admin_status — smallint(6)
  • title — longtext
  • content — longtext
  • search_content — longtext
  • is_solved — tinyint(1)
  • is_announcement — tinyint(1)
  • is_anonymous — tinyint(1)
  • view_number — int(11)
  • shared_number — int(11)
  • modified_date — datetime
  • created_date — datetime
  • language — varchar(10)
  • thumbnail — varchar(2048)
  • post_type — smallint(6)
  • up_vote — int(11)

joinus_question_newest

  • id — int(11) — Primary key — NOT NULL — pk
  • question_id — int(11)
  • language — varchar(10)

joinus_question_search

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • search_content — longtext — Primary key — NOT NULL — fk
  • admin_status — smallint(6)
  • title — longtext
  • content — longtext
  • is_solved — tinyint(1)
  • is_announcement — tinyint(1)
  • is_anonymous — tinyint(1)
  • view_number — int(11)
  • shared_number — int(11)
  • modified_date — datetime
  • created_date — datetime
  • language — varchar(10)
  • thumbnail — varchar(2048)
  • post_type — smallint(6)
  • up_vote — int(11)

joinus_reaction

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11)
  • article_type — smallint(6)
  • article_id — int(11)
  • code — smallint(6)
  • created_date — datetime

joinus_realpush

  • id — int(11) — Primary key — NOT NULL — pk
  • notification_id — int(11)
  • user_id — int(11)

joinus_reply

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • post_id — int(11) — Primary key — NOT NULL — fk
  • admin_status — smallint(6)
  • content — longtext
  • search_content — longtext
  • modified_date — datetime
  • created_date — datetime
  • is_pinned — tinyint(1)
  • up_vote — int(11)
  • down_vote — int(11)

joinus_reply_search

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • post_id — int(11) — Primary key — NOT NULL — fk
  • search_content — longtext — Primary key — NOT NULL — fk
  • admin_status — smallint(6)
  • content — longtext
  • modified_date — datetime
  • created_date — datetime
  • is_pinned — tinyint(1)
  • up_vote — int(11)
  • down_vote — int(11)

joinus_reply_source

  • id — int(11) — Primary key — NOT NULL — pk
  • reply_id — int(11)
  • content — longtext

joinus_reputation

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • answer_id — int(11) — Primary key — NOT NULL — fk
  • comment_id — int(11) — Primary key — NOT NULL — fk
  • post_id — int(11) — Primary key — NOT NULL — fk
  • activity_id — int(11) — Primary key — NOT NULL — fk
  • reply_id — int(11) — Primary key — NOT NULL — fk
  • point — smallint(6)
  • index — smallint(6)
  • category — smallint(6)
  • board — smallint(6)
  • article — longtext
  • date_time — datetime
  • by_user_id — int(11)
  • guestbook_id — int(11)
  • guestbook_comment_id — int(11)

joinus_reputation_log

  • id — int(11) — Primary key — NOT NULL — pk
  • category_id — int(11) — Primary key — NOT NULL — fk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • date_time — datetime

joinus_reputation_rule

  • id — int(11) — Primary key — NOT NULL — pk
  • name — varchar(45)
  • value — int(11)
  • index — int(11)

joinus_smart_newsletter_setting

  • id — int(11) — Primary key — NOT NULL — pk
  • is_enabled — tinyint(1)
  • period — smallint(6)
  • language — varchar(100)
  • tag — varchar(100)
  • tag_interval — int(11)
  • grade — varchar(100)
  • grade_unverified — tinyint(1)
  • grade_unregistered — tinyint(1)
  • grade_active — tinyint(1)
  • grade_inactive — tinyint(1)
  • grade_admin — tinyint(1)
  • grade_moderator — tinyint(1)
  • grade_blocked — tinyint(1)
  • grade_deleted — tinyint(1)
  • user_option — varchar(100)
  • recent_access — int(11)
  • max_notice — int(11)
  • max_qa — int(11)
  • max_community — int(11)
  • sending_schedule_time — varchar(100)
  • last_modified — datetime
  • last_run_job — datetime

joinus_smart_newsletter_statistic

  • id — int(11) — Primary key — NOT NULL — pk
  • tracking_id — varchar(250)
  • title — mediumtext
  • sent — int(11)
  • click — int(11)
  • status — varchar(250)
  • created_date — datetime
  • last_modified — datetime

joinus_spam

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • answer_id — int(11) — Primary key — NOT NULL — fk
  • question_id — int(11) — Primary key — NOT NULL — fk
  • post_id — int(11) — Primary key — NOT NULL — fk
  • comment_id — int(11) — Primary key — NOT NULL — fk
  • activity_id — int(11) — Primary key — NOT NULL — uk
  • spam_type — smallint(6)
  • date — datetime

joinus_statistic_tag

  • id — int(11) — Primary key — NOT NULL — pk
  • board_type — smallint(6)
  • tag — longtext
  • count — int(11)
  • last_modified — datetime

joinus_statistic_user

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11)
  • level — int(11)
  • activity — int(11)
  • popularity — int(11)
  • confidence — int(11)
  • visit — int(11)
  • question — int(11)
  • question_anonymous — int(11)
  • question_solved — int(11)
  • answer — int(11)
  • answer_accepted — int(11)
  • notice — int(11)
  • post — int(11)
  • reply — int(11)
  • comment_to_q — int(11)
  • comment_to_a — int(11)
  • comment_to_r — int(11)
  • created_date — datetime
  • modified_date — datetime

joinus_tag N

  • id — int(11) — Primary key — NOT NULL — pk
  • content — varchar(45)

joinus_trending

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11)
  • type — smallint(11)
  • board_type — smallint(11)
  • article_id — int(11)
  • content — varchar(250)
  • created_date — datetime

joinus_usernotifysetting

  • id — int(11) — Primary key — NOT NULL — pk
  • user_id — int(11) — Primary key — NOT NULL — fk
  • answer — tinyint(1)
  • reply_comment — tinyint(1)
  • vote — tinyint(1)
  • accepted — tinyint(1)
  • spam — tinyint(1)
  • guestbook — tinyint(1)
  • newsletter — tinyint(1)

sample_realpush N

  • id — int(11) — Primary key — NOT NULL — pk
  • new_message_num — int(11)
  • num — int(11)