mingle

Tables (16)

mingle_blocks

  • id — NUMBER(19) — Primary key — NOT NULL
  • blocker_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • blocked_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • created_at — DATE — NOT NULL

mingle_chat_messages

  • id — NUMBER(19) — Primary key — NOT NULL
  • chat_room_id — NUMBER(19) — Foreign key → mingle_chat_rooms.id — NOT NULL
  • sender_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • message_type — VARCHAR2(20) — NOT NULL
  • content — CLOB
  • is_read — NUMBER(1) — NOT NULL
  • created_at — DATE — NOT NULL

mingle_chat_rooms

  • id — NUMBER(19) — Primary key — NOT NULL
  • match_id — NUMBER(19) — Foreign key → mingle_matches.id
  • opened_by_user_item — NUMBER(19) — Foreign key → mingle_user_items.id
  • user1_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • user2_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • created_at — DATE — NOT NULL
  • closed_at — DATE

mingle_item_orders

  • id — NUMBER(19) — Primary key — NOT NULL
  • user_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • item_id — NUMBER(19) — Foreign key → mingle_items.id — NOT NULL
  • quantity — NUMBER(10) — NOT NULL
  • unit_price — NUMBER(19) — NOT NULL
  • total_price — NUMBER(19) — NOT NULL
  • created_at — DATE — NOT NULL

mingle_items

  • id — NUMBER(19) — Primary key — NOT NULL
  • name — VARCHAR2(100) — NOT NULL
  • description — VARCHAR2(255)
  • item_type — VARCHAR2(30) — NOT NULL
  • point_price — NUMBER(19) — NOT NULL
  • is_active — NUMBER(1) — NOT NULL
  • created_at — DATE — NOT NULL

mingle_matches

  • id — NUMBER(19) — Primary key — NOT NULL
  • user1_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • user2_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • matched_at — DATE — NOT NULL
  • cancelled_by — NUMBER(19) — Foreign key → mingle_users.id
  • cancelled_at — DATE
  • cancel_reason — VARCHAR2(255)

mingle_payments

  • id — NUMBER(19) — Primary key — NOT NULL
  • user_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • order_id — VARCHAR2(100) — NOT NULL
  • amount — NUMBER(19) — NOT NULL
  • point_amount — NUMBER(19) — NOT NULL
  • payment_method — VARCHAR2(30)
  • pg_transaction_id — VARCHAR2(255)
  • status — VARCHAR2(20) — NOT NULL
  • paid_at — DATE
  • refunded_at — DATE
  • created_at — DATE — NOT NULL

mingle_point_transactions

  • id — NUMBER(19) — Primary key — NOT NULL
  • user_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • transaction_type — VARCHAR2(30) — NOT NULL
  • amount — NUMBER(19) — NOT NULL
  • balance_after — NUMBER(19) — NOT NULL
  • reference_type — VARCHAR2(30)
  • reference_id — NUMBER(19)
  • description — VARCHAR2(255)
  • created_at — DATE — NOT NULL

mingle_reports

  • id — NUMBER(19) — Primary key — NOT NULL
  • reporter_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • reported_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • message_id — NUMBER(19) — Foreign key → mingle_chat_messages.id
  • reason_type — VARCHAR2(30) — NOT NULL
  • detail — CLOB
  • status — VARCHAR2(20) — NOT NULL
  • handled_by — NUMBER(19) — Foreign key → mingle_users.id
  • handled_at — DATE
  • created_at — DATE — NOT NULL

mingle_rewind_logs

  • id — NUMBER(19) — Primary key — NOT NULL
  • user_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • swipe_id — NUMBER(19) — Foreign key → mingle_swipes.id — NOT NULL
  • created_at — DATE — NOT NULL

mingle_swipes

  • id — NUMBER(19) — Primary key — NOT NULL
  • swiper_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • target_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • action — VARCHAR2(20) — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • rewound_at — DATE
  • created_at — DATE — NOT NULL

mingle_user_items

  • id — NUMBER(19) — Primary key — NOT NULL
  • user_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • item_id — NUMBER(19) — Foreign key → mingle_items.id — NOT NULL
  • quantity — NUMBER(10) — NOT NULL
  • expired_at — DATE
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL

mingle_user_photos

  • id — NUMBER(19) — Primary key — NOT NULL
  • user_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • photo_url — VARCHAR2(500) — NOT NULL
  • is_main — NUMBER(1) — NOT NULL
  • sort_order — NUMBER(5) — NOT NULL
  • created_at — DATE — NOT NULL

mingle_user_points

  • user_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • balance — NUMBER(19) — NOT NULL
  • updated_at — DATE — NOT NULL

mingle_user_profiles

  • id — NUMBER(19) — Primary key — NOT NULL
  • user_id — NUMBER(19) — Foreign key → mingle_users.id — NOT NULL
  • nickname — VARCHAR2(50) — NOT NULL
  • birth_date — DATE
  • gender — VARCHAR2(10)
  • height — NUMBER(5)
  • job — VARCHAR2(100)
  • region — VARCHAR2(100)
  • introduction — CLOB
  • interests — VARCHAR2(255)
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL

mingle_users

  • id — NUMBER(19) — Primary key — NOT NULL
  • email — VARCHAR2(255) — NOT NULL
  • password_hash — VARCHAR2(255) — NOT NULL
  • phone — VARCHAR2(20)
  • status — VARCHAR2(20) — NOT NULL
  • last_login_at — DATE
  • withdrawn_at — DATE
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL