alarm

Tables (10)

ALARM (알람 설정)

  • alarm_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • alarm_time (Field2)
  • repeat_days (Field3)
  • verification_type (Field4)
  • is_active (Field5)

Payment_method (결제 수단)

  • payment_method_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • pg_provider (Field2)
  • billing_key (Field3)
  • status (Field4) — enum(active, revoked)
  • created_at (Field5)

User (사용자)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • name (Field3)
  • phone (Field4)
  • status (Field5) — enum(active, blocked)
  • created_at (Field6)
  • penalty_id (Key2) — Foreign key → penalty.penalty_id — NOT NULL
  • alarm_log+id (Key22) — Foreign key → penalty.alarm_log+id — NOT NULL
  • alarm_id (Key222) — Foreign key → penalty.alarm_id — NOT NULL
  • user_id (Key2222) — Foreign key → penalty.user_id — NOT NULL

User_account (수령계좌)

  • account_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • bank_code (Field2)
  • account_number (Field3)
  • account_holder (Field4)
  • verified_at (Field5)

alarm_log (알람 실행 기록)

  • alarm_log+id (Key) — Primary key — NOT NULL
  • alarm_id (Key2) — Foreign key → ALARM.alarm_id — NOT NULL
  • user_id (Key22) — Foreign key → ALARM.user_id — NOT NULL
  • fired_at (Field3)
  • result (Field4) — enum(success, fail)
  • verified_at (Field5)

group (모임테이블)

  • group_id (Key) — Primary key — NOT NULL
  • created_at (Field)
  • user_id (Field2)
  • Field3

participants (참가자)

  • pa_id (Key) — Primary key — NOT NULL
  • created_at (Field)
  • bangjang_id (Field2)

payment_transaction (결제 기록)

  • transaction_id (Key) — Primary key — NOT NULL
  • penalty_id (Key2) — Foreign key → penalty.penalty_id — NOT NULL
  • alarm_log+id (Key22) — Foreign key → penalty.alarm_log+id — NOT NULL
  • alarm_id (Key222) — Foreign key → penalty.alarm_id — NOT NULL
  • user_id (Key2222) — Foreign key → penalty.user_id — NOT NULL
  • pg+transcation_id (Field3)
  • amount (Field4)
  • status (Field5) — enum(success, fail)
  • paid_at (Field6)

penalty (벌금이벤트)

  • penalty_id (Key) — Primary key — NOT NULL
  • alarm_log+id (Key2) — Foreign key → alarm_log.alarm_log+id — NOT NULL
  • alarm_id (Key22) — Foreign key → alarm_log.alarm_id — NOT NULL
  • user_id (Key222) — Foreign key → alarm_log.user_id — NOT NULL
  • from_user_id (Field2)
  • to_user_id (Field3)
  • amount (Field4)
  • platform_fee (Field5)
  • status (Field6) — enum(pending, paid, refunded)

settlement (정산 / 송금)

  • settlement_id (Key) — Primary key — NOT NULL
  • penalty_id (Key2) — Foreign key → penalty.penalty_id — NOT NULL
  • alarm_log+id (Key22) — Foreign key → penalty.alarm_log+id — NOT NULL
  • alarm_id (Key222) — Foreign key → penalty.alarm_id — NOT NULL
  • user_id (Key2222) — Foreign key → penalty.user_id — NOT NULL
  • account_id (Field2)
  • amount (Field3)
  • transfer_status (Field4)
  • transferred_at (Field5)