addit
Tables (11)
banners (배너)
- id — bigint — Primary key — NOT NULL
- Field (image) — varchar(1024) — NOT NULL
clip (클립)
- id — bigint — Primary key — NOT NULL
- id (relay_id) — bigint — Foreign key → relays.id — NOT NULL
- id (user_id) — bigint — Foreign key → users.id — NOT NULL
friends (애디/애더)
- id (adder_id) — varchar(36) — Foreign key → users.id — NOT NULL
- id (addie_id) — varchar(36) — Foreign key → users.id — NOT NULL
notifications (알림)
- id — bigint — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → users.id — NOT NULL
- Field (object_id) — varchar(36) — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (is_read) — bit(1) — NOT NULL
reactions (반응)
- id — bigint — Primary key — NOT NULL
- id (tickle_id) — bigint — Foreign key → tickles.id — NOT NULL
- id (author_id) — bigint — Foreign key → users.id — NOT NULL
- Field (type) — varchar(10) — NOT NULL
relay_tags (릴레이 태그)
- id — bigint — Primary key — NOT NULL
- id (relay_id) — bigint — Foreign key → relays.id — NOT NULL
- id (tag_id) — bigint — Foreign key → tags.id — NOT NULL
relays (릴레이)
- id — bigint — Primary key — NOT NULL
- author_id — bigint — Foreign key → users.id — NOT NULL
- Field (uuid) — varchar(36) — NOT NULL
- Field (title) — varchar(100) — NOT NULL
- Field (description) — longtext
- Field2 (reactions_count) — int — NOT NULL
- Field6 (tickles_count) — int — NOT NULL
- Field5 (status) — varchar(10) — NOT NULL
- Field3 (created_at) — datetime — NOT NULL
- Field4 (updated_at) — datetime — NOT NULL
replies (댓글)
- id — bigint — Primary key — NOT NULL
- id (tickle_id) — bigint — Foreign key → tickles.id — NOT NULL
- id (author_id) — bigint — Foreign key → users.id — NOT NULL
- Field (content) — varchar(300) — NOT NULL
- Field (created_at) — datetime — NOT NULL
tags (태그)
- id — bigint — Primary key — NOT NULL
- tag — varchar(20) — NOT NULL
tickles (티클)
- id — bigint — Primary key — NOT NULL
- id (relay_id) — biigint — Foreign key → users.id — NOT NULL
- id (uesr_id) — bigint — Foreign key → relays.id — NOT NULL
- Field (uuid) — varchar(36) — NOT NULL
- Field (description) — varchar(300)
- Field (file) — varchar(1025) — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (replies_count) — int — NOT NULL
- Field (reactions_count) — int — NOT NULL
- Field (funny_count) — int — NOT NULL
- Field2 (sad_count) — int — NOT NULL
- Field3 (surprise_count) — int — NOT NULL
- Field4 (like_count) — int — NOT NULL
users (사용자)
- id — bigint — Primary key — NOT NULL
- Field (uuid) — varchar(36) — NOT NULL
- Field (provider) — varchar(10) — NOT NULL
- Field2 (email) — varchar(30) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (name) — varchar(20) — NOT NULL
- Field (profileImage) — varchar(1024)
- Field (introduction) — varchar(60)
- Field (addies_count) — int — NOT NULL
- Field2 (adders_count) — int — NOT NULL