ASSA 파일 관리방식 변경

테이블 (17)

Untitled (user_comment_like)

  • Key (user_id) — int — 외래 키 → User.Key — NOT NULL
  • Key (comment_id) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (images)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (uploader_id) — int — 외래 키 → User.Key — NOT NULL
  • Field (name) — varchar(255)
  • Field (url) — varchar(255)
  • Field (created_at) — datetime

Untitled (chat_message)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (sender_id) — int — 외래 키 → User.Key — NOT NULL
  • Field (message) — TEXT
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime

Untitled (notification)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (receiver_id) — int — 외래 키 → User.Key — NOT NULL
  • Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (type) — int
  • Field (message) — varchar(255)
  • Field (read_at) — datetime
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime

Untitled (terms_user_agree)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (agree) — boolean
  • Key (user_id) — int — 외래 키 → User.Key — NOT NULL
  • Key (terms_id) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (terms)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (title) — varchar(30)
  • Field (content) — TEXT
  • Field (is_essential) — boolean

Untitled (user_chat_room_map)

  • Key (chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — int — 외래 키 → User.Key — NOT NULL

Untitled (chat_room)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (host_id) — int — 외래 키 → User.Key — NOT NULL
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime

Untitled (user_reply_like)

  • Key (user_id) — int — 외래 키 → User.Key — NOT NULL
  • Key (reply_id) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (user_post_like)

  • Key (user_id) — int — 외래 키 → User.Key — NOT NULL
  • Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (reply)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (user_id) — int — 외래 키 → User.Key — NOT NULL
  • Key (comment_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — TEXT
  • Field (image_urls) — TEXT
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime

Untitled (comment)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (user_id) — int — 외래 키 → User.Key — NOT NULL
  • Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — TEXT
  • Field (image_urls) — TEXT
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime

Untitled (community_banned)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (community_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — int — 외래 키 → User.Key — NOT NULL

Untitled (follow)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (follower_id) — int — 외래 키 → User.Key — NOT NULL
  • Key (following_id) — int — 외래 키 → User.Key — NOT NULL

Untitled (post)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (user_id) — int — 외래 키 → User.Key — NOT NULL
  • Field (title) — varchar(100)
  • Field (content) — TEXT
  • Field (image_urls) — TEXT
  • Field (views) — bigint
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime — asdf

Untitled (community)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (video_call_chat_room_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — varchar(255)
  • Field (description) — varchar(255)
  • Field (cover_image_url) — varchar(255)
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime

User (user)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (email) — varchar(100)
  • Field2 (password) — varchar(100)
  • Field (nickname) — varchar(20)
  • Field (profile_image) — varchar(255)
  • Field (login_type) — varchar(10)
  • Field (description) — varchar(255)
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime
  • Field