Project PG
okky erd
Tables (24)
activity (activity_point)
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- avatar_id (artist_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
- point — int(11) — NOT NULL
- point_type — varchar(255) — NOT NULL
- type — varchar(255) — NOT NULL
article
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- enabled — bit(1) — NOT NULL
- author_id — bigint(20) — Foreign key → avatar.id
- category_id — varchar(255) — Foreign key → category.code — NOT NULL
- content_id — bigint(20) — Foreign key → content.id
- create_ip — varchar(255)
- choice — bit(1) — NOT NULL
- title — varchar(255) — NOT NULL
- tag_string — varchar(255)
- note_count (comment_count) — int(11) — NOT NULL
- view_count — int(11) — NOT NULL
- vote_count — int(11) — NOT NULL
- scrap_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 (artist)
- 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 (artist_tag)
- avatar_tags_id (artist_tags_id) — bigint(20) — Foreign key → avatar.id
- tag_id — bigint(20) — Foreign key → tag.id
banner (banner (low))
- 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
category
- code — varchar(255) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- Field (enabled) — bit(1) — NOT NULL
- parent_id — varchar(255) — Foreign key → category.code
- level — int(11) — NOT NULL
- default_label — varchar(255) — NOT NULL
- label_code — varchar(255) — NOT NULL
- icon_css_names — varchar(255)
- writable — bit(1) — NOT NULL
change_log (change_log (low))
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — 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
- md5 — varchar(255) — NOT NULL
- patch — longtext — NOT NULL
- revision — int(11) — NOT NULL
- type — varchar(255) — NOT NULL
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
- 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
- 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 (content_vote (low))
- 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
- width — 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
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
notification (notification (medium))
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- article_id — bigint(20) — Foreign key → article.id — NOT NULL
- sender_id — bigint(20) — Foreign key → avatar.id — NOT NULL
- content_id — bigint(20) — Foreign key → content.id — NOT NULL
- receiver_id — bigint(20) — Foreign key → avatar.id — NOT NULL
- type — varchar(255) — NOT NULL
notification_read (notification_read (low))
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- avatar_id (artist_id) — bigint(20) — Foreign key → avatar.id — NOT NULL
- last_read — datetime — NOT NULL
oauthid (oauth)
- 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 (comment (medium))
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- content_id — bigint(20) — Foreign key → content.id — NOT NULL
- author_id — bigint(20) — Foreign key → avatar.id — NOT NULL
- id (parent_id) — bigint(20) — Foreign key → opinion.id
- comment — longtext — NOT NULL
- vote_count — int(11) — NOT NULL
scrap (scrap (low))
- avatar_id (artist_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 (spam_word (low))
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- text — varchar(255) — NOT NULL
tag (tag (medium))
- 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 (tag_similar_text (low))
- 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 (Member)
- id — bigint(20) — Primary key — NOT NULL
- avatar_id (artist_id) — bigint(20) — Foreign key → avatar.id — NOT NULL
- version — bigint(20) — NOT NULL
- enabled — bit(1) — NOT NULL
- Field (role) — enum — NOT NULL
- account_expired — bit(1) — NOT NULL
- account_locked — bit(1) — NOT NULL
- create_ip — varchar(255)
- date_created — datetime — NOT NULL
- withdraw — bit(1) — NOT NULL
- date_withdraw — datetime
- last_password_changed — datetime — NOT NULL
- last_update_ip — varchar(255)
- last_updated — datetime — NOT NULL
- username — varchar(15) — NOT NULL
- password — varchar(255) — NOT NULL
- password_expired — bit(1) — NOT NULL