ERD연습
테이블 (8)
Employee
- id — Long — 기본 키 — NOT NULL
- createdAt
- updatedAt
binary_contents
- id — uuid — 기본 키 — NOT NULL
- created_at — timestamptz — NOT NULL
- file_name — varcar(255) — NOT NULL
- size — bigint — NOT NULL
- content_type — varchar(100) — NOT NULL
- bytes — bytea — NOT NULL
channels
- id — uuid — 기본 키 — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz
- name — varchar(100)
- description — varchar(500)
- type — varchar(10) — NOT NULL
message_attachments
- message_id — uuid — 외래 키 → messages.id — NOT NULL
- attachment_id — uuid — 외래 키 → binary_contents.id — NOT NULL
messages
- id — uuid — 기본 키 — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz
- content — text
- channel_id — uuid — 외래 키 → channels.id — NOT NULL
- author_id — uuid — 외래 키 → users.id — NOT NULL
read_statuses
- id — uuid — 기본 키 — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz
- user_id — uuid — 외래 키 → users.id — NOT NULL
- channel_id — uuid — 외래 키 → channels.id — NOT NULL
user_statuses
- id — uuid — 기본 키 — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz
- user_id — uuid — 외래 키 → users.id — NOT NULL
- last_active_at — timestamptz — NOT NULL
users
- id — uuid — 기본 키 — NOT NULL
- created_at — timestampts — NOT NULL
- updated_at — timestampts
- username — varchar(50) — NOT NULL
- email — varchar(100) — NOT NULL
- password — varchar(60) — NOT NULL
- profile_id — uuid — 외래 키 → binary_contents.id — NOT NULL