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 (연체 알림 받기)