landy-erd

Tables (5)

fcm_tokens (토큰)

  • token_id — Primary key — NOT NULL
  • user_id — Foreign key → users.user_id — NOT NULL
  • value (토큰 값)
  • platform (플랫폼 (안드로이드, IOS))

notifications (알림)

  • notification_id — Primary key — NOT NULL
  • user_id — Foreign key → users.user_id — NOT NULL
  • tenant_id — Foreign key → tenants.tenant_id — NOT NULL
  • title (제목)
  • content (내용)
  • type (알림 종류)
  • sent_at (보낸 시각)
  • is_read (읽음 여부)

payments (납부기록)

  • payment_id — Primary key — NOT NULL
  • tenant_id — Foreign key → tenants.tenant_id — NOT NULL
  • paid_at (납부일)
  • amount (입금액)
  • target_date (예정 납부일)
  • source (입력 주체)

tenants (임차인)

  • tenant_id — Primary key — NOT NULL
  • user_id — Foreign key → users.user_id — NOT NULL
  • name (이름)
  • phone (전화번호)
  • rent_price (월세)
  • payment_day (납부일)
  • start_date (계약 시작일)
  • end_date (계약 종료일)
  • notify_enabled (세입자 별 알림 설정)

users (유저)

  • user_id — Primary key — NOT NULL
  • sub (식별자)
  • provider (OAuth2 제공자)
  • notify_due (납부일 알림 받기)
  • notify_overdue (연체 알림 받기)