양도교환

테이블 (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)