discodeit - old
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
- uuid (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
- uuid (id) — uuid — Primary key — NOT NULL
- userId (author_id) — uuid — Foreign key → users.userId
- uuid (channel_id) — uuid — Foreign key → channels.uuid — NOT NULL
- 생성일 (created_at) — timestamptz — NOT NULL
- 업데이트일 (updated_at) — timestamptz
- 내용 (content) — text
- Field
message_attachments
- attachment_id — uuid — Foreign key → binary_contents.bcId
- message_id — uuid — Foreign key → message.uuid
- Field
read_statuses
- rsId (id) — uuid — Primary key — NOT NULL
- userId (user_id) — uuid — Foreign key → users.userId — NOT NULL
- uuid (channel_id) — uuid — Foreign key → channels.uuid — NOT NULL
- 생성일 (created_at) — timestamptz — NOT NULL
- 업데이트일 (updated_at) — timestamptz
- 마지막읽은시간 (last_read_at) — timestamptz — NOT NULL
user_statuses
- usId (id) — uuid — Primary key — NOT NULL
- userId (user_id) — uuid — Foreign key → users.userId — NOT NULL
- 생성일 (created_at) — timestamptz — NOT NULL
- 업데이트일 (updated_at) — timestamptz
- 마지막활동시간 (last_active_at) — timestamptz — NOT NULL
users
- userId (id) — uuid — Primary key — NOT NULL
- profileId (profile_id) — uuid — Foreign key → binary_contents.bcId
- 생성일 (created_at) — timestamptz — NOT NULL
- 업데이트일 (updated_at) — instant
- 로그인아이디 (username) — varcahr(50) — NOT NULL
- 이메일 (email) — varchar(100) — NOT NULL
- 비밀번호 (password) — varchar(60) — NOT NULL