dionysus

Tables (11)

AdminUser (admin_users)

  • Key — Primary key — NOT NULL
  • Field

Bookmark (bookmarks)

  • 북마크 ID (bookmark_id) — bigint — Primary key — NOT NULL
  • 유저 ID (user_id) — bigint — Foreign key → User.유저 ID — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

Bookmarking (bookmarkings)

  • Key — bigint — Primary key — NOT NULL
  • 북마크 ID (bookmark_id) — bigint — Foreign key → Bookmark.북마크 ID — NOT NULL
  • 유저 ID (user_id) — bigint — Foreign key → Bookmark.유저 ID — NOT NULL
  • 밈 ID (meme_id) — bigint — Foreign key → Meme.밈 ID — NOT NULL
  • 생성일 (created_at) — datetime — NOT NULL
  • 수정일 (updated_at) — datetime — NOT NULL

Meme (memes)

  • 밈 ID (id) — bigint — Primary key — NOT NULL
  • 타입 (type) — int — NOT NULL — 0: Text, 1: Image, 2: Video
  • 제목 (title)
  • Field3 (description)
  • 원본 링크 (original_link)
  • File ID (thumbnail_id) — bigint — Foreign key → Thumbnail.File ID — NOT NULL
  • Video ID (id2) — Foreign key → Video.Video ID — NOT NULL
  • Status (status) — int — 0: preparing, 1: published, 999: Archived
  • Field

Tag (tags)

  • Tag ID (tag_id) — Primary key — NOT NULL
  • name — string — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime
  • 유저 ID (creator_id) — bigint — Foreign key → User.유저 ID — NOT NULL

Tagging (taggings)

  • Tagging ID (id) — Primary key — NOT NULL
  • 밈 ID (meme_id) — Foreign key → Meme.밈 ID — NOT NULL
  • Tag ID (tag_id) — Foreign key → Tag.Tag ID — NOT NULL

Thumbnail (files)

  • File ID (id) — bigint — Primary key — NOT NULL
  • filename
  • web_url (Field2)
  • file_url (Field)
  • 종류 (type)

Untitled

    User (users)

    • 유저 ID (id) — bigint — Primary key — NOT NULL
    • 닉네임 (nickname) — varchar(20) — NOT NULL
    • 이메일 (email) — varchar — NOT NULL
    • 생성일 (created_at) — datetime — NOT NULL
    • 수정일 (updated_at) — datetime — NOT NULL
    • Field

    Video (videos)

    • Video ID (id) — Primary key — NOT NULL

    Views (views)

    • View ID (id) — bigint — Primary key — NOT NULL
    • 유저 ID (viewer_id) — bigint — Foreign key → User.유저 ID — NOT NULL
    • viewable_id — bigint — NOT NULL
    • viewable_type — string — NOT NULL
    • views_count — bigint — NOT NULL