IEUM
테이블 (14)
answers
- answer_id — BIGSERIAL — 기본 키 — NOT NULL
- question_id — BIGINT — 외래 키 → questions.question_id — NOT NULL
- author_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- content — TEXT — NOT NULL
- is_accepted — BOOLEAN — NOT NULL
- embedding — vector(1536)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
chat_members
- room_id — BIGINT — 외래 키 → chat_rooms.room_id — NOT NULL
- user_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- joined_at — TIMESTAMPTZ — NOT NULL
- left_at — TIMESTAMPTZ
- last_read_at — TIMESTAMPTZ
chat_rooms
- room_id — BIGSERIAL — 기본 키 — NOT NULL
- meeting_id — BIGINT — 외래 키 → meetings.meeting_id
- room_type — room_type — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
friendships
- friendship_id — BIGSERIAL — 기본 키 — NOT NULL
- requester_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- addressee_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- status — friendship_status — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
meeting_participants
- meeting_id — BIGINT — 외래 키 → meetings.meeting_id — NOT NULL
- user_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- status — participant_status — NOT NULL
- joined_at — TIMESTAMPTZ — NOT NULL
meetings
- meeting_id — BIGSERIAL — 기본 키 — NOT NULL
- pin_id — BIGINT — 외래 키 → 핀.pin_id — NOT NULL
- host_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- meeting_at — TIMESTAMPTZ — NOT NULL
- max_members — SMALLINT — NOT NULL
- icon — VARCHAR(50)
- status — meeting_status — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
messages
- message_id — BIGSERIAL — 기본 키 — NOT NULL
- room_id — BIGINT — 외래 키 → chat_rooms.room_id — NOT NULL
- sender_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- content — TEXT
- image_url — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
notifications
- notification_id — BIGSERIAL — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- type — notification_type — NOT NULL
- title — VARCHAR(200) — NOT NULL
- body — TEXT
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
question_images
- image_id — BIGSERIAL — 기본 키 — NOT NULL
- question_id — BIGINT — 외래 키 → questions.question_id — NOT NULL
- image_url — TEXT — NOT NULL
- sort_order — SMALLINT — NOT NULL
questions
- question_id — BIGSERIAL — 기본 키 — NOT NULL
- pin_id — BIGINT — 외래 키 → 핀.pin_id — NOT NULL
- author_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- is_resolved — BOOLEAN — NOT NULL
- embedding — vector(1536)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
reports
- report_id — BIGSERIAL — 기본 키 — NOT NULL
- reporter_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- message_id — BIGINT — 외래 키 → messages.message_id
- reason — report_reason — NOT NULL
- detail — TEXT
- status — report_status — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
user_settings
- user_id — BIGSERIAL — 외래 키 → 사용자.user_id — NOT NULL
- language — VARCHAR(5) — NOT NULL
- camera_permission — BOOLEAN — NOT NULL
- push_permission — BOOLEAN — NOT NULL
- notify_default — BOOLEAN — NOT NULL
- notify_location — BOOLEAN — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
사용자 (users)
- user_id — BIGSERIAL — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- provider — AUTH_PROVIDER — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- birth_date — DATE
- gender — gender_type
- nationality — VARCHAR(2)
- profile_image_url — TEXT
- email_verified — BOOLEAN — NOT NULL
- last_location (last_loaction) — GEOGRAPHY(POINT, 4326)
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
핀 (pins)
- pin_id — BIGSERIAL — 기본 키 — NOT NULL
- author_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
- pin_type — PIN_TYPE — NOT NULL
- location — GEOGRAPHY(POINT, 4326) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ