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