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)
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