Submate
Tables (13)
BillingKey (빌링키)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- payment_method_id (Key3) — Foreign key → PaymentMethod.id — NOT NULL
- provider_name (Field)
- billing_key_ref (Field2)
- customer_key_ref (Field3)
- status (Field4)
- issued_at (Field5)
- expired_at (Field6)
- created_at (Field7)
- updated_at (Field8)
Invitation (초대)
- id (Key) — Primary key — NOT NULL
- party_id (Key2) — Foreign key → Party.id — NOT NULL
- party_member_id (Key3) — Foreign key → PartyMember.id — NOT NULL
- invitation_type (Field)
- invitation_payload (Field2)
- invitation_status (Field3)
- sent_at (Field4)
- accepted_at (Field5)
- expired_at (Field6)
- created_at (Field7)
- updated_at (Field8)
LeaveReservation (파티탈퇴예약)
- id (Key) — Primary key — NOT NULL
- party_member_id (Key2) — Foreign key → PartyMember.id — NOT NULL
- cycle_id (Key3) — Foreign key → SubCycle.id — NOT NULL
- reservation_status (Field)
- requested_at (Field2)
- scheduled_leave_at (Field3)
- processed_at (Field4)
- created_at (Field5)
- updated_at (Field6)
Party (파티)
- id (Key) — Primary key — NOT NULL
- plan_id (Key2) — Foreign key → ServicePlan.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
- party_status (Field)
- current_member_count (Field2)
- max_member_count (Field3)
- recruit_started_at (Field4)
- active_started_at (Field5)
- ended_at (Field6)
- created_at (Field7)
- updated_at (Field8)
PartyMember (파티멤버)
- id (Key) — Primary key — NOT NULL
- party_id (Key2) — Foreign key → Party.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
- role (Field)
- member_status (Field2)
- joined_at (Field3)
- active_started_at (Field4)
- left_at (Field5)
- created_at (Field6)
- updated_at (Field7)
Payment (결제)
- id (Key) — Primary key — NOT NULL
- cycle_id (Key2) — Foreign key → SubCycle.id — NOT NULL
- party_id (Key3) — Foreign key → Party.id — NOT NULL
- user_id (Key5) — Foreign key → User.id — NOT NULL
- billing_key_id (Key4) — Foreign key → BillingKey.id — NOT NULL
- amount (Field)
- payment_status (Field2)
- requested_at (Field3)
- approved_at (Field4)
- failed_at (Field5)
- failure_reason (Field6)
- created_at (Field7)
- updated_at (Field8)
PaymentMethod (결제수단)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- provider_name (Field)
- method_type (Field2)
- masked_card_number (Field3)
- card_company (Field4)
- is_default (Field5)
- status (Field6)
- created_at (Field7)
- updated_at (Field8)
ServicePlan (공유구독 상품)
- id (Key) — Primary key — NOT NULL
- service_name (Field)
- plan_name (Field2)
- official_price (Field3)
- max_member_count (Field4)
- billing_cycle_months (Field5)
- invite_method_type (Field6)
- is_active (Field7)
- created_at (Field8)
- updated_at (Field9)
Social (소설로그인)
- id (Key) — Primary key — NOT NULL
SubCycle (Untitled6)
- id (Key) — Primary key — NOT NULL
- party_id (Key2) — Foreign key → Party.id — NOT NULL
- cycle_no (Field)
- cycle_status (Field2)
- cycle_start_at (Field3)
- cycle_end_at (Field4)
- payment_due_at (Field5)
- created_at (Field6)
- updated_at (Field7)
Transfer (승계)
- id (Key) — Primary key — NOT NULL
- party_id (Key2) — Foreign key → Party.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
- candidate_user_id (Key4) — Foreign key → User.id — NOT NULL
- transfer_status (Field)
- requested_at (Field2)
- responded_at (Field3)
- completed_at (Field4)
- deadline_at (Field5)
- created_at (Field6)
- updated_at (Field7)
User (사용자)
- id (Key) — Primary key — NOT NULL
bankAccount (Untitled12)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.id — NOT NULL
- fintech_use_num (Field)
- access_token (Field2)
- refresh_token (Field3)
- bank_tran_id (Field4)
- tran_dtime (Field5)
- bank_name (Field6)
- account_alias (Field7)
- account_num_masked (Field8)
- balance_amt (Field9)
- inquiry_trace_info (Field10)