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)