discodeit
Tables (7)
binary_contents
- bcId (id) — uuid — Primary key — NOT NULL
- 생성일 (created_at) — timestamptz — NOT NULL
- 파일이름 (file_name) — varchar(255) — NOT NULL
- 크기 (size) — bigint — NOT NULL
- 타입 (content_type) — varchar(100) — NOT NULL
- bytes — bytea — NOT NULL
channels
- channelId (id) — uuid — Primary key — NOT NULL
- 생성일 (created_at) — timestamptz — NOT NULL
- 업데이트일 (updated_at) — timestamptz
- 채널이름 (name) — varchar(100)
- 설명 (description) — varchar(500)
- 타입 (type) — varchar(10) — NOT NULL
message_attachments
- bcId (attachment_id) — uuid — Foreign key → binary_contents.bcId — NOT NULL
- uuid (message_id) — uuid — Foreign key → messages.uuid — NOT NULL
messages
- uuid (id) — uuid — Primary key — NOT NULL
- 생성일 (created_at) — timestamptz — NOT NULL
- 업데이트일 (updated_at) — timestamptz
- 내용 (content) — text
- authorId (author_id) — uuid — Foreign key → users.userId
- channelId (channel_id) — uuid — Foreign key → channels.channelId — NOT NULL
read_statuses
- rsId (id) — uuid — Primary key — NOT NULL
- 생성일 (created_at) — timestamptz — NOT NULL
- 업데이트일 (updated_at) — timestamptz
- 마지막읽은시간 (last_read_at) — timestamptz — NOT NULL
- userId (user_id) — uuid — Foreign key → users.userId
- channelId (channel_id) — uuid — Foreign key → channels.channelId
user_statuses
- usId (id) — uuid — Primary key — NOT NULL
- 생성일 (created_at) — timestamptz — NOT NULL
- 업데이트일 (updated_at) — timestamptz
- 마지막활동시간 (last_active_at) — timestamptz — NOT NULL
- userId (user_id) — uuid — Foreign key → users.userId — NOT NULL
users
- userId (id) — uuid — Primary key — NOT NULL
- 생성일 (created_at) — timestamptz — NOT NULL
- 업데이트일 (updated_at) — timestamptz
- 로그인아이디 (username) — varchar(50) — NOT NULL
- 이메일 (email) — varchar(100) — NOT NULL
- 비밀번호 (password) — varchar(60) — NOT NULL
- profileId (profile_id) — uuid — Foreign key → binary_contents.bcId