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