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