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)