양도교환
테이블 (28)
actor
- id — UUID
- name — VARCHAR(50) — NOT NULL
- profile_image — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
chat_room
- id — UUID
- type — chat_room_type — NOT NULL
- transfer_id — UUID — 외래 키 → transfer.id
- exchange_request_id — UUID — 외래 키 → exchange_request.id
- status — chat_room_status — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- closed_at — TIMESTAMPTZ
chat_room_user
- id — UUID
- chat_room_id — UUID — 외래 키 → chat_room.id — NOT NULL
- user_id — UUID — 외래 키 → user.id — NOT NULL
- last_read_at — TIMESTAMPTZ
- joined_at — TIMESTAMPTZ — NOT NULL
- left_at — TIMESTAMPTZ
- UNIQUE(chat_room_id, — user_id)
exchange
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- status — exchange_status — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
exchange_have_card
- id — UUID
- exchange_id — UUID — 외래 키 → exchange.id — NOT NULL
- actor_id — UUID — 외래 키 → actor.id — NOT NULL
- show_id — UUID — 외래 키 → show.id
- character_name — VARCHAR(50)
- image_url — TEXT — NOT NULL
- image_original — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
exchange_request
- id — UUID
- target_exchange_id — UUID — 외래 키 → exchange.id — NOT NULL
- requester_id — UUID — 외래 키 → user.id — NOT NULL
- requester_exchange_id — UUID — 외래 키 → exchange.id — NOT NULL
- offered_card_ids — UUID — NOT NULL
- status — exchange_request_status — NOT NULL
- requester_confirmed — BOOLEAN — NOT NULL
- target_confirmed — BOOLEAN — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- responded_at — TIMESTAMPTZ
exchange_want_card
- id — UUID
- exchange_id — UUID — 외래 키 → exchange.id — NOT NULL
- actor_id — UUID — 외래 키 → actor.id — NOT NULL
- show_id — UUID — 외래 키 → show.id
- character_name — VARCHAR(50)
fcm_token
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- token — TEXT — NOT NULL
- device_type — device_type — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
giveaway
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- image_urls — TEXT — NOT NULL
- type — giveaway_type — NOT NULL
- location_name — VARCHAR(100)
- location_address — VARCHAR(300)
- location_lat — DECIMAL(10, 7)
- location_lng — DECIMAL(10, 7)
- max_applicants — INTEGER — NOT NULL
- password — VARCHAR(100)
- status — giveaway_status — NOT NULL
- scheduled_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
giveaway_application
- id — UUID
- giveaway_id — UUID — 외래 키 → giveaway.id — NOT NULL
- user_id — UUID — 외래 키 → user.id — NOT NULL
- status — giveaway_application_status — NOT NULL
- applied_at — TIMESTAMPTZ — NOT NULL
- selected_at — TIMESTAMPTZ
- UNIQUE(giveaway_id, — user_id)
keyword_alert
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- show_id — UUID — 외래 키 → show.id — NOT NULL
- date_start — DATE
- date_end — DATE
- actor_ids — UUID
- seat_grades — VARCHAR(10)
- max_price — INTEGER
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
message
- id — UUID
- chat_room_id — UUID — 외래 키 → chat_room.id — NOT NULL
- sender_id — UUID — 외래 키 → user.id
- type — message_type — NOT NULL
- content — TEXT
- image_url — TEXT
- metadata — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
notification
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- type — notification_type — NOT NULL
- title — VARCHAR(100) — NOT NULL
- body — TEXT — NOT NULL
- data — JSONB
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
report
- id — UUID
- reporter_id — UUID — 외래 키 → user.id — NOT NULL
- reported_user_id — UUID — 외래 키 → user.id — NOT NULL
- type — report_type — NOT NULL
- reference_type — VARCHAR(20)
- reference_id — UUID
- description — TEXT — NOT NULL
- evidence_urls — TEXT
- status — report_status — NOT NULL
- admin_note — TEXT
- resolved_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- CHECK — (reporter_id != reported_user_id)
schedule_casting
- id — UUID
- schedule_id — UUID — 외래 키 → show_schedule.id — NOT NULL
- actor_id — UUID — 외래 키 → actor.id — NOT NULL
- character_name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(schedule_id, — character_name)
show
- id — UUID
- title — VARCHAR(200) — NOT NULL
- category — show_category — NOT NULL
- venue_name — VARCHAR(100) — NOT NULL
- poster_url — TEXT
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- running_time — INTEGER
- intermission — INTEGER
- age_limit — INTEGER
- seat_prices — JSONB — NOT NULL
- status — show_status — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
show_casting
- id — UUID
- show_id — UUID — 외래 키 → show.id — NOT NULL
- actor_id — UUID — 외래 키 → actor.id — NOT NULL
- character_name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(show_id, — actor_id,
show_schedule
- id — UUID
- show_id — UUID — 외래 키 → show.id — NOT NULL
- date — DATE — NOT NULL
- time — VARCHAR(5) — NOT NULL
- round — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(show_id, — date,
subscription
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- plan — subscription_plan — NOT NULL
- price — INTEGER — NOT NULL
- receipt — TEXT
- platform — device_type — NOT NULL
- status — subscription_status — NOT NULL
- auto_renew — BOOLEAN — NOT NULL
- started_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- cancelled_at — TIMESTAMPTZ
transfer
- id — UUID
- seller_id — UUID — 외래 키 → user.id — NOT NULL
- schedule_id — UUID — 외래 키 → show_schedule.id — NOT NULL
- account_id — UUID — 외래 키 → user_account.id — NOT NULL
- seat_grade — VARCHAR(10) — NOT NULL
- seat_info — VARCHAR(50) — NOT NULL
- original_price — INTEGER — NOT NULL
- selling_price — INTEGER — NOT NULL
- ticket_image_url — TEXT — NOT NULL
- ticket_image_original — TEXT — NOT NULL
- receipt_image_url — TEXT — NOT NULL
- receipt_image_original — TEXT — NOT NULL
- last_four_digits — VARCHAR(4) — NOT NULL
- description — TEXT
- status — transfer_status — NOT NULL
- current_buyer_id — UUID — 외래 키 → user.id
- bumped_at — TIMESTAMPTZ
- completed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(schedule_id, — seat_info)
- CHECK — (selling_price <= original_price)
transfer_bookmark
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- transfer_id — UUID — 외래 키 → transfer.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(user_id, — transfer_id)
transfer_mute
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- transfer_id — UUID — 외래 키 → transfer.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(user_id, — transfer_id)
transfer_request
- id — UUID
- transfer_id — UUID — 외래 키 → transfer.id — NOT NULL
- requester_id — UUID — 외래 키 → user.id — NOT NULL
- queue_position — INTEGER — NOT NULL
- status — transfer_request_status — NOT NULL
- requested_at — TIMESTAMPTZ(3) — NOT NULL
- selected_at — TIMESTAMPTZ
- expires_at — TIMESTAMPTZ
- responded_at — TIMESTAMPTZ
- UNIQUE(transfer_id, — requester_id)
trust_history
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- change_amount — INTEGER — NOT NULL
- reason — VARCHAR(100) — NOT NULL
- reference_type — VARCHAR(20)
- reference_id — UUID
- created_at — TIMESTAMPTZ — NOT NULL
user
- id — UUID
- phoneNumber (phone_number) — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- imageUri (image_uri) — TEXT
- trustScore (trust_score) — INTEGER — NOT NULL
- trustGrade (trust_grade) — trust_grade — NOT NULL
- status — user_status — NOT NULL
- banReason (ban_reason) — TEXT
- isPremium (is_premium) — BOOLEAN — NOT NULL
- premiumPlan (premium_plan) — subscription_plan
- premiumExpiresAt (premium_expires_at) — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
- canRejoinAt (can_rejoin_at) — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_account
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- bank_code — VARCHAR(10) — NOT NULL
- bank_name — VARCHAR(20) — NOT NULL
- account_number — VARCHAR(30) — NOT NULL
- holder_name — VARCHAR(20) — NOT NULL
- is_primary — BOOLEAN — NOT NULL
- verified_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(user_id, — account_number)
user_agreement
- id — UUID
- user_id — UUID — 외래 키 → user.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- version — VARCHAR(10) — NOT NULL
- agreed_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(user_id, — type,
user_block
- id — UUID
- blocker_id — UUID — 외래 키 → user.id — NOT NULL
- blocked_id — UUID — 외래 키 → user.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- UNIQUE(blocker_id, — blocked_id)
- CHECK — (blocker_id != blocked_id)