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)