Analysis of OKKY

okky erd

Tables (40)

Untitled

    activity

    • id — bigint(20) — Primary key — NOT NULL
    • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • article_id — bigint(20) — Foreign key → article.id — NOT NULL
    • content_id — bigint(20) — Foreign key → content.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • date_created — datetime — NOT NULL
    • last_updated — datetime — NOT NULL
    • point — int(11) — NOT NULL
    • point_type — varchar(255) — NOT NULL
    • type — varchar(255) — NOT NULL

    anonymous

    • id — bigint(20) — Primary key — NOT NULL
    • article_id — bigint(20) — Foreign key → article.id — NOT NULL
    • user_id — bigint(20) — Foreign key → user.id — NOT NULL
    • content_id — bigint(20) — Foreign key → content.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • type — varchar(255) — NOT NULL

    area_city_code

    • id — varchar(255) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • name — varchar(255) — NOT NULL

    area_district_code

    • id — varchar(255) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • area_city_code_id — varchar(255) — Foreign key → area_city_code.id — NOT NULL
    • name — varchar(255) — NOT NULL

    article

    • id — bigint(20) — Primary key — NOT NULL
    • category_id — varchar(255) — Foreign key → category.code — NOT NULL
    • version — bigint(20) — NOT NULL
    • a_nick_name — varchar(255)
    • anonymity — bit(1) — NOT NULL
    • author_id — bigint(20) — Foreign key → avatar.id
    • choice — bit(1) — NOT NULL
    • content_id — bigint(20) — Foreign key → content.id
    • create_ip — varchar(255)
    • date_created — datetime — NOT NULL
    • enabled — bit(1) — NOT NULL
    • is_recruit — bit(1) — NOT NULL
    • last_editor_id — bigint(20) — Foreign key → avatar.id
    • last_updated — datetime — NOT NULL
    • note_count — int(11) — NOT NULL
    • scrap_count — int(11) — NOT NULL
    • selected_note_id — bigint(20) — Foreign key → content.id
    • tag_string — varchar(255)
    • title — varchar(255) — NOT NULL
    • view_count — int(11) — NOT NULL
    • vote_count — int(11) — NOT NULL

    article_tag

    • article_tags_id — bigint(20) — Foreign key → article.id
    • tag_id — bigint(20) — Foreign key → tag.id

    avatar

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • activity_point — int(11) — NOT NULL
    • nickname — varchar(20) — NOT NULL
    • official — bit(1)
    • picture — varchar(255) — NOT NULL
    • picture_type — int(11) — NOT NULL

    avatar_tag

    • avatar_tags_id — bigint(20) — Foreign key → avatar.id
    • tag_id — bigint(20) — Foreign key → tag.id

    banner

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • date_created — datetime — NOT NULL
    • image — varchar(255)
    • last_updated — datetime — NOT NULL
    • name — varchar(255) — NOT NULL
    • target — varchar(255)
    • type — varchar(255) — NOT NULL
    • url — varchar(255) — NOT NULL
    • visible — bit(1) — NOT NULL

    banner_click

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • banner_id — bigint(20) — Foreign key → banner.id — NOT NULL
    • click_count — int(11) — NOT NULL
    • date_created — datetime — NOT NULL
    • ip — varchar(255) — NOT NULL

    career

    • id — bigint(20) — Primary key — NOT NULL
    • company_id — bigint(20) — Foreign key → company.id — NOT NULL
    • resume_id — bigint(20) — Foreign key → resume.id — NOT NULL
    • version — bigint(20) — NOT NULL

    category

    • code — varchar(255) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • anonymity — bit(1)
    • date_created — datetime — NOT NULL
    • default_label — varchar(255) — NOT NULL
    • enabled — bit(1) — NOT NULL
    • external_link — varchar(255)
    • icon_css_names — varchar(255)
    • isurl — bit(1) — NOT NULL
    • label_code — varchar(255) — NOT NULL
    • last_updated — datetime — NOT NULL
    • level — int(11) — NOT NULL
    • parent_id — varchar(255) — Foreign key → category.code
    • require_tag — bit(1) — NOT NULL
    • sort_order — int(11) — NOT NULL
    • url — varchar(255)
    • use_evaluate — bit(1) — NOT NULL
    • use_note — bit(1) — NOT NULL
    • use_opinion — bit(1) — NOT NULL
    • use_tag — bit(1) — NOT NULL
    • writable — bit(1) — NOT NULL
    • write_by_external_link — bit(1)

    change_log

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • article_id — bigint(20) — Foreign key → article.id — NOT NULL
    • avatar_id — bigint(20) — Foreign key → avatar.id
    • content_id — bigint(20) — Foreign key → content.id
    • date_created — datetime — NOT NULL
    • md5 — varchar(255) — NOT NULL
    • patch — longtext — NOT NULL
    • revision — int(11) — NOT NULL
    • type — varchar(255) — NOT NULL

    company

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • enabled — bit(1) — NOT NULL
    • locked — bit(1) — NOT NULL
    • logo — varchar(255)
    • manager_id — bigint(20) — Foreign key → person.id
    • name — varchar(255) — NOT NULL
    • register_number — varchar(255) — NOT NULL

    company_info

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • company_id — bigint(20) — Foreign key → company.id
    • description — longtext
    • email — varchar(255) — NOT NULL
    • employee_number — int(11) — NOT NULL
    • homepage_url — varchar(255)
    • tel — varchar(255) — NOT NULL
    • welfare — longtext

    confirm_email

    • id — bigint(20) — Primary key — NOT NULL
    • user_id — bigint(20) — Foreign key → user.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • date_expired — datetime — NOT NULL
    • email — varchar(255) — NOT NULL
    • secured_key — varchar(255) — NOT NULL

    content

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • a_nick_name — varchar(255)
    • anonymity — bit(1) — NOT NULL
    • article_id — bigint(20) — Foreign key → article.id
    • author_id — bigint(20) — Foreign key → avatar.id
    • create_ip — varchar(255)
    • date_created — datetime — NOT NULL
    • last_editor_id — bigint(20) — Foreign key → avatar.id
    • last_updated — datetime — NOT NULL
    • selected — bit(1) — NOT NULL
    • text — longtext — NOT NULL
    • text_type — int(11) — NOT NULL
    • type — int(11) — NOT NULL
    • vote_count — int(11) — NOT NULL

    content_file

    • content_files_id — bigint(20) — Foreign key → content.id
    • file_id — bigint(20) — Foreign key → file.id

    content_vote

    • id — bigint(20) — Primary key — NOT NULL
    • article_id — bigint(20) — Foreign key → article.id — NOT NULL
    • voter_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • content_id — bigint(20) — Foreign key → content.id — NOT NULL
    • date_created — datetime — NOT NULL
    • point — int(11) — NOT NULL

    file

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • attach_type — varchar(255) — NOT NULL
    • byte_size — int(11) — NOT NULL
    • height — int(11) — NOT NULL
    • name — varchar(255) — NOT NULL
    • org_name — varchar(255) — NOT NULL
    • type — varchar(255) — NOT NULL
    • width — int(11) — NOT NULL

    follow

    • follower_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • following_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • date_created — datetime — NOT NULL

    job_position

    • id — bigint(20) — Primary key — NOT NULL
    • recruit_id — bigint(20) — Foreign key → recruit.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • description — varchar(255) — NOT NULL
    • job_pay_type — varchar(255) — NOT NULL
    • max_career — int(11)
    • min_career — int(11) — NOT NULL
    • tag_string — varchar(255)
    • title — varchar(255) — NOT NULL

    job_position_tag

    • job_position_tags_id — bigint(20) — Foreign key → job_position.id
    • tag_id — bigint(20) — Foreign key → tag.id

    logged_in

    • id — bigint(20) — Primary key — NOT NULL
    • user_id — bigint(20) — Foreign key → user.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • date_created — datetime — NOT NULL
    • remote_addr — varchar(255)

    managed_user

    • id — bigint(20) — Primary key — NOT NULL
    • user_id — bigint(20) — Foreign key → user.id — NOT NULL
    • version — bigint(20) — NOT NULL

    notification

    • id — bigint(20) — Primary key — NOT NULL
    • article_id — bigint(20) — Foreign key → article.id — NOT NULL
    • sender_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • receiver_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • content_id — bigint(20) — Foreign key → content.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • date_created — datetime — NOT NULL
    • last_updated — datetime — NOT NULL
    • type — varchar(255) — NOT NULL

    notification_read

    • id — bigint(20) — Primary key — NOT NULL
    • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • last_read — datetime — NOT NULL

    oauthid

    • id — bigint(20) — Primary key — NOT NULL
    • user_id — bigint(20) — Foreign key → user.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • access_token — varchar(255) — NOT NULL
    • provider — varchar(255) — NOT NULL

    opinion

    • id — bigint(20) — Primary key — NOT NULL
    • content_id — bigint(20) — Foreign key → content.id — NOT NULL
    • author_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • comment — longtext — NOT NULL
    • date_created — datetime — NOT NULL
    • last_updated — datetime — NOT NULL
    • vote_count — int(11) — NOT NULL

    person

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • company_id — bigint(20) — Foreign key → company.id
    • date_created — datetime — NOT NULL
    • dm_allowed — bit(1) — NOT NULL
    • email — varchar(255) — NOT NULL
    • full_name — varchar(255) — NOT NULL
    • homepage_url — varchar(255)
    • last_updated — datetime — NOT NULL
    • resume_id — bigint(20) — Foreign key → resume.id

    recruit

    • id — bigint(20) — Primary key — NOT NULL
    • article_id — bigint(20) — Foreign key → article.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • city — varchar(255) — NOT NULL
    • closed — bit(1) — NOT NULL
    • company_id — bigint(20) — Foreign key → company.id
    • district — varchar(255) — NOT NULL
    • email — varchar(255) — NOT NULL
    • job_type — varchar(255) — NOT NULL
    • start_date — varchar(255)
    • tel — varchar(255) — NOT NULL
    • working_month — int(11)

    resume

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL

    role

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • authority — varchar(255) — NOT NULL

    scrap

    • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • article_id — bigint(20) — Foreign key → article.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • date_created — datetime — NOT NULL

    spam_word

    • id — bigint(20) — Primary key — NOT NULL
    • version — bigint(20) — NOT NULL
    • text — varchar(255) — NOT NULL

    tag

    • id — bigint(20) — Primary key — NOT NULL
    • date_created — datetime — NOT NULL
    • description — varchar(255)
    • name — varchar(255) — NOT NULL
    • tagged_count — int(11) — NOT NULL

    tag_similar_text

    • id — bigint(20) — Primary key — NOT NULL
    • tag_id — bigint(20) — Foreign key → tag.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • text — varchar(255) — NOT NULL

    user

    • id — bigint(20) — Primary key — NOT NULL
    • avatar_id — bigint(20) — Foreign key → avatar.id — NOT NULL
    • person_id — bigint(20) — Foreign key → person.id — NOT NULL
    • version — bigint(20) — NOT NULL
    • account_expired — bit(1) — NOT NULL
    • account_locked — bit(1) — NOT NULL
    • create_ip — varchar(255)
    • date_created — datetime — NOT NULL
    • date_withdraw — datetime
    • enabled — bit(1) — NOT NULL
    • last_password_changed — datetime — NOT NULL
    • last_update_ip — varchar(255)
    • last_updated — datetime — NOT NULL
    • password — varchar(255) — NOT NULL
    • password_expired — bit(1) — NOT NULL
    • username — varchar(15) — NOT NULL
    • withdraw — bit(1) — NOT NULL

    user_role

    • user_id — bigint(20) — Foreign key → user.id — NOT NULL
    • role_id — bigint(20) — Foreign key → role.id — NOT NULL